Courses

Advanced Excel

Become an Excel power user with this online advanced Excel training course. Learn the use of advanced excel functions, formulas, macros, and many more with skilled professional instructors.

Difficulty Level: INTERMEDIATE

Age group: 15-39

Content

Printing Charts - Excel New Features of Chart Excel New Features of Chart - Excel–Chart Recommendations - Change in Charts Group - Fine Tune Charts Quickly - Select/De-select Chart Elements - Format Style - Format Color - Filter Data - Format Axis - Provision for Combo Charts - Excel Functions Excel Functions - Excel–New Functions Excel–New Functions - Functions by Category - New Functions in Excel2019 - User Defined Functions in Add-ins - Web Functions Web Functions - Excel Data Validation Excel Data Validation - Creating an Excel Data Validation List - Excel Decimal Data Validation - Adding a Custom Excel Data Validation Error - Dynamic Formulas by Using Excel Data Validation Techniques - Data Validation Quiz Data Validation Quiz - Excel Look Up Functions Excel Look Up Functions - Microsoft Excel VLOOKUP() Function - Microsoft Excel HLOOKUP() Function - Microsoft Excel INDEX() Function - Microsoft Excel MATCH() Function - Microsoft Excel INDEX() and MATCH() Function Combined - Creating a Dynamic HLOOKUP() with the MATCH() Function Creating a Dynamic HLOOKUP() with the MATCH() Function - Excel " What if " Tool Excel " What if " Tool - Working with Excel's Goal Seek Tool - Working with Excel's Solver Tool - Building Effective Data Tables in Excel - Creating Scenarios in Excel Creating Scenarios in Excel - Excel with Macros Excel with Macros - Understanding Excel Macros - Activating the Developer Tab in Excel - Creating a Macro with the Macro Recorder - Editing a Macro with VBA - Creating Buttons to Run Macros Creating Buttons to Run Macros - Data Analysis Data Analysis - Instant Data Analysis - Quick Analysis Features - Quick Analysis of Data - Conditional Formatting - Charts - Totals - Tables - Excel–Sorting Data by Color - Excel–Slicer Excel–Slicer - Powerful Data Analysis Powerful Data Analysis - Introduction to Excel–Pivot Table - Create a PivotTable to Analyze External Data - Connect to a new External Data Source - Using the Field List Option - Pivot Tables Based on Multiple Tables Pivot Tables Based on Multiple Tables - Excel–Data Model in Excel Excel–Data Model in Excel - Explore Data Using PivotTable - Create Relationship between Tables - Data Model Using Calculated Columns - Relationship Using Calculated Columns Relationship Using Calculated Columns - Excel–External Data Connection Excel–External Data Connection - Update the Data Connections - Automatically Refresh Data - Automatically Refresh Data at Regular Intervals - Enable Background Refresh Enable Background Refresh - PivotTable Tools PivotTable Tools - Source Data for a PivotTable - Change to a Different External Data Source - Delete a PivotTable - Using the Timeline - Use a Timeline to Filter by Time Period - Create a Stand alone PivotChart Create a Stand alone PivotChart - Visualizations Visualizations - Create Charts and other Visualizations - Visualization–Matrix - Visualization–Card - Visualization –Charts Visualization –Charts - Pie Charts Pie Charts - Bubble and Scatter Charts - Maps - Multiples:A Set of Charts with the Same Axes - Visualization –Tiles Visualization –Tiles - Power View–Additional Features Power View–Additional Features - Modify the Internal Data Model - Excel–Power View in Services - Key Performance Indicators(KPIs) - Hierarchies - Drill-Up and Drill-Down Drill-Up and Drill-Down - Format Reports Format Reports - Hyperlinks - Printing - Support for right-to-left languages Support for right-to-left languages - Handling Integers Handling Integers - Power Query - Power BI Desktop Other Features - Excel–Templates - Excel–Inquire - Ensure Inquire Add-in is Active - Compare Two Workbooks - Embed Worksheet Data in a Web Page Power BI Desktop - Other Features Embed Worksheet Data in a Web Page - Workbook Analysis Workbook Analysis - Diagrams - Workbook Relationship - Worksheet Relationship - Cell Relationship - Clean Excess Cell Formatting Assignment - Assignments Basis of given topic

Prerequisites

Basic understanding of MS Excel
Enthuziasm to explore MS Excel

Objectives

Data Management and Power Query: Learn to use Power Query for data transformation and cleansing, and manage large datasets efficiently with data validation, conditional formatting, and advanced sorting and filtering techniques.
Automation with Macros and VBA: Understand how to write and run macros, and use Visual Basic for Applications (VBA) to automate repetitive tasks and enhance Excel functionality.
Advanced Data Analysis with PivotTables: Gain expertise in creating and manipulating PivotTables for dynamic data summarization, filtering, and trend analysis.
Data Visualization Techniques: Develop skills to create and customize advanced charts, pivot charts, and dashboards for effective data presentation and insights.
Mastering Advanced Formulas and Functions: Learn to use complex formulas and functions such as VLOOKUP, HLOOKUP, INDEX, MATCH, and advanced array formulas to automate calculations and data analysis.

Learning Outcomes

Solid understanding of the powerful features of Excel
Mastery in working with advanced formulas and functions
Ability to create impressive charts, graphs, and tables
Proficiency in working with real-time data
Skill of working as a data analyst

Why learn with EnthuZiastic?

Here's why more and more people are joining EnthuZiastic

Personalized Lessons

Customize your lessons to meet your individual goals.

Expert Teachers

Top rated teachers to guide you through the learning process.

Flexible Timings

Attend classes anytime, anywhere. Make your own schedule.

Easy Rescheduling

manage holidays or conflicting appointments easily by rescheduling classes.

Complete Support

A compassionate support team to listen to your needs.

Completion Certificate

You will get a certificate for the completion of the course.

How it works?

Enroll

Enroll for the course of your liking by selecting 1:1 or group classes. Choose the type of instructor you want to learn with.

Schedule

Download Enthu app and schedule classes for the day and time that works best for you. You own your learning schedule.

Learn

Join classes on Zoom and start learning with lessons customized for you. Make most of our student success program.

Value Proposition

We offer a diverse range of interactive classes, ensuring accessible and personalized education for everyone, anytime, anywhere.

Carefully Curated Expert Instructors

All courses are taught by our expert instructors who are carefully chosen with a rigorous < 1% acceptance rate. For every 100 tutors interviewed, only 1 is chosen, ensuring you get the best.

Engaging and Interactive Classes

Each session is designed to be dynamic and captivating, ensuring the learner stays excited and engaged throughout.

Progress Reports

Our team works hard behind the scenes to create and maintain a meticulously detailed progress report for each learner as they progress through the sessions.

Session Recordings

The recordings of each session are automatically available in the app after 24 hours of each session, they are extremely helpful for revisions.

Certificates

Some rewards are necessary for motivating learners and Enthuziastic awards dedicated learners with official certificate of completion and if they win in any of our regular competitions, they are awarded the respective winners certificates.

Feedback and Assignments

Parents/Learners provide us regular feedback after every session through a formal submission in the app, this helps us customize the learning path after every session according to how the learners are responding to the tutoring.

Chat Communication

Connect with instructors and peer learners directly via our app's dedicated chat group for every batch fostering a community experience while learning together.

24/7 Support

We take great pride in our service delivery. We're here for you round the clock to address any questions or concerns.

Quality & Affordability

The entire Enthuziastic team strives hard to bring you high quality learning at affordable prices. Because of the support of learners like yourself, we continue to grow our offerings and keep making them more and more affordable.

Personal Family Buddy

You will be assigned a personal family buddy, whom you can continuously stay in touch through and beyond your learners learning journey. Whatever your needs are you can always reach out to your Family Buddy/Student Success Manager whose only job is to make your learning journey successful.

Carefully Curated Expert Instructors

All courses are taught by our expert instructors who are carefully chosen with a rigorous < 1% acceptance rate. For every 100 tutors interviewed, only 1 is chosen, ensuring you get the best.

Engaging and Interactive Classes

Each session is designed to be dynamic and captivating, ensuring the learner stays excited and engaged throughout.

Progress Reports

Our team works hard behind the scenes to create and maintain a meticulously detailed progress report for each learner as they progress through the sessions.

Session Recordings

The recordings of each session are automatically available in the app after 24 hours of each session, they are extremely helpful for revisions.

Certificates

Feedback and Assignments

Chat Communication

Connect with instructors and peer learners directly via our app's dedicated chat group for every batch fostering a community experience while learning together.

24/7 Support

We take great pride in our service delivery. We're here for you round the clock to address any questions or concerns.

Quality & Affordability

Personal Family Buddy

Do you have any questions?

Fill this form and we will respond back, on priority.

This course Includes

19 live tutoring sessions

Access on mobile and web

Certificate of completion

Typical Price

$29 .59

/ session / seat

30-Day Money-Back Guarantee

Courses

Advanced Excel

Become an Excel power user with this online advanced Excel training course. Learn the use of advanced excel functions, formulas, macros, and many more with skilled professional instructors.

Difficulty Level: INTERMEDIATE

Age group: 15-39

Content

Prerequisites

Basic understanding of MS Excel
Enthuziasm to explore MS Excel

Objectives

Data Management and Power Query: Learn to use Power Query for data transformation and cleansing, and manage large datasets efficiently with data validation, conditional formatting, and advanced sorting and filtering techniques.
Automation with Macros and VBA: Understand how to write and run macros, and use Visual Basic for Applications (VBA) to automate repetitive tasks and enhance Excel functionality.
Advanced Data Analysis with PivotTables: Gain expertise in creating and manipulating PivotTables for dynamic data summarization, filtering, and trend analysis.
Data Visualization Techniques: Develop skills to create and customize advanced charts, pivot charts, and dashboards for effective data presentation and insights.
Mastering Advanced Formulas and Functions: Learn to use complex formulas and functions such as VLOOKUP, HLOOKUP, INDEX, MATCH, and advanced array formulas to automate calculations and data analysis.

Learning Outcomes

Solid understanding of the powerful features of Excel
Mastery in working with advanced formulas and functions
Ability to create impressive charts, graphs, and tables
Proficiency in working with real-time data
Skill of working as a data analyst

Why learn with EnthuZiastic?

Here's why more and more people are joining EnthuZiastic

Personalized Lessons

Customize your lessons to meet your individual goals.

Expert Teachers

Top rated teachers to guide you through the learning process.

Flexible Timings

Attend classes anytime, anywhere. Make your own schedule.

Easy Rescheduling

manage holidays or conflicting appointments easily by rescheduling classes.

Complete Support

A compassionate support team to listen to your needs.

Completion Certificate

You will get a certificate for the completion of the course.

How it works?

Enroll

Enroll for the course of your liking by selecting 1:1 or group classes. Choose the type of instructor you want to learn with.

Schedule

Download Enthu app and schedule classes for the day and time that works best for you. You own your learning schedule.

Learn

Join classes on Zoom and start learning with lessons customized for you. Make most of our student success program.

Value Proposition

We offer a diverse range of interactive classes, ensuring accessible and personalized education for everyone, anytime, anywhere.

Carefully Curated Expert Instructors

All courses are taught by our expert instructors who are carefully chosen with a rigorous < 1% acceptance rate. For every 100 tutors interviewed, only 1 is chosen, ensuring you get the best.

Engaging and Interactive Classes

Each session is designed to be dynamic and captivating, ensuring the learner stays excited and engaged throughout.

Progress Reports

Our team works hard behind the scenes to create and maintain a meticulously detailed progress report for each learner as they progress through the sessions.

Session Recordings

The recordings of each session are automatically available in the app after 24 hours of each session, they are extremely helpful for revisions.

Certificates

Feedback and Assignments

Chat Communication

Connect with instructors and peer learners directly via our app's dedicated chat group for every batch fostering a community experience while learning together.

24/7 Support

We take great pride in our service delivery. We're here for you round the clock to address any questions or concerns.

Quality & Affordability

Personal Family Buddy

Carefully Curated Expert Instructors

All courses are taught by our expert instructors who are carefully chosen with a rigorous < 1% acceptance rate. For every 100 tutors interviewed, only 1 is chosen, ensuring you get the best.

Engaging and Interactive Classes

Each session is designed to be dynamic and captivating, ensuring the learner stays excited and engaged throughout.

Progress Reports

Our team works hard behind the scenes to create and maintain a meticulously detailed progress report for each learner as they progress through the sessions.

Session Recordings

The recordings of each session are automatically available in the app after 24 hours of each session, they are extremely helpful for revisions.

Certificates

Feedback and Assignments

Chat Communication

Connect with instructors and peer learners directly via our app's dedicated chat group for every batch fostering a community experience while learning together.

24/7 Support

We take great pride in our service delivery. We're here for you round the clock to address any questions or concerns.

Quality & Affordability

Personal Family Buddy