Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel for Business Analysts

via LinkedIn Learning

Overview

This course shows business analysts how to use Excel to measure the health of an organization. Learn how to use Excel to gather, assess, and use business analytics information.

Syllabus

Introduction
  • Benefit from business analytics
1. The Basics
  • What is business analytics?
  • Business analytics and company financials
  • Basics of business analysis
  • Finding data for business analytics
  • Using business analytics for sales prospecting
  • Testing marketing content with business analytics
2. Getting Started with Business Analytics
  • Data access and availability
  • Integrating data sets
  • Data and business analytics
  • Finding a data model
  • Mapping your data
  • Dealing with data Issues
  • Tools for business analysis
3. Predictive Tools in Business Analytics
  • Business analytics and performance
  • Using data in hiring plans
  • Understanding HR issues with data
  • Troubleshooting at the organization
  • Forecasting with business analytics data
  • Making corporate investment decisions
4. Reading Business Analytics Output
  • Examining financial data
  • Waterfall charts in Excel
  • Competitor analysis and benchmarking
  • Growing revenue with business analytics
  • Business strategy and business analytics
  • Product pricing with business analytics
  • Price, volume, and sensitivity analysis
  • Controlling costs in business
5. Business Analytics and AI
  • Understanding AI tools and BA
  • Using data with generative AI
  • Limitations on AI and data
Conclusion
  • Putting tools into action

Taught by

Michael McDonald

Reviews

4.6 rating at LinkedIn Learning based on 5329 ratings

Start your review of Excel for Business Analysts

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.