Spreadsheets are at the core of a huge percentage of the businesses in the world - and the effective construction and use of these files makes the business run more effectively, and the technician more valuable.
In this session, we will address the skills and best practices every prospective user of Excel should have in their toolbox. This includes laying out and entering data, using shortcuts to move quickly across a worksheet, and essential calculation and reporting tools.
Learn to use keyboard skills to navigate, select and edit spreadsheets
Discover Excel Tables for dynamic named references
Use Absolute and Relative References in calculations
Accurately build functions and formulas for reporting
Learn to sort and filter data based on multiple criteria