Power Functions in Excel 2019

Course Code:
EX03-200-2019
Duration:
1 days
8.30am to 5.30pm  
Location:
80 Jurong East Street 21 #04-04
Devan Nair Institute
Singapore 609607
Course Fees:
S$230 (excl of G.S.T)
2020 Course Dates
10 Jan 2020
6 Mar 2020
5 May 2020
10 Jul 2020
4 Sep 2020
13 Nov 2020
None of the published dates will work for you? Speak to our training consultants for a private tuition arrangement or a closed door training.
Do note that this course listed uses digital courseware. You are required to bring your own device to access the digital manual.

Course Overview

Excel Formula and Functions provide a powerful way to carry out automate calculations on your data and streamline your work. You will learn in detail, how basic operators and functions work, some common types of functions available and their applications.

Course Outline

SECTION 1: WORKING WITH TABLES
Formatting Data as a Table

SECTION 2: PROTECTION
Protection in Excel
Protect a File
Protect a Worksheet
Protect a Workbook

SECTION 3: FUNCTIONS
Introduction to Functions
Using Functions
Using Commonly Used Functions
Using IF Functions
Using IFS Functions
Using Nested Functions
Using Conditional Summary Functions
Using Text Functions
Using Lookup Functions

SECTION 4: AUDITING WORKSHEETS
Trace Formula Precedents
Trace Formula Dependents
Show Formulas
Error Checking
Evaluate Formulas
Watch Window

SECTION 5: DATA TOOLS
Consolidating Data

SECTION 6: ADVANCED FORMATTING
Conditional Formatting

Click Here for full course outline

Take the Next Step

It Takes Less Than 5 Min