Course Overview
This 3-day intensive boot camp for beginners is designed to take you from the absolute basics of Microsoft Excel navigation and data entry all the way to mastering advanced, real-world applications.
course outline
Day 1: Microsoft Excel Fundamentals
-
- Getting Started with Microsoft Excel
- Performing Calculations
- Modifying a Worksheet
- Formatting a Worksheet
- Printing Workbook Contents
- Managing Large Workbooks
Day 2: Microsoft Excel Intermediate
-
- Working with Functions
- Working with Lists
- Analysing Data
- Visualising Data with Charts
- Using PivotTables and PivotCharts
Day 3: Microsoft Excel Advanced
-
- Working with Multiple Worksheets and Workbooks
- Using Lookup Functions and Formula Auditing
- Sharing and Protecting Workbooks
- Automating Workbook Functionality
- Creating Sparklines and Mapping Data
- Forecasting Data
In this 1-day course, you will learn the basics of Microsoft Excel and take the first step on your journey to becoming an Excel expert!
Learning outcomes
Getting Started with Microsoft Excel
-
Navigate the Excel User Interface
-
Use Excel Commands
-
Creating and Save a Basic Workbook
-
Enter Cell Data
-
Use Excel Help
Performing Calculations
-
Creating Formulas in a Worksheet
-
Insert Functions in a Worksheet
-
Reuse Formula
Modifying a Worksheet
-
Manipulate Data
-
Insert, Manipulate, and Delete Cells, Columns, and Rows
-
Search for and Replace Data
-
Use Proofing and Research Tools
Formatting a Worksheet
-
Modify Fonts
-
Add Borders and Color to Cells
-
Apply Number Formats
-
Align Cell Contents
-
Apply Cell Styles and Themes
-
Apply Basic conditional formatting
-
Create and Use Templates
Printing Workbook Contents
-
Preview and Print a Workbook
-
Define the Page Layout
Managing Large Workbooks
-
Manage Worksheets
-
Manage the View of Worksheets and Workbooks
-
Manage Workbook Properties
