Udemy

Ultimate Microsoft Excel Course: Beginner to Excel Expert

Enroll Now
  • 9,813 Students
  • Updated 9/2022
  • Certificate Available
4.6
(783 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
15 Hour(s) 27 Minute(s)
Language
English
Taught by
Alan Murray
Certificate
  • Available
  • *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
4.6
(783 Ratings)

Course Overview

Ultimate Microsoft Excel Course: Beginner to Excel Expert

Master Excel with this Complete Excel Course. Learn Everything Right Now (Workbooks and Real-World Exercises included).

★★★★★ Course access includes the exact files I use to download and follow along, 1 on 1 Instructor support, lifetime access and a 30 day money back guarantee ★★★★★

It is time to master Excel. If you are a beginner and want to develop your Excel skills or have the desire to be an Excel guru, you have come to the right place.

This course starts with the basics of formulas and managing spreadsheets and quickly moves to advanced Excel techniques required for creating powerful, dynamic and visually appealing spreadsheets.

This course is perfect if you;

  • Use Excel every day but want to improve your all-round skills and become the office expert

  • Have a basic knowledge but want to take the plunge and develop your Excel muscles

  • Learn all the essential skills in Excel to help get a new job or promotion

The course has been designed as a one-stop shop for all of the essential skills of Excel. It is very comprehensive and you can come back again and again to revisit the material.

The course will be consistently updated with the latest features and techniques of Excel. With big plans for Excel and amazing features on the horizon - you can be sure to find lessons added to this course so that you stay ahead of the game.

I teach in a hands-on way with unique examples demonstrating all of the essential features of Excel. You will not only understand HOW these Excel tools and formulas work but see examples of WHY they are so awesome.

By the end of the course, you will be a confident user of Excel with the skills to progress your career further, or become the office Excel guru.

During the course you will learn;

  • To use the power of PivotTables to summarise large amounts of data and produce dynamic reports in minutes.

  • Be confident in using over 50 of the most important Excel functions including INDEX, VLOOKUP, MID, IF, MATCH and COUNTIF.

  • Create charts in a flash that visualize data effectively.

  • Conditional Formatting to highlight data comparisons, progress and issues.

  • Utilise the awesomeness of Power Query to import, shape and transform data.

  • Clean up messy data with formulas, Flash Fill and other Excel features.

  • Understand the data model in Excel and PowerPivot.

  • To use macros to automate time-consuming tasks.

  • And much much more.

Why learn from me?

I have been training businesses all around the world on how to get the most out of Excel for over 20 years.

Learning and teaching Excel is my passion. I am a full-time Excel trainer and a Microsoft MVP, so every day I am in the thick of the action teaching others to master Excel.

I set up the Computergaga blog and YouTube channel > 13 years ago where I am lucky enough to have taught millions of people across the globe to increase their skills and overcome everyday real-world Excel problems.

The course includes the exact files that I use in the lessons to download and follow along, lifetime access and 1 on 1 instructor support every step of the way.

Don't delay. Take action. Grab a coffee and let's get started.

Your journey towards mastering Excel starts today

Course Content

  • 18 section(s)
  • 152 lecture(s)
  • Section 1 Introduction
  • Section 2 Working with Large Worksheets
  • Section 3 5 Essential Tricks for Printing Spreadsheets
  • Section 4 Getting Started with Excel Formulas
  • Section 5 Logical Functions: The Decision Making Formulas of Excel
  • Section 6 Conditional Formatting - Make your Data Come to Life
  • Section 7 Dynamic Array Functions - Formulas Have Changed
  • Section 8 Lookup Functions - The Powerful VLOOKUP Function and beyond
  • Section 9 Validating and Protecting Excel Data
  • Section 10 Advanced Formulas for Analysing Data
  • Section 11 Charts - Simple and Effective Data Presentation
  • Section 12 Manipulating Text in Excel
  • Section 13 Formatting your Data Ranges as Tables for Easier Management
  • Section 14 Master PivotTables for Powerful Analysis and Reporting
  • Section 15 Getting and Transforming Data with Power Query
  • Section 16 Working with the Data Model and PowerPivot
  • Section 17 Introduction to Macros and VBA
  • Section 18 Getting Started with Writing VBA

What You’ll Learn

  • Become a Confident and Well-Rounded Excel user
  • Learn new techniques that you will be able to apply right way
  • Learn to write Excel formulas from scratch, up to to rock star level
  • Utilise the awesomeness of Power Query to import, shape and transform data for analysis
  • Master some of the most important functions in Excel such as IF, VLOOKUP, INDEX, SUMIF and many more
  • Learn the latest Cutting-Edge Excel Tips and Features that most users will not have even heard of
  • Automate Daily Tasks with the power of Macros and VBA
  • Lifetime access to the lessons, practice files, exercises, and 1-on-1 instructor support


Reviews

  • P
    Pedro Mendez
    3.5

    useful tips

  • R
    Rita L Koehn
    4.0

    So far it’s great. Don’t know yet what all content it has.

  • P
    Prasenjit Nag
    5.0

    Good Style of Teaching by Mr. Murray.

  • C
    Candacia Somwaru
    4.5

    Very good

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed