Office365 Tips & Tricks for using Excel

Office365 Tips and Tricks for using Excel - Workshop Takeaways

October 15, 2019: 9:40 am – 10:40 am


Presented by Martin Heck, Solutions Architect, Information & Technology Solutions and TJ Tremblay, Manager, IT Service Management, Information & Technology Solutions

Session Overview: Framed within the context of the larger Office365 environment, this general workshop will focus on giving Mines Staff some tangible tips, tricks, and skills to better use Microsoft Excel at work. The session will highlight content on 3 specific SkillSoft tutorials so attendees may leave with online resources directly tied to the material covered in class.
Highlights include:
+See how to retrieve, combine and separate data
+Automate and simplify calculations
+Share your documents via email or upload them to OneDrive to collaborate with your team.
+Stay in the loop with document comments, and the version history and track changes tools.
+Discover absolute and relative cell references, using data across multiple worksheets, and formula auditing

 

Sample File: 

AFC_ProfDevSession_Excel365_SampleFile.xlsx:

SHARED Version Using OneDrive: https://mines0-my.sharepoint.com/:x:/g/personal/tjtremblay_mines_edu/Ef8n2jjE975Hi0bvNFSZoL4BYRedhlH4PfQWjKJpdsCCAw?e=nOJU5V

 

Links to SkillSoft tutorials:

Excel 2019 for Windows: Sharing & Collaborating on a Documenthttps://mines.skillport.com/skillportfe/main.action#summary/COURSES/CDE$100653:_ss_cca:ds_msex2019_07_enus

Excel 2019: Finding & Analyzing Information with Formulashttps://mines.skillport.com/skillportfe/main.action#summary/COURSES/CDE$112799:_ss_cca:ds_msex2019_19_enus

Excel 2019: Referencing Datahttps://mines.skillport.com/skillportfe/main.action#summary/COURSES/CDE$111497:_ss_cca:ds_msex2019_11_enus

Details

Article ID: 89217
Created
Sat 10/12/19 4:27 PM
Modified
Tue 10/15/19 9:00 AM

Files (2)