Complete Excel Bootcamp: Zero to Hero in Excel
What you'll 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
Requirements
- No prior knowledge required
- Access to Microsoft Excel (most current versions are compatible with course material)
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
Who this course is for:
- This course is designed for anyone looking to go from Zero to Hero in Microsoft Excel in a Bootcamp environment.
- We take you all the way from understanding core basics like Excel Cells to advanced topics like Linear Optimizations in Excel
Instructors
- 4.6 Instructor Rating
- 1,279,962 Reviews
- 4,296,499 Students
- 87 Courses
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.
- 4.5 Instructor Rating
- 816 Reviews
- 6,225 Students
- 1 Course
I have over a decade of experience in consulting, product management, data analytics, and software engineering. I have developed analytical expertise in Excel, then progressed to Tableau and SQL, and finally mastered Python and JavaScript. During this journey I have taken dozens of online courses on Udemy, MIT, Coursera, and elsewhere to hone my skills.
I manage a company, Uprove, which helps career starters and career switchers find new jobs and prove their skills through project exercises.
Outside of work, I love everything outdoors. I love hiking with my dog, Shelby, and also traveling internationally for multi-day backpacking trips. I am also a practicing volunteer EMT with my local fire department.
- 4.6 Instructor Rating
- 1,287,775 Reviews
- 4,225,283 Students
- 94 Courses
Pierian Training stands as a premier provider in the realms of Data Science and Machine Learning education, offering both in-person and virtual instructor-led training tailored for enterprises. Explore our comprehensive profile to discover a wide range of courses designed to enhance your professional skills and organizational capabilities. Feel free to contact us if you have any questions in the link on our profile!