4.88
(136 Ratings)

Microsoft Excel Bootcamp 2022 – Beginner to Expert (including VBA)

Categories: MS Excel

About Course

This course is all about using formulas & functions to transform basic Excel worksheets into dynamic and powerful analytics tools.

We’ll cover 75+ core functions, using hands-on demos designed to showcase why they are important and how they can be applied in a variety of ways. This isn’t about memorizing syntax; it’s about learning how to THINK like Excel.

It’s time to show Excel who’s boss. Whether you’re starting from square one or aspiring to become an absolute Excel power user, you’ve come to the right place.

This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.

By the end of the course you’ll be writing robust, elegant formulas from scratch, allowing you to:

  • Easily build dynamic tools & Excel dashboards to filter, display and analyze your data
  • Create your own formula-based Excel formatting rules
  • Join datasets from multiple sources with LOOKUP, INDEX & MATCH functions
  • Manipulate dates, times, text, and arrays
  • Automate tedious and time-consuming tasks using cell formulas and functions in Excel (no VBA required!)
  • Pull real-time data from APIs directly into Excel (weather, stock quotes, directions, etc.)

 

We’ll dive into a broad range of Excel formulas & functions, including:

  • Lookup/Reference functions
  • Statistical functions
  • Formula-based formatting
  • Date & Time functions
  • Logical operators
  • Dynamic Array formulas
  • Text functions
  • INDIRECT & HYPERLINK
  • Web scraping with WEBSERVICE & FILTERXML

 


 

Ask people what comes to mind when they think of Excel, and odds are they’ll say “spreadsheets“. The truth is, Excel is an incredibly powerful and dynamic data visualization platform for those willing to think beyond rows, columns, and primitive pie charts — and I’m here to prove it.

This course gives you a deep, 100% comprehensive understanding of Excel’s latest data visualization tools and techniques. I’ll show you whenwhy, and how to use each Excel chart type, introduce key data visualization best practices, and guide you through interactive, hands-on demos and Excel exercises every step of the way.

 

We’ll kick things off by exploring each of the 20+ charts & graphs introduced in Excel 2016, including:

  • Bar & Column charts
  • Histograms & Pareto charts (Office 365, Excel 2016, or Excel 2019)
  • Line charts & trend lines
  • Area charts
  • Pies & Donuts
  • Scatter plots & Bubble charts
  • Box & Whisker charts (Office 365, Excel 2016, or Excel 2019)
  • Tree Maps & Sunbursts (Office 365, Excel 2016, or Excel 2019)
  • Waterfall & Funnel charts (Office 365, Excel 2016, or Excel 2019)
  • Radar & Stock charts
  • Heat maps, 3-D Surface & contour charts
  • Chloropleths & Geospatial maps
  • Custom combo charts & graphs
  • Sparklines
  • And more…

 

From there we’ll dive into a series of 12+ advanced Excel demos guaranteed to turn you into an absolute data viz rockstar. These aren’t “textbook” demos that you can find on Excel YouTube channels; these are projects adapted from actual, award-winning work featured by Microsoft, MIT, and the New York Times. I’ve built my analytics career around data visualization, and I can help you do the same.

We’ll cover advanced Excel data viz topics that you won’t find anywhere else, including:

  • Custom image overlay charts
  • Automation with named ranges and OFFSET/COUNTA functions
  • Scroll & Zoom functionality with Excel form controls
  • Animated charts to visualize changes over time
  • Dynamic, custom Excel dashboards
  • Value-based chart formatting
  • Custom gauge charts & pacing charts
  • Grid visuals using Excel array formulas

 


 

Excel Pivot Tables are an absolutely essential tool for anyone working with data in Excel.

Pivots allow you to quickly explore and analyze raw data in Excel, revealing powerful insights and trends otherwise buried in the noise. In other words, they give you answers. Whether you’re exploring product sales, analyzing which marketing tactics drove the strongest conversion rates, or wondering how condo prices have trended over the past 10 years, Excel Pivot Tables provide fastaccurate, and intuitive solutions to even the most complicated analytics questions.

This course gives you a deep, 100% comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts. I’ll show you whenwhy, and how to use Excel Pivot Tables, introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and Excel exercises every step of the way.

 

We’ll explore and analyze Excel datasets from a number of real-world case studies, including:

  • San Diego burrito ratings
  • Shark attack records from 1900-to 2016
  • Facebook Post data from Spartan Race
  • Major League Baseball team statistics
  • San Francisco employee salaries
  • Daily stock market data
  • IMDb movie ratings
  • Apple Store mobile app ratings
  • Wine ratings and descriptions

 


 

This is a hands-onproject-based course designed to teach you key visualization and design principles, along with powerful techniques for creating dynamic, interactive Excel reports and dashboards.

 

We’ll start by reviewing data visualization best practices, including tips for selecting the right visuals, eliminating clutter, focusing attention, and telling data-driven stories. From there we’ll introduce dashboard design principles, and share frameworks for defining clear objectives, identifying effective metrics and visual elements, and leveraging concepts like reading patterns and Gestalt principles to optimize layout and flow.

 

Throughout the course you’ll practice applying these techniques to unique, real-world projects and scenarios:

  • Maven Music
    • Create a visual showing the evolution of the music industry and the impact of digital formats
  • Maven Careers
    • Build a dashboard to explore salary and employment data across key industries in the US
  • Maven Toys
    • Design a monthly KPI dashboard for sales managers to track regional performance
  • Maven Hotel Group
    • Visualize hotel booking data to show key cancellation patterns and business insights

 

By the end of the course, not only will you have unique, professional-quality Excel dashboards to add to your portfolio, but you’ll have gained the knowledge and confidence to apply these same concepts to your own work.

 


 

Go from Beginner to Microsoft Excel VBA Expert!

I’ll take you step-by-step through engaging video tutorials and teach you everything you need to know to be able to use VBA to improve your workflow, save time and automate your current Excel projects.

 

What differentiates this course from the other Microsoft Excel VBA & macros courses? It includes:

  1. Over 50 Microsoft Excel VBA & macro examples. These are solutions my clients have needed through the years. They are likely to be useful for you too.
  2. Using the right VBA syntax is the most difficult part. An important topic that isn’t covered enough in other VBA courses. In this course, you understand why you write things in certain ways.
  3. Create 3 Complete Excel VBA Tools. We go from idea to final product and cover each step.
  4. Over 100 pages of documentation (including useful code) so you can easily refer to it when in need.
  5. Simple explanations for complex concepts.
  6. High-quality video and different delivery methods to keep things interesting.
  7. Lots of ideas to automate your current tasks.

 

What you can look forward to in this course:

  • Understand how to use the right syntax in VBA
  • Useful Excel VBA codes you can directly use for your work
  • Use the macro recorder for simpler tasks and improve the code
  • Working with the Visual Basic Editor
  • Debugging tools and error handling methods
  • Different ways to reference ranges and cells
  • Different methods to loop
  • How to work with data types
  • PivotTables in Excel using VBA
  • Importing data from other files and exporting data to text files
  • Interacting with other applications (Word, PowerPoint, Outlook)
  • ActiveX and Userforms to enhance the Excel interface
  • Basically all the knowledge you need to automate tasks in Excel
Show More

What Will You Learn?

  • Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch
  • Automate, streamline, and completely revolutionize your workflow with Excel
  • Master unique tips & techniques that you won't find in ANY other course, guaranteed
  • Write advanced conditional, text, date, and lookup functions, including XLOOKUP & Dynamic Arrays
  • Understand WHEN, WHY, and HOW to use 20+ chart types in Excel 2016+
  • Learn advanced Excel tools like automated dashboards, scrolling charts, dynamic formats, and more
  • Master unique tips, tools and case studies that you won't find in ANY other Excel course, guaranteed
  • Build 10+ Excel projects designed to take your data visualization skills to the next level
  • Take your data analysis skills from ZERO to PRO with Excel Pivot Tables
  • Learn how to use Pivot Tables and Pivot Charts to streamline and absolutely revolutionize your workflow in Excel
  • Master unique Pivot Table tips, tools and case studies that you won't find in ANY other course, guaranteed
  • Test your skills with 10 real-world Pivot Table case studies (weather, shark attacks, wine tastings, burrito ratings, and more!)
  • Build stunning, professional-quality dashboards in Excel (from scratch!)
  • Review key data visualization best practices and dashboard design principles
  • Apply powerful techniques for transforming raw data into beautiful, interactive visuals
  • Learn the same tools used by professional business intelligence analysts and data scientists
  • Work through 4 unique, hands-on course projects
  • Enhance your current Excel files & automate your work with VBA.
  • Master Excel VBA & Macros
  • Directly apply the Excel VBA example files included to your own work.
  • Reduce manual routine tasks to the click of a button.
  • Make your work-life easier.
  • Create simple solutions to complex problems by levering Excel functionality with Macros.
  • Formulas & Excel core functionality can't do everything. Use VBA when you reach a limitation.
  • Easily adjust VBA code you find online to fit your purpose.

Course Content

Getting Started

  • Course Structure & Outline
    01:20
  • Setting Expectations
    03:37
  • Introduction
    01:49
  • Download: Course Resources

Excel Formulas 101

Conditional & Logical Operators

Statistical Functions

Lookup/Reference Functions

Text Functions

Date & Time Functions

Formula-Based Formatting

Dynamic Array Formulas

Bonus Functions

Getting Started

Data Visualization Best Practices

Customizing Charts in Excel

Mastering Basic Charts & Graphs

Next-Level Data Visualization Exercises

Getting Started

PivotTable 101

PivotTable Formatting

Sorting, Filtering & Grouping

Calculated Values, Fields & Items

Pivot Charts

PivotTable Case Studies

Getting Started

Data Viz Best Practices

PROJECT 1: Maven Music

Dashboard Design Principles

PROJECT 2: Maven Careers

PROJECT 3: Maven Toys

PROJECT 4: Maven Hotel Group

Tips for Success

Getting Started

Your First Excel Macro

The Object Model

Referencing Ranges, Worksheets & Workbooks with VBA

Working with Variables

Looping through Collections & Making Decisions

Useful Built-in Functions

Debugging, Error Handling & Procedure Scope

Main Project #1: Create a Tool to Automate Table of Contents (TOC)

Looping in VBA (Controlling the Flow of Code)

Working with Arrays

Working with Files, Folders & Text Files

Excel Tables, Formulas & Pivot Tables

Main Project #2: Sales Regional Reporting Tool

Interacting with Other Applications (Word, PowerPoint etc.)

Workbook and Worksheet Events

Working with Userforms & ActiveX Controls

Main Project #3: Invoice Generation Tool

Create your own Custom Functions

Working with Charts

Certification of Completion

Student Ratings & Reviews

4.9
Total 136 Ratings
5
121 Ratings
4
13 Ratings
3
2 Ratings
2
0 Rating
1
0 Rating
FF
8 months ago
Alhumdulillah! Excel Certified Now :) This was the Best Course that I've ever Purchased. Mene pehle bhi Excel ke kaafi Free Course kiye hai Online but koi bhi Course Complete Excel nahi sikha pata tha, and phir mene yeh Paid Course liya aur Alhumdulillah mene kaafi kuch seekh liya. The Best Part was VBA from Leila. I think She's the Best Teacher I've ever learned from. Highly Recommend to Everyone. Yeh Course seekh kar Fiverr ya Freelancer par Excel Project lena shuru kar $10-20 me.
HI
8 months ago
Woww...what a course..i thank you instructor the way he teach, the way he makes us understand from scratch. I really love this course.
MA
8 months ago
The course covered all I needed on Excel.
MK
8 months ago
The way the trainer has explained every concept and provided a demo is really Awesome.
FR
8 months ago
Best VBA and Excel Course ever!
TA
8 months ago
I learnt alot from this course, ab me Fiverr pe Excel se related freelancing ka work asani se kr paa rah hun.
HA
8 months ago
Its a great course. While joining this course I don't know anything about Excel. But now in my organization I am completing my tasks on time and presenting in a good way.
SA
8 months ago
It was an amazing course and I learn all that I need to know about Excel.
AA
8 months ago
good information. the instructor is very good and knowledgeable.
SA
8 months ago
As a Non-Native English speaker, I understood everything that was explained easily thanks to the simple and calm explanation. Jinhe English thori bohat bhi aati hai unke liye bohat asaan hoga samjhna with Subtitles. Excellent work.
MA
8 months ago
Best Excel course! I've learned so much, from the very basis to the more advanced levels, I highly recommend it!
IA
8 months ago
Great, straight forward explanations, easy to follow. Thank you :)
AA
8 months ago
Great and comprehensive course! I've learnt so much useful things
AR
8 months ago
Amazing, I have learnt excel in bits and pieces through Youtube, however found this course very very helpful as all the contents are systematically prepared. I would highlight recommend this course if anyone wants to excel in EXCEL :-)
AH
8 months ago
Covers Excel from its basics to more advanced stuff (VBA, Macros) in a very concise, clear, and engaging way. Good value for money,
SA
8 months ago
I like the fact that how the instructor has emphasized on Hands On usage right from the beginning. To the point videos. Great narration. Loving it.
MI
8 months ago
I never give perfect 5/5 so this 5 is saying alot. Easy to understand and the skills I use are easily translatable to my job. This course is already making my life easier!
MS
8 months ago
This course was excellent. Teaching style is very unique and keep engaged.
MA
8 months ago
Thank you for sharing your knowledge and expertise. I will try my best to remember and apply the learnings I gained from this course. "Khuda Kamyab Karey Aap Ko"
AA
8 months ago
Great lessons, easy to apply directly to "real life"! Easy to follow, recommend 10/10