Skip to content
UdemyExcelPaid courseAll LevelsCertificate

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

icon
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

icon
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

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

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.

icon
More courses by Jose Portilla

$199.99

$159.99

$124.99

$159.99

$27.99

$27.99

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

icon
Reviews

4.3

933 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

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.

Showing all 10 reviews on CourseDuck

Read all 933 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 86 / 100