Microsoft Excel Essentials

Introduction

Microsoft Excel is a powerful yet user-friendly spreadsheet software. In this course, you will learn how to input and organize data, use functions to perform calculations, format the appearance of your data and cells, and build stunning charts and PivotTables.

Furthermore, powerful functions such as IF, VLOOKUP, and COUNTIF are taught in this in-depth course, along with Data Analysis tools such as Goal Seek and Solver. Finally, simple automation with macros are taught.

Course Outline

  1. Introduction to Excel
    • Understanding Excel
    • Excel Navigation and Workspace
  1. Entering Data in Excel
    • Data entry and editing
    • Autofill function
    • Working with different data formats
    • Comments
  1. Functions and Formulas
    • Simple formulas in Excel
    • Copying formulas
    • Relative, absolute and mixed references
    • Common functions
  1. Formatting
    • Fonts
    • Cells
    • Borders
    • Formatting numbers and dates
    • Conditional formatting
    • Introduction to tables
    • Creating and editing tables
    • Inserting shapes and objects
  1. Worksheet layout and data
    • Inserting and deleting rows / columns
    • Hiding and unhiding rows / columns
    • Move, copy and insert data
    • Find and replace tool
  1. Printing
    • Page layout and page breaks
    • Print preview
    • Page setup and print control
  1. Charts
    • Creating charts
    • Styling and formatting charts
    • Chart elements
    • Sparklines
  1. Viewing Worksheets
    • Freeze and unfreeze panes
    • Split screens
    • Outline view
  1. Viewing Worksheets
    • IF function
    • VLOOKUP function
    • COUNTIF function
    • More functions
  1. Worksheet Security
    • Locking and unlocking cells
    • Worksheet protection
    • Setting passwords
    • Sharing workbooks and tracking changes
  1. Data Management
    • Sorting data
    • Using subtotals
    • Using filters
    • Flash fill
    • Removing duplicates
    • Validation tools
  1. Data Analysis
    • Goal Seek tool
    • Solver tool
    • Scenario Manager tool
    • Data tables
  1. PivotTables
    • Creating PivotTables
    • Manipulating PivotTables
    • Grouping PivotTables
    • Slicers
    • PivotCharts
  1. Macros
    • Understanding macros
    • Creating macros
    • Running macros