Skills and Knowledge you gain:

1: INTRO TO EXCEL This intro section fully introduces Microsoft Excel, the data analyst industry and marketplace, job opportunities and salaries, and the various Excel-related job roles. Intro to Microsoft Excel Excel Industry and Marketplace Excel Job Opportunities Getting Started with Excel Excel Functions 2: INTERMEDIATE EXCEL This section gives you a complete introduction to the Intermediate Excel functions with hands-on, step-by-step training. Data Visualization Datasets Databases Data Validation PivotTables Conditional Functions Lookup Functions Formulas, + more! 3: EXCEL MACROS & VBA This section introduces you to Excel Macros and VBA with hands-on, step-by-step training. VBA Language VBA Code VBA Loops Macros User Forms 4: STARTING AN EXCEL CAREER This section gives you a complete introduction to starting a career as an Excel Programmer with hands-on, step-by-step training. Creating a Resume Freelancing + Freelance websites How To Get Your 1st Client Personal Branding Importance of Having a Website Networking

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. Here's a breakdown of the benefits for each skill level: Beginner Level: 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.

Curriculum

28 Chapters · 155 Lessons

  1. 1

    Excel from A-Z Course Introduction

    1. (Included in full purchase)

      Excel from A-Z Course Section Overview

    2. (Included in full purchase)

      What is Microsoft Excel?

    3. (Included in full purchase)

      Who This Course is For

    4. (Included in full purchase)

      Microsoft Excel Marketplace

    5. (Included in full purchase)

      Microsoft Excel Job Opportunities

    6. (Included in full purchase)

      Microsoft Excel Job Types

    7. (Included in full purchase)

      Course resources to download

  2. 2

    Getting Started with Excel

    1. (Included in full purchase)

      Finding & Opening Microsoft Excel

    2. (Included in full purchase)

      Excel’s Start Screen

    3. (Included in full purchase)

      Explaining the Excel Interface

    4. (Included in full purchase)

      Excel Interface Continued

    5. (Included in full purchase)

      Excel Workbook vs Excel Worksheet

    6. (Included in full purchase)

      Saving & Opening Excel Documents

    7. (Included in full purchase)

      Customizing the Excel Quick Access Toolbar

    8. (Included in full purchase)

      Customizing the Excel Ribbon

    9. (Included in full purchase)

      Excel Shortcut Keys

  3. 3

    Values, Referencing and Formulas

    1. (Included in full purchase)

      Creating Excel Labels

    2. (Included in full purchase)

      Entering Numeric Values in Excel

    3. (Included in full purchase)

      Formatting Date Values in Excel

    4. (Included in full purchase)

      Building Basic Formulas in Excel

    5. (Included in full purchase)

      Order of Operations

    6. (Included in full purchase)

      Relative vs Absolute Cell References

  4. 4

    Intro to Excel Functions

    1. (Included in full purchase)

      Excel Functions Explained

    2. (Included in full purchase)

      The SUM() Function

    3. (Included in full purchase)

      The MIN() & MAX() Function

    4. (Included in full purchase)

      The AVERAGE() Function

    5. (Included in full purchase)

      COUNT() Functions

  5. 5

    Adjusting Excel Worksheets

    1. (Included in full purchase)

      Moving & Copying Data

    2. (Included in full purchase)

      Insert & Delete Rows/Columns

    3. (Included in full purchase)

      Adjusting the Width & Height of Cells

    4. (Included in full purchase)

      Hiding and Unhiding Excel Rows and Columns

    5. (Included in full purchase)

      Renaming, Moving & Deleting Excel Worksheets

    6. (Included in full purchase)

      Adding Protection to Specific Cells

    7. (Included in full purchase)

      Protecting the Structure of a Workbook

    8. (Included in full purchase)

      Adding a Workbook Password to Open File

  6. 6

    Visually Pleasing Cell Formatting

    1. (Included in full purchase)

      Formatting Fonts and Cell Background Color

    2. (Included in full purchase)

      Adding Cell Borders

    3. (Included in full purchase)

      Formatting Data Appropriately

    4. (Included in full purchase)

      The Magic behind Excel’s Format Painter

    5. (Included in full purchase)

      Creating Styles for Formatting Efficiency

    6. (Included in full purchase)

      Merging Cells for a Cleaner Look

    7. (Included in full purchase)

      The Power of Conditional Formatting

  7. 7

    How to Insert Images and Shapes!

    1. (Included in full purchase)

      Grab User’s Attention using Illustrations

    2. (Included in full purchase)

      Customizing Icons

    3. (Included in full purchase)

      Create Compelling Graphics with SmartArt

  8. 8

    Visualize Data with Charts

    1. (Included in full purchase)

      The Commonly used Column Chart

    2. (Included in full purchase)

      Changing the Chart Design

    3. (Included in full purchase)

      Formatting Elements of a Chart

    4. (Included in full purchase)

      Modifying the Data, Type & Location of a Chart

    5. (Included in full purchase)

      Little Slice of Pie Charts

  9. 9

    Excel's Printing Options

    1. (Included in full purchase)

      Print Preview Options

    2. (Included in full purchase)

      Excel’s Page Layout View

    3. (Included in full purchase)

      Printing a Specific Range of Cells

    4. (Included in full purchase)

      Converting Spreadsheets to PDF Files

  10. 10

    Benefits of Using Excel Templates

    1. (Included in full purchase)

      Why Create an Excel Template

    2. (Included in full purchase)

      How to Create an Excel Template

  11. 11

    Working with Excel Datasets

    1. (Included in full purchase)

      How to Prepare Data for Analysis

    2. (Included in full purchase)

      How to Sort Data in Excel

    3. (Included in full purchase)

      Multi-Level Sorting

    4. (Included in full purchase)

      Custom Sorting Datasets in Excel

    5. (Included in full purchase)

      Applying Filters to Datasets

    6. (Included in full purchase)

      Creating Subtotals within a Dataset

    7. (Included in full purchase)

      Converting Datasets into Tables

    8. (Included in full purchase)

      Finding & Removing Duplicate Values

  12. 12

    Excel Database Functions

    1. (Included in full purchase)

      The SUMIF() Function

    2. (Included in full purchase)

      The DSUM() Function

    3. (Included in full purchase)

      DSUM() Function Cont.

    4. (Included in full purchase)

      The SUBTOTAL() Function

  13. 13

    Excel Data Validation

    1. (Included in full purchase)

      What is Excel Data Validation?

    2. (Included in full purchase)

      Creating a Drop Down List with Data Validation

    3. (Included in full purchase)

      Different Types of Excel Data Validation

    4. (Included in full purchase)

      Adding Custom Alerts to Data Validation

    5. (Included in full purchase)

      Creating a Dynamic Drop Down List

    6. (Included in full purchase)

      Complex Validation: Dependent Drop Down List!

  14. 14

    Excel PivotTables

    1. (Included in full purchase)

      Creating an Excel Pivot Table

    2. (Included in full purchase)

      Modifying Excel PivotTables

    3. (Included in full purchase)

      Grouping & Filtering PivotTable Data

    4. (Included in full purchase)

      Drilling Down into PivotTable Data

    5. (Included in full purchase)

      Creating Pivot Charts & Utilizing Slicers

  15. 15

    Excel's PowerPivot Add-In

    1. (Included in full purchase)

      What is PowerPivot?

    2. (Included in full purchase)

      Activating the Excel PowerPivot Add-In

    3. (Included in full purchase)

      Creating Relationships between Data Tables

    4. (Included in full purchase)

      Using Data Models to Create PivotTables

    5. (Included in full purchase)

      How to Create PowerPivot KPI’s

  16. 16

    Excel's Conditional Functions

    1. (Included in full purchase)

      Excel’s IF() Function

    2. (Included in full purchase)

      IF() Function with AND() Criteria

    3. (Included in full purchase)

      IF() Function with OR() Criteria

    4. (Included in full purchase)

      Nesting Multiple IF() Functions

    5. (Included in full purchase)

      The COUNTIF() Function

    6. (Included in full purchase)

      Key Benefits of Named Ranges

  17. 17

    Excel's Lookup Functions

    1. (Included in full purchase)

      VLOOKUP() Function

    2. (Included in full purchase)

      The Beauty of Excel’s IFERROR() Function

    3. (Included in full purchase)

      HLOOKUP() Function

    4. (Included in full purchase)

      INDEX() Function

    5. (Included in full purchase)

      MATCH() Function

    6. (Included in full purchase)

      INDEX() and MATCH() Combined

    7. (Included in full purchase)

      Two-Way Lookup with INDEX() and MATCH()

  18. 18

    Text Based Functions in Excel

    1. (Included in full purchase)

      LEFT(), RIGHT() and MID() Function

    2. (Included in full purchase)

      Extracting Specific Text using LEN() & SEARCH()

    3. (Included in full purchase)

      Combining Text with CONCATENATE()

    4. (Included in full purchase)

      Quick Tips & Other Text Based Functions

  19. 19

    Auditing Formulas & Custom Views in Excel

    1. (Included in full purchase)

      Tracing Precedents & Dependents in Formulas

    2. (Included in full purchase)

      Showing Formulas

    3. (Included in full purchase)

      Grouping Data

    4. (Included in full purchase)

      3D Referencing in Formulas

    5. (Included in full purchase)

      Utilizing the Watch Window in Excel

    6. (Included in full purchase)

      How to Freeze Panes in Excel

  20. 20

    Excel’s “What If?” Tools

    1. (Included in full purchase)

      Excel’s Scenario Manager Tool

    2. (Included in full purchase)

      Goal Seek in Excel

    3. (Included in full purchase)

      Compare Results with Excel Data Tables

    4. (Included in full purchase)

      Solver Tool

  21. 21

    Welcome to Excel VBA!

    1. (Included in full purchase)

      The Power Behind Excel VBA

    2. (Included in full purchase)

      A Look Inside the Visual Basic Editor (VBE)

    3. (Included in full purchase)

      Recording a Macro

    4. (Included in full purchase)

      Saving & Opening a Macro-Enabled Workbook

  22. 22

    The VBA Language

    1. (Included in full purchase)

      Modules and Procedures

    2. (Included in full purchase)

      Objects, Methods and Properties

    3. (Included in full purchase)

      Excel VBA Variables

  23. 23

    Writing VBA Code

    1. (Included in full purchase)

      Referencing a Range

    2. (Included in full purchase)

      InputBox & MsgBox

    3. (Included in full purchase)

      Using Variables in VBA Code

    4. (Included in full purchase)

      If Then Else Statement

    5. (Included in full purchase)

      Worksheet Functions inside VBA

    6. (Included in full purchase)

      Creating User Defined Functions

    7. (Included in full purchase)

      User Defined Functions within VBA Scripts

  24. 24

    Important VBA Tools and Logic

    1. (Included in full purchase)

      Find Last Row of Data

    2. (Included in full purchase)

      Find Last Column of Data

    3. (Included in full purchase)

      With Statement

    4. (Included in full purchase)

      Debugging & Error Handling

    5. (Included in full purchase)

      Debugging & Error Handling Cont.

  25. 25

    Excel VBA Loops

    1. (Included in full purchase)

      For Next Loop

    2. (Included in full purchase)

      Do Until Loop

    3. (Included in full purchase)

      For Each Loop

Why Choose this course?

- Developed and delivered by Microsoft Excel Expert - Get Instant E-certificate - Fully online - Self-paced learning and laptop, tablet, and smartphone-friendly - 24/7 Support

Course Central Team

Entrepreneur | Digital Marketer | Web Developer | Programmer

What others say about the course?

This course was excellent for a beginner all the way to an expert level teaching you so many different aspects of the power of Excel. Ateka Blooch December 24, 2021

£55.99

Enroll now