Build formulas to add, subtract, multiply, divide, average, and figure percentages. Create different spreadsheets from scratch, learn many tips and shortcuts, as well as Charts!
Create formulas using Absolute Cell References, Order of Operations, etc. Combine data from different worksheets and workbooks. And Data Validation Rules, Condiitional Formatting, and learn Pivot Table basics.
Use Excel Functions to take your skills to the next level.Learn VLookup, If, and dozens of other popular functions. Create basic Macros (VBA is NOT covered in class) and use What If Tools such as Goal Seek and Solver.
