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.
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
Modifying format of graphs
Service Managers & Technicians, Field Supervisors & Personnel, Project Managers, Foremen, Estimators and Clerical Roles
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.