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