New Logo
White mail

Microsoft Excel

Formulas and functions

This course is for users of Excel who wish to gain a wider understanding of how formulas and functions can be used in their everyday tasks.

Objectives

Revision of the Basics

Creating a basic formula

Understanding calculation order

 

Time Savers

Copying formulas

Working out percentages

Absolute & mixed cell addressing

 

Quick Functions

AutoSum

Average, Max, Min & Count Numbers

AutoCalculate

NEW Quick Analysis tool

 

Statistical And Logical Functions

Counta & Countblanks

Testing cell contents using the If function

Sumif & Countif

 

Formula Auditing

Tracing errors

Tracing precedents & dependents

Showing formulas

Evaluating formulas

 

Date & Time Functions

Custom formats for dates & times

Today, Now

Year, Month, Week, Day, Weekday, Days

Hour & Minute

Calculating dates

 

Text Functions

Text to columns tool

Left, Right & Mid

Concatenate

Upper, Lower & Proper

Trim & Find

Previous knowledge of Excel is essential.

Prerequisities

Content

© PrimeraTraining 2020

aIkYTrpHRRG58ENlqEQrRF0h5WI
Green_PolicyBee_Badge

Professionally insured through PolicyBee

We are GDPR compliant. For information on how we handle personal data, and your associated rights, please view our Privacy & Data Protection Notice.