Home - Excel - Word - PowerPoint

OBJECTIVE(S) WORKBOOK TYPE(S)
  • Create, Save, and Navigate an Excel Workbook
  • Enter Data in a Worksheet
  • Construct and Copy Formulas and Use the SUM Function
  • Format Cells with Merge & Center, Cell Styles, and Themes
  • Chart Data to Create a Column Chart and Insert Sparklines
  • Print a Worksheet, Display Formulas, and Close Excel
Sales Report with Embedded Column Chart and Sparklines
  • Check Spelling in a Worksheet
  • Enter Data by Range
  • Construct Formulas for Mathematical Operations
  • Edit Values in a Worksheet
  • Format a Worksheet
Inventory Valuation
  • Use Flash Fill and the SUM, AVERAGE, MEDIAN, MIN, and MAX Functions
  • Move Data, Resolve Error Messages, and Rotate Text
  • Use COUNTIF and IF Functions and Apply Conditional Formatting
  • Use Date & Time Functions and Freeze Panes
  • Create, Sort, and Filter an Excel Table
  • View, Format, and Print a Large Worksheet
Inventory Status Report
  • Use Flash Fill and the SUM, AVERAGE, MEDIAN, MIN, and MAX Functions
  • Move Data, Resolve Error Messages, and Rotate Text
  • Use COUNTIF and IF Functions and Apply Conditional Formatting
  • Use Date & Time Functions and Freeze Panes
  • Create, Sort, and Filter an Excel Table
  • View, Format, and Print a Large Worksheet
Weekly Sales Summary
  • Chart Data with a Pie Chart
  • Format a Pie Chart
  • Edit a Workbook and Update a Chart
  • Use Goal Seek to Perform What-If Analysis
Enterprise Fund Pie Chart
  • Design a Worksheet for What-If Analysis
  • Answer What-If Questions by Changing Values in a Worksheet
  • Chart Data with a Line Chart
Tourism Spending Projection with Line Chart
  • Use Financial Functions
  • Use Goal Seek
  • Create a Data Table
  • Use Defined Names in a Formula
Amortization Schedule and Merchandise Costs
  • Use Lookup Functions
  • Validate Data
  • Audit Worksheet Formulas
  • Use the Watch Window to Monitor Cell Values
Lookup Form and Revenue Report
  • Navigate and Manage Large Worksheets
  • Enhance Worksheets with Themes and Styles
  • Format a Worksheet to Share with Others
  • Save Excel Data in Other File Formats
Class Schedule
  • Use Advanced Sort Techniques
  • Use Custom and Advanced Filters
  • Subtotal, Outline, and Group a List of Data
Fall Sections
  • Create and Format Sparklines and a Column Chart
  • Create and Format a Line Chart
  • Create and Modify a SmartArt Graphic
  • Create and Modify an Organization Chart
Attendance Charts and Diagrams
  • Create an Excel Template
  • Protect a Worksheet
  • Create a Worksheet Based on a Template
Order Form Template