Course Overview
  • Course Overview
Excel Basics
  • Introduction to Excel Basics
  • Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon
  • Using Excel Templates to Save Time and Effort
  • Saving Your Document Where You Can Find It
  • Entering Data and Navagating Around the Cells
  • Creating Simple Formulas to do Powerful Calculations
  • Working with Workbooks and Worksheets
  • Print Your Work
  • Put Your Knowledge to Work - Create Your First Excel Document
  • Review of Excel Basics
Create Your First Excel Spreadsheet From Scratch
  • Introduction - Creating and Formatting Your Heading
  • Formatting Subheadings and Columns, and Alphabetizings Lists
  • Entering and Formatting Numbers
  • Create Formulas to Quickly Calculate Your Costs
  • Formatting - Grids and Spacing
  • Review of Creating Your First Spreadsheet
Charts - How to Create Bar, Column and Pie Charts
  • Introduction - How to Create a Chart
  • Format Your Chart
  • Download for the Next 3 Chart Lectures
  • Create a Bar Chart
  • Create a Pie Chart
  • Create a Line Chart
  • Review of How to Create Charts
Introduction to Excel Formulas and Functions
  • What is a Formula?
  • What is a Function?
  • The Anatomy of a Formula
  • How to Quickly Select Cells to Use in Your Formula
  • Absolute vs. Relative Cell References
  • Review of Introduction to Formulas and Functions
Top 50 Excel Formulas
  • Introduction to Excel Formulas and Vlookup with Bryan
  • Download this Exercise File
  • Quick Tips to Master These Formulas
Text Formulas
  • TEXT: Concatenate Formula
  • TEXT: Find Formula
  • TEXT: Left Formula
  • TEXT: Len Formula
  • TEXT: Lower Formula
  • TEXT: Mid Formula
  • TEXT: Proper Formula
  • TEXT: Rept Formula
  • TEXT: Substitute Formula
  • TEXT: Trim Formula
  • TEXT: Upper Formula
  • TEXT: Value Formula
Mathematical Formulas
  • MATHEMATICAL: Average Formula
  • MATHEMATICAL: Int Formula
  • MATHEMATICAL: Mod Formula
  • MATHEMATICAL: Rand Formula
  • MATHEMATICAL: Round Formula
  • MATHEMATICAL: Sum Formula
Date and Time Formulas
  • DATE AND TIME: Day Formula
  • DATE AND TIME: Hour Formula
  • DATE AND TIME: Minute Formula
  • DATE AND TIME: Month Formula
  • DATE AND TIME: Networkdays Formula
  • DATE AND TIME: Now Formula
  • DATE AND TIME: Second Formula
  • DATE AND TIME: Today Formula
  • DATE AND TIME: Weekday Formula
  • DATE AND TIME: Year Formula
Logic Formulas
  • LOGIC: And Formula
  • LOGIC: Countblank Formula
  • LOGIC: Countif Formula
  • LOGIC: If Formula
  • LOGIC: Large Formula
  • LOGIC: Max Formula
  • LOGIC: Min Formula
  • LOGIC: Not Formula
  • LOGIC: Or Formula
  • LOGIC: Small Formula
  • LOGIC: Sumif Formula
  • LOGIC: Vlookup Formula
Financial Formulas
  • FINANCIAL: Fv Formula
  • FINANCIAL: Npv Formula
  • FINANCIAL: Pmt Formula
  • FINANCIAL: Ppmt Formula
Informational Formulas
  • INFORMATIONAL: Column Formula
  • INFORMATIONAL: Isblank Formula
  • INFORMATIONAL: Iserror Formula
  • INFORMATIONAL: Isnumber Formula
  • INFORMATIONAL: Istext Formula
  • INFORMATIONAL: Row Formula
  • Excel Formula Review
VLOOKUP Deep Dive
  • Download this Exercise File
  • Menu Example
  • Comparing Lists