Search

Tracy van der Schyff

Facilitating The Evolution of Human Capabilities

Tag

Excel

Day 327 – Using CONCAT and TEXTJOIN in Microsoft Excel

 #Office365Challenge I've always been a huge fan of data clean-up formulas. LEFT, MID, RIGHT, TRIM, CONCATENATE etc. The January 2016 update had some updates around new functions and data entry. Day:  327 of 365, 38 left Tools:  Office 365, Office 2016, Excel Description: Using... Continue Reading →

Day 228 – Searching entire workbook in Excel

#Office365Challenge By now most of us know that CTRL+F brings up Search in Office. When working with Excel, it's important to know that it will only search the current sheet (by default). Day: 228 of 365, 137 left Tools: Excel Description: Searching... 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 →

Powered by WordPress.com.

Up ↑