Excel Data Analysis Training and Certification
Course Overview
- Course Rating 5.0/5
Overview
Excel Data Analysis Training focuses on the advance features of working with spreadsheets, using advance tabular functions, pivot analysis and dealing with Macros
refer: Microsoft
Excel Data Analysis Training focuses on the advance features of working with spreadsheets, using advance tabular functions, pivot analysis and dealing with Macros.
Excel Data Analysis corporate training and certification oriented remote program aims to upskill you with Lookup functions, Data Analysis, Pivot Tables, Macros
Currently due to Covid19 outbreak, the course is available remote and however it can also be accessed online via your nearby Prog360 centre based on local availability.
Course Prerequisites
It is the beginner level program in working with MS Excel
Course Content
- Introduction
- MS Excel Basic Features Overveiw
- Look Up values in Spreadsheets
- Organizing Data in a Worksheet
- Using Filters and Advance Functions
- Using Data Validation
- Working with Formulas
- Analyzing Data with Functions
- Statistical functions to aid analysis
- Basic financial functions
- Serial dates vs date presentations
- Calculating the number of working days
- Controlling calculations and nested formulas
- Data variations with the IF function
- Calculations with referencing
- Using Nested functions
- Using Lookup functions
- Troubleshooting nested calculations
- Using "What-If" Analysis
- Variables in worksheets
- Comparing various data sets
- Quantifying variables
- Goal Seek Feature
- Calculating the optimum variable values
- Dealing with Multiple Workbooks and Links
- Consolidating Ranges
- Distilling Data Sets for Data Analysis
- Intrepreting Data with Pivot Tables
- Data Summaries
- Grouping and Aggregation
- Comparing Totals
- Report Filters and Slicers
- Visualizing Data with Pivot Reports
- Using Pivot Table reports
- Using Pivot Charts
- Data patterns with Sparklines
- Using Power Pivots
- Presenting with Power View
- Macros for Repetitive Functions
- Simplifying complex tasks
- Reducing errors
- Bulletproofing routine editing and formatting
- Invoking macros with Form controls
- Hands-On Exercises
- Prog360 Assessment
- Prog360 Certification
Excel Data Analysis Certifications
Excel Data Analysis course delivery involves case studies, examples, discussions and exercises to enhance the learning experience.
At the end of the training the participants will be awarded Course Completion Certificates on Excel Data Analysis.
Post Course Evaluation
You may chose to enroll for a post course evaluation to analyse your knowledge metrics. The post course evaluation would cover the topics related to the training delivered over the period of the complete session, like:
- Using Filters and Advance Functions
- Using Data Validation
- Working with Formulas
- Analyzing Data with Functions
- Controlling calculations and nested formulas
- Using "What-If" Analysis
- Quantifying variables
- Dealing with Multiple Workbooks and Links
- Consolidating Ranges
- Distilling Data Sets for Data Analysis
- Intrepreting Data with Pivot Tables
- Visualizing Data with Pivot Reports
- Macros for Repetitive Functions
- Working with Formulas
- Analyzing Data with Functions
- Controlling calculations and nested formulas
- Using "What-If" Analysis
- Quantifying variables
- Dealing with Multiple Workbooks and Links
- Consolidating Ranges
- Distilling Data Sets for Data Analysis
- Intrepreting Data with Pivot Tables
- Visualizing Data with Pivot Reports
- Macros for Repetitive Functions
Excel Data Analysis Corporate Training
Prog360 offers on-demand corporate learning and development solutions around Excel Data Analysis that can be delivered both onsite and remote (based on availability). With Prog360, you can train your employees with our 360 Approach which not only enhance professional skills but also improvise inter-personal development. Please feel free to inquire further. We are open to discuss your requirement to provide you more customized solution specific to your needs. We will evaluate the skillset, analyze the business requirement and post that provide customized training solutions as per your business needs. Our corporate team for Excel Data Analysis training is based across the globe hence you can reach us nearby your region as well. For general training inquiries you can contact us at training@prog360.com.
Excel Data Analysis Consultation
If you have already up-skilled your team and have started implementing Excel Data Analysis, but are still facing challenges, Prog360 can still help you. Our SMEs can get on a call with you to understand the situation and provide you a plan involving the next steps covering both audit and implementation based on your problem statement. Our corporate team for Excel Data Analysis consultation is based across the globe hence you can reach us nearby your region as well. For general consultation inquiries you can contact us at consult@prog360.com . For more nearby inquiries you can reach your nearby team.
South East Asia and Oceania
Oceania: Melbourne, Australia: 152 Elizabeth St,Melbourne,VIC,Melbourne,
Corporate Training: training.au@prog360.com
Consulting Services: consult.au@prog360.com
South East Asia: Singapore: 5, Temasek Boulevard, Singapore, Central Region, 03898, Singapore
Corporate Training: training.sg@prog360.com
Consulting Services: consult.sg@prog360.com
Contact Number :- +61 3 9015 4952
South Asia and Middle East
South Asia: Bengaluru, India: No. 78, Next to KR Puram Tin Factory, Old Madras Road, Bangalore – Mahadevapura, Bengaluru, Karnataka, 560016
Corporate Training: training.southasia@prog360.com
Consulting Services: consult.southasia@prog360.com
Middle East:- Dubai, UAE: The Offices 4, One Central Dubai World Trade Center, Dubai, Dubai, 00000, UAE
Corporate Training: training.ae@prog360.com
Consulting Services: consult.ae@prog360.com
Contact Number :- +91 9810 643 989