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! »
Feb 2017 ›
Venue:
TED Integrated, Binjai 8, KLCC, Kuala Lumpur, Malaysia
Schedule:
Mon 13 Feb 2017 - Tue 14 Feb 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.
Apr 2017 ›
Venue:
TED Integrated, Binjai 8, KLCC, Kuala Lumpur, Malaysia
Schedule:
Thu 20 Apr 2017 - Fri 21 Apr 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.
Jun 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Mon 19 Jun 2017 - Tue 20 Jun 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.
Aug 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Wed 23 Aug 2017 - Thu 24 Aug 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.
Oct 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Mon 16 Oct 2017 - Tue 17 Oct 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.
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.
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

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: ,