Microsoft Excel Intermediate

Module 1: Referencing Calculations

Topic A: Formula Reference

• Relative References
• Absolute References
• Mixed References

Module 2: Working with Functions

Topic A: Data Summary with Function

• COUNTA
• AVERAGEA

Topic B: Conditional Data Summary 1

• COUNTIF
• AVERAGEIF
• SUMIF

Topic C: Conditional Data Extraction

• IFERROR
• IF

Module 3: Organizing Dynamic Data Range with Tables

Topic A: Create and Modify Tables

• Create table
• Styles and Quick Style Sets
• Removing Duplicate Values

Topic B: Sort and Filter Data

• Sorting Data
• Filtering Data
• Advanced Filtering

Topic C: Use Subtotal to Calculate Data

• Total Row with SubTotal Functions

Module 4: Visualizing Data as a Graphics

Topic A: Conditional Formatting

• Highlight Cell Rules
• Using Data Bars
• Using Icon Sets
• Creating New Rules with Formula

Topic B: Create Charts

• Charts
• Chart Types
• Chart Insertion Methods
• Resizing and Moving the Chart
• Adding Additional Data
• Switching Between Rows and Columns

Topic C: Modify and Format Charts

• Difference Between Modifying and Formatting
• Chart Elements
• Minimize Extraneous Chart Elements
• The Chart Tools Contextual Tabs
• Formatting the Chart with a Style
• Adding a Legend to the Chart

Module 5: Setting Up Reports as Pages

Topic A: Managing Multiple Windows

• Arranging Workbooks
• Comparing Workbooks Side by Side
• Synchronous Scrolling and Resetting a Windows