Microsoft Excel – Basic to Intermediate
About Course
Our Basic to Intermediate Excel Training is designed for everyone!
Microsoft Excel is an essential tool and the most popular spreadsheet software across
different job roles and levels worldwide. This class enables you to start from the basics and
build a solid background in Formatting, Analysis, Reporting, and Dash Board Creation.
The course is designed for those with little or no functional knowledge of Excel and those who regularly use Excel at a basic level but wish to enhance their skills. From basic operations to an introduction to more advanced techniques, within 8 weeks, you’ll gain the confidence to navigate the Excel interface, master essential spreadsheet functions, perform calculations, and produce creative charts and graphs from your data while building an aptitude for data analysis that is critical to the success of any organization.
Course Content
INTRODUCTION TO EXCEL (BASIC TO INTERMEDIATE)
-
Getting Started with Excel
35:37 -
Data Cleaning 1
31:14 -
Data Cleaning 2
27:17 -
Working with dates 1
30:38 -
Working with dates 2
20:36 -
Statistics/Conditional Functions and Formulas
32:19 -
Text Functions & Data Separation
22:27 -
Working with Data, Formulas and Functions
37:23 -
Working with Large Worksheets
22:34 -
Conditional formatting & Cell Reference
30:23 -
List Management
34:26 -
Lookup Function
38:48 -
Intro to Pivot table & Charts
36:35 -
Graph in Excel
27:19 -
E-Books
-
Excel Shortcuts
-
Excel Formulas
-
Intro Pivot Table, Slicer & Dashboard 2
01:04:13



