Search

Tracy van der Schyff

Facilitating The Evolution of Human Capabilities

Category

Excel

Day 328 – Open and Edit SVG files in Microsoft Office

 #Office365Challenge I'm a sucker for doing crazy design stuff in PowerPoint, and when Microsoft adds functionality to do even more - I'm super happy. Today we'll take a look at working with SVG files in Office. Day:  328 of 365, 37 left... Continue Reading →

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 306 – 7 New Year’s Resolutions with Office 365

#Office365Challenge This blog is dedicated to everyone out there who wants to do better and do it faster - see what Microsoft has to offer you, to achieve more. Day: 306 of 365, 59 left Tools: Office 365 Description: Skype for business... 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 →

Up ↑