Course curriculum

  1. 1

    • Course Instructions

    • Course File 1

    • 1.1 Starting Excel

    • 1.2 Understanding Excel Interface

    • 1.3 Getting Familiar with The Excel Workbook and Worksheets

    • 1.4 Explaining the Ribbon

    • 1.5 Saving an Excel File
  2. 2

    • 2.1 Combined What you can enter in a cell

    • 2.2 Relative and Absolute Cell Referencing

    • 2.3 Entering Formula

    • 2.4 Order of Operations

    • 2.5 Date Serial Numbers
  3. 3

    • 3.1 Copy and Drag

    • 3.2 Working with rows and columns

    • 3.3 Working with sheets
  4. 4

    • 4.1 Functions

    • 4.2 SUM Function

    • 4.3 Copy and Drag Formula

    • 4.4 more basic functions

    • 4.5 Named Ranges

    • 4.6 Names Constants and Formula

    • 4.7 Shortcuts

    • 4.8 More Shortcuts
  5. 5

    • Course File 2

    • 5.1 Formatting Font

    • 5.2 Formatting Alignment

    • 5.3 Formatting Borders

    • 5.4 Formatting Numbers

    • 5.5 Conditional Formatting PreConfigured

    • 5.6 Conditional Formatting with Formula

    • 5.7 Conditional Formatting Dialogue Box Formula Trick
  6. 6

    • 6.1 Icons Shapes and Formatting

    • 6.2 Printing Page Layout

    • 6.3 Printing Headers Footers
  7. 7

    • 7.1 Data Sort

    • 7.2 Filtering

    • 7.3 Tables

    • 7.4 Text to Columns

    • 7.5 Flash Fill

    • 7.6 Data Validation

    • 7.7 Group and Outline

    • 7.8 Freeze Panes
  8. 8

    • 8.1 Relative and Absolute Referencing

    • 8.2 VLOOKUP

    • 8.3 Index Match

    • 8.4 IF

    • 8.5 Nested If

    • 8.6 Countif Countifs

    • 8.7 SUMIF SUMIFS

    • 8.8 LEN

    • 8.9 RIGHT LEFT MID

    • 8.10 SEARCH

    • 8.11 Common Error Types

    • 8.12 IFERROR
  9. 9

    • 9.1 Chart Basics

    • 9.2 Chart Series and Column Charts

    • 9.3 Bar Charts

    • 9.4 Pie Charts

    • 9.5 Composite Charts
  10. 10

    • 10.1 Power Query Intro

    • 10.2 Power Query Consolidation

    • 10.3 Pivot Tables

    • 10.4 Setting up a Pivot Table

    • 10.5 Pivot Table Field Settings

    • 10.6 Pivot Table Calculated Fields

    • 10.7 Pivot Table Groupings

    • 10.8 Pivot Table Slicers and Timelines

    • 10.9.1 Dashboards Part 1

    • 10.9.2 Dashboards Part 2
  11. 11

    • 11.1 What is a macro

    • 11.2 Recording a Macro

    • 11.3 Relative and Absolute Macros
  12. 12

    • 12.1 Introduction to VBE

    • 12.2 Object Model

    • 12.3 Module Worksheets Classes

    • 12.4 Variables and Constants

    • 12.5 vba Formatting

    • 12.6a If Statement

    • 12.6b Select Case

    • 12.7a For Loop

    • 12.7b DoWhile DoUntil Loop

    • 12.7c ForEach Loop

    • 12.8a Errors

    • 12.8b Errors

    • 12.9 Consolidate

What Our Students Think

5 star rating

Fast and Easy!

Brice SONE

Learning is fun when any subject matter is delivered in the most basic and comprehensible way. That's my candid experience so far with Earn and Excel. I am e...

Read More

Learning is fun when any subject matter is delivered in the most basic and comprehensible way. That's my candid experience so far with Earn and Excel. I am exceling in my understanding and usage of Excel as a work tool and much more.

Read Less