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

145 Reviews

1018 Students

24 Courses

Simon Calder

Teaching Business Software

The IT in Simon Sez IT stands for Information Technology. In a nutshell: We make business and technical software simple to learn. We teach people to use the most popular business software including Microsoft Office, Microsoft Project, Photoshop, Web Design, and QuickBooks. Self-paced, affordable software training is what Simon Sez IT is all about. We only hire the best authors to teach and our style is to take the time to explain things in the detail they deserve. That means our courses are perfect if you're new to a certain technology or just technology shy in general. 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.

Student Feedback

4.8

Average Rating

Reviews

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

Training 5 or more people?

Unlimited access for your entire SAP team.

SAP Training for Business