Watch This First
  • Course Intro.
  • A few reminders before we begin
  • COURSE FILES
Jumpstart
  • Jumpstart Overview
  • JUMPSTART NOTE
  • Jumpstart Part 1
  • Jumpstart Part 2
  • Jumpstart Part 2 Filtering Unique Values
  • Jumpstart Part 3
  • Quick Reminder
Getting Acclimated with EXCEL - Foundations
  • Getting Acclimated Section Overview
  • EXCEL User Interface
  • Adding, Deleting, and Editing Data in a Cell
  • Introduction to Keyboard Shortcuts
  • 50 Time Saving Excel Shortcuts
  • Navigation Keyboard Shortcuts
  • Data Selection Keyboard Shortcuts
  • Inserting and Deleting Rows and Columns
  • Auto Fit Row and Column Size
  • Freeze Panes and Split Boxes
  • Formatting Numbers
  • Formatting Cells
  • Grouping and Hiding Rows or Columns
  • Installing EXCEL Add-Ins
  • Quiz #1
Basic EXCEL Formulas & Functions - Foundations
  • Basic Excel Formulas & Functions Section Overview
  • Basic Math Functions in Excel
  • Conditional Math Functions
  • MIN, MAX, and AVERAGE Functions
  • Logical Operators and Functions
  • Anchoring Cell References and Name Ranges
  • Array Functions
  • Quick note about next three lectures
  • Internal Rate of Return (IRR) Functions
  • Net Present Value (NPV) and Cash Multiple
  • Loan Amortization Table
  • Compound Annual Growth Rate (CAGR)
  • Formula Auditing
  • Fill Commands
  • IS Functions
  • Rounding Numbers
  • Quiz #2
Text, Times, and Dates Data Formats - Foundations
  • Text, Times, and Date Data Formats Section Overview
  • Note to EU Students about Date Format
  • How EXCEL Treats Text, Times, and Dates Data
  • Changing the Case of Text
  • Combining Strings of Text Together
  • Cutting Substrings from a Text
  • Using the FIND Function
  • Searching for Specific Text in Data
  • Splitting a Text Field into Multiple Columns
  • Converting Dates from Text into Values
  • Adding and Subtracting Dates
  • Compiling Monthly and Annual Totals
  • Conducting Day of the Week Analysis
  • Combining Date and Time Data
  • Adding and Subtracting Times
  • Conducting Hours of the Day Analysis
Introduction to Statistics in EXCEL - Foundations
  • Introduction Statistics in EXCEL Section Overview
  • Brief Overview of Statistics
  • Mean, Median, & Mode
  • Percentile and PercentileRank
  • Frequency Distributions
  • Standard Deviation and Variance
  • Trends in Data
  • Introduction to Correlation
Handling Data in EXCEL
  • Handling Data Overview
  • Lookup with VLOOKUP
  • Lookup with HLOOKUP
  • Name Arrays for Reuse and Readability
  • Group Records with Nested IF Statements
  • Avoid Errors with IF and ISNUMBER
  • Create Dropdown Lists for Filtering
  • Create Unique Lists
  • Fast Lookup with INDEX and MATCH
  • Multi-Condition Lookup with DSUM
  • Create Rankings with SMALL and LARGE
  • Multi-Condition Lookup with INDEX and MATCH
Pivot Tables
  • Insert a Pivot Table
  • Prepare Data for Pivoting
  • Learn to Pivot a Table
  • Group Rows and Columns
  • Format for Readability
  • Modify Output Values for Insights
  • Insert Calculated Fields
  • Sort, Filter and Slicer
  • Handle New Data in Pivot Tables
Introduction to Charts in Excel
  • Intoduction to Charts in Excel Overview
  • Why Use Charts Anyway?
  • Line Chart
  • Pie Charts