Course curriculum

  • 1

    Getting Started with Excel 2016

    • Intro to the Excel Screen

    • The Quick Access Toolbar (QAT) and Top of Screen

    • Introducing the Ribbon

    • File Backstage View

    • Microsoft Excel Help and Tell Me

    • Horizontal and Vertical Bars

    • Name Box and Formula Bar

    • Tour-Zoom-WorksheetViews-StatusBar

    • WorkbooksVsWorksheets

    • Quiz - Getting Started with Excel

  • 2

    Creating and Saving Workbooks

    • Open Excel and Create A New File

    • Create New Based Workbook Based On An Existing One

    • Create a New Workbook Based on a Template

    • Create Your Own Excel Template

    • Saving and Closing a Workbook the First Time

    • Saving an Existing Workbook

    • Quiz - Creating and Saving Workbooks

  • 3

    Navigating Excel Worksheets

    • Quiz - Navigating Excel Worksheets

    • Selecting and Resizing Rows and Columns

    • Navigating Excel Using the Keyboard

  • 4

    Entering and Editing Data & Formulas

    • Data Entry Into One Cell

    • Data Entry Into Multiple Cells

    • Mouse-Indicators

    • Cut, Copy & Paste - Using the Clipboard

    • The Office Clipboard is Great

    • Copying and Pasting Values

    • Copying and Pasting Links

    • How to Cut or Copy Part of a Cell

    • Creating Basic Formulas

    • Editing Formulas

    • Autofill

    • AutoFill Dates and Sequences

    • Editing Cell Values

    • Quiz - Entering and Editing Data and Formulas

  • 5

    Introduction to Functions

    • Intro to Excel Functions: SUM

      FREE PREVIEW
    • AutoSum and SUM Functions

    • Count and CountA Functions

    • Date Functions: Now, Today, Static Date & Time

    • Excel Functions: Order of Operations

    • AutoSum and Max Functions | Combining Functions

    • AutoSum Function: Average | Editing Functions

    • Absolute vs. Relative References (aka Locking Function References)

    • Quiz - Introduction to Functions

  • 6

    Formatting Numbers, Text, etc.

    • Text and Font Formatting

    • Number Formatting

    • Borders

    • Shading and Filling Cells

    • Inserting and Deleting Rows, Columns, Cells

    • Hide and Unhide Columns and Rows

    • Resize Columns & Rows | Wrap Text

    • Built-in Cell Styles

    • Custom Cell Styles

    • How to Copy & Share Custom Styles

    • Introduction to Themes

    • Mix & Match Themes

    • Cell Alignment and Orientation | Rotate Cells Up

    • Align, Merge and Center Styles

  • 7

    Headers & Footers

    • Intro to Headers & Footers

    • Inserting Headers & Footers in Page Layout View

    • More on Headers & Footers

    • Adding Pictures to Headers & Footers

  • 8

    Printing Worksheets

    • Find and Replace | Using Wildcards

    • Print Preview | Page Options

    • Setting a Print Area

    • Creating Print Titles

    • Working with Page Breaks

  • 9

    Working with Multiple Worksheets & Workbooks

    • Copying Worksheets

    • From Multiple to 1

    • Rename and Select Multiple Sheets

    • Freeze Panes

    • Move and Insert Sheets

    • Sync Scrolling through Multiple Sheets

  • 10

    Sorting & Filtering

    • Sorting - Setting Up Your Data

    • Basic & Advanced Sort

    • Applying Basic Filters

    • Filters Based on Colors

    • Filters: Text and Custom

    • Filter: Date Filters

    • Filters: Number Filters

  • 11

    Outlining and Subtotaling

    • Creating Auto Outlines

    • Single Subtotals

    • Multiple Subtotals

  • 12

    Pictures & Images

    • Insert Pictures from Online Sources

    • Moving, Resizing and Compressing Pictures

    • Inserting and Formatting Pictures

    • Inserting Worksheet Pictures

  • 13

    Charts

    • Creating a Chart Manually

    • Selecting Data - Manual Charts

    • Creating a Chart Using a Shortcut

    • Editing Charts

    • Changing Chart Colors

  • 14

    Links & Hyperlinks

    • Inspecting and Updating External Links

    • Creating & Editing Hyperlinks

    • Creating & Using Internal Links in Formulas

  • 15

    Commenting in Workbooks

    • Viewing Comments

    • Inserting, Editing, Deleting and Copying Comments

    • Copying and Pasting Comments

  • 16

    Protecting Worksheet, Workbooks & Cell Ranges

    • Cells Protection

    • Protecting Cells & Hiding Formulas

    • Protection: 2 Methods

    • Protecting a Workbook's Structure

    • Protect-Sheet-With-Password

Liquid error: internal