Search

Tracy van der Schyff

Facilitating The Evolution of Human Capabilities

Open Search
Category

Office 365

Day 37 – Pin or Unpin the Office Ribbon

#Office365Challenge - Office ribbon - how to pin or unpin (into place). Day: 37 of 365, 328 left Tools: Excel Description: How to Pin/Unpin the Office Ribbon Even thought the Office Ribbon is pretty awesome if you ask me -... Continue Reading →

1

Day 36 – Data Bars, Colours Scales and Icon Sets in Excel

#Office365Challenge - Excel Conditional Formatting - Data Bars, Colour Scales and Icon Sets. This is the third post dealing with Conditional Formatting in Excel. An extremely underrated, underused functionality. Day: 36 of 365, 329 left Tools: Excel Description: Data Bars,... Continue Reading →

1

Day 35 – Excel Top to Bottom Rules

#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 →

1

Day 34 – Highlight Cell Rules in Excel

#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 →

2

Day 33 – Removing duplicates in Excel

#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 →

1

Day 32 – Data Validation in Excel

#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 →

0

Up ↑