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