#Office365Challenge Beginning of August the new "modern look" list features were rolled out to First Release Tenants. Join me as we take at look at what has changed, what is better and what they still need to work on a... Continue Reading →
#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 →