Ms Excel
Microsoft Excel: Statistical Functions
COUNT, SUMIF, AVERAGE, rounding functions, and data analysis
3 CPD credits on completion
Enrol Now
Certificate on completion
Downloadable resources
Self-paced learning
About This Course
Course Information
This course covers the use of statistical formulas and the key concepts and techniques required.
Certificate on Completion
This course is made up of videos, questions and additional reading materials and accounts for 3 units of CPD. One unit is the equivalent of one hour of learning. A certificate will be issued once you have completed all 3 units.
Course Sections
This Course is made up of the following sections:
- Use of Functions (Video)
- Analysis (Video)
- Statistical Functions (Notes)
- Statistical Functions (Multiple Quizzes)
What You Will Learn
- Apply COUNT, COUNTA, and COUNTIF to tally cells based on different criteria
- Calculate conditional totals using SUMIF for filtered datasets
- Distinguish between ROUND, ROUNDUP, ROUNDDOWN, and INT for controlling decimal precision
- Explain how AVERAGE works and interpret its result in the context of financial data
- Describe how to combine statistical functions for basic data analysis in Excel
Who This Course Is For
- Accountants who need to summarise and analyse datasets with conditional calculations
- Finance professionals who work with large datasets requiring counting, summing, and averaging by criteria
- Excel users who have covered basic functions and want to add statistical tools to their skill set
Prerequisites
- Familiarity with basic Excel functions such as SUM and simple formulas
- Completion of the Learnsignal Spreadsheet Functions course or equivalent knowledge
Frequently Asked Questions
Course Details
CPD Credits3
CertificateYes
Pricing
Pricing
Invest in your professional development with flexible payment options.
Everything included in your subscription:
CPD certificate on completion
Downloadable resources
Self-paced learning
Expert-led content
24/7 access
Mobile friendly
Ready to Start Learning?
Join thousands of finance professionals who have advanced their careers with Learnsignal CPD courses.
Enrol Now