Excel for Business Analysts

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.

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