MENUv1.0

MalaysiaTraining.net
✕

Share this Page ›

Browse for Courses ›

IT IT Soft Skills Soft Skills Human Resource Management HRM Business Management Business Manufacturing Operations Manufacturing Health & Safety Safety Commercial Arts Arts View all View All

Contact Training Providers ›

Promore Your Courses ›

Read Our LinkedIn Pulse Articles ›

Using Formulas & Functions in Excel

Formulas & Functions in Microsoft Excel 2007/2010 Training Formulas & Functions in Microsoft Excel
By TED Integrated
PSMB HRDF Claimable
Course Title:
Using Formulas & Functions in Microsoft Excel 2007/2010
Training Category:
Information Technology
Target Audience:
Anyone who has a good basic working experience of Microsoft Excel who wants to dramatically improve their function and formula skills.
Duration:
2 Days
Public Program* Now Available! »
Nov 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Wed 29 Nov 2017 - Thu 30 Nov 2017
9:00AM - 5:00PM
Fee Per Person:
RM900.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Dec 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Wed 06 Dec 2017 - Thu 07 Dec 2017
9:00AM - 5:00PM
Fee Per Person:
RM900.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Jan 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Thu 25 Jan 2018 - Fri 26 Jan 2018
9:00AM - 5:00PM
Fee Per Person:
RM954.00
Register Now!

* Other terms & conditions apply.
Mar 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Mon 19 Mar 2018 - Tue 20 Mar 2018
9:00AM - 5:00PM
Fee Per Person:
RM954.00
Register Now!

* Other terms & conditions apply.
Apr 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Mon 23 Apr 2018 - Tue 24 Apr 2018
9:00AM - 5:00PM
Fee Per Person:
RM954.00
Register Now!

* Other terms & conditions apply.
Aug 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Wed 15 Aug 2018 - Thu 16 Aug 2018
9:00AM - 5:00PM
Fee Per Person:
RM954.00
Register Now!

* Other terms & conditions apply.
Sep 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Wed 26 Sep 2018 - Thu 27 Sep 2018
9:00AM - 5:00PM
Fee Per Person:
RM954.00
Register Now!

* Other terms & conditions apply.
Oct 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Thu 25 Oct 2018 - Fri 26 Oct 2018
9:00AM - 5:00PM
Fee Per Person:
RM954.00
Register Now!

* Other terms & conditions apply.
Nov 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Thu 15 Nov 2018 - Fri 16 Nov 2018
9:00AM - 5:00PM
Fee Per Person:
RM954.00
Register Now!

* Other terms & conditions apply.
For In-house Training »
Request for Quotation Request for Quotation
For Customization & Other Inquiries »
Contact TED Integrated
Contact customer service +603-2386-7788
Email customer service [email protected]
Delivery Methods
  • Language: English
  • Workshop
  • PowerPoint Presentation
  • Presentation Handouts
  • Computer Lab Work
  • Certificate of Participation
Ad by Google™
*Terms & Conditions
Microsoft Excel Training Series:

Using Formulas & Functions in Microsoft® Excel 2007/2010

“Greatly enhance the manipulation of business data to produce dynamic and analytical spreadsheets...”

By TED Integrated


PSMB Certified Training Provider
Request for In-house TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Register for Public TrainingRegister for Public Training
Email Customer Service [email protected] Contact Customer Service+603-2386-7788

Introduction

This course is for anyone who has a good basic working experience of Microsoft Excel who wants to dramatically improve their function and formula skills.

Formulas can manipulate both numbers and text. This course is therefore ideal for advanced spreadsheet builders who need the power of combined functions that will greatly enhance the manipulation of business data to produce dynamic and analytical spreadsheets.

Prerequisites

To ensure your success, we recommend that you have a good basic working knowledge of Excel. Knowledge of basic formulas is definitely recommended. Students can obtain this level of skill through our Excel Foundation, Intermediate and Advance courses.

Course Objectives

At the end of this course, participants should be able to:

  • Define function and formula in Excel.
  • Use the built-in financial functions.
  • Use the logical functions for conditional comparisons.
  • Use text category functions to manipulate text.
  • Use date and time functions to perform date related analysis.
  • Use lookup and reference category functions for productivity.
  • Use math and trig category functions for advance calculations.
  • Use statistical category functions for other data analysis activities.

Course Outline

DAY 1

Lesson 1: Financial Function

  • SLN
  • SYD
  • FV
  • PMT

Lesson 2: Logical Functions

  • IF
  • NESTED IF
  • AND
  • OR
  • IFERROR
  • NOT

Lesson 3: Text Category Functions

  • CONCATENATE
  • LEFT
  • MID
  • RIGHT
  • LOWER
  • PROPER
  • UPPER
  • EXACT
  • LEN
  • CHAR
  • FIND
  • REPLACE

Lesson 4: Date and Time Functions

  • TODAY
  • NOW
  • DATEDIF
  • DAYS360
  • YEAR
  • YEARFRAC
  • WEEKDAY
  • WEEKNUM
  • EDATE
  • EMONTH

DAY 2

Lesson 5: Lookup and Reference Category Functions

  • LOOKUP
  • VLOOKUP
  • HLOOKUP
  • INDEX & MATCH

Lesson 6: Math and Trig Category Functions

  • POWER
  • PRODUCT
  • CEILING
  • FLOOR
  • ROUND
  • ROUNDDOWN
  • ROUNDUP
  • SUBTOTAL
  • SUMIF

Lesson 7: Statistical Category Functions

  • COUNT
  • COUNTA
  • COUNTIF
  • COUNTBLANK
  • SMALL
  • LARGE
  • AVERAGE IFS
  • AVERAGE A
  • RANK

For In-house Training:

Request for Quotation

Request for Quotation Now

For Content Customization & Other Inquiries:

Contact TED Integrated

Contact Customer Service

+603-2386-7788
Email Customer Service [email protected]
Ad by Google™

Related Training Courses:

More Other Training Courses:

Published by: ,
Quick Edit