#Office365Challenge Excel allows you to set the minutes between AutoRecover saves - and also gives you the AutoRecover Location in case you've never saved that file before. Day: 166 of 365, 199 left Tools: Microsoft Office Excel Description: Excel AutoRecover File... Continue Reading →
#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 →
Tracy van der Schyff 