The Complete Excel For Beginners Course
Published 3/2025
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 7.26 GB | Duration: 12h 24m
Published 3/2025
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 7.26 GB | Duration: 12h 24m
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.