TARGET AUDIENCE
Designed for anyone with minimal or no prior knowledge of Microsoft Excel 365 and looking to acquire solid foundational skills to perform calculation and table in a spreadsheet.
PRE-REQUISITE
Basic knowledge of computers, using the keyboard, mouse and Windows and Excel is required.
LEARNING OUTCOME
In this course, participants will:
Discover calculation features to increase data reliability for reporting use.
Understand how to work with formulas and functions.
Learn on how to work with Excel table and its features.
Increase knowledge on filtering and sorting data in Table and data list.
Course Outline ::EXC365I::
CONTENTS
9:00am-10:30am
Module 1: Working with Formulas
Concept of Formulas
Understanding Relative and Absolute Cell References
Understanding Named Ranges
Defining Named Ranges
Editing Named Ranges
Deleting Named Ranges
Using Named Ranges in Formulas
Using Array Formulas
Using 3D References
Module 2: Working with Functions Part 1
Concept of Functions
Using Advanced Functions
Using Logical Function: IF
Using Logical Function: AND
Using Logical Function: OR
Using Logical Function: IFS, SWITCH
10:30am-10:45pm Morning Break
10:45pm-12:30pm
Module 3: Working with Functions Part 2
Using Statistical functions: SUMIF, AVERAGEIF and COUNTIF
Using Lookup Functions: VLOOKUP, HLOOKUP and XLOOKUP
Using Text functions: TEXTJOIN and CONCAT
Using Statistical Functions: MAXIFS and MINIFS
12:30pm-1:30pm Lunch
1:30pm-3:30pm
Module 4: Auditing Worksheets
Tracing Formula Precedents and Dependents
Showing Formulas
Evaluating Formulas
Using Error Option Buttons
Running an Error Check
Course Outline ::EXC365I::
3:30pm-3:45pm Afternoon Break
3:45pm-5:00pm
Module 5: Working with Table
Converting Data in range as a Table
Total the Data in Table
Removing Duplicates from Table
Using Sort and Filter
Programme scope, delivery arrangements and suitability are confirmed during enquiry.