Description

Level 2 of excel skills will include the introduction of advanced formatting techniques and analysis tools that 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. 

1. Advanced Formatting 
   1. Font and background color changes 
   2. Creating borders 
   3. Alignment of labels: displaying labels vertically, at an angle, etc. 
2. Creation of formulas that will copy the direct reference of a cell, rather than the relative reference. This is known as the absolute cell reference. 
3. Solver procedure. Calculating a formula backwards. Users will learn how to change the value of a cell that is dependent on a formula. 
4. Outlining spreadsheets. Similar to hiding columns and rows, but done automatically by the computer 
5. Using data from spreadsheet to create a graph a)Modifying format of graphs.

Ginnie Floraday has consulted and taught technology courses for over two decades. Floraday’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). Floraday encourages her clients to explore and use the tools in order to build a more comfortable relationship with the software.