Microsoft Excel Functions & Formulas Training Course

Microsoft® Excel Tips & Tricks
By TED Integrated

Microsoft^® Excel Series:

Tips & Tricks in Microsoft^® Excel Functions & Formulas

“Delivers all the tips and techniques one needs to maximize one of the most powerful spreadsheet tools”

By TED Integrated

PSMB Certified Training Provider

Request for In-house Training	Public program not yet available
training@ted.com.my	+603-2386-7788

Course Title:
Tips & Tricks in Microsoft^® Excel Functions & Formulas
Training Category:
Information Technology
Target Audience:
Those who have good basic of Microsoft^® Excel and would like to discover the secrets of functions & formulas that make them standout from the crowd.
Duration:
2 Days

Public Training Events

Mar 2018 ›

Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Mon 26 Mar 2018 - Tue 27 Mar 2018
9:00AM - 5:00PM
Fee Per Person:
RM1,060.00

* Other terms & conditions apply.

Jul 2018 ›

Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Mon 23 Jul 2018 - Tue 24 Jul 2018
9:00AM - 5:00PM
Fee Per Person:
RM1,060.00

* Other terms & conditions apply.

For In-house Training

For Other Inquiries

Contact TED Integrated

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

Delivery Methods

Language: English
PowerPoint Presentation
Presentation Handouts
Computer Lab Work
Certificate of Participation

*Terms & Conditions

Ad by Google^™

Course Introduction ›

Formulas are critically important to every Excel users. They are what make a spreadsheet a spreadsheet. This one-of-a-kind course delivers all the tips and techniques one needs to maximize one of the most powerful spreadsheet tools: formulas. The more you know about formulas, the better your spreadsheets will be. Hence the course is to aim to get the most out of worksheet formulas.

Course Objectives ›

Upon completion of this 2-day Microsoft^® Excel Functions & Formulas training course, participants should be able to:

Have a deep understanding on how functions work and how functions complement each others.
Develop mega formulas by combining various functions in a single formula hence creating powerful spreadsheet.

Course Outline ›

DAY 1

Module 2: Logical Category Functions

AND
OR
IF
Nested IF
IFERROR

Module 3: Financial Functions

SYD
FV
PMT
RATE

Module 4: Working with Names

What's in a Name?
Creating Names Using the Define Name Dialog Box
Creating Names Using the Name Box
Rules for Naming Names
Creating Names Automatically
Naming Entire Rows and Columns
Creating Multisheet Names
Creating a List of Names
Using Names in Formulas
Applying Names to Existing Formulas
Deleting Names
Deleting Named Cells or Ranges
Redefining Names
Changing Names
How Excel Maintains Cell and Range Names
Name Problems when Deleting Sheets
The Secret to Understanding Names
Naming Constants
Naming Text Constants

Module 5: Information Category Functions

CELL
IS Functions
ISEVEN
ISODD
TYPE

DAY 2

Contact us now ›

Course content customization
In-house training request
Available public program

Consultation services
Other inquiries

Call : +603-2386-7788

E-mail : training@ted.com.my

Related Courses ›

More Other Training Courses ›

Published by: MalaysiaTraining.net , 01 July 2015

Browse Short Courses

Training Category

	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

Can't wait to subscribe to our MTN Web Store App?

Pages

Excel Functions & Formulas: Tips & Tricks