MICROSOFT EXCEL ADVANCED
Specialization | 42 Course Series | 15 Mock Tests
This Excel Advanced Course includes 42 courses with 146+ hours of video tutorials and One year access and several mock tests for practice. You will also get verifiable certificates (unique certification number and your unique URL) when you complete each of the courses. This course is dedicated for you to learn Advanced Excel Functions, Pivot Tables, VBA & Macros, Dashboard creation etc.
Offer ends in:
What you'll get
- 146+ Hours
- 42 Courses
- Mock Tests
- Course Completion Certificates
- One year access
- Self-paced Courses
- Technical Support
- Mobile App Access
- Case Studies
Synopsis
- Courses: You get access to all the 42 courses, Projects. You do not need to purchase each course separately.
- Hours: 146++ Video Hours
- Core Coverage: Advanced Excel Functions, Pivot Tables, Power Pivot, Excel Reports, Excel Charts and Graphs, Excel Simulations, VBA & Macros, Dashboard creation
- Course Validity: One year access
- Eligibility: Anyone serious about mastering Microsoft Excel
- Pre-Requisites: Basic Excel Knowledge
- What do you get? Certificate of Completion for each of the 42 courses, Projects
- Certification Type: Course Completion Certificates
- Verifiable Certificates? Yes, you get verifiable certificates for each course with a unique link. These link can be included in your resume/Linkedin profile to showcase your enhanced Excel skills
Content
-
MODULE 1: Excel Advanced Overview
Courses No. of Hours Certificates Details Excel Advanced Overview 1m ✔ Microsoft Excel - Advanced 9h 32m ✔ Data Analysis with Pivot Tables 4h 58m ✔ Pivot Table for Beginners 1h 28m ✔ Pivot Tables Hands-on! 2h 3m ✔ Power Pivot in Microsoft Excel 3h 31m ✔ Power Pivot and DAX 32m ✔ Working with Pivot Tables Presentation 3h 7m ✔ Pivot Table Project - Problem Handling and Automation 1h 11m ✔ Pivot Table Case Study - Performance Ratings of Employees 1h 11m ✔ Test - Excel Mock Exam Test - Excel Assessment Exam -
MODULE 2: VBA and Macros Training
Courses No. of Hours Certificates Details Comprehensive VBA and Macros Training 10h 43m ✔ Creation of Basic CRM using MS Excel & VBA 3h 49m ✔ Project on VBA Macros - Automation using Loop 28m ✔ Creating Attendance Register using MS Excel & VBA 3h 6m ✔ MS Excel Sales Productivity Dashboard 6h 41m ✔ MS Excel Sales Productivity Dashboard - Advanced 7h 39m ✔ MS Excel Sales Dashboard 1h 3m ✔ Project - Case Paper using Excel VBA and Macros 2h 51m ✔ Project on VBA - Project Schedule Indexes 2h 52m ✔ Project on VBA - Financial Modeling using VBA 3h 7m ✔ Macros and VBAs Features and Concepts 6h 39m ✔ Project on VBA Macros - Create a Login-Logout Tracker 3h 35m ✔ Test - Excel VBA Mini Quiz Test - Mini Quiz Excel VBA Test - Excel VBA Assessment Test -
MODULE 3: Excel Charts, Functions, and Shortcuts
Courses No. of Hours Certificates Details Microsoft Excel Charts and SmartArt Graphics 6h 4m ✔ Power Excel Training 5h 15m ✔ MS Excel Shortcuts 8h 22m ✔ Financial Functions In MS Excel 2h 36m ✔ Date and Time Functions Microsoft Excel Training 2h 37m ✔ Statistical Tools in Microsoft Excel 1h 11m ✔ Shortcuts in Microsoft Excel 24m ✔ Mastering Microsoft Excel Date and Time 2h 47m ✔ Test - Complete Excel Exam Test - Ultimate Excel Test Test - 2023 Excel Exam -
MODULE 4: Excel HR and Interactive Dashboards
Courses No. of Hours Certificates Details MS Excel HR Dashboard 5h 56m ✔ Advanced HR Dashboard with MS Excel 8h 15m ✔ Interactive Dashboards using VBA 1h 6m ✔ TreeView and ListView in VBA 2h 23m ✔ Interactive Sales Dashboards using MS Excel & VBA 2h 18m ✔ Project on Excel VBA - Restaurant Billing System using Microsoft Excel VBA 3h 1m ✔ MS Excel Dashboard Training 5h 45m ✔ Test - Excel Mock Exam Test - Excel Assessment Exam Test - Complete Excel Exam -
MODULE 5: Advanced Excel Practicals and Financial Analysis
Courses No. of Hours Certificates Details Advanced Excel Practicals: Essentials for the Real World 3h 25m ✔ Pivot Table Case Study - Performance Ratings of Employees 1h 11m ✔ Advanced Excel for Financial Analysis 5h 38m ✔ Advanced Excel - Some Important Features 3h 21m ✔ Mastering Microsoft Excel Date and Time 2h 47m ✔ Test - 2023 Excel Exam -
MODULE 6: Mock Tests and Quizzes
Courses No. of Hours Certificates Details Test - Excel Mini Quiz Test - Mini Quiz Excel Test - Excel Assessment Test
Description
Welcome to our comprehensive Advanced Excel Mastery Course, where you'll embark on a journey to unlock the full potential of Microsoft Excel. Whether you're a beginner seeking to grasp the basics or an experienced user aiming to master advanced functionalities, this course is designed to cater to your needs and elevate your Excel proficiency to new heights. In this course, we have meticulously curated a series of modules, each offering in-depth exploration and hands-on practice in key areas of Excel. From fundamental concepts to advanced techniques, we cover everything you need to know to become a proficient Excel user. Our course begins with an overview of Excel fundamentals, providing a solid foundation for your learning journey. You'll then progress through modules dedicated to advanced topics such as data analysis with Pivot Tables, VBA programming, creating interactive dashboards, and mastering financial analysis tools. Each module comprises expertly crafted courses, practical projects, and quizzes, ensuring a holistic learning experience. Whether you're learning on your own or as part of a team, our course materials are designed to accommodate different learning styles and preferences. By the end of this course, you'll have the skills and confidence to tackle any Excel task with ease. Whether you're crunching numbers, analyzing data, or creating dynamic visualizations, Excel will become your go-to tool for productivity and efficiency. Join us on this exciting journey as we delve into the world of Excel mastery. Let's unlock the full potential of Excel together and take your skills to the next level!
Section 1: Excel Advanced Overview
This section provides an advanced overview of Microsoft Excel, encompassing a comprehensive exploration of its advanced functionalities and features. With a runtime of 1 minute, learners are introduced to the diverse capabilities of Excel, setting the stage for deeper exploration in subsequent courses. The "Learn Microsoft Excel from A-Z: Advanced Level" course, spanning over 9 hours and 21 minutes, serves as the cornerstone of this section, offering an extensive deep dive into advanced Excel topics. Learners delve into advanced data analysis techniques, formula manipulation, and automation strategies, empowering them to tackle complex tasks efficiently. The section further explores data analysis with Pivot Tables, with a runtime of 4 hours and 58 minutes, providing learners with the skills to summarize and analyze large datasets effectively. Additionally, learners are introduced to Pivot Table basics and hands-on practice in subsequent sections, ensuring a comprehensive understanding of this powerful feature. The "Power Pivot in Microsoft Excel 2016" and "Power Pivot and DAX 2019" courses further enhance learners' proficiency by introducing advanced data modeling techniques and DAX formulas. Finally, learners refine their presentation skills in "Working with Pivot Tables Presentation," preparing them to communicate insights effectively through visually compelling reports and dashboards. The section concludes with practical projects focusing on problem-solving and performance analysis using Pivot Tables, reinforcing learners' understanding and application of advanced Excel concepts.
Section 2: VBA and Macros Training
This section immerses learners in the world of Visual Basic for Applications (VBA) and macros, empowering them to automate tasks and customize Excel functionalities. The "Comprehensive VBA and Macros Training," spanning over 10 hours and 43 minutes, serves as the core component of this section, offering a comprehensive exploration of VBA programming concepts and techniques. Learners acquire essential skills to create, edit, and debug macros, enhancing their productivity and efficiency in Excel. The "Creation of Basic CRM using MS Excel & VBA" course provides practical insights into building a Customer Relationship Management (CRM) system using VBA, enabling learners to apply their knowledge in real-world scenarios. Practical projects such as "Project on VBA Macros - Automation using Loops" and "Creating Attendance Register using MS Excel & VBA" offer hands-on experience in automating repetitive tasks and building customized solutions. The section also includes specialized training on creating sales productivity dashboards and financial modeling using VBA, catering to learners' diverse interests and career goals. Through theoretical instruction, practical projects, and real-world applications, this section equips learners with the skills and expertise to leverage VBA and macros effectively in Excel.
Section 3: Excel Charts, Functions, and Shortcuts
This section focuses on enhancing data visualization, efficiency, and productivity in Microsoft Excel through charts, functions, and keyboard shortcuts. Learners embark on a journey to master Excel charts and SmartArt graphics, with a comprehensive runtime of 6 hours and 29 minutes, enabling them to create visually appealing and informative visuals to communicate data insights effectively. The "Power Excel Training" course, spanning over 5 hours and 15 minutes, equips learners with powerful Excel features for efficient data management and analysis, including data validation, filtering, and sorting. Learners further streamline their workflow and expedite tasks through the "MS Excel Shortcuts" course, with a runtime of 7 hours and 49 minutes, mastering time-saving keyboard shortcuts across various Excel operations. The section also covers essential financial and date/time functions in Excel, providing learners with the tools to perform complex calculations and date manipulations efficiently. Statistical tools in Excel are explored in depth, empowering learners to analyze and interpret data effectively for informed decision-making. With a focus on mastering date and time functions, learners refine their skills in handling temporal data and performing date-related calculations accurately. The section concludes with practical projects focusing on creating interactive dashboards and reports, allowing learners to apply their skills in real-world scenarios and showcase their proficiency in Excel.
Section 4: Excel HR and Interactive Dashboards
This section delves into specialized applications of Excel in human resources management and the creation of interactive dashboards. Learners are equipped with the skills to design and develop HR dashboards using Excel, with courses such as "MS Excel HR Dashboard" and "Advanced HR Dashboard with MS Excel," providing comprehensive training spanning over 5 hours and 56 minutes and 8 hours and 15 minutes, respectively. The "Interactive Dashboards using VBA" course offers insights into creating dynamic and user-friendly dashboards through VBA programming, enhancing learners' ability to customize Excel functionalities to meet specific requirements. Practical projects such as "TreeView and ListView in VBA" and "Interactive Sales Dashboards using MS Excel" provide hands-on experience in implementing advanced dashboard features and interactivity, further enriching learners' skill set. The section also includes project-based learning opportunities, allowing learners to apply their knowledge and expertise in creating practical solutions for HR management and interactive dashboard development. Through theoretical instruction, practical projects, and real-world applications, this section empowers learners to harness the power of Excel in HR management and dashboard creation, contributing to organizational efficiency and effectiveness.
Section 5: Advanced Excel Practicals and Financial Analysis
This section focuses on advanced Excel applications for financial analysis, data manipulation, and date/time functions. The "Advanced Excel Practicals: Essentials for ..." course, spanning over 3 hours and 25 minutes, provides learners with practical insights into advanced Excel functionalities, including formula manipulation, data analysis techniques, and data visualization methods. Learners further enhance their proficiency in financial analysis through the "Advanced Excel for Financial Analysis" course, with a runtime of 5 hours and 35 minutes, mastering advanced modeling techniques, valuation methods, and scenario analysis in Excel. The "Advanced Excel 2016 - Some Important Features" course offers an in-depth exploration of advanced features introduced in Excel 2016, enabling learners to leverage the latest tools and functionalities for enhanced productivity and efficiency. With a focus on mastering date and time functions, learners refine their skills in handling temporal data and performing date-related calculations accurately. The section concludes with practical projects focusing on performance rating analysis and financial modeling, allowing learners to apply their skills in real-world scenarios and showcase their proficiency in Excel. Through theoretical instruction, practical projects, and real-world applications, this section empowers learners to leverage advanced Excel tools and techniques for financial analysis and data manipulation, contributing to informed decision-making and organizational success.
Section 6: Mock Tests and Quizzes
This section offers mock tests and quizzes to assess learners' understanding and proficiency in Microsoft Excel. Learners have the opportunity to reinforce their learning and identify areas for improvement through regular assessments and feedback. The mock tests and quizzes cover a wide range of Excel topics, allowing learners to gauge their knowledge and measure their proficiency against industry standards. With regular assessments and feedback, learners can track their progress and tailor their learning experience to focus on areas that require further attention. By completing mock tests and quizzes, learners can build confidence in their Excel skills and prepare effectively for real-world applications and certifications. Through regular assessments and feedback, this section ensures learners are well-prepared to excel in their professional endeavors and contribute to organizational success through their proficiency in Microsoft Excel.
Sample Certificate
Requirements
- Basic Computer Literacy: Familiarity with using a computer, including navigating the operating system and using software applications, is essential.
- Basic Excel Knowledge: While not mandatory, having a basic understanding of Excel's interface, functions, and formulas will help you grasp concepts more quickly. If you're new to Excel, don't worry—we'll start with the fundamentals!
- Understanding of Spreadsheet Concepts: Knowledge of fundamental spreadsheet concepts such as cells, rows, columns, and basic data entry will be beneficial.
- Mathematical Skills: Basic mathematical skills, including arithmetic operations (addition, subtraction, multiplication, division) and percentages, will aid in understanding formulas and performing calculations.
- Ability to Follow Instructions: Excel requires attention to detail, so strong reading comprehension skills and the ability to follow step-by-step instructions are important.
- Willingness to Practice: Excel proficiency comes with practice, so be prepared to dedicate time outside of the course to reinforce your learning and explore Excel's features.
Target Audience
- Beginners: Individuals who are new to Excel and eager to learn its basics and functionalities. This group includes students, recent graduates, and professionals who are entering fields where Excel proficiency is essential.
- Intermediate Users: Those with some experience in Excel but seeking to deepen their knowledge and expand their skill set. This group comprises professionals in administrative roles, analysts, and small business owners looking to enhance their Excel skills.
- Advanced Users: Experienced Excel users who want to refine their expertise and explore advanced features and functionalities. This group may include financial analysts, data scientists, and business intelligence professionals.
- Professionals Seeking Career Advancement: Individuals aiming to advance their careers by mastering Excel and leveraging it effectively in their roles. This includes professionals in finance, accounting, marketing, operations, and human resources.
- Entrepreneurs and Small Business Owners: Business owners and entrepreneurs looking to utilize Excel for tasks such as financial management, budgeting, sales tracking, and performance analysis.
- Educators and Trainers: Teachers, trainers, and educators who want to incorporate Excel training into their curriculum or training programs to equip students with essential skills for the workforce.
- Continuous Learners: Individuals with a passion for learning and a desire to expand their knowledge and skill set. This includes lifelong learners, career switchers, and individuals pursuing personal development goals.
Course Ratings
Offer ends in:
Training 5 or more people?
Get your team access to 5,000+ top courses, learning paths, mock tests anytime, anywhere.
Drop an email at: [email protected]
This course is simple and easy to understand. Henceforth, I learned a lot about Pivot Tables, Pivot Charts, and Slicers from this. The person discussing is straight to the point. He does not use a lot of confusing words. He is clear and precise on the discussion. This is best for beginners such as I. I have never created Pivot Tables, Pivot Charts, or Slicers before, but after completing this course, I am confident in creating all of those.
Jasmin Charlotte A. Poblacion
The ability to build simple-to-read and highly insightful dashboards in excel is a necessity for any data analyst or business intelligence professional worth their salt. I recommend this short course to anyone out there trying to start learning how to build interactive dashboards in excel. Learn with ease and fun. Thank me later!
Joel Baidoo
I have learned a lot from your courses about Excel. I can say it is especially useful for people who lack in advanced Excel skills. Everything in videos are very clear and well-defined. I am very happy with the result, so thank you for providing us with the good quality of programs!
Gizem Ayvazoglu
Easy environment and objective teaching.
Marcus Vinicius de Sant Anna Agnelli