Microsoft Excel Masterclass

Master Microsoft Excel from beginner to expert with this online course. Learn everything from basic functions to advanced data analysis with pivot tables, formulas, macros, VBA, and data analysis and learn how to land your first job as an expert.

Buy £55.99

What will you learn

Skills and knowledge you will gain after completing this course:

Effectively utilise VLOOKUP, HLOOKUP, INDEX, and MATCH functions to find values.
Create basic and advanced formulas, including math, statistical, logic, and text functions.
Master PivotTables and PowerPivot for robust data analysis.
Understand and apply VBA (Visual Basic for Applications) and Macros to automate tasks.
Develop the skills required to become a professional Data Analyst or Excel Programmer.
Perform data validation, work with datasets, and utilise database functions.

Course curriculum

1. Excel from A-Z Course Section Overview
2. What is Microsoft Excel?
3. Who This Course is For
4. Microsoft Excel Marketplace
5. Microsoft Excel Job Opportunities
6. Microsoft Excel Job Types
7. Course resources to download
1. Finding & Opening Microsoft Excel
2. Excel’s Start Screen
3. Explaining the Excel Interface
4. Excel Interface Continued
5. Excel Workbook vs Excel Worksheet
6. Saving & Opening Excel Documents
7. Customizing the Excel Quick Access Toolbar
8. Customizing the Excel Ribbon
9. Excel Shortcut Keys
1. Creating Excel Labels
2. Entering Numeric Values in Excel
3. Formatting Date Values in Excel
4. Building Basic Formulas in Excel
5. Order of Operations
6. Relative vs Absolute Cell References
1. Excel Functions Explained
2. The SUM() Function
3. The MIN() & MAX() Function
4. The AVERAGE() Function
5. COUNT() Functions
1. Moving & Copying Data
2. Insert & Delete Rows/Columns
3. Adjusting the Width & Height of Cells
4. Hiding and Unhiding Excel Rows and Columns
5. Renaming, Moving & Deleting Excel Worksheets
6. Adding Protection to Specific Cells
7. Protecting the Structure of a Workbook
8. Adding a Workbook Password to Open File
1. Formatting Fonts and Cell Background Color
2. Adding Cell Borders
3. Formatting Data Appropriately
4. The Magic behind Excel’s Format Painter
5. Creating Styles for Formatting Efficiency
6. Merging Cells for a Cleaner Look
7. The Power of Conditional Formatting
1. Grab User’s Attention using Illustrations
2. Customizing Icons
3. Create Compelling Graphics with SmartArt
1. The Commonly used Column Chart
2. Changing the Chart Design
3. Formatting Elements of a Chart
4. Modifying the Data, Type & Location of a Chart
5. Little Slice of Pie Charts
1. Print Preview Options
2. Excel’s Page Layout View
3. Printing a Specific Range of Cells
4. Converting Spreadsheets to PDF Files
1. Why Create an Excel Template
2. How to Create an Excel Template
1. How to Prepare Data for Analysis
2. How to Sort Data in Excel
3. Multi-Level Sorting
4. Custom Sorting Datasets in Excel
5. Applying Filters to Datasets
6. Creating Subtotals within a Dataset
7. Converting Datasets into Tables
8. Finding & Removing Duplicate Values
1. The SUMIF() Function
2. The DSUM() Function
3. DSUM() Function Cont.
4. The SUBTOTAL() Function
1. What is Excel Data Validation?
2. Creating a Drop Down List with Data Validation
3. Different Types of Excel Data Validation
4. Adding Custom Alerts to Data Validation
5. Creating a Dynamic Drop Down List
6. Complex Validation: Dependent Drop Down List!
1. Creating an Excel Pivot Table
2. Modifying Excel PivotTables
3. Grouping & Filtering PivotTable Data
4. Drilling Down into PivotTable Data
5. Creating Pivot Charts & Utilizing Slicers
1. What is PowerPivot?
2. Activating the Excel PowerPivot Add-In
3. Creating Relationships between Data Tables
4. Using Data Models to Create PivotTables
5. How to Create PowerPivot KPI’s
1. Excel’s IF() Function
2. IF() Function with AND() Criteria
3. IF() Function with OR() Criteria
4. Nesting Multiple IF() Functions
5. The COUNTIF() Function
6. Key Benefits of Named Ranges
1. VLOOKUP() Function
2. The Beauty of Excel’s IFERROR() Function
3. HLOOKUP() Function
4. INDEX() Function
5. MATCH() Function
6. INDEX() and MATCH() Combined
7. Two-Way Lookup with INDEX() and MATCH()
1. LEFT(), RIGHT() and MID() Function
2. Extracting Specific Text using LEN() & SEARCH()
3. Combining Text with CONCATENATE()
4. Quick Tips & Other Text Based Functions
1. Tracing Precedents & Dependents in Formulas
2. Showing Formulas
3. Grouping Data
4. 3D Referencing in Formulas
5. Utilizing the Watch Window in Excel
6. How to Freeze Panes in Excel
1. Excel’s Scenario Manager Tool
2. Goal Seek in Excel
3. Compare Results with Excel Data Tables
4. Solver Tool
1. The Power Behind Excel VBA
2. A Look Inside the Visual Basic Editor (VBE)
3. Recording a Macro
4. Saving & Opening a Macro-Enabled Workbook
1. Modules and Procedures
2. Objects, Methods and Properties
3. Excel VBA Variables
1. Referencing a Range
2. InputBox & MsgBox
3. Using Variables in VBA Code
4. If Then Else Statement
5. Worksheet Functions inside VBA
6. Creating User Defined Functions
7. User Defined Functions within VBA Scripts
1. Find Last Row of Data
2. Find Last Column of Data
3. With Statement
4. Debugging & Error Handling
5. Debugging & Error Handling Cont.
1. For Next Loop
2. Do Until Loop
3. For Each Loop
1. Assigning Macros to Shapes
2. Form Controls vs ActiveX Controls
3. Worksheet Events
4. Workbook Events
5. Fun with VBA Events!
1. Creating an Excel User Form
2. Adding Controls to User Forms
3. How to Show an User Form
4. Passing Text Box Values to Desired Cells
5. Passing Option Buttons to Desired Cells
6. User Form Combo Boxes
7. Clearing Values from User Form Controls
8. How to Close an User Form
9. User Forms and Protected Sheets
1. Creating an Excel Resume
2. Getting Started with Freelancing
3. How to Become an Excel Freelancer
4. Top Freelance Websites
5. How to Get Your First Client
6. Personal Branding
7. Networking Do’s and Don’ts
8. Importance of Having a Website

About this course

£55.99
155 lessons
13 hours of video content

Who is this course beneficial for?

The Microsoft Excel Masterclass course offers specific benefits to individuals at different skill levels, including beginners, intermediate learners, and advanced users.

Beginners: If you are new to Excel or have limited experience with spreadsheets, this course provides a solid foundation. It covers essential Excel functions, formulas, and features, allowing beginners to gain confidence and navigate Excel effectively. Office Administrators: For office administrators, the course equips them with the necessary skills to streamline administrative tasks, such as data entry, organizing information, and creating basic reports. It improves their efficiency and accuracy in handling Excel-related duties.
Intermediate Level:Data Analysts: Intermediate learners can enhance their data analysis capabilities through advanced Excel techniques covered in the course. They learn to manipulate data, perform complex calculations, and create insightful visualizations, enabling them to extract meaningful insights from datasets. Financial Professionals: Intermediate learners in finance-related roles benefit from the course by acquiring advanced financial modeling skills, budgeting techniques, and data analysis capabilities. They can effectively manage financial data, analyze trends, and make informed decisions based on accurate financial information. Business Professionals: Intermediate-level business professionals, such as sales or marketing specialists, gain practical skills in data manipulation, formula usage, and report generation. This empowers them to analyze data, track performance, and make data-driven decisions to drive business growth.
Advanced Level:Advanced Data Analysts: Advanced users can further refine their data analysis skills by mastering complex Excel functions, advanced formulas, and pivot tables covered in the course. They gain expertise in data modelling, statistical analysis, and advanced data visualization techniques. Financial Experts: Advanced learners in finance-related roles, such as financial analysts or controllers, can leverage the course to expand their knowledge in financial forecasting, advanced financial modelling, and scenario analysis. This enables them to make sophisticated financial decisions and provide strategic insights to stakeholders. Business Intelligence Professionals: Advanced Excel users can utilize the course to enhance their data cleansing, data transformation, and advanced data visualization skills. They learn how to create dynamic dashboards and interactive reports, enabling them to deliver valuable business insights.

Course FAQ

I'm a complete beginner with Excel. Is this course suitable for me?

Absolutely! This course is specifically designed to take you from A-Z, meaning it caters to complete beginners whilst also offering advanced content for those looking to upskill. We start with the fundamentals and progressively build your knowledge and practical skills.
What exactly is VBA and how will it benefit me in Excel?

VBA stands for Visual Basic for Applications, and it's the programming language used to create Macros in Excel. By learning VBA and Macros, you can automate repetitive tasks, create custom functions, and develop powerful, tailor-made solutions within Excel, saving you a significant amount of time and boosting efficiency.
Will I learn how to analyse large datasets effectively with this course?

Yes, absolutely. This course covers key aspects of data analysis, including working with datasets, databases, and mastering PivotTables. You'll learn how to transform raw data into meaningful insights, a crucial skill for any data-driven role.
How important are formulas and functions in Excel, and will I master them here?

Formulas and functions are the backbone of Excel's power, enabling complex calculations and data manipulation. This course will ensure you master a wide array of mathematical, statistical, logic, and text functions, as well as crucial lookup functions like VLOOKUP, HLOOKUP, INDEX, and MATCH.
Beyond technical skills, does this course help with job searching?

Yes, this course goes beyond just technical Excel skills. It includes a dedicated section on "Starting an Excel Career". You'll learn how to create an effective resume, understand freelancing opportunities and platforms, discover how to get your first client, and appreciate the importance of personal branding and networking. This comprehensive approach aims to help you confidently apply for jobs and feel prepared.

Want to explore more?

Others are doing these courses

View more products