Search

Tracy van der Schyff

Facilitating The Evolution of Human Capabilities

Tag

Excel

Day 162 Data Clean-up in Excel – TRIM formula

#Office365Challenge The next couple of posts will be all about the various functions available in Excel to help you clean data you've received from other sources etc. Today we'll take a look at using TRIM to remove unnecessary spaces. Day:... Continue Reading →

Day 161 Data Clean-up in Excel – Left Mid and Right + Search & LEN

#Office365Challenge The next couple of posts will be all about the various functions available in Excel to help you clean data you've received from other sources etc. Today we'll take a look at the Left, Mid and Right Function with... Continue Reading →

Day 160 Data Clean-up in Excel – Left Mid and Right

#Office365Challenge The next couple of posts will be all about the various functions available in Excel to help you clean data you've received from other sources etc. Today we'll take a look at the Left, Mid and Right Function which... Continue Reading →

Day 159 Data Clean-up in Excel – Concatenate

#Office365Challenge The next couple of posts will be all about the various functions available in Excel to help you clean data you've received from other sources etc. Today we'll take a look at the Concatenate Formula. Day: 159 of 365,... Continue Reading →

Day 146 Change the case of text in Excel

#Office365Challenge - I must admit, when I see spreadsheets or documents typed in All Caps, I get a little bit annoyed. I always say people typing in CAPS only, do it because they're lazy (excusing when the process actually calls for... Continue Reading →

Day 142 Speak Cells in Excel

#Office365Challenge - Did you know that Excel can read cells to you so you can proofread it? Well, neither did I. Picked this cool tip up today from a friend Corrie, thanks cupcake!! Day: 142 of 365, 223 left Tools:... Continue Reading →

Up ↑