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 by: Mach 42 Productions
Excel Consulting | 21,000+ Students

What Will I 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

Target audience

• 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