Helpful and informative
Complete Excel Course including VBA - Beginner to Advanced
Gain comprehensive knowledge of Excel with VBA, whether you're a student or a professional, through a single course
Office Productivity,Microsoft,Excel
Lectures -180
Resources -70
Duration -13.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Excel Beginner: Conquer Spreadsheet Fears!
Embark on your Excel journey with our Beginner course, addressing common hurdles faced by newcomers. Tackle challenges like understanding basic functions and formatting pitfalls. We guide you through potential stumbling blocks, ensuring you grasp foundational concepts with confidence. Transform Excel from a puzzle into a powerful tool at your fingertips.
Excel Intermediate: Overcome Analysis Anxiety!
Navigate through the Intermediate course, overcoming obstacles such as data interpretation confusion and formula complexities. We break down barriers, providing solutions to common hurdles in data analysis and function integration. By addressing these challenges head-on, you'll emerge adept at handling real-world Excel conundrums.
Excel Advanced: Navigate the Depths of Data!
In the Advanced course, we tackle intricate challenges like mastering pivot tables and unraveling complex data structures. Overcome hurdles associated with advanced functions and intricate modeling. We guide you through potential stumbling blocks, ensuring you emerge as a data manipulation virtuoso, equipped to navigate Excel's intricate terrains.
VBA Mastery: Troubleshoot Automation Challenges!
As you delve into VBA Mastery, we address potential roadblocks in automation, from script debugging to creating custom functions. Navigate through common pitfalls associated with automating tasks and learn troubleshooting techniques. By dissecting these challenges, you'll harness the full potential of VBA, transforming Excel into a seamless, automated powerhouse.
Goals
- Conquer the foundations, envision seamlessly handling data, charts, and simple analyses.
- Confidently analyze data, employ advanced formulas, and present insights with finesse.
- Empower with the skills to design and implement powerful automation solutions using VBA. Picture yourself as the automation maestro, streamlining workflows, and unlocking new levels of efficiency in your data-driven endeavors. VBA Mastery propels you into the realm of Excel mastery, where automation is not just a tool but a transformative force.
Prerequisites
- No prior knowledge is required for the Excel Beginner course.
- Familiarity with basic Excel functions, formulas, and spreadsheet navigation will ensure a smooth transition into the intermediate level.
- Participants should be comfortable with advanced functions, data analysis, and basic data modeling to fully benefit from the content covered in the advanced course.
- Familiarity with concepts like variables, loops, and conditional statements will facilitate a deeper comprehension of VBA (Visual Basic for Applications) programming.

Curriculum
Check out the detailed breakdown of what’s inside the course
The Complete Excel Course
1 Lectures
-
Why Learn Excel 00:34 00:34
Excel Beginner - Course Welcome
2 Lectures

Excel Beginner - Excel Fundamentals
8 Lectures

Excel Beginner - Entering and Editing Text
8 Lectures

Excel Beginner - Basic Excel Functions
5 Lectures

Excel Beginner - Modifying and Excel Worksheet
7 Lectures

Excel Beginner - Formatting Data
5 Lectures

Excel Beginner - Images, Shapes and Smart Art
2 Lectures

Excel Beginner - Printing in Excel
3 Lectures

Excel Beginner - Templates
3 Lectures

Excel Beginner - Conclusion
1 Lectures

Excel Intermediate - Welcome
3 Lectures

Excel Intermediate - Lists
6 Lectures

Excel Intermediate - Database Functions
7 Lectures

Excel Intermediate - Data Validation
3 Lectures

Excel Intermediate - Importing and Exporting
3 Lectures

Excel Intermediate - Creating Basic Charts
4 Lectures

Excel Intermediate - Pivot Tables
9 Lectures

Excel Intermediate - Working with Large Data
2 Lectures

Excel Intermediate - LookUp Functions
3 Lectures

Excel Intermediate - Financial Functions
4 Lectures

Excel Intermediate - Conclusion
1 Lectures

Excel Advanced
3 Lectures

Excel Advanced - Working with Multiple Workbooks
4 Lectures

Excel Advanced - Protecting Worksheets and Workbooks
3 Lectures

Excel Advanced - Conditional Formulas
7 Lectures

Excel Advanced - Advanced Functions
8 Lectures

Excel Advanced - Text Based Functions
5 Lectures

Excel Advanced - What IF Tools
4 Lectures

Excel Advanced - Conclusion
1 Lectures

Excel Dashboards
1 Lectures

Excel VBA
1 Lectures

Excel VBA - Course Introduction
2 Lectures

Excel VBA - Macros
3 Lectures

Excel VBA - The VBA Editor
7 Lectures

Excel VBA - Variables and Procedures
14 Lectures

Excel VBA - Loops and IF Statements
9 Lectures

Excel VBA - Error Handling
1 Lectures

Excel VBA - UDFs - User Defined Functions
1 Lectures

Excel VBA - Advanced Exercise Walkthroughs
10 Lectures

Excel VBA - All About Forms
5 Lectures

Excel VBA - Course Resources
1 Lectures

Instructor Details

Andries Nienaber
Hi there, my name is Andries and I have been working with Excel for over 20 years. I have worked with major corporate companies such as Nespresso and various Banks.
I currently am one of the preferred in-classroom trainers for Office and I am dedicated to helping you create outstanding tools and reports in Excel. Our courses are for those who want to learn Excel, accelerate their careers, and achieve more in less time.
For over 20 years I have worked in the Finance and IT departments implementing reporting systems based on SQL and XML. All the while using Excel VBA to automate and improve processes.
Our courses include examples based on real-life experience as well as the consulting work I have done for many international companies.
I place great value on keeping my Excel courses not only informative but also engaging. For this reason, students will find enough challenges, exercises, and downloadable files to practice so they can maximize the value gained from each course.
Course Certificate
Use your certificate to make a career change or to advance in your current career.

Our students work
with the Best


































Feedbacks
excellent lecture
You guys are amazing! Things my own job cant even teach us
Nice
Great!
good course
nice
nice
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now