The Complete Excel For Beginners Course

Master Excel from Scratch: Comprehensive Training for Beginners to Transform Your Data Skills

What you'll learn

Navigate Excel’s interface, customize settings, manage sheets, and format data professionally to create clean and organized spreadsheets.

Master essential formulas like IF, VLOOKUP, INDEX-MATCH, and SUMIF to automate calculations, analyze data, and solve complex problems.

Organize data with advanced sorting, filtering, conditional formatting, and tools to clean and optimize datasets for accurate analysis.

Create dynamic charts, Pivot Tables, and dashboards to analyze trends, measure KPIs, and present data with clarity and professionalism.

Automate repetitive tasks with Macros, Power Query, Power Pivot, and Microsoft Copilot AI to boost efficiency and productivity.

Integrate Excel with Word, PowerPoint, and cloud platforms like OneDrive and SharePoint to enhance collaboration and accessibility.

Requirements

There are no prior skills or experience required to take this course—it’s designed specifically for beginners who are new to Microsoft Excel. All you need is a computer or laptop with Microsoft Excel installed (version 2016 or later, including Office 365) and basic computer skills such as navigating files and using a mouse and keyboard.

Additionally, an internet connection is required to access the course materials, download resources, and practice alongside the lessons. A willingness to learn and apply new skills through hands-on exercises is all that’s needed to succeed in this course. Access to cloud storage tools like OneDrive or SharePoint is optional for collaboration lessons.

Description

Unlock the power of Microsoft Excel with The Complete Excel for Beginners Course—your all-in-one guide to mastering Excel from the ground up! Whether you're completely new to spreadsheets or want to sharpen your data management, analysis, and reporting skills, this course offers a structured, easy-to-follow path to Excel proficiency.Through detailed lectures and hands-on exercises, you’ll explore everything from the basics to advanced tools, including formulas, functions, data visualization, and automation. By the end of this course, you’ll be equipped to confidently use Excel for personal projects, workplace tasks, and beyond.What You’ll Learn:Excel Basics: Learn how to navigate the interface, manage data, and work with cells, rows, and columns.Data Management Essentials: Master formulas, sorting, filtering, and cleaning data.Powerful Formulas & Functions: Discover logical functions, LOOKUP formulas, financial functions, and advanced text manipulations.Data Analysis & Visualization: Create dynamic tables, charts, pivot tables, and even dashboards.Automation Tools: Get started with macros, VBA, and Power Query for seamless efficiency.Integration & Productivity: Use Excel with Word, PowerPoint, cloud tools, and AI features like Microsoft CoPilot.Real-World Project: Apply your skills to a practical business scenario with the PivotPoint Enterprises project.Why Choose This Course?Beginner-friendly with step-by-step guidance.Practical, real-world examples for better understanding.Comprehensive coverage of Excel features, from fundamentals to advanced tools.Interactive project-based learning to test and apply your knowledge.Who This Course Is For:Beginners with no prior experience in Excel as well as those wanting to explore more intermediate techniques.Professionals looking to build or improve their data management and analysis skills.Students or entrepreneurs aiming to boost productivity and streamline tasks.Take the first step towards Excel mastery—enroll now and start transforming your data skills today!

Overview

Section 1: Introduction to Excel

Lecture 1 Introduction & Overview

Lecture 2 Course Resources & Requirements

Lecture 3 Downloading & Installing Excel

Lecture 4 Overview of Excel as a Software

Lecture 5 Opening Excel for the First Time

Lecture 6 Saving your Excel & File Types

Lecture 7 Entering your first Data Types

Lecture 8 Discover Cell Font, Size & Alignment

Lecture 9 Managing multiple cells/rows/columns

Lecture 10 Adding, Deleting & Navigating Sheets

Lecture 11 Customising the Interface Settings

Section 2: Data Management Basics

Lecture 12 Basic Excel Numerical Functions

Lecture 13 Basic Formulas & Operators

Lecture 14 Understanding Cell References

Lecture 15 Basic Excel Text Functions

Lecture 16 Using the Series & Flash Fill Function

Lecture 17 Fundamentals for Data Management

Lecture 18 Efficient Data Sorting Techniques

Lecture 19 Adding and Using Filters

Lecture 20 Cleaning your data from Duplicates

Lecture 21 Basic Conditional Formatting

Lecture 22 Text to Columns Feature

Lecture 23 Construct a simple chart

Section 3: Excel Formulas & Functions

Lecture 24 Overview of Formulas & Functions

Lecture 25 Logical Functions Overview - IF,AND,OR

Lecture 26 Using SUMIF & COUNTIF functions for one criteria

Lecture 27 Using SUMIFS & COUNTIFS functions for multiple criterion

Lecture 28 Overview of LOOKUP Functions

Lecture 29 Using the HLOOKUP (Horizontal Lookup) Function

Lecture 30 Using the VLOOKUP (Vertical Lookup) Function

Lecture 31 Using INDEX & MATCH Function for a 2 Dimensional LookUp

Lecture 32 Using the Newer XLOOKUP function

Lecture 33 Using the CHOOSE Function

Lecture 34 Using the SWITCH function instead of IF

Lecture 35 Using the INDIRECT Function

Lecture 36 Basic Text Functions UPPER, LOWER, PROPER, CONCATENATE

Lecture 37 Text Functions to Clean Data CLEAN, TRIM, FIND & REPLACE

Lecture 38 Advanced Text Functions TEXT SPLIT,JOIN,BEFORE,AFTER

Lecture 39 Using the Newer WRAPROWS, WRAPCOLS Function

Lecture 40 Date & Time Overview in Excel

Lecture 41 Date & Time Formats

Lecture 42 Date & Time Functions TODAY, NOW, EDATE, EOMONTH

Lecture 43 Date & Time Calculations

Lecture 44 Statistical Functions using SMALL, LARGE & FREQUENCY

Lecture 45 Using the RANK Function

Lecture 46 Rounding functions, ROUND, TRUNC, CEILING, FLOOR

Lecture 47 Basic Financial Functions PMT, ABS, PV, FV, NPV, IRR

Lecture 48 Crafting Complex Formulas and Functions

Lecture 49 How to Solve Common Errors in Excel & IFERROR function

Section 4: Excel for Data Analysis & Reporting

Lecture 50 Creating Datasets from Scratch

Lecture 51 Data Validation

Lecture 52 Checkboxes

Lecture 53 Creating an Easy data entry Form

Lecture 54 Creating a Dynamic Table

Lecture 55 Importing a Dataset

Lecture 56 Data Cleaning Techniques

Lecture 57 Navigating within the dataset

Lecture 58 Advanced Conditional Formatting

Lecture 59 Adding, Deleting & Moving Rows or Columns

Lecture 60 Advanced Sorting of Tables

Lecture 61 Advanced Data Filtering Functions

Lecture 62 How Formulas work in Tables

Lecture 63 Common Formulas in Tables FILTER, UNIQUE & SORT

Lecture 64 Creating a Basic Bar Chart, Line Graph & Pie Chart

Lecture 65 Creating a Second Axis on a Basic Chart

Lecture 66 Introduction to Pivot tables

Lecture 67 Design & Layout of Pivot tables

Lecture 68 Data Manipulation in Pivot Tables

Lecture 69 Common Errors in Pivot tables

Lecture 70 Calculated Fields in Pivot Tables

Lecture 71 Pivot Table Filters

Lecture 72 Pivot Charts

Lecture 73 Customisation of Pivot Charts

Lecture 74 Using Slicers and Timelines

Lecture 75 Creating a Simple Dashboard

Section 5: Advanced Excel Power Tools

Lecture 76 Introduction to Macros & VBA

Lecture 77 Macro Security & Settings

Lecture 78 Automating Repetitive Tasks with Macros

Lecture 79 Writing simple VBA Macros from Scratch

Lecture 80 Introduction to Power Pivot

Lecture 81 Basics of Power Pivot & Data Modelling

Lecture 82 Introduction to Power Query

Lecture 83 Building a Simple Data model using Power Query & Power Pivot

Section 6: Integrating Excel with Other Applications

Lecture 84 Microsoft Word Integration with Excel

Lecture 85 Microsoft PowerPoint Integration with Excel

Lecture 86 Emailing Directly from Excel

Lecture 87 Web Scraping from Excel

Lecture 88 Excel Add-ins and Tools

Lecture 89 Exploring Microsoft CoPilot - Al in Excel

Lecture 90 Excel and the Cloud/One Drive/Sharepoint

Lecture 91 Printing, Sharing & Collaborating

Section 7: Productivity Tricks & Tips

Lecture 92 Common Shortcuts

Lecture 93 Transpose Data

Lecture 94 Sparklines

Lecture 95 Camera Tool

Lecture 96 Go to Special Dialogue Box

Lecture 97 Customising Quick Access Toolbar & Ribbon

Lecture 98 Freezing Panes & Different Views

Lecture 99 Custom Lists

Lecture 100 Creation of Multiple Folders

Lecture 101 Combining Data from Multiple Sheets

Lecture 102 Forecasting using Goal Seek & Other Tools

Lecture 103 Introduction to Excel Templates

Section 8: PivotPoint Enterprises Project

Lecture 104 Introduction to the project objectives

Lecture 105 Prepare the data by cleaning & formatting

Lecture 106 Analyse the data by checking trends & measuring KPIs

Lecture 107 Present the Data using Tables & Charts

Lecture 108 Share, Collaborate & Print the Data

Lecture 109 Create a Project Timeline

Section 9: Conclusion & Final Thoughts

Lecture 110 Recap of Key Learnings

Lecture 111 100 Common Qs & As

Lecture 112 99 Shortcuts Reference

Lecture 113 Next Steps & Resources

Beginners with no prior Excel experience who want to build a strong foundation and confidently use Excel for personal or professional tasks.,Students, professionals, or entrepreneurs looking to improve their data management, analysis, and reporting skills to boost productivity and efficiency.,Anyone seeking to master Excel from scratch, including those transitioning into data-driven roles or wanting to streamline everyday tasks with Excel tools.