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 Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native 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 Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing 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

Beginners to Expert Excel and Excel VBA 38 Hours Mega Course

Learn Excel formulas, Pivot Tables, Excel VBA macros, charts and the basics with our Microsoft Excel 38+ hours tutorial
Rating: 4.5 out of 54.5 (1,323 ratings)
15,327 students
Created by Mach 42 Productions
Last updated 12/2020
English
30-Day Money-Back Guarantee

What you'll learn

  • Students will be able to use Excel to an expert level for their work
  • Students will be able to use formulas in all aspects- write them, edit them, fix them and know which ones to use
  • Students will be able to use Pivot Tables and build them to analyse their data
  • Students will be able to use Excel VBA to write macros to increase productivity
  • Students will be able to use Excel VBA to speed up data analysis of their work
  • Students will be able to quickly format cells, make tables and dynamic charts
  • Students will be able to sort, find and replace data in Excel quickly
  • Students will be able to navigate a spreadsheet without losing the context of their data
  • Students will be able apply these Excel skills to their CV/Resume
  • Students will be able to print spreadsheets properly with no cut offs
  • Students will be able to use Excel's security features to protect their spreadsheet reports
  • Students will learn essential tips to help them for their Excel reports
  • Students will be able to use conditional formatting to highlight entries e.g. top 10 performers

Requirements

  • A copy of Excel 2013, Excel 2016, Excel 2019 or Office 365 (now known as Microsoft 365) for Windows based computers
  • A willingness to learn
  • A Windows based PC
  • A basic competence of Excel e.g. being able to launch it, open, save and close a workbook

Description

This comprehensive 38 hours+ Microsoft Excel and Excel VBA course includes content from our Mach 42 Productions Excel courses 1 through 11 and our IT careers course, to take you from beginner to expert level:

  • Excel Course 1- Step By Step Beginners Excel  

  • Excel Course 2- How To Use Excel comments  

  • Excel Course 3- Excel Charts And Tips To Make Better Charts  

  • Excel Course 4- How To Make Waterfall Charts  

  • Excel Course 5 - Advanced Excel Charts  

  • Excel Course 6- Automated Excel Charts And Tables  

  • Excel Course 7- Learn How To Use Excel Text Functions  

  • Excel Course 8- Advanced Excel tips  

  • Excel Course 9- Quick Excel Tips For Excel Reports  

  • Excel Course 10- Advanced Excel Skills And Career Tips  

  • Excel Course 11- Spreadsheet Protection  

  • 8 Ways to Further your IT Career



If you are enrolled on any of our above courses, please bear this in mind before considering this one.  

Our in-depth Excel syllabus takes you from beginner level to advanced level in Excel and will help build you a solid understanding of Excel and use it effectively in your work. Over 38 hours of Excel content is provided in this course including:   

  • How to use the basics of Excel e.g. create new worksheets, copy, cut and paste, the Excel ribbon and how to print documents properly  

  • How to sort, find and replace Excel data quickly  

  • How to understand, write, use, audit formulas and coverage of Excel text functions, maths operators and advanced functions including vlookup via worked examples/case studies. We provide hours of material on this to build your confidence levels (11 sections)   

  • Coverage of Excel charts from beginner level to advanced automated charts. We cover charts such as bar charts, line charts, waterfall charts and funnel charts. We also provide tips on how to make better charts.

  • A thorough grounding in Excel Pivot Tables- from scratch. This tool alone can save you a lot of time in your data work.   

  • Essential Excel tips to boost your work and help you make better Excel reports e.g. how to watermark Excel sheets  

  • How to protect your Excel spreadsheets using Excel’s security model.

  • Excel VBA- We teach from ground up Excel’s powerful VBA programming language which can be used to automate tasks, clean up data (very fast) and overall increase your productivity. Our VBA learning culminates in building real life (and actually useful) programs/macros which you can use in your everyday work. Further the skills taught will enable you to build your own macros. All the source code is provided in our examples in addition to testing your knowledge with assignments and tasks. We have over 7 hours of lecture videos covering Excel VBA.   

  • Excel career tips- Advice on how to write Excel examples for your CV/Resume


Full support is given on this Excel course by means of our course discussion forum, lecture quizzes and tasks/activities are provided right from the start of the course. All Excel workbooks used in the lectures are provided too.   

Remember by picking up essential Excel skills, you can significantly increase your productivity, save time and money and furthermore be confident that you can use one of the most popular office business tools today.

Who this course is for:

  • Students who are at a basic beginners Excel level and want to become an expert in Excel
  • Those who want to learn Excel formulas, charts and the essentials of Excel
  • Students who want to progress to learning Excel VBA after mastering Excel
  • Analysts needing to reinforce their skills
  • New staff starting at a company and need to get familiar with Excel
  • Students starting an apprenticeship who need to learn Excel
  • Students studying at college/university who are required to use Excel in their coursework/assignments/internships
  • Those who use Excel in their work and want to make the most of it

Course content

46 sections • 324 lectures • 38h 18m total length

  • Preview08:48
  • Get your personalised training program
    01:26
  • How to access the course discussion forum
    00:19
  • Handy List of Excel Shortcuts
    1 page

  • Preview03:50
  • Preview10:03
  • Sorting Excel worksheet tabs
    06:47
  • The Excel ribbon tab
    12:14
  • Customising the Quick Access Toolbar and Excel Ribbon
    13:22
  • Your Excel exercises for the Excel ribbon
    01:01
  • Changing the look of Excel- Office Themes
    04:38
  • Preview04:48
  • Preview06:27
  • Hiding and Unhiding Excel Rows
    05:50
  • Hiding and Unhiding Non Sequential Excel Rows and Columns
    04:35
  • Preview07:00
  • Splitting a worksheet view in Excel
    02:54
  • Preview01:58
  • Using Freeze Panes part 2
    04:40
  • Filling in data using Auto Fill
    12:59
  • Excel Auto Fill exercises
    03:04
  • The Excel skill of spotting errors
    08:01
  • A quick note about Auto Fill in Excel
    03:32
  • Using Flash Fill in Excel to fill in data
    05:00
  • Flash Fill exercises
    02:01
  • Printing pages in Excel properly
    03:42
  • Using Excel's status bar
    09:01
  • How to use Excel's Spell Checker Properly
    08:45
  • Good Excel Spreadsheet Practice
    08:12
  • Student Handout: Excel Essentials 'How to' Sheet Summary of Section
    00:10

  • An overview to Copy, Cutting and Pasting Excel data
    02:59
  • Examples of Copy/Cut/Paste
    12:14
  • More Worked Examples
    11:11
  • Yours Tasks for this Section
    00:48
  • How to cut, copy and paste rows and columns
    06:53
  • How to copy only visible cells in Excel
    03:25

  • Adding comments to Excel worksheets
    04:31
  • Quiz on Comments in Excel
    2 questions
  • Deleting Excel comments all at the same time
    02:20
  • Changing the colour of Excel comments
    05:54
  • Resize comments in Excel
    04:08
  • How to use Excel comments properly
    03:59

  • Overview of sort
    08:20
  • Sorting data by numbers
    02:35
  • Sorting data by cell background colour
    02:38
  • Sorting data by font colour
    01:43
  • Using more than one rule to sort data
    08:29
  • Conclusion to Sorting in Excel section
    00:56
  • Your Sorting Tasks
    00:45
  • How to sort in reverse order with data that has no logical order
    04:07

  • Finding and replacing data in Excel
    03:19
  • Finding and replacing data for selected columns
    02:06
  • Quiz on finding and replacing data
    1 question

  • Applying formatting to text
    16:56
  • Applying formatting to text part 2
    15:13

  • Applying a format quickly to other cells
    06:16
  • Quiz on Format Painter
    2 questions

  • Making a table
    09:07
  • Using filters in tables, removing duplicate data and resetting a table
    19:23
  • Your turn! Preparing a table for a report
    01:23
  • How to copy a table from MS Excel to MS Word
    06:21

  • Data Validation Part 1
    09:46
  • Data Validation Part 2
    07:25

Instructor

Mach 42 Productions
Excel Consulting | 21,000+ Students
Mach 42 Productions
  • 4.5 Instructor Rating
  • 1,324 Reviews
  • 22,348 Students
  • 2 Courses

Our Excel courses on Udemy have been developed to cover a wide range of needs for the Excel user. We provide all workbooks and full support via discussion forums.

Our Excel courses use real life examples and not just theory to help you learn and improve yourself and give you proper skills you can use in your workplace.

Our Excel IT Consultant/Instructor Navin and Founder of Mach 42 Productions has been in the IT industry for approximately ten years. Recently featured nationwide in The Times UK and Costco Magazine, Navin has over 6 years experience as an Analyst. Having self-taught himself Microsoft Excel and VBA, he achieved MCAS (now known as Microsoft Office Specialist) certification in Excel in 2010. His work in Excel has been varied having worked on automating and streamlining reports to building and deploying real time dashboards to monitor performance.

During his time as an Analyst, he often assisted colleagues who needed problems solved in Excel. By relating the functions to use, to the context of their problem, his colleagues were able to grasp the concepts of what functions to use and in what context.

This spurned Navin's need to teach Excel online. So please have a look and join us on our journey!

  • 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.