#Office365Challenge When the ribbon appeared in Office 2007, we were suddenly flooded with many commands in Excel, we didn't even know existed. 9 Years later and we still don't use many of them - I know. Today I'll show you... Continue Reading →
#Office365Challenge HLOOKUPS are used to retrieve data from other tables or ranges horizontally. A common field is needed to match and return stated values. Day: 164 of 365, 201 left Tools: Microsoft Office Excel Description: Using HLOOKUP in Excel In... Continue Reading →
#Office365Challenge VLOOKUPS are used to retrieve data from other tables or ranges by row. A common field is needed to match and return stated values. Day: 163 of 365, 202 left Tools: Microsoft Office Excel Description: Using VLOOKUP in Excel... Continue Reading →
#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 →
#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 →
#Office365Challenge - I love and use the Windows Button on my keyboard SO much, that I have a tattoo of it. Ok, I'm kidding - but I could - and that would be totally cool!! I'm considering painting it on... Continue Reading →
Tracy van der Schyff 