The Excel Spreadsheet Workshop 2015 is a course dedicated to professionals who want exposure to many of the tools and features available in Microsoft Excel.
The Excel Spreadsheet Workshop 2015 covers topics such as:
- Creating Charts and using other visual features
- Essential shortcuts and tips
- Formula auditing tools
- Creating formulas and functions
- Using the powerful IF and VLOOKUP functions
- Mastering AutoSum and 3-D formulas
- Sorting, filtering, subtotals, and other critical data management tools
- Creating powerful summaries and analysis with PivotTables
- Creating and running macros
- Analyzing data with Goal Seek and Solver