height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=945058072538609&ev=PageView&noscript=1"
Saturday, 25th March 2023 & Sunday, 26th March 2023Seats are filling fast2 Days WorkshopHosted by:- analyticstraininghub.com

Advanced Excel in JUST 2 DAYS

With Anil Dhawan
(Founder & CEO | Corporate Trainer | Automation Coach)

Industry Based Learning & Assignments

Completion of Certificate

Hands on Practice

Why Analytics Training Hub?

We offer Corporate Training in the most innovative technologies of today, utilizing a blended learning approach to maximize engagement and completion rates. Our customized training can be tailored to meet your specific requirements and we are adept at delivering effective learning experiences in areas such as Data Science, Data Analytics, BI Tools, AWS, DevOps, Automation, Full-Stack Development, AI, and more.

1000 +
Students Trained
1000 +
Candidates Placed
100 +
Corporate & College Workshops

Training Schedule

Date:- Saturday, 25th March 2023 & Sunday, 26th March 2023

Live Timing:- 9:30 AM – 5:00 PM IST

Duration:- 2 Days Workshop

Venue:–  B1/H3, 91 SpringBoard, MOHAN CO-OPERATIVE, Mathura Rd, Industrial Area, BLOCK B, Delhi, 110044

Training Features

2 Days Workshop
Instructor Led Training

Certificate of Completion

Hands on Based Learning: Practical Learning with Industry Based Examples

Key Takeaways: Lectures Recording, Training PPT, Case Studies, Projects

Action Driven Training, 90% Practical & 10% Theory

Ask Your Questions: Clear Your Doubts During Live Sessions

Overview of Microsoft Excel

Microsoft Excel is a powerful tool used to manage and organize data, create spreadsheets, analyze data, and perform calculations. Through this workshop, you will get an overview of the features of Microsoft Excel that are essential for efficient workflows. You will learn how to create effective spreadsheets, use data analysis tools and functions to make calculations easier and more accurate. In addition, you will gain familiarity with formulas to help you manipulate the data in whatever way you need. By the end of this workshop, you will have a better understanding of how Microsoft Excel can be used to increase productivity and streamline your processes.


  • This workshop requires you to bring your own laptop with Microsoft Excel pre-installed.
  • The laptop must have windows 8.1 or above with 4 GB RAM and 10 GB empty space in main drive
  • Microsoft 365® on Windows® / Mac® is preferred, but earlier versions such as 2013/2016/2019/2021 of Excel will suffice.
  • Having some prior knowledge and experience working with spreadsheets can be helpful
  • Know your way around a computer: You should be comfortable with basic computer skills such as navigating files and folders, opening and closing applications, and using a keyboard and mouse.
  • Have an open mind to learn new techniques.

Who Should Attend this Workshop?

  • Professionals in any field who are looking to gain an edge over their peers and stand out from the crowd.
  • Professionals such as marketers, sales representatives, entrepreneurs, managers, and executives with relevant experience can benefit greatly from this workshop.
  • Suitable for those interested in honing their skills or starting on a new career path.
  • Graduate / Post-graduate students who are eying for making their career in the field of Data Analytics to understand Data Analytics concepts and get started with advanced tools
  • Participants should have some knowledge of marketing principles, customer service strategies, and problem-solving techniques which will be taught during the session.

Workshop Benefits

Attending this workshop provides an invaluable opportunity to learn the essentials of a certain topic. Industry experts will provide their insights and facilitate discussions on market trends and challenges in the respective area. Through informative presentations, interactive exercises and other activities, participants can develop a deeper understanding of relevant topics which they can instantly apply at work. The workshop also provides participants with networking opportunities so that they may connect with like-minded professionals within their field or expand their knowledge on related subjects beyond it. Additionally, attending this workshop grants access to resources such as case studies that are perfect for further research or future reference material purposes.

Content Will be Cover in this Exclusive Workshop

  • Introduction to Workshop and Data Analytics (9:30 AM – 10:00 AM)
    • What is Data Analytics
    • Why Data Analytics
    • Importance of Data Analytics in 21st Century
    • Data Analytics Tools?
    • Excel for Data Analytics
  • Getting Started with Microsoft Excel (10:00 AM – 10:30 AM)
    • Introduction to Modern Excel
    • Understanding the difference between Mouse and Keyboard action behaviour
    • HotKeys Vs ShortCut Keys
    • Navigating and Controlling Excel Interface with Keyboard
    • Important Data Handling Keyboard shortcuts
  • Data Cleansing Time Saving Techniques (10:30 AM – 11:30 AM)
    • Spilt content of column into multiple columns and extract text
    • Filling range in a specific direction using fill handle feature.
    • How to get the values automatically filled basis on pattern recognition.
      • Extracting Names
      • Taking out only initial letters
      • Reversing words / names
      • Merging cells & static values
    • Fixing Headers And Key Columns for better view and analysis
    • Removing duplicate line items with Excel feature
    • Turning static range of cells into dynamic range with clicks of button
    • Creating relationships between tables
    • Making Interactive tables
    • Filtering data with just clicks of button
    • Sorting By Values / Colours / Text / Numbers
    • Using the Advanced Filter to display the needed information
    • Multiple criteria for creating advanced filters

Tea Break (11:30 AM – 11:40 AM)

  • Formatting Essentials (11:40 AM – 1:00 PM)
    • Formatting block of cells / non-adjacent cells quickly and efficiently
    • Paste Special feature to paste specific attributes from copied cells
    • Custom Cell Formatting
      • Applying currency format with decimals
      • Getting leading zeros without converting number into text
      • Applying different country’s Phone number formats
      • Changing date-time into short/long format
    • Working with New Comments Vs Old Comments (Notes)

Lunch Break (1:00 PM – 1:40 PM)

  • Shaping up Data for Analysis Using Functions & Formulas (1:40 PM – 3:20 PM)
    • Introduction to Excel Formulas & Functions
    • Basic Rules for using Functions & Formulas in Excel
    • Relative Vs Absolute Reference
    • Most used Functions & Formulas for Analysing the Data
      • Text Functions
      • Date & Time Functions
      • Merging two or more strings using multiple methods
      • Replacing specific occurrence of text with another value/text
      • Returning exact date before / after specified number of months
      • Finding number of calendar/business days from two dates

Tea Break (3:20 PM – 3:30 PM) 

  • Functions & Formulas Continued (3:30 PM – 4:30 PM)
  • Lookup, Logical, Maths & Stats Functions
  • One Dimensional / Two Dimensional Lookups
  • Formulas for Calculating Ageing
  • Calculating remaining/pending days and weeks in a year
  • Extracting Date and Time values from Date-Time Stamp
  • Returning the Count of Items

Q&A (4:30 PM – 5:00 PM)

Signing OFF: Workshop Day 1

  • Best Practices for Excel Data Management and Analysis (9:30 AM – 11:30 AM)
    • Use of Named Ranges in Functions/Formulas
    • Working with Conditional Formatting
      • Formatting values basis on one/multiple conditions
      • Formatting cells based on specific values
      • Highlighting Duplicate Line Items
      • Custom Conditional Formatting using Functions/Formulas
    • Data Validation for Analysing the Data
      • Prevent User to enter Duplicate Entry
      • Allow user to enter only text/numbers in a cell
      • Simple & Dynamic Drop-Down List
    • Using the Goal Seek function to help determine how to get the desired result
    • Scenario tool to do What-if analysis

Tea Break (11:30 AM – 11:40 AM)

  • Visualizing the Data in Excel (11:40 AM – 1:00 PM)
    • Introduction to Charts/Visuals
    • How to pick appropriate visual
    • Quickly inserting in-built chart with a single keystroke
    • Working with Charts i.e. Columns, Line, Pie, Waterfall, Map, Combo etc.
    • Important Chart Fields & Options
    • Interactive Charts
    • Customizing Charts to Present Target Vs Actual
    • Step Chart Vs Line Chart
    • Visualizing data using Sparkline into a cell to instantly reveal the pattern of the data

Lunch Break (1:00 PM – 1:40 PM)

  • Working with Pivot Table (1:40 PM – 2:40 PM)
    • Introduction to Pivot Table
    • Nuts and Bolts – Pivot Table
    • Creating Pivot Table and Use of its’ components
    • Grouping & Summarizing data
    • Creating Calculated Fields
    • Making Interactive Pivot Tables using Slicer
    • Creating PivotTables based on Multiple tables
    • Exploring PivotTable field settings to a variety of options
    • Interactive Pivot Tables
    • Intro to Power Pivot
    • Do’s and Don’t
  • Introducing Power Pivot & Power Query (2:40 PM – 3:20 PM)
    • What is Excel Power Pivot
    • Understanding ETL operations
    • Getting data from multiple sources and performing Transformation (Cleaning) steps
    • Preparing report and analysing the data

Tea Break (3:20 PM – 3:30 PM)

Introducing VBA-Macros and Its’ Uses with Live Example (3:30 PM – 3:45 PM)

  • Conclusion (3:45 PM – 5:00 PM)
    • Quiz Round / Live-Case Study and Assignment
    • Q&As
    • Announcing Quiz Winners
    • Distributing Certificates
    • Closing Notes

Request More Information

Learn DataAnalytics

Using Advanced Excel
2,999/- Includes Tea, Snacks & Lunch
  • 2-Days Workshop - 14 Hours
  • Industry Level Training
  • Hands on Practice
  • Completion of Certificate
  • Session Study Material, Case Study
  • Session Recording Access for 2 Months
  • Support Access for 2 Months

Venue Details:-

B1/H3, 91 SpringBoard, MOHAN CO-OPERATIVE, Mathura Rd, Industrial Area, BLOCK B, Delhi, 110044
Call us at +91 96503 08956

Testimonials & Reviews

Bhanu Pratap Yadav
Bhanu Pratap YadavWealth Management Consultant
Read More
Our trainer Anil dhawan sir was really good with their teaching style and the deep knowledge of the subjects such as advance excel and power bi, For me it becomes very easy to learn and gain knowledge as he is very patient and always ready to resolve queries rather than just completing the course, it was a great experience and I will continue with other subjects in future as well with ATH. ATH support staff and the trainers are really helpful it was complete different experience what I had in past with other institutions, Thank you for the guidance and support
Amandeep Vaseer
Amandeep Vaseer@username
Read More
I have completed four modules from ATH. It was a great learning experience as the Instructors are highly trained professionals, who have in depth knowledge of all the concepts and provide variety of case studies. This helped me understand all the modules effortlessly. Moreover, they have a support team who resolves queries even after the classes and which is very helpful. I highly recommend this institute for learning.
Himani Verma
Himani Verma@username
Read More
I am Himani a working professional I have completed my analytics Training from ATH. My experience with ATH is very nice 👍 I am happy with the trainers knowledge they are really knowledgeable and guide us well, I have learnt Power BI Tableau VBA each trainer is specialised in there specific fields.

Who will be the Mentor?

Anil Dhawan, The trainer and Data Analyst Expert

Anil Dhawan is a professional with decades of experience in the field. He has held numerous positions over the years, ranging from research and development to designing products across various industries. The mentor has extensive knowledge and a passion for helping others succeed; his mission is to impart this knowledge to those he works with today. His interactions with people allow him to act as an effective teacher by providing them valuable guidance on strategies they can use while working towards their goals. With such great experience and qualifications, it’s no wonder that companies trust him in delivering success continued throughout his career.

Industry Experience:- With nearly one and half decades of experience, I have worked with some of the biggest MNCs in the industry like Google*, Alcatel-Lucent*, the World’s Largest Microsoft Excel Community, Chrome Data Analytics & Media, etc.

Tools Knowledge:- Data Analysis & Visualization Tools like Advance Excel, VBA-Macros, SQL Server, PowerBI, Tableau, sound knowledge of Business Object (SAP Reporting Module), Sales-Force, Ms-Access, Dashboarding with knowledge of SAS Base & SAS Advance (Business Intelligence tools) and Google Tools.

Trainings, he has delivered so far:- Trained 10,000+ working professionals from more than hundreds of Top MNCs like; Google, American Express, WNS, Cvent India, Ericsson India, Accenture, Aricent, HCL, TCS, Ernst & Young (EY), KPMG, Barclays Bank, HP, Aon Hewitt, Bank of America, ICICI Bank, Airbus India, Benling India Energy & Technology, Eicher, Eli Research, GFL Limited, etc. Conducted Corporate workshops for companies namely; Shell India Ltd, Ecocert India, Kalpataru Power Transmission, SB eCommerce, Amazon
India, Samsung India Pvt.Ltd, Voltas Beko, GFL Limited and many more


Earn your certificate

Your certificate and skills are essential for launching your career and competing in a global environment.

Share your achievement

You should communicate your accomplishment on LinkedIn, Twitter, and Facebook; include it in your resume; show it off to your friends and colleagues.

Are you satisfied with our training curriculum and other features?

If yes, then Register Today and give us a chance to provide you with impeccable learning solutions

Frequently Asked Questions

The workshop will be conducted using the latest version of Microsoft Excel. However, the concepts covered in the workshop can be applied to older versions of Excel as well.

Yes, participants are required to bring their own laptop with Microsoft Excel installed.

The maximum number of participants is typically 20 to ensure individual attention and effective learning.

No, there are no pre-requisites for attending the workshop. However, it would be helpful if participants have a basic understanding of spreadsheets and are comfortable using a computer.

Get In Touch

Email: info@analyticstraininghub.com