Course
|
Excel

Formulas and Functions

This course introduces the most useful of Excel's built-in arithmetic and logical functions. You also learn how to write, manipulate and audit your own formulas.
4 HOURS
Beginner
17 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Use basic arithmetic functions like SUM and AVERAGE
Perform conditional arithmetic
Use logical operators such as IF, AND, and OR
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
helping to build
data, Tech & ai skills in
g2-badgebritish-airwaysjotunamazon-logopwc-logoford-logo
Course
|
Excel

Formulas and Functions

This course introduces the most useful of Excel's built-in arithmetic and logical functions. You also learn how to write, manipulate and audit your own formulas.
4 HOURS
Beginner
17 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Use basic arithmetic functions like SUM and AVERAGE
Perform conditional arithmetic
Use logical operators such as IF, AND, and OR
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

What’s Included

17 Lessons
Basic Arithmetic Operations
4 MINS
LESSON
Basic Arithmetic Operations
Exercise

Apart from the basic arithmetic operators (+ - x /), Excel has in-built functions such as SUM and COUNT, which I'll show you in this lesson.

Conditional Arithmetic
5 MINS
LESSON
Conditional Arithmetic
Exercise

COUNTIF and SUMIF apply conditions to basic arithmetic functions. This enables us to calculate subtotals such as total revenue for a given month, location and product type.

Max, Min and Average Functions
3 MINS
LESSON
Max, Min and Average Functions
Exercise

Basic statistics can quickly yield helpful insights from our datasets. Here I show you how to use Excel's statistics formulas on a company's sales data.

Logical Operators
6 MINS
LESSON
Logical Operators
Exercise

Operators such as AND, IF and OR give you much more control when performing data queries in Excel. Find out how to use them in this lesson.

Using the Switch Function
5 MINS
LESSON
Using the Switch Function
Exercise

Testing many IF conditions can become difficult to follow. The Switch function provides an alternative that is useful in certain situations.

Naming and Anchoring Cells
5 MINS
LESSON
Naming and Anchoring Cells
Exercise

Writing many formulas in Excel can get tedious and time-consuming. Naming and anchoring cells are two techniques that you can use to make the process faster and easier.

Array Formulas
5 MINS
LESSON
Array Formulas
Exercise

Array formulas allow you to perform calculations on multiple cells. Here I show you how to use them to create Max(IF) and Min(IF) functionality.

More On Array Formulas
6 MINS
LESSON
More On Array Formulas
Exercise

In this lesson, we'll see how to create array constants, and use them to calculate an array of sales with low revenue. We'll also see how to use an array formula to count unique values in a dataset.

Using SUMPRODUCT for Conditional Arithmetic
5 MINS
LESSON
Using SUMPRODUCT for Conditional Arithmetic
Exercise

SUMPRODUCT is a highly versatile formula that can be used in a number of different situations. In this lesson, we'll see how SUMPRODUCT can be used to perform conditional arithmetic, letting us calculate revenue for particular customer and products.

Adding Multiple Conditions to SUMPRODUCT
3 MINS
LESSON
Adding Multiple Conditions to SUMPRODUCT
Exercise

In this lesson, we'll see some more advanced uses of SUMPRODUCT. We'll see how we can identify sales or revenue satisfying multiple conditions using a single SUMPRODUCT function.

Consolidating Multiple Datasets
4 MINS
LESSON
Consolidating Multiple Datasets
Exercise

Excel's Consolidate tool lets you quickly combine and summarize data from multiple sheets in your workbook. Learn how to use it in this lesson.

Generating Random Numbers
7 MINS
LESSON
Generating Random Numbers
Exercise

Sometimes you may want to introduce randomness into your Excel spreadsheets. In this lesson, we'll look at RAND and RANDBETWEEN, Excel's two functions for generating random numbers, and use them to divide orders into multiple groups.

See More
See Less
Certifications
Earn a certificate with every exam you complete. All successful course completions are recognized by CPD, CPE, and NASBA. As your team gains confidence, skill, and speed, your firm becomes more competitive.
Earn cPE / CPD Credits
No items found.
Get More Info
Looking to understand how Kubicle can better help your organization meet its learning objectives?  Book some time with one of our consultants today.
Contact Information
Looking to speak to someone directly?
01 700 9000
info@kubicle.com
Dublin, Ireland
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Plus Size YourLearning with Academies+
THE PLATFORM OF CHOICE FOR 1M+ USERS

A Learner Experience Designed to Deliver Transformation

Testimonials

How Leading Teams Use Kubicle to Upskill & Excel

Heineken Case Study
ADL Logo