#Office365Challenge - Excel Conditional Formatting - Top to Bottom Rules. As mentioned yesterday, Excel has many options when it comes to Conditional Formatting. Yesterday we worked with Highlighting Cell Rules. Today we'll take a look at Top to Bottom Rules.... Continue Reading →
#Office365Challenge - Excel Conditional Formatting - Highlighting Cell Rules. Excel has many options when it comes to Conditional Formatting. Today we'll take a look at Highlighting Cell Rules. If you want to highlight certain areas in your spreadsheet - that... Continue Reading →
#Office365Challenge - Excel Removing Duplicates - As most of our data calculation, manipulation and reporting still happens in Excel, it might be necessary to check for and remove duplicates at times. Seeing as Excel can have over a 1,000,000 rows... Continue Reading →
#Office365Challenge - Data Validation in Excel: As much as I love SharePoint, some things still need to happen in Excel. Should you require users to complete certain fields - then Data Validation is for you. This allows you to validate... Continue Reading →
#Office365Challenge - For any SharePoint lover (who like me, cannot code from scratch to save their life), the loss of the Designer View in SharePoint (Designer) 2013 was devastating, to say the least. A bit like the Matrix without the... Continue Reading →
#Office365Challenge - Ever need to change data in Excel displayed as columns to rows? No retyping necessary. This is very easy to accomplish with Paste Special - Transpose. Day: 19 of 365, 346 left Tools: Microsoft Office; Excel 2013 Description:... Continue Reading →
Tracy van der Schyff 