Course Information
  • Welcome
  • Academic Discounts & Student Pricing
  • MS Office Versions & MS Office 365
  • Video Settings
  • Locating Files Used In Course
  • Section 1 Review
Quick Start
  • Introduction To Excel
  • Relative References
  • Absolute References
  • Functions
  • Charts
  • Calculating Your Grade
  • Copying Data From The Web
  • Gathering Data With Online Forms
  • Section 2 Review
Getting Started
  • Introduction To Excel
  • Mouse Pointer Awareness
  • Writing Formulas
  • Relative, Absolute, and Mixed References
  • Section 3 Review
Working With Functions
  • Introduction to Functions
  • Payment Functions and Loans
  • Create A Loan Amortization Schedule
  • Future Value Functions & Pensions
  • Investment Amortization
  • Gradebook & VLookup
  • The "IF" Function
  • Conditional Formatting
  • The "IfError" Function
  • Section 4 Review
Creating Charts & Graphs
  • Introduction to Charts (graphs)
  • The Basics of Creating Charts
  • Chart Types
  • Creating Charts - Pie Chart
  • Creating Charts - Line Chart
  • Creating Charts - Column Chart
  • Creating Charts - Bar Chart
  • Creating Charts - Sparklines
  • Creating Charts - Scatter Charts
  • Creating Charts - Area Stacked Chart
  • Creating Charts - Combo Chart (AWESOME!!!)
  • Creating Charts - Troubleshooting Charts
  • Creating Charts - Pivot Charts
  • Section 5 Review
Working With Data
  • Introduction to Data
  • Data & Excel - Google Adwords Example
  • Extracting Data From The Web
  • Sorting Data
  • Filtering Data
  • Removing Duplicates
  • Transposing Data
  • Freeze Panes
  • Subtotaling Data
  • Data Tables
  • Section 6 Review
Going Pro With Pivot Tables
  • Introduction to Pivot Tables
  • Creating Pivot Tables
  • Refreshing Pivot Tables
  • Pivot Table Examples
  • Pivot Table Grouping
  • Pivot Charts & Slicers
  • Section 7 Review
Formatting For Impact
  • Intro to Formatting
  • Content & Form
  • Saving Time With Templates
  • Right-Clicking for Formatting
  • Border & Fill
  • Predefined Styles
  • Formatting Tour
  • Inserting & Formatting Images
  • Inserting Media
  • Arrows, Circles, & Shapes
  • Textboxes & Hyperlinks
  • Word Art
  • Home Ribbon Formatting
  • You Are Amazing
  • Section 8 Review
Printing
  • Printing Introduction
  • Page Layout
  • Page Setup
  • Headers, Footers & Page Numbers
  • Scaling Content
  • Section 9 Review
Excel Errata
  • Macros
  • Not Creating A Macro
  • Macros Illustrated
  • Securing Workbooks
  • Locking & Securing Worksheets
  • Integrating Word & Excel
  • Section 10 Review