Excel Functions
Developing formulas and functions for calculations you want to make can be complicated. Excel has an entire library of functions or predefined formulas that you can use.
Excel Functions – Course Objectives
This hands-on, tutor-led Excel Functions course helps users explore and apply a wide range of Excel functions and formulae to their own work. Delegates learn to copy and reuse formulas across cells and worksheets, saving time and effort. The course begins with a brief review of Level 1 skills, then covers key function types, including text manipulation, financial calculations, logical tests, date and time formulas, lookup and reference, database functions, maths and information functions, equipping delegates to work efficiently and confidently with complex spreadsheets.
Excel Functions – Course Contents
Working with Text
Preparing text for mail-merge, removing spaces in text, making text change case. Concatenate, Lower, Upper, Proper, Rept, Trim, Text to Columns.
Financial
Can you afford that business loan or new credit card? Use financial functions to work out repayments. FV, PMT, NPer.
Logical
Use logical functions, such as IF, OR, AND, NOT, TRUE, FALSE, and IFERROR, to find out whether certain conditions are true or false.
Date and Time
Use Date and Time functions to create formulas that display a specific date or time, or that calculate the difference between dates. Networkdays, Now, DateDif.
Lookup and Reference
There are multiple Lookup and Reference functions that let you find matching values. Hyperlink, Transpose, Lookups, two list data validation.
Database Functions
DSum, DAverage.
Maths
Rand, RandBetween, SumIf.
Information
Use functions to return information about your spreadsheet. Cell, Isblank, IsText.
Excel Functions – Course Details
This is a one-day Excel Functions intermediate course running from 9:30 am – 4:00 pm. Courses run in Swansea and on-site.
Prerequisites
Attendees will gain the maximum benefit if they have attended our Introduction to Excel – level 1 course or are familiar with creating basic spreadsheets and using simple formulas.
Qualification
Delegates will receive a Computeraid certificate of achievement.
What Next? Excel Level 3
Gain an in-depth knowledge of data analysis, learn how to audit your spreadsheet and use advanced features such as templates and macros.