EVENT DESCRIPTION
Master the art of Automating reports, applying Functions, Analysing data, creating Graphical reports, and preparing Dashboards
How can advanced Excel help you succeed?
Excel may appear like a simple spreadsheet software to you. But it is much more than that. It is one of the most powerful tools to boost your career.
Excel is a game changer in the world of business intelligence. In today’s world, data is the new currency. And when it comes to working with data, there is no better tool than Excel.Look at how mastering Excel can take your career to the next level!
It can help you to:
- improve data analysis
- automate tedious tasks
- boost financial analysis
- make informed decisions
- enhance your productivity
Excel continues to be the most sought-after skill for professionals across all industries. Be ready to get an edge ahead of the rest by attending our advanced Excel workshop.
Why should you enroll for this workshop?
This workshop will help you elevate your Excel skills to the next level. At the end of the workshop, you will be able to:
- create automated reports with key trends and actionable insights
- work with graphs to represent and structure your data
- use commands, formulas, and short keys like a pro
- learn data validation and consolidation
- automate repetitive tasks
What are your key takeaways from the workshop?
Here’s what you can look forward to from the workshop.
- Earn an e-certificate at the end of the session.
- Practice, review, and ask questions in real time.
- Receive guidance from a Microsoft-certified Excel expert.
- Get 100% practical application of concepts with case studies and examples.
- Access all the solved files, case studies, and reference guides after the session.
What is the schedule of this workshop?
The workshop has been planned for late evening hours, allowing you to attend without disrupting your regular working schedule. It spans over a total of 24 hours, divided into 2-hour sessions on alternate days (Monday to Friday). The workshop commences on June 5, 2023. Take a look at the comprehensive schedule provided below, which progresses from foundational to intermediate and advanced modules. This approach will enable you to develop your skills starting from the basics. Additionally, each module will encompass relevant topics, ensuring a smooth and continuous learning experience.
Module | Date | Time |
Setting workbook & worksheets | Jun 5, 2023 | 8:30 PM – 10:30 PM |
Text, Maths and Date Functions | Jun 7, 2023 | 8:30 PM – 10:30 PM |
Logical, Statistical Functions & Formula Auditing | Jun 9, 2023 | 8:30 PM – 10:30 PM |
Sorting and Filtering data, Adding Hyperlinks, Importing data, Removing duplicate entries and Data representation using Tables | Jun 12, 2023 | 8:30 PM – 10:30 PM |
Adding Conditional formatting and data representation using Column, Line, Bar, Pie and Combo charts | Jun 14, 2023 | 8:30 PM – 10:30 PM |
Extracting data using Vlookup, Hlookup, Match, Index and XLookup Function | Jun 16, 2023 | 8:30 PM – 10:30 PM |
Designing forms using Data Validation and Consolidating them | Jun 19, 2023 | 8:30 PM – 10:30 PM |
Data Analysis using Subtotal and Pivot Tables | Jun 21, 2023 | 8:30 PM – 10:30 PM |
Cost Analysis using Goal Seek, Data table, Scenario Manager and Solver | Jun 23, 2023 | 8:30 PM – 10:30 PM |
Adding sparklines and advanced charts like Histogram, Pareto, Waterfall, Treemap, Radar, Funnel and Scatter | Jun 26, 2023 | 8:30 PM – 10:30 PM |
Automation of repetitive task by recording Macros | Jun 28, 2023 | 8:30 PM – 10:30 PM |
Designing Interactive Dashboards | Jun 30, 2023 | 8:30 PM – 10:30 PM |
What are the commercials for this workshop?
We make sure our fees don’t burn a hole in your pocket. You can enroll in this workshop at an affordable price of INR 2499/-.
Where will this workshop be conducted?
This will be a live instructor-led workshop hosted on Microsoft Teams. You will receive all the practice materials once you complete the workshop. Remember that recording any session is forbidden.
Know your instructor!
To facilitate this workshop, we have an industry-leading trainer with us, Jatin Sukhija. He is a Microsoft-certified trainer with 20+ years of industry experience. He is a well–known Excel specialist with a track record of helping professionals master Excel applications. He will guide you through hands-on exercises and smart tips and tricks to help you advance your Excel skills. Follow him on
How can you register for this workshop?
What are you waiting for? Don’t miss out on this opportunity to take your Excel skills to the next level. We have limited seats only.