Excel Full Course Tutorial - From Basics to Advanced (4+ Hours)

Overview

Embark on a comprehensive 4.5-hour journey through Microsoft Excel, designed for both beginners and experienced users looking to enhance their skills. Learn to navigate the Excel interface, perform calculations with formulas and functions, and master data organization techniques. Explore advanced features like sorting, filtering, and creating dynamic charts and pivot tables. Dive into XLOOKUP, database functions, and macros to automate tasks. Gain practical knowledge on data validation, conditional formatting, and VBA coding for Excel. By the end of this tutorial, you'll be equipped with the tools to efficiently analyze data, create insightful visualizations, and streamline your spreadsheet workflows.

Syllabus

Start
Introduction
What is Excel?
Excel Interface Overview
Search and Help
Navigating and Selecting Cells
Entering, Replacing, and Deleting Data
Adjusting Cells
Calculations, Formulas, and Functions
Basic Functions
AutoFill
Relative and Absolute Cell Reference
Saving and Sharing Workbooks
Comments
Inserting Rows and Columns
Cut, Copy, and Paste
Formatting Data with Cell Styles
Managing Worksheets
Hiding Row and Columns
Creating Custom Views
Reviewing Worksheets
Printing Worksheets
Conclusion
Introduction
Creating Tables
Flash Fill
Introduction to Sorting Data
SORT Function
SORTBY Function
UNIQUE Function
Filters
Slicers
Subtotals
Quick Analysis Tool
Inserting Charts
Formatting Charts
Creating Chart Templates
Printing Charts
Using Sparklines
Introduction to Pivot Tables
Pivot Charts
Using Slicers with Pivot Tables
Data Validation
Conditional Formatting
Custom Conditional Formatting
Linking Data
Conclusion
Introduction
Named Ranges
Multiple Named Ranges
XLOOKUP
Data Mining with XLOOKUP
IF Function
Database Functions
Goal Seek
PMT Data Tables
Macros
IF-THEN Statements
Do Until Loops
Creating Games with Excel VBA Code
Conclusion