Microsoft Excel - Using Range Names and More Functions
Course Duration: 90 Minutes
Target Audience:
This session is intended for Excel users who wish to create complex calculations using advanced functions and range names.
Course Objectives:
The majority of Excel users utilise only a small number of the built-in functions. This session aims to expand the participant’s knowledge and use of functions into different areas. We will also look at the use and advantages of the use of range names.
Course Outline:
Introduction and Overview
CONTENT
Range Names
-
Creating a Range Name for single and multiple cells
-
Using a Range Name in a formula
-
Editing Range Names
-
Applying and Listing Range Names
Review of Standard Functions
-
Review of Sum, Average, Min, Max and Count
Other Useful Functions
-
COUNTA, COUNTIF, SUMIF, COUNTIFS, SUMIFS, IF, AND, NOT, OR
Paste Special and Go To Special
-
Copy/Paste Special
-
Go To Special Options
-
Autofill options