Complete Excel Bootcamp: Zero to Hero in Excel (Udemy.com)
Learn how to become a professional Excel wizard
Created by: Jose Portilla
Last updated April 2022
What you will learn
- Go from Zero to Hero in Excel
- Explore the core functions that make you an Excel wizard
- Understand List Operations and Logical Functions in Excel
- Create functions with Math, Text, and Date operators inside of Excel
- Get lifetime access to advanced template spreadsheets and projects
- Automate your workflow with efficient Excel tricks
- Explore advanced functionality in Excel, such as Pivot Tables and Macros
- Learn about Linear Optimization and Solver within Excel
Course Description
Welcome to the best online resource to become an Excel Professional!
We'll take you from Zero to Excel Hero through an interactive and project based learning experience in this course!
We've carefully designed this course to teach you how to become a pro in excel, using lessons based on real world situations.
We start by covering all the basics to make sure you quickly get up to speed on Excel Versions and the Excel Interface, along with covering Workbooks and the Anatomy of the cell. Afterwards we'll start taking you through Excel functionality that can turn you into a super-user. Including exploring common functions in Excel and creating your own Excel functions. Once we've covered the basics we start to ramp up your skills with List Operations and Logical Functions, including LOOKUP functions in Excel. Then we begin a tour of some more advanced functionality built into Excel, including Text, Math, and Date functions. At this point many courses would stop, but we want to turn you into a Hero! We'll continue your education with advanced topics such as Pivot Tables, Add-ins and Macros, and very advanced tools like Solvers, Linear Optimization, and the Analysis ToolPak.
All along the way we present real-world based projects and template spreadsheets for you to use to practice your new skills. We also include access to our Q&A forums and our Discord chat channel where you can connect with other students to talk about Excel.
This course includes topics such as:
Understanding Excel Versions
Core Excel Spreadsheet Ideas
Common Functions in Excel
Creating References and Functions
List Operations
Logical Functions
LOOKUP Functions
Text Functions
Math Functions
Date Functions
Pivot Tables
Data Imports
Charts
Debugging
Data Hygiene
Add-ins and Macros
Solvers and Linear Optimization
Analysis ToolPak
and much more!
All of this comes with a 30-day money back guarantee, so you can try the course completely risk free!
Enroll in the course and become an Excel Hero today! We'll see you inside the course.
- Pierian Training Team
Instructor Details
- 4.3 Rating
933 Reviews
Jose Portilla
Jose Marcial Portilla has a BS and MS in Mechanical Engineering from Santa Clara University and years of experience as a professional instructor and trainer for Data Science, Machine Learning and Python Programming. He has publications and patents in various fields such as microfluidics, materials science, and data science. Over the course of his career he has developed a skill set in analyzing data and he hopes to use his experience in teaching and data science to help other people learn the power of programming, the ability to analyze data, and the skills needed to present the data in clear and beautiful visualizations. Currently he works as the Head of Data Science for Pierian Training and provides in-person data science and python programming training courses to employees working at top companies, including General Electric, Cigna, SalesForce, Starbucks, McKinsey and many more. Feel free to check out the website link to find out more information about training offerings.
More courses by Jose Portilla
The Complete Python Bootcamp From Zero to Hero in Python (2025)
4.6 (566,376 Reviews)
Provider: Udemy
Time: 22.4h
$199.99
The Complete SQL Bootcamp: Go from Zero to Hero (2022)
4.7 (258,007 Reviews)
Provider: Udemy
Time: 8.9h
$159.99
Python for Data Science and Machine Learning Bootcamp (2020)
4.5 (160,681 Reviews)
Provider: Udemy
Time: 24.9h
$124.99
Python and Django Full Stack Web Developer Bootcamp (2019)
4.4 (52,248 Reviews)
Provider: Udemy
Time: 31.9h
$159.99
Spark and Python for Big Data with PySpark (2020)
4.6 (26,667 Reviews)
Provider: Udemy
Time: 10.6h
$27.99
Learning Python for Data Analysis and Visualization Ver 1 (2022)
4.5 (20,266 Reviews)
Provider: Udemy
Time: 21.1h
$27.99
More Excel courses
Microsoft Excel Data Analysis - Learn How The Experts Use It (2026)
5.0 (5,696 Reviews)
Provider: Udemy
Time: 3h
$39.99
Microsoft Excel: Advanced Dashboard Design (Project-Based!) (2026)
4.9 (4,868 Reviews)
Provider: Udemy
Time: 6.4h
$99.99
Master NEW Excel Functions in Office 365 & Office 2021+
4.8 (5,262 Reviews)
Provider: Udemy
Time: 7.1h
$15.99
Microsoft Excel Certification Exam Prep: MO-201 Excel Expert (2026)
4.8 (3,239 Reviews)
Provider: Udemy
Time: 8.6h
$119.99
Reviews
By PRASANTH PERIYASAMY on 4/24/2026
This course helped me to understand the Index, VLOOKUP, Ifs purpose in clear manner. Data analysis and VBA creation are good options to explore which will save the repeated work and save the time. The one who wants to familiarize the available options in Excel, can enroll in this course.
By Teresa Whelan on 6/25/2025
The course was very through. Presented very well and clear. The exercises were perfect even though some of them may have been too advanced for me. Now I have a good idea of the scope of tasks that Excel can do, so I can build from there.
By Lautaro Valentín Ramos on 1/7/2024
El curso está muy bien organizado, haciendo que el aprendizaje sea fluido y sencillo. Los ejercicios son desafiantes y reflejan los que uno podría encontrarse en situaciones reales.
By Manthan kapopara on 12/16/2023
Nothing but amazing. When I started I literally had zero knowledge about Excel. But, after attending this course, that notion has been broken. I would like to convey my gratitude and regards for Jose sir.
By Theresa Parker on 4/9/2023
Loving this course. Very easy to follow. I love how everything has been designed for a hands -on experience. I always felt the best way to learn was to do.
By Christopher Boorman on 2/22/2023
The guy is knowledgeable, but he's trying to "wing it". If you're making a recording, there should be no interrupting of yourself or awkward explanations. There should also be no editorializing of which functions you don't like. Course leader is frequently surprized at the results he gets when he applies the formulas. Why? Didn't he walk through his own course beforehand? Should have prepared more before recording, then do as many retakes and edits as needed so everything is smooth.
By James Ong on 10/14/2022
It's been an enjoyable learning experience as Jose has been a great trainer. I have also started to use the things I learned here on my work and results have been great.
By M. George Puziak on 6/4/2022
I was at 80% Hero, so I understood it all even though it was presented very quickly. For a true beginner, assuming a 25% Level, this course should be studied over 17 weeks so that it can be fully absorbed. Overall, it was exciting to have access to the mental workings of a true expert and lean not only the functions of Excel but, more importantly for me, how to think about its applications.
By Lillian Reyes on 5/11/2022
Instructor seems to be stumbling on a few of the exercise instructions. Probably should have practiced the materials to know the caveats prior to recording these lessons.
By Edouard Piché on 5/2/2022
I have taken Pyhton and data science courses with Jose Portillo and they were excellent. Todd Hanford appears to be knowledgeable, but comes across as unrehearsed. This detracts from the subject matter.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 86 / 100












