Search

Tracy van der Schyff

Facilitating The Evolution of Human Capabilities

Open Search
Category

Excel

Day 65 – Text Case conversion in Word

#Office365Challenge - Text Case conversion in Word is fairly easy using the Text Case menu. The same can be achieved in Excel by using these functions : =Upper(Cell), =Lower(Cell) or =Proper(Cell). I have to admit...... It's easier in Word (never... Continue Reading →

0

Day 51 – SmartArt in Microsoft Office

#Office365Challenge - SmartArt was introduced to the Office Suite in 2007. I don't see a lot of people using it, so that must mean that not a lot of people know about it. SmartArt is used to insert "prepopulated" template... Continue Reading →

0

Day 44 – Excel / SharePoint Formulas using Commas or Semicolons

#Office365Challenge - Today's post is not so much an awesome thing about Excel / SharePoint / Office 365, but definitely something I think you should know. This post is dedicated to Anne Williams for reminding me to chat about this.... Continue Reading →

7

Day 43 – Auto Fill in Excel

#Office365Challenge - One of the options in Excel that I use often is Auto Fill. Auto Fill can be used to complete lists like Days of the Week, Months, Years, Series etc. This means that you only have to complete... Continue Reading →

0

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

Up ↑