
Excel for Business Analysts
Excel for Business Analysts
What You Will Learn In This Free Course
- Explain how to make better business...
- Outline the difference between conc...
- Describe how to split data using te...
- Apply ‘vlookup’ and ‘hlookup’ funct...
- Explain how to make better business decisions with ‘if’ functions
- Outline the difference between concatenating and standardizing data
- Describe how to split data using text functions like ‘search’, ‘left’, ‘right’ and ‘mid’
- Apply ‘vlookup’ and ‘hlookup’ functions in your own spreadsheets
- Select ‘index match’ and ‘xlookup’ in Excel
- Analyze business data with the ‘if’, ‘ifs’, ‘iferror’, ‘sumif’ and ‘countif’ functions
- Indicate the difference between the ‘countif’, ‘sumif’ and ‘countif’ functions in Excel
- Review and ‘clean’ data for analysis
Explore Careers Related To This Course
Complete This CPD Accredited Course & Get Your certificate!
Certify Your Skills
A CPD accredited Alison Diploma/Certificate certifies the skills you’ve learnedStand Out From The Crowd
Add your Alison Certification to your resumé and stay ahead of the competitionAdvance in Your Career
Share your Alison Certification with potential employers to show off your skills and capabilities
Learner Reviews & Feedback For Excel for Business Analysts






Want to create a customised learning path for your team?
Our dedicated Learning Advisors are here to help you curate a customised learning path tailored to your organisation's needs and goals.
Not sure where to begin?
Discover the career most suitable for you and get started in the field with a step-by-step plan.
Get your PlanLearners Who Took This Course Also Enrolled In
- Microsoft Excel Formulas and Functions
- Master Microsoft Power BI
- Data Entry Tools and Techniques
- SQL Server for Data Analysis
- Mastering Data Analysis using Microsoft Excel: Formulas and Pivot Tables
- Basics of Data Analysis with Excel
- Advanced Excel 2021
- MS Excel: Manage and Report with Microsoft Excel (Basic)