Complete Microsoft Excel Tutorial 2024 - From Basics to Advanced

Overview

Embark on a comprehensive 7-hour tutorial covering all aspects of Microsoft Excel in 2024. Start with the basics of navigating worksheets and progress to advanced techniques like VLOOKUP, Power Query, and data analytics. Master essential formulas, functions, and formatting skills. Learn to create impactful visualizations, dashboards, and explore Excel's applications in budgeting and financial management. Dive into data cleaning, validation, and pivot tables. Discover how to leverage AI and ChatGPT for Excel tasks, from generating functions to interpreting financial reports. Gain practical tips for all skill levels and receive a certificate upon completion of this free course, equipping you with valuable data analysis skills using Excel.

Syllabus

- Beginning
- Introduction to Excel
- Cell referencing
- What is a Formula in Excel
- How to enter a formula
- Precedence order of operations
- Smallest and Largest Value
- Function in workbook
- Multiple Values at once
- How to Enter Copy Edit and Hide a Formula
- Precedence order of operations
- Tables and Borders in Excel
- Date and Time Function in Excel
- Introduction to Conditional Formatting - Formatting in Excel
- Cells that Contain
- Greater than
- Top Bottom Values
- Unique and Similar Values
- Data Bars
- Color Scales
- Icon Sets
- Formula Based
- More Rule Types
- Google Sheets
- Color Scales in Google Sheets
- What is VLOOKUP
- VLOOKUP Function in the Same Sheet
- VLOOKUP Function in a Different Sheet
- VLOOKUP Function in a Different Workbook
- Copy VLOOKUP Function
- Lookup Functions
- Introduction to Power Query in Excel
- Understanding Functions for Power Query
- Data Transfering and Cleaning
- Power Query Dashboard Overview
- Introduction to Data Analytics
- Phases of Data Analytics Project
- Data Cleaning
- Data Validation
- Sort and Filter
- Data Visualisation Using Excel
- Introduction to Graphs and Charts in Excel
- Insert Slicer
- Style Options
- Refresh
- Various Tools
- Pivot Table and Its Importance
- How to Create a Pivot Table
- Pivot Tables in Excel
- Change Data Source
- Introduction to Budgeting
- Budget Categories and Budgeting Methods
- Types of Financial Goals
- Creating Budget using Excel
- Introduction to Savings and Investments
- Tips to Avoid Debts
- Introduction to AI
- Introduction to ChatGPT
- Understanding Excel Using ChatGPT
- Generating Excel Functions Using ChatGPT
- Preparation of Financial Statements using ChatGPT
- Dashboard Analysis using ChatGPT
- Interpretations of Financial Reports using ChatGPT
- Basic Level Tips
- Intermediate Level Tips
- Advanced Level Tips