Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Freelancing Online Business Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel

Microsoft Excel - From Excel Beginner to Excel Expert

Learn Pivot Tables, Formulas, Charts, Data Analysis, Dashboards, VBA, Macros & More for Excel 2010, 2013 or Excel 2016
Rating: 4.4 out of 54.4 (529 ratings)
10,999 students
Created by Martyn Blythin
Last updated 11/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Learn the most useful functions in Excel used in business
  • Learn to analyse large data sets with Pivot Tables
  • Learn to wow your boss with great looking management dashboards
  • Learn how to automate away boring repetitive tasks using VBA & Macros
  • Access to a Professional Trainer with 12+ years of Excel Training
  • Get your CV/Resume ready to impress on your next job application

Requirements

  • This course was created with Excel 2013. However it will also work with Excel 2010, 2013 and 2016 for Windows
  • You'll need a basic working knowledge of Excel, including things like SUM formulas, entering data, adding sheets etc. If you're not yet at this level, check out my 'Getting Started with Excel 2013' course.

Description

Just imagine what it would feel like if using Excel was effortless - if you could create charts, functions, and analyse data with ease. Becoming an Excel expert isn't about learning what every button and every formula does - it's about learning methods you can use over and over again to effortlessly clean, enrich and analyse data.

I bet your a bit like me, you've tried learning through trial and error, but it takes a long time and involves a lot of mistakes along the way! I've been using Excel for over 15 years and there's still a few functions I've never used. The good news is that you can become an Excel expert in just a few hours by learning the right tools and approaches to use. How would it feel to have those skills on your resume and at your next job interview?

So, you want to become an Excel expert but you don't want to overwhelm yourself with stuff you're never going to use and you need the skills for your job, or the next job you hope to get. As I see it, you have three options. First, you could take a classroom based course and try to learn it all in a day, but from experience I know many people who have just been overwhelmed with the amount of information and the pace of learning. Second, you could do absolutely nothing, stay exactly where you are right now with your Excel skills. Or third, you could give this a try, work it alongside your current job and be genuinely good at Excel within a week or two.

We designed this Microsoft Excel - Excel from Beginner to Advanced using feedback received from over 30,000 students over years who told us they wanted opportunities to advance Excel skills. This course has it all, including:

  • Downloadable challenges to test your knowledge.

  • Multiple choice quizzes at the end of each module.

  • Each lesson has a downloadable Excel file containing the examples used.

  • Cheat sheets for functions & excel keyboard shortcuts that you can have at your desk for reference.

  • Ask me any Excel question on the course message boards.

  • A certificate of completion at the end of the course.

The course covers all levels, from beginner to advanced, so you don't have to worry about if the course is right for you, and you don't have to buy multiple courses for each level of your Excel knowledge! The course is split into 6 core modules:

  • Module 1: Master The Basics - Useful excel for beginners, including Excel fundamentals

  • Module 2: Your Data Gameplan - cover how to organise your data including Excel filters

  • Module 3: Your Functions Toolkit - Learn Excel advanced formulas and functions

  • Module 4: Your Data Analysis Strategy - The Complete Microsoft Excel Pivot Tables and Pivot Charts including Excel pivot table basics and data analysis Excel

  • Module 5: Your Dashboard Playbook - Learn how to create an Excel Dashboard

  • Module 6: Your Excel Automation Machine - Learn how to create an Excel macro and use Excel VBA code to automate your work. Excel vba programming is an extremely powerful tool, once you know the basics.

The course also comes with everything you'd expect from a great online course, including:

  • Lifetime access to the material

  • Unlimited free updates to the course

  • 30 day money back guarantee

If you're prepared to give this a try, then we're certain you will see the results as early as the first day you try it.


Here is what students said about this Excel course:

"Love the tips. Best practices quite relevant and to be kept in mind. Also, there are quizzes to test your understanding of the previous lessons as well as links to the lectures for the answers that you missed. I love this course. Highly recommended!"

- Mary J. de Guzman

"This is a really great course. He started at what I would definitely consider an intermediate Excel level--and I even learned some things during that part--and then took us well into advanced Excel, as promised. Martyn was also very responsive, answering in-depth questions I had, even when they were beyond the scope of the course."

- Randy Crane

"Thoroughly enjoyed the course as it was very well paced. Bite-sized yet providing clear concise detailed instructions that I could follow the activities in a separate local spreadsheet and learn by doing. Good clarity in speech and good examples help. Martyn also reverts back quickly if you have a question or suggestion."

- Kaushal Vyas


Who is this course for?

This course can be used whatever your industry - anything from Excel for Accounting and Bookkeeping to excel for investment banking or Excel for data science. Anyone who is looking to achieve excellence in Excel and advance excel skills at work and on their resume.


Excel certification

Although this course does not issue an official microsoft excel certification, it includes a Udemy certificate of completion which you can use to illustrate your Excel skills on your resume and in interviews.

Who this course is for:

  • This course will take your Excel skills from beginner to advanced level
  • This Microsoft Excel courses will take you through 4 of Microsoft Excel topics (Data, Analysis, Presentation & Automation).

Course content

9 sections • 121 lectures • 7h 21m total length

  • Course Roadmap to becoming an Excel expert
    01:35
  • One Thing - Keep it Simple
    00:54

  • Master the Excel Basics & Excel Fundamentals
    00:29
  • Some Quick Definitions
    01:22
  • Preview09:03
  • How to Use & Customise Text Styles
    02:25
  • Challenge: Create a custom text style
    00:11
  • Preview04:39
  • Challenge - Prepare a file for printing
    00:12
  • Saving Your Work Correctly
    00:50
  • Preview03:16
  • Challenge: Using paste special
    00:09
  • Inserting shapes, text boxes and smart art
    03:53
  • Preview6 pages
  • Quiz: Have you mastered the basics?
    6 questions

  • Managing Data
    00:48
  • The 10 immutable laws of structuring data in Excel
    04:56
  • How to Sort Your Data Correctly
    02:46
  • Using Autofilter to Effectively Search & Filter Your Data
    05:45
  • Tables & Named Ranges
    06:21
  • Challenge: Convert a range to a table
    00:06
  • Preview05:14
  • Challenge - Create a drop down selection for data entry
    00:10
  • Excel Conditional Formatting
    06:55
  • Challenge - Add Excel conditional formatting for a project list
    00:07
  • How to Download Data Tables From Websites
    02:56
  • Challenge - Download the latest stock prices
    00:06
  • What to do When Excel Can't Read Your Data - Text To Columns
    03:03
  • Quiz: Can you work with data in Excel?
    6 questions

  • Excel formulas and functions
    00:47
  • SUM, AVERAGE, MAX, MIN
    02:36
  • Challenge: Find COUNT, SUM and AVERAGE Sales Value
    00:09
  • Absolute vs Relative cell references
    05:21
  • SUMIF, COUNTIF, AVERAGEIF
    07:17
  • Challenge: Finding duplicate rows using COUNTIF
    00:12
  • Referencing Tables & Named Ranges Correctly
    03:35
  • Nesting Functions
    03:11
  • Preview07:48
  • Challenge: Add data from another table using VLOOKUP
    00:09
  • INDEX & MATCH
    04:43
  • Challenge: Perform a lookup using INDEX & MATCH
    00:06
  • Create Conditional Formulas with IF
    04:16
  • IFERROR & ISERROR
    06:50
  • Challenge: Create a VLOOKUP with a custom error message
    00:11
  • LEFT, RIGHT, MID & LEN
    06:17
  • FIND, SEARCH & SUBSTITUTE
    05:23
  • TODAY & NOW
    02:27
  • DATE
    06:09
  • Challenge: Turn a text date into an Excel date
    00:17
  • All Excel functions and formulas cheat sheet
    12 pages
  • Quiz: Can you use Excel functions?
    6 questions

  • Analyzing and Visualizing Data with Excel
    00:56
  • Preparing your data for charts
    02:22
  • Challenge: Prepare Data for a Chart
    00:05
  • Pie & Donut Charts
    05:43
  • Line Charts
    04:33
  • Challenge - Create a pie chart
    00:04
  • Bar & Column Charts
    06:48
  • Challenge: Create a Bar Chart
    00:08
  • Challenge: Create a Stacked Bar Chart
    00:12
  • Chart & Axis Formatting
    05:16
  • Multi Type Charts & Dual Axis Charts
    04:48
  • Scatter & Bubble Diagrams
    11:01
  • Create in-cell charts with Sparklines
    04:56
  • Excel Pivot Table basics
    08:30
  • Challenge: Create a Pivot Table
    00:10
  • Pivot Table Calculations
    05:18
  • Challenge: Create a Pivot Table with a Percentage Summary
    00:05
  • Pivot Table Custom Fields
    03:24
  • Challenge: Create a Pivot Table with a Custom Field
    00:07
  • Save time & effort by usng Pivot Charts
    07:18
  • Challenge: Create a Pivot Table & Pivot Chart
    00:09
  • Quiz: Can you analyse data in Excel?
    6 questions

  • Presenting Data Analysis
    00:53
  • How to create red/amber/green metrics
    06:51
  • How to create up/down change metrics
    03:35
  • List style excel dashboards
    26:30
  • Challenge: Create a list style excel dashboard
    00:08
  • Designing chart style excel dashboards
    22:58
  • Challenge: Create a chart style excel dashboard
    00:14
  • Create a seamless self service excel dashboard by joining slicers
    12:35
  • Choosing the right method for report distribution
    01:01
  • Quiz: Can you create dashboards in Excel?
    6 questions

  • An Introduction to the VBA Window & Excel macros
    06:55
  • Using the Excel Macro Recorder
    06:10
  • Creating Buttons and Message Boxes in Excel vba
    02:45
  • How to run, debug and step through a macro
    01:46
  • Referencing Spreadsheet Objects
    13:06
  • How to copy and paste using Excel VBA
    04:00
  • How to Store and Recall Data in Code Using Variables
    09:20
  • Challenge: Create a user entered variable and input onto sheet
    00:08
  • How to find the edges of your data using VBA
    00:58
  • How to create text strings in Excel VBA
    00:51
  • How to create If and Case Statements
    09:44
  • Challenge: Create a Case Select Statement
    00:08
  • The Power of Loops
    08:33
  • Challenge: Create a loop
    00:09
  • How to open and close files using VBA
    07:21
  • Challenge: Open a file and import data using VBA
    00:09
  • How to add comments to your VBA code
    00:31
  • Challenge: Create a VLOOKUP using excel vba and macros
    00:10
  • Case Study: Build an Automated Dashboard
    13:52
  • Case Study: Build a tool to convert time-sheets into pay slips
    33:10
  • Event Based excel vba and macros
    02:12
  • Excel VBA Forms: Create Interactive Data Entry Forms
    16:43
  • Challenge: Build a questionnaire pop up form and store the data in a table
    00:14
  • Quiz: Can you use excel vba and macros?
    6 questions

  • How to use this resource
    00:17
  • Preview00:03
  • How to get a value from a Pivot Table
    00:04
  • Dynamic Named Ranges
    00:05
  • How to remove duplicate rows in Excel
    00:03
  • Conditional Formatting Based on Other Cells Value
    00:06
  • How to create Pie Charts in Excel
    00:03
  • How to use IF in VBA
    00:05
  • How to use COUNTIF and COUNTIFS
    00:04
  • How to use SUMIF and SUMIFS
    00:06
  • How to use Case Statements in VBA
    00:05
  • How to hide & unhide rows and columns
    00:04
  • Pivot Tables Cheat Sheet
    00:04
  • Using the watch window in Excel
    00:03
  • Using Loops in VBA
    00:05
  • Error Handling in VBA
    00:04
  • Creating Integer Variables in VBA
    00:04
  • How to create an animated scrolling chart in Excel
    00:03
  • How to print labels using Excel
    00:08

  • Bonus Lecture: More from Martyn Blythin & DataMinded Training
    00:19

Instructor

Martyn Blythin
Data Minded Excel Training, 30,000+ students
Martyn Blythin
  • 4.4 Instructor Rating
  • 2,067 Reviews
  • 31,167 Students
  • 3 Courses

Hi, I'm Martyn. I created my courses to help you to get better at Excel and to get your next promotion, job or raise. My courses are a little different to most - you'll learn the most powerful functionality in Excel through in depth online courses, ongoing learning through case studies and exercises, as well as a fantastic online student community to share your experiences of breaking through the career ladder with better skills..

If you want to stop drifting and start learning Excel, you are in the right place. Welcome!

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.