Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Beginners to Expert Excel and Excel VBA 38 Hours Mega Course
Rating: 4.6 out of 5(1,786 ratings)
17,143 students

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
Created byMach 42 Productions
Last updated 9/2023
English

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

Course content

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

  • Introduction to the Excel course8:48

    This lecture introduces the course, the syllabus, our aim and best ways to learn! We have also included an Excel course syllabus print out which you can use to monitor your progress (please print out!)

  • Get your personalised training program1:26

    This lecture overviews how you can get a customised training program based on your Excel skill level from me (the Instructor) via the discussion forums. If you let me know your existing skill level in Excel, I can then direct you to the necessary sections of the course, particularly if there are some bits you already have prior experience with.

  • How to access the course discussion forum0:29

    This Excel lecture shows you how to access the course discussion forum.

  • Handy List of Excel Shortcuts1:00

    Microsoft Excel has loads of keyboard shortcuts. This lecture lists a couple of handy Excel shortcuts which you will actually use in everyday Excel tasks.

  • Sorting Excel worksheet tabs6:47

    This Excel lecture shows you a very common task of how to sort Excel worksheet tabs. This will enable you to organise your Excel workbooks efficiently.

  • The Excel ribbon tab12:14

    This Excel lecture overviews the menu structure of Excel, commonly known as the Excel ribbon. We go over the various tabs and features.

  • Customising the Quick Access Toolbar and Excel Ribbon13:22

    This Excel lecture covers the Quick Access Toolbar. We also cover how to customise this toolbar and also how to create your own Ribbon of personal frequent commands. This lecture will be useful once the course is completed since you will by then have a list of favourite Excel items you always want available.

  • Your Excel exercises for the Excel ribbon1:01

    This lecture overviews your Excel exercises for the ribbon.

  • Changing the look of Excel- Office Themes4:38

    This lecture shows you how to change the look of Excel and other Office applications in terms of colour scheme. This lecture is very useful because it can help maximise your productivity by helping you choose a colour scheme that is comfortable for you.

  • Resizing Excel columns4:48

    Ever had an Excel table with columns that are overlapping with each other? Annoying right? Well this lecture shows you how to quickly resize all columns to the perfect size. This will make your data tables and reports much more easier to read.

  • Hiding and Unhiding Excel Columns6:27

    This Excel lecture shows you how to hide and unhide Excel columns. This is very useful when dealing with lots of data.

  • Hiding and Unhiding Excel Rows5:50

    This Excel lecture shows you how to hide and unhide Excel rows. 

  • Hiding and Unhiding Non Sequential Excel Rows and Columns4:35

    This Excel lecture shows you how to hide and unhide non sequential Excel rows and columns

  • How to zoom in and out on an Excel spreadsheet7:00

    This Excel lecture shows you how to zoom in and out on an Excel spreadsheet.

  • Splitting a worksheet view in Excel2:54

    This Excel lecture shows you how to split an Excel worksheet view in two.

  • Using Freeze Panes part 11:58

    This lecture will show you how to use Freeze Panes in Microsoft Excel. This is a great way of making scrolling around a spreadsheet really easy!

  • Using Freeze Panes part 24:40

    This lecture continues the topic of Freeze Panes. In this lecture more uses of this option are covered!

  • Filling in data using Auto Fill12:59

    This Excel lecture covers the use of Excel's Auto Fill feature. This enables you to fill in data quickly and is super time saving!

  • Excel Auto Fill exercises3:04

    This Excel lecture overviews some Auto Fill exercises to practice on.

  • The Excel skill of spotting errors8:01

    This Excel lecture illustrates a very important Excel skill involving spotting errors.

  • A quick note about Auto Fill in Excel3:32

    This Excel lecture explains what to do if the Auto Fill button/icon disappears and how to get it back.

  • Using Flash Fill in Excel to fill in data5:00

    This Excel lecture covers a handy feature of Excel called Flash Fill. Basically it can 'sense' patterns of data entry and complete the remaining rows for you.

  • Flash Fill exercises2:01

    This Excel lecture overviews two Flash Fill exercises for you to do.

  • Printing pages in Excel properly3:42

    This lecture will show you how to print pages correctly in MS Excel and avoid the 'dreaded cut off to the next page' syndrome that often happens.

  • Using Excel's status bar9:01

    This Excel lecture shows you how to use Excel's status bar to aid your work

  • How to use Excel's Spell Checker Properly8:45

    This Excel lecture shows you how to use Excel's spell checker in your workbook.

  • Good Excel Spreadsheet Practice8:12

    This Excel lecture covers the importance of good Excel spreadsheet practice.

  • Student Handout: Excel Essentials 'How to' Sheet Summary of Section0:10

    This Excel lecture provides a simple one page summary of how to do the most common tasks in Excel - basically a summary of the section.

    • 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

    Report abuse