Course Summary:
Remote
The introduction of advanced formatting techniques and the analysis tools will enable users to become more efficient spreadsheet users. Topics will include spreadsheet formatting, absolute cell references, the Solver procedure, the Outline procedure which will allow users to hide detail rows in spreadsheets and designing graphs.
Objectives:
- Creation of formulas that will copy the direct reference of a cell, rather than the relative reference
- Calculating a formula backwards, users will learn how to change the value of a cell that is dependent on a formula
- Outlining spreadsheets and using data from spreadsheet to create a graph
- Modifying format of graphs
Recommended Audience: Service Managers & Technicians, Field Supervisors & Personnel, Project Managers, Foremen, Estimators and Clerical Roles. Attendees need to have attended Excel Level 1 or have a working knowledge of the topics covered in Level 1
Instructor
Ginnie
Floraday
Digital Consultant
Ginnie Floraday has consulted and taught technology courses for over two decades. Ginnie’s primary areas of expertise include corporate training and database development in Microsoft Access. She trains and consults remotely and on-site in various platforms, including the Microsoft Office Suite, Blue Beam Revu, and iOS (iPad, iPhone). Ginnie encourages her clients to explore and use the tools in order to build a more comfortable relationship with the software.