Excel for Business Analysts
Microsoft Excel remains one of the best tools for Data Analysis. In this course, we focus on the specific functions, formulas, and tools that Excel has to help conduct business or data analysis. We start by looking at how to take raw data and clean it so it’s in a usable format. Then, we look at tools and functions used to conduct analysis, displaying data in the most meaningful way and advanced techniques designed to aid in forecasting.
5.0 (1 Reviews)
64 student views
Course Goal
- Which formulas and functions in Excel help you to prepare data for analysis
- How to use Pivot Tables to perform data analysis in Excel
- How to display your analysis using charts, graphs, and Pivot Charts
- How to conduct forecasting in Excel using various forecast functions
- How to fill gaps in data using Goal Seek, Scenario Manager and Solver
Who This Training Is For
- Consultants
- End users
- IT/Business analysts
- Project Managers
Exam/Certificate
- Certificate of Completion (more certification info)
- Upon successful completion of this course, receive your Excel for Business Analysts certificate
This Course is In the Following Learning Paths:
Learn the concepts and fundamentals needed for a career as an IT / Business Analyst. In this learning path, you will lea...
Instructor
4.7 Average Rating
99 Reviews
724 Students
21 Courses
Teaching Business Software
Students Also Bought:
Implementing SAP is a complex job. That's why companies value SAP implementation and configuration skills. No mat...
Your path to specializing in SAP S/4 HANA starts here. Perform hands-on simulations to learn the basics of SAP S/4 HA...
Specialize in SAP S/4 HANA. Open the door to new job opportunities and a command higher wages. Designed for intermedi...
Student Feedback
5.0
Average Rating