What you'll get
- 145+ Hours
- 42 Courses
- Mock Tests
- Course Completion Certificates
- Self-paced Courses
- Technical Support
- Case Studies
Synopsis
- Master advanced Excel features, formulas, and data analysis
- Create and analyze Pivot Tables and use Power Pivot & DAX
- Automate tasks with VBA and Macros
- Build charts, dashboards, and interactive reports
- Perform financial analysis and advanced data modeling
- Apply skills through practical projects and real-world examples
- Test your knowledge with quizzes and mock assessments
Content
| Courses | No. of Hours | Certificates | Details |
|---|---|---|---|
| Excel Advanced Overview | 1m | ✔ | View Curriculum |
| Advanced Excel Training 2019 | 9h 21m | ✔ | View Curriculum |
| Pivot Tables Course | 4h 58m | ✔ | View Curriculum |
| Pivot Table | 1h 28m | ✔ | View Curriculum |
| Pivot Tables in Microsoft Excel 2013 | 2h 3m | ✔ | View Curriculum |
| Power Pivot in Microsoft Excel | 3h 31m | ✔ | View Curriculum |
| Power Pivot 2019 | 32m | ✔ | View Curriculum |
| Pivot Table Presentation | 3h 7m | ✔ | View Curriculum |
| Issue Solving and Macro in Pivot Table | 1h 11m | ✔ | View Curriculum |
| Excel Smart Arts and Graphics | 1h 11m | ✔ | View Curriculum |
| Courses | No. of Hours | Certificates | Details |
|---|---|---|---|
| Comprehensive VBA and Macros Training | 10h 45m | ✔ | View Curriculum |
| Build CRM in Excel with VBA | 3h 49m | ✔ | View Curriculum |
| VBA Macros Automation | 24m | ✔ | View Curriculum |
| Attendance Register using Microsoft Excel VBA | 3h 6m | ✔ | View Curriculum |
| Sales Productivity Dashboard - Beginners Training | 6h 41m | ✔ | View Curriculum |
| Sales Productivity Dashboard - Advanced Training | 7h 39m | ✔ | View Curriculum |
| MS Excel Sales Dashboard | 1h 3m | ✔ | View Curriculum |
| EXCEL VBA MACROS #2 | 2h 51m | ✔ | View Curriculum |
| VBA Macros-Project | 2h 52m | ✔ | View Curriculum |
| Financial Modeling Using VBA Macros | 3h 7m | ✔ | View Curriculum |
| VBA Macros | 6h 39m | ✔ | View Curriculum |
| VBA Macro Applications Training | 3h 35m | ✔ | View Curriculum |
| Courses | No. of Hours | Certificates | Details |
|---|---|---|---|
| Microsoft Excel Charts and SmartArt Graphics | 6h 43m | ✔ | View Curriculum |
| Power Excel Training | 5h 15m | ✔ | View Curriculum |
| Microsoft Excel Reports | 7h 7m | ✔ | View Curriculum |
| Financial Functions in Excel | 2h 36m | ✔ | View Curriculum |
| Date and Time Functions Microsoft Excel Training | 2h 37m | ✔ | View Curriculum |
| Statistical Tools in Excel | 1h 11m | ✔ | View Curriculum |
| Shortcuts in Microsoft Excel | 24m | ✔ | View Curriculum |
| Mastering Microsoft Excel Date and Time | 2h 47m | ✔ | View Curriculum |
| Courses | No. of Hours | Certificates | Details |
|---|---|---|---|
| HR Dashboard & Analytics - Beginners | 5h 13m | ✔ | View Curriculum |
| HR Dashboard & Analytics - Advanced | 8h 11m | ✔ | View Curriculum |
| Interactive Dashboards using Microsoft Excel VBA | 1h 6m | ✔ | View Curriculum |
| TreeView & ListView - Creating a Basic Project Management Tool | 2h 23m | ✔ | View Curriculum |
| Interactive Excel & VBA Dashboards | 2h 12m | ✔ | View Curriculum |
| Restaurant Billing System using Microsoft Excel VBA | 3h 1m | ✔ | View Curriculum |
| Microsoft Excel Dashboard Training | 5h 45m | ✔ | View Curriculum |
| Courses | No. of Hours | Certificates | Details |
|---|---|---|---|
| Excel 2019 Advanced Functions | 3h 25m | ✔ | View Curriculum |
| Excel Smart Arts and Graphics | 1h 11m | ✔ | View Curriculum |
| Advanced Excel for Financial Analysis | 5h 38m | ✔ | View Curriculum |
| Advanced Excel 2016 - Some Important Features | 3h 21m | ✔ | View Curriculum |
| Mastering Microsoft Excel Date and Time | 2h 47m | ✔ | View Curriculum |
| Courses | No. of Hours | Certificates | Details |
|---|---|---|---|
| No courses found in this category. | |||
Description
Learn Microsoft Excel from the basics to the advanced in this all-in-one course. Whether you are a beginner wanting to learn the basics or an experienced user aiming to master advanced Excel functionalities, this course provides practical, hands-on training to elevate your skills and boost your productivity.
Module 1: Excel Advanced Overview
Gain an in-depth understanding of Excel's advanced features. Begin with the basics and move on to advanced data analysis, formulas, and automation. Learn how to work with Pivot Tables, Power Pivot, and DAX formulas to summarize and analyze large datasets efficiently. Complete practical projects to reinforce your knowledge and develop skills for presenting insights through visually compelling reports and dashboards.
Key Topics: Advanced data analysis, Pivot Tables, Power Pivot, DAX formulas, data presentation, and practical projects.
Module 2: VBA and Macros Training
Master automation in Excel with VBA and macros. Learn to create, edit, and debug macros to save time and enhance productivity. Apply your skills to practical projects such as creating a CRM, an attendance register, or a sales dashboard. Gain expertise in customizing Excel functionalities and automating repetitive tasks.
Key Topics: VBA programming, macro creation, automation projects, CRM system, dashboards, and financial modeling.
Module 3: Excel Charts, Functions, and Shortcuts
Enhance your data visualization and efficiency with Excel charts, SmartArt graphics, and essential functions. Learn powerful data management techniques, master date, time, and financial functions, and streamline workflows with keyboard shortcuts. Build dashboards and reports to clearly share insights.
Key Topics: Charts and SmartArt, financial and date/time functions, statistical tools, keyboard shortcuts, and interactive dashboards.
Module 4: Excel HR and Interactive Dashboards
Explore specialized Excel applications for human resources management and dynamic dashboards. Learn to design interactive HR dashboards, implement TreeView and ListView controls, and create engaging, user-friendly dashboards using VBA. Apply your skills in practical projects to develop real-world HR and business solutions.
Key Topics: HR dashboards, interactive dashboards, VBA controls, project-based learning, business applications.
Module 5: Advanced Excel Practicals and Financial Analysis
Focus on advanced Excel techniques for financial analysis, data manipulation, and scenario modeling. Master formula manipulation, valuation methods, and performance analysis using real-world projects. Learn to leverage advanced Excel tools introduced in Excel 2016 for maximum efficiency and productivity.
Key Topics: Advanced formula techniques, financial modeling, scenario analysis, data visualization, performance analysis projects.
Module 6: Mock Tests and Quizzes
Test your Excel knowledge with mock assessments and quizzes. Practice, spot your weak areas, and track your progress. Prepare for real-world applications and professional certifications with confidence.
Key Topics: Mock tests, quizzes, self-assessment, progress tracking, certification preparation.
Sample Certificate
Requirements
-
Basic computer literacy
-
Familiarity with Excel and spreadsheet concepts
-
Basic mathematical skills
-
Ability to follow instructions and practice regularly.
Target Audience
-
Beginners and intermediate users
-
Advanced users and professionals seeking career growth
-
Entrepreneurs and small business owners
-
Educators, trainers, and lifelong learners.
