Excel Intermediate

This course is designed for Excel users who are ready to move beyond the basics and take advantage of intermediate-level features like Linking, Consolidation, 3D formulas, and Absolute Cell References to create more complex formulas. You’ll also learn how to use other tools like Pivot Tables & Pivot Charts to analyze large spreadsheets, and how to apply multiple sorts & filters, group & outline data, and more. Use Conditional Formatting to make important values stand out (make negative numbers turn red or change the background/fill color of a cell based on a value). Password Protect a workbook to prevent unauthorized changes to specific areas of a spreadsheet.

Topics Covered:

• Create more complex formulas
• Formula Syntax (proper use of special characters in formulas)
• Absolute Cell References (lock in an address so it won’t change)
• Order of Operations (control the order of math operations)
• 3-D Formulas (combine data from different worksheets)
• Link workbooks (dynamic link between files so they instantly update)
• Consolidate worksheets or workbooks
• Data Validation (set limits on data entry)
• Deep Dive into Pivot Tables & Pivot Charts (summarize large spreadsheets)
• Create a Pivot Table / Pivot Chart Dashboard (interactive main menu)
• Group and Outline data
• Sub-Total data
• Multiple Sorts and Filters
• Subtotal data
• Formula Auditing (resolve errors, view the relationship between cells, etc.)
• Templates
• Conditional Formatting (use color to make important values stand out)
• Password Protect all or part of a workbook