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 beginners.
Course Overview
This Kubicle course contains 17 lessons, it covers the following topics:
- Basic Arithmetic Operations
- Conditional Arithmetic
- Max, Min and Average Functions
- Logical Operators
- Using the Switch Function
- Naming and Anchoring Cells
- Array Formulas
- More On Array Formulas
- Using SUMPRODUCT for Conditional Arithmetic
- Adding Multiple Conditions to SUMPRODUCT
- Consolidating Multiple Datasets
- Generating Random Numbers
- Formula Auditing
- Fill Commands
- Information Functions
- Rounding Numbers
- Creating Your Own Functions
Key Outcomes
- Use basic arithmetic functions like SUM and AVERAGE
- Perform conditional arithmetic
- Use logical operators such as IF, AND, and OR
- Anchor cells in your formulas
- Use array formulas
- Generate and use random numbers
- Audit your formulas to identify errors
- Use fill commands to copy formulas between cells
- Understand how Excel displays and stores numbers
Contact Us
If you have any questions regarding this or any other CPD course or requirements, please feel free to contact the team here or call us at (+353) 01 523 3930.