Search

Tracy van der Schyff

Facilitating The Evolution of Human Capabilities

Tag

2016Week32

Day 167 Modern Lists in SharePoint

#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 →

Day 166 Excel AutoRecover File Location

#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 →

Day 165 Hidden Treasures in Excel

#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 →

Day 164 HLOOKUP Formula in Excel

#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 →

Day 163 VLOOKUP Formula in Excel

#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 →

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 →

Powered by WordPress.com.

Up ↑