|
CATEGORY
Data Analytics |
|
DURATION
Two Day |
|
SKILL LEVEL
Introductory - Advanced |
|
PD HOURS
14 |
Description
Whether you work for a large or small organization, you probably use Microsoft Excel. Your job likely involves analyzing, summarizing, and reporting data. It might also involve building models to help reduce costs, increase profits, or better manage operations.
The course will teach participants how to use Microsoft Excel more competently to analyze data, create models, and generate insights. Participants will learn all of the key skills needed to excel as a business analyst and learn techniques to solve any business problem in any industry.
Participants will learn how to work with data, sort and filter lists, create charts, use formulas, conduct text manipulation, and leverage multiple lookup functions, create PivotTables, use data analysis tools, generate array formulas, visualize data, and conduct detailed statistical analysis.
The course will teach participants how to use Microsoft Excel more competently to analyze data, create models, and generate insights. Participants will learn all of the key skills needed to excel as a business analyst and learn techniques to solve any business problem in any industry.
Participants will learn how to work with data, sort and filter lists, create charts, use formulas, conduct text manipulation, and leverage multiple lookup functions, create PivotTables, use data analysis tools, generate array formulas, visualize data, and conduct detailed statistical analysis.
What you'll learn
- Understand and learn many of the key formulas, functions, and tools in Excel to conduct basic to advanced data analysis and model building.
- Create flexible and dynamic models, charts, and graphic visualizations using Offsets.
- Employ the suite of What-If-Analysis tools to perform powerful sensitivity analysis and optimization.
- Use Formula auditing tools to understand and diagnose spreadsheet and model errors.
- Conduct detailed statistical tests and analysis using the Data Analysis ToolPak.
- Discover multiple ways to visualize data to transform basic information into actionable insights.
Who will benefit
Business professionals that need to learn key Excel skills to analyze data, business professionals that need to develop broader analytic capabilities to make faster and smarter business decisions, and analysts that want to build their analytical capabilities and learn techniques to solve business problems.
Special Instructions / Notes:
Attendees must bring a laptop with Microsoft Office 2013 or newer installed.
|
Our courses emphasize high-quality instruction, interactive learning, and student-centered curricula.
All courses meet the same exacting standards for content excellence and expert instruction. |
|
