Booking Information
Once you have booked your course, the link to the recording will be available
in your "My Account" area.
Please be aware that you will have access to this course for 180 days from
the date of purchase
Online courses cannot be booked on behalf of someone else. Access will only
be granted to the person completing the online order.
Who Should Attend?
This course is suitable for beginner learners who have a very basic level of familiarity with writing Microsoft Excel formulas. It is best suited to accountants, management consultants, analysts and other business professionals.
Course Overview
This Kubicle course contains 14 lessons, 4 exercises and 1 Exam. It covers the following topics:
- Basic Arithmetic Operations
- Conditional Arithmetic
- Max, Min and Average Functions
- Logical Operators
- Naming and Anchoring Cells
- Array Formulas
- Using SUMPRODUCT for Conditional Arithmetic
- Adding Multiple Conditions to SUMPRODUCT/li>
- Generating Random Numbers
- Formula Auditing
- Fill Commands
- Information Functions
- Rounding Numbers
Key Outcomes
Once you have completed this course you will know how to use Excel’s most useful and widely-used functions (e.g. IF, SUMIF, AVERAGE, ROUND) and be able to deploy these functions in formulas that perform calculations on various datasets. You will also know how check your formulas for errors to ensure your work is correct and reliable.