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 Training	Public program not yet available Register for Public Training
[email protected]	+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

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

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

Request for Quotation Now

	+603-2386-7788
	[email protected]