| Saturday, 25th March 2023 & Sunday, 26th March 2023 | Seats are filling fast⚡2 Days Workshop | Hosted by:- analyticstraininghub.com |
Learn DATA ANALYTICS Using
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.
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.
Pre-Requisites
- 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
- 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
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
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
TRAINING CERTIFICATION
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
Glimpse of Our Recents Events & Workshops
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.