

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