Learn
Excel Dashboard
This workshop includes almost all the important features, functions & formulas
>>Become a Certified Microsoft Excel Expert
In 2 Hours Workshop
- Learn Advanced Excel from Skilled Trainer
- Allocate substantial time for participants to apply concepts through exercises
- Keep groups small to facilitate personalized attention and interaction
- Engage participants with hands-on exercises and practical applications
- Set and refer to specific learning outcomes to maintain focus and alignment.
- Customize content to participants' industries and job roles for practicality.
This Workshop is Scheduled for 10th of September at 11:00 AM and will be for 3 hours
Hurry UP! Book Your Seat Now, we have LIMITED SEATS available
If you have any of the reasons from the above mentioned list then this workshop is for you
FAQ's
- There are no strict prerequisites, but a basic understanding of Excel functions and formulas is recommended. If you’re not sure if you meet the requirements, feel free to contact us for guidance.
- We offer both online and in-person options for your convenience. You can choose the format that suits your schedule and learning style.
- Yes, upon successful completion of the Advanced Excel course, you will receive a certificate. This certificate is a valuable addition to your professional portfolio and can be shared on your LinkedIn profile and resume.
- Our experienced instructors are dedicated to helping you succeed. You’ll have access to live Q&A sessions, discussion forums, and email support to address your questions and concerns.
- Yes, to reinforce your learning, the course includes hands-on assignments and projects. These practical exercises are designed to help you apply what you’ve learned to real-world scenarios.
- Yes, you will have continued access to course materials, including lecture notes, video recordings (if applicable), and resources for a specified period after completing the course. This allows you to review and refresh your knowledge as needed.
To Enroll, simply visit our registration page and follow the steps outlined there. if you have any questions or encounter issues during the registration process, our support team is here to assist you.
Still have more questions? Feel free to reach out to us via our contact page, and we’ll be happy to provide further assistance or clarification.
Who will be the Mentor?
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
Glimpse of Trainings Done by Anil Dhawan
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
- TEXTJOIN, CONCATENATE, TRIM, UPPER, LOWER, PROPER, CLEAN, TEXT, SEARCH*, SUBSTITUTE
- Date & Time Functions
- TODAY, NOW, EDATE, EOMONTH, WORKDAYS, WORKDAYS.INTL, NETWORKDAYS, NETWORKDAYS.INTL
- 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
- Text Functions
Tea Break (3:20 PM – 3:30 PM)
- Functions & Formulas Continued (3:30 PM – 4:30 PM)
- Lookup, Logical, Maths & Stats Functions
- VLOOKUP, INDEX, MATCH, IF, AND/OR, IFERROR, ROUND, ROUNDUP, COUNTA, INT, MOD, SUMIFS, COUNTIFS etc.
- 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-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
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