We guarantee you that this is the best and most up-to-date Excel Bootcamp that you'll find. You will learn Excel from scratch including advanced topics like data analysis & modeling, pivot tables, macros, building your own professional spreadsheets and charts, and have the skills to get hired as a Data Analyst in 2023!
Why learn Excel? Because it's one of the most powerful applications ever built, with a massive and widely under-appreciated feature set. It has the horsepower and flexibility to play a crucial role in any data analyst and developer’s toolbox.
If you squint just a little bit, Microsoft Excel absolutely has all the essential components of a full-stack application development platform. And for rapid development of data-driven applications, you’d be hard-pressed to find a better solution.
The Bottom Line: whether you're a computer novice or an experienced developer, there's a good chance Excel has something for you.
The next time you're tempted to scoff at a colleague using Excel, consider that it just might be the fastest, best tool for the job they're doing... and it might just be for the job you're doing too.
This Excel Bootcamp is focused on efficiency. Never spend time on confusing, out-of-date, incomplete tutorials anymore. Instead, learn everything from the basics to using the most advanced features Excel has to offer. All in one course. And in a fun and supportive environment.
Graduates of Zero To Mastery are now working at Google, Tesla, Amazon, Apple, IBM, JP Morgan, Facebook, Shopify + other top tech companies. This could be you.
By enrolling today, you’ll also get to join our exclusive live online community classroom to learn alongside thousands of students, alumni, mentors, TAs and Instructors. Most importantly, you will be learning from an industry expert that has actual real-world experience working as a Data Solutions Engineer on massive datasets for some of the largest companies.
Along the way, we give you tons of exercises so you can practice yourself but you will also build a massive personal budget and expense tracker tool using Excel macros and data visualization. It's more than just a spreadsheet. It's an interactive, user-driven tool that lets you compare your income and expenses, plan your spending with precision, determine what percentage of your income you'd like to save, analyze your spending habits, and more. This will not only help solidify your understanding but also help you master your finances.
The curriculum is presented in basic building blocks so that you can build your knowledge step-by-step.
We start from the very beginning by teaching you Excel basics and fundamentals. We then dive into advanced topics so you can make good decisions on data manipulation, analysis, and visualization, and tools for use in any of your future Excel projects.
By the end of this course, we guarantee you're going to love Excel. It will make you more effective and efficient at your job, no matter your role or industry.
Here is what the course will cover to take you from Zero to Excel Mastery:
1. EXCEL 101
You'll learn about the fundamentals of Excel, such as formulas, working with multiple worksheets & workbooks, and utilizing Excel for data entry. With just the fundamentals, you'll be able to manipulate, format, and prepare data for analysis. You'll also start your first exercise to practice and solidify your knowledge.
2. FILTERING & SORTING DATA
You'll learn to filter and sort data sets, and how to further prepare data sets for analysis and visualization.
3. EXCEL FORMULAS 101
You'll dive into the magic of Excel formulas for text, dates, and arithmetic purposes. We'll also start the Budget Project where you will start applying your knowledge to creating a personal budget and expense tracker tool that will allow you to masterfully track and analyze your personal finances.
4. CRUNCHING NUMBERS WITH EXCEL FUNCTIONS
You'll start learning how to analyze data with arithmetic functions including calculating median and standard deviation. Throughout your career, you'll need to know the importance of these fundamental arithmetic functions and what they say about your data.
5. CONDITIONAL CALCULATIONS
You'll go down the rabbit hole into more advanced subjects with calculations that are conditional upon variables. The goal of Excel is to make the relationships and patterns in data pop and allow you to tell the story of complex data sets, and conditional calculations are your first step towards doing that.
6. DATE & TIME FUNCTIONS
You'll learn how to add some pizzaz to your spreadsheets using the DATE and TIME Excel functions and analyze data across one of the most important variables that you'll want to consider when analyzing your data: changes across time.
7. TEXT FUNCTIONS
Ever receive a data dump and need to somehow sort through it all? Here you're going to learn how to pull out pieces of text data from a data set so that you can sort, organize, and ultimately analyze it using Text Excel functions. Large, messy data sets are present in almost every industry, so this is going to come in handy.
8. LOGICAL & LOOKUP FUNCTIONS
You'll start working with the magical VLOOKUP function! VLOOKUP works a lot like a phone book, where you start with the piece of data you know, like someone's name, in order to find out what you don't know, like their phone number. Nifty, huh?
9. MODELING IN EXCEL
Now the tables will turn (so to speak!) and you'll begin to learn from our data! This'll be done by learning how to model data. Modeling allows you to take messy data, learn from it, and make decisions from it. We'll also help you model your own finances in the Budget Project.
10. DATA VISUALIZATION
You'll learn to tell a story with our data using graphs. As humans we're often visual learners. We can't just look at a spreadsheet of numbers, we need to visualize it in order to separate the signal from the noise. Here you will learn how to do just that, so you can tell a persuasive story with your data that will influence how you (and your clients or boss!) make decisions.
11. WORKING WITH STRUCTURED DATA
You're going to learn to present & structure data using tables. We'll look at how we can use tables to present complex data, including external data and utilizing ranges, in a cohesive and structured manner.
12. PIVOT TABLES
You'll be introduced to one of our favourite parts of Excel: Pivot Tables. A Pivot Table is a table of grouped values that aggregates the individual items of a more extensive table within one or more discrete categories. This summary might include sums, averages, or other statistics, which the pivot table groups together using a chosen aggregation function applied to the grouped values. Sounds complex? It doesn't have to be. We'll break it down step-by-step so you learn exactly how powerful Pivot Tables are and how you can create them yourself.
13. MACROS & VBA
You'll learn about Macros and VBA, which stands for "Visual Basic for Applications" and are used to create custom user-generated functions and speed up manual tasks by creating automated processes - essentially to write your own code in Excel. Once you learn to do this, the possibilities are endless...
This course is not about making you just watch along without understanding the principles so that when you are done with the course you don’t know what to do other than watch another tutorial... No!
This course will push you and challenge you to go from an absolute beginner in Excel and turn you into an Excel wizard.
Taught by an industry professional:
Travis Cuzick has been architecting and coding data solutions for well over a decade and for some of the biggest companies on the Fortune 500.
As a self-taught developer and an Instructor at Zero To Mastery, Travis aims to make the learning process as efficient, intuitive, and fun (yes, fun!) for his students as possible to help them achieve real world success that extends far beyond the completion of his courses.
Travis applies exceptional Excel and SQL programming skills and extensive experience querying and manipulating multi-terabyte enterprise data stores for his work as a Data Solutions Engineer with major U.S. financial institutions. With a focus on being a strong communicator that is effective at defining complex business requirements and concisely summarizing detailed data analysis to business leaders, you know Travis can both talk the talk and walk and walk.
Courses should teach practical skills that are current and that lay a foundation for a future in this incredible and exciting industry. Having started as a self-taught developer, Travis knows the overwhelming feeling of not knowing where to begin, and the importance of learning from the best available sources.
Drawing from his vast experiences, Travis will show you that you don’t need to spend tens of thousands of dollars to get the skills you need to learn in-demand and future-proof skills, get hired, and make a difference.