Formulas & Functions in Microsoft Excel 2007/2010 Training

Formulas & Functions in Microsoft Excel
By TED Integrated

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! »

Jun 2019 ›

Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Mon 17 Jun 2019 - Tue 18 Jun 2019
9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Promotions:

10% discount for group registration of 3 paxs or more.

* Other terms & conditions apply.

Jul 2019 ›

Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Mon 01 Jul 2019 - Tue 02 Jul 2019
9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Promotions:

10% discount for group registration of 3 paxs or more.

* Other terms & conditions apply.

Aug 2019 ›

Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Thu 08 Aug 2019 - Fri 09 Aug 2019
9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Promotions:

10% discount for group registration of 3 paxs or more.

* Other terms & conditions apply.

Sep 2019 ›

Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Tue 10 Sep 2019 - Wed 11 Sep 2019
9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Promotions:

10% discount for group registration of 3 paxs or more.

* Other terms & conditions apply.

Oct 2019 ›

Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Mon 07 Oct 2019 - Tue 08 Oct 2019
9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Promotions:

10% discount for group registration of 3 paxs or more.

* Other terms & conditions apply.

Nov 2019 ›

Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Mon 11 Nov 2019 - Tue 12 Nov 2019
9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Promotions:

10% discount for group registration of 3 paxs or more.

* Other terms & conditions apply.

Dec 2019 ›

Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Mon 09 Dec 2019 - Tue 10 Dec 2019
9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Promotions:

10% discount for group registration of 3 paxs or more.

* Other terms & conditions apply.

For In-house Training »

Request for Quotation

For Customization & Other Inquiries »

Contact TED Integrated

	+603-2386-7788
	training@ted.com.my

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 Training	Public program not yet available Register for Public Training
training@ted.com.my	+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

Lesson 2: Logical Functions

IF
NESTED IF
AND
OR
IFERROR
NOT

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

For In-house Training:

Request for Quotation Now

For Content Customization & Other Inquiries:

Contact TED Integrated

	+603-2386-7788
	training@ted.com.my

Ad by Google^™

Related Training Courses:

More Other Training Courses:

Published by: MalaysiaTraining.net , 01 July 2014

	e-Learning (Experimental) Health & Safety (COVID-19), Work-from-Home Productivity, e-Learning Guidelines for Training Providers and more.
	Information Technology Microsoft®, Linux™, Adobe®, CompTIA®, Huawei®, Scrum, AutoCAD, Cyber Security and more.
	Soft Skills Communication, Leadership, Team-building, Customer Service, Selling & Marketing, Train-the-Trainer and more.
	HR Management Recruitment & Selection, Talent Management, Industrial Relations and more.
	Business Management Project Management, Purchasing & Logistic, Financial & Taxation Management and more.
	Manufacturing Operations ISO 9001, ISO Internal Audit, Quality Management System, Lean Six Sigma, Lean Manufacturing and more.
	Health & Safety ISO 14001, OHSAS 18001, Safety Audit, First Aid, Chemical Management, Occupational Health & Safety and more.
	Commercial Arts Corporate Photography, Digital Photography and Editorial Photography.

Professional Short Courses in Malaysia

MTN Web Store App now Free for Everyone!

Pages

Using Formulas & Functions in Excel

Jun 2019 ›

Jul 2019 ›

Aug 2019 ›

Sep 2019 ›

Oct 2019 ›

Nov 2019 ›

Dec 2019 ›

Using Formulas & Functions in Microsoft® Excel 2007/2010

By TED Integrated

Introduction

Prerequisites

Course Objectives

Course Outline

DAY 1

Lesson 1: Financial Function

Lesson 2: Logical Functions

Lesson 3: Text Category Functions

Lesson 4: Date and Time Functions

DAY 2

Lesson 5: Lookup and Reference Category Functions

Lesson 6: Math and Trig Category Functions

Lesson 7: Statistical Category Functions

For In-house Training:

Request for Quotation Now

For Content Customization & Other Inquiries:

Contact TED Integrated

+603-2386-7788

Related Training Courses:

More Other Training Courses:

e-Learning (Experimental)

Information Technology

Soft Skills

HR Management

Business Management

Manufacturing Operations

Health & Safety

Commercial Arts

About us

Training category

For training providers

Follow us

Who would you like to contact?

Training Providers

Our Customer Service

Using Formulas & Functions in Microsoft^® Excel 2007/2010