Excel for Business Analysts
IC1353

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.


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:

IT / Business Analyst
IT / Business Analyst

Learn the concepts and fundamentals needed for a career as an IT / Business Analyst. In this learning path, you will lea...

Show All Learning Paths

Instructor

Simon Calder

4.7 Average Rating

99 Reviews

724 Students

21 Courses

Simon Calder

Teaching Business Software

Chris "Simon" Calder was working as a Project Manager in IT for one of Los Angeles's most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course which he sold on DVD via eBay. Fast forward to now and Simon Sez IT has taught hundreds of thousands of students through its online course platform and popular YouTube channel.

Students Also Bought:

Introduction to SAP Configuration
Introduction to SAP Configuration

Implementing SAP is a complex job. That's why companies value SAP implementation and configuration skills. No mat...

4.6

Average Rating

SAP S/4 HANA - Basic Navigation
SAP S/4 HANA - Basic Navigation

Your path to specializing in SAP S/4 HANA starts here. Perform hands-on simulations to learn the basics of SAP S/4 HA...

4.5

Average Rating

SAP S/4 HANA Intermediate SAP Skills
SAP S/4 HANA Intermediate SAP Skills

Specialize in SAP S/4 HANA. Open the door to new job opportunities and a command higher wages. Designed for intermedi...

4.5

Average Rating

View All Courses

Student Feedback

5.0

Average Rating

Reviews

Language: English
Level: Intermediate
Duration: 7 hours
Type:  Instructor-led
Category: Microsoft

Training 5 or more people?

Unlimited access for your entire SAP team.

SAP Training for Businesses