Intro to Excel

Last Update August 23, 2023
1 already enrolled

About This Course

This Introduction to MS Excel course will help you develop a thorough understanding of MS Excel and explore its abundant features. You will learn how to write functions; sort, filter, and import data and much more. Learn MS Excel and explore various functions and formulas that you can leverage on MS Excel to track and manage and track data-driven projects.

Learning Objectives

Excel Sort and Filter
Excel Dashboard
Functions in Excel
Conditional formatting
Data Validation
Pivot Tables and Charts
Data Analysis in Excel
Macros and VBA


  • There are no prerequisites to learn MS Excel.


115 Lessons

Formulas and Functions

Exploring audit tools to examine and evaluate formulas00:00
Constructing common functions with the aid of the function wizard and the Formula tab00:00
Implementing names in formulas and functions00:00

Worksheet Formatting and Presentation

Getting Data In and Out

Sorting, Selecting and Subtotaling data

6: Present Data Visually

Introducing Advanced Features

Working with Data

Creating and Working with PivotTables

Enhancing PivotTables

Creating Advanced Formulas

Use Specialized Functions

Working with Multiple Worksheets and Workbooks

Automating Workbook Functionality

Analyzing Data with Logical and Lookup Functions Use Text Functions

Use Logical Functions

Use Lookup Functions

Use Date Functions

Use Financial Functions

Organizing Worksheet Data with Tables Create and Modify Tables

Sort and Filter Data

Use Subtotal and Database Functions to Calculate Data

Visualizing Data with Charts

Modify and Format Charts

Excel Table

This module explains how to create data tables in Excel

: Pivot Tables and Pivot Charts

This module describes pivot tables and pivot charts and how to work with them.


This module describes Excel dashboards, how to create them and the role in data analysis in Excel pivot tables.

: Hierarchies

This module describes hierarchies and time data.

: The Excel Data Mode

This module explores the Excel data model and looks at ways of extending it.
115 lectures
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
  • Attributes
  • Custom attributes
  • Custom fields
Click outside to hide the comparison bar