50449: Useful Formulas And Functions | IT Training & Certification | Info Trek
Respect Your Dreams
Follow through on your goals with courses

50449: Useful Formulas And Functions

Location

Format What’s this?
Starting From
RM 1000.00
  1. 2 Days
  1. HRDF SBL Claimable
  2. Lunch & refreshment provided
  3. Certificate of Attendance available

All of our private classes are customized to your organization's needs.


Click on the button below to send us your details and you will be contacted shortly.

  1. 2 Days

50449: Useful Formulas And Functions

WHAT YOU WILL LEARN

This 2 days course provides students with the knowledge and skills to the usage of useful formulas and functions in Microsoft Excel 2007 and Microsoft Excel 2010.

AUDIENCE

This course is intended for users of Microsoft Office Excel who want to learn about useful formulas and functions.

PREREQUISITES

Basic working knowledge of Microsoft Office Excel

METHODOLOGY

This program will be conducted with interactive lectures, PowerPoint presentations, discussions and practical exercises

COURSE OBJECTIVES

After completing this course, students will be able to:

  • Apply Formula and Functions Basic
  • Statistical and Logical Functions
  • Lookup and Reference Formulas
  • Text Formulas
  • Date and Time Formulas
  • Array and Database Functions
  • Efficiency Tips

Expand All

Modules

Module 1 - Making Data Work For You

This module explains how to understand and apply Excel basic formulas and functions.

Lessons

· Formula basics

· Using cell references

· Copy formula without changing cell reference

· Transpose formula

· Using nested functions

After completing this module, students will be able to:

· Understand and apply formula basics

· Using cell references

· Copying formula without changing cell reference

· Transpose formula using paste special

· Using nested function

Module 2 - Statistical And Logical Functions

This module explains how to use logical functions including CountIf, Sumif, If, IsError.

Lessons

· Perform calculation using CountIF

· Perform calculation using SumIF

· Perform calculation using AverageA

· Using IF function to prevent division by zero

· Using IsError function to avoid error display

· Creating multiple conditions using nested IF

· Using logical function OR, And

After completing this module, students will be able to:

· Perform calculation using CountIf, SumIf, AverageA

· Using If function to prevent division by zero

· Using IsError function to avoid error display

· Create multiple conditions using nested IF

Using logical function OR, AND

Module 3 - Lookup And Reference Formulas

This module explains how to apply and use lookup formulas including vlookup, hlookup, match and index.

Lessons

· Using Vlookup to find specific data

· Using Hlookup to find values in rows

· Using Match and Index to retrieve data

After completing this module, students will be able to:

· Using Vlookup to find specific data

· Using Hlookup to find values in rows

· Using Match and Index to retrieve data


Module 4 - Text Formulas

This module explains how to apply Text formula to help change casing of text, append text and numerical value in excel spreadsheet.

Lessons

· Changing case of text

· Append text and numerical value

· Convert imported text format into numbers

· Break imported date field into individual columns

After completing this module, students will be able to:

· Changing case of text using Upper, Lower or Proper formula

· Append text and numerical value

· Convert imported text format into numbers

· Break imported date field into individual columns


Module 5 - Date And Time Formulas

This module explains how to make use of calculate the difference of two given Date fields and to perform calculation with Time fields.

Lessons

· Perform addition to Date fields

· Calculate difference between two Dates

· Perform calculations with Time fields

After completing this module, students will be able to:

· Perform addition and calculate difference between two dates

· Perform calculations with Time fields


Module 6 - Array And Database Functions

This module explains how to apply and use advance formula including Array, Frequency and Database functions.

Lessons

· Using Array Formulas

· Calculate the difference between Maximum and Minimum values

· Using Frequency function to Count responses

· Using Database functions DSum and DCount

After completing this module, students will be able to:

· Using Array Formulas

· Calculating the difference between Maximum and Minimum values in an Array

· Using Frequency function to Count responses in tabulated data

· Using Database functions DSum and DCount


Module 7 - Efficiency Tips

This module discusses some useful Excel Tips including application of Data Validations and Auditing Tools.

Lessons

· Shortening worksheets names

· Protecting cells containing formulas

· Using Data Validation

· Displaying Formula syntax

· Using Auditing Tools for errors checking

· Tracing precedent and dependent

· Adding comments to worksheet

After completing this module, students will be able to:

· Understand the advantages of shortening worksheet names

· Protecting cells from amendments by others

· Using Data validation to improve data entries

· Using Auditing Tools for checking errors

· Adding useful notes by commenting worksheet


Anne Teoh Hui San

Anne Teoh Hui San

A rising and highly engaging trainer, Anne Teoh represents a new face for Microsoft Office training. She has been involved in training Microsoft Windows 8 and Windows Phone development and design Microsoft Student Partners (MSP) for a year. Within her first year venture into the training industry, she is now highly sought after by banking, investment firms and high-tech industries; to execute competent Microsoft Office training. She specializes in delivering Office Word, Office Excel and Office PowerPoint trainings, having most of the occasion delivering beyond client expectations of what defines a training.Focusing heavily on delivering hands-on experience to her participants, she instils a robust understanding of the fundamentals for Microsoft Office training; as she strongly views that traditional delivery of training should be phased out and delivered in a lively manner that reflects the everyday routine of a given professional.Besides training, she is also as a deeply involved the development of Windows Phone Applications, mostly handling the UI/UX portion.


Read More

Pauline Leong Pei Loo

Pauline Leong Pei Loo

Being in the information technology background for so many years, she is an expert on Microsoft Applications, Publisher (Version 2000, XP, 2003 & 2007, VBA, Introduction To Internet, Multimedia Fundamentals, IT Skills For Non-PC Users, Basic IT skills and related programs. In her previous company, she was responsible for developing training courseware and customizing training curriculum.Pauline is a reliable person, helpful, independent and friendly person with a pleasant personality. Her classes are lively as she enjoys interacting with people and delivering her knowledge to individuals. Read More

Patrick Cheah Liat Hin

Patrick Cheah Liat Hin

Patrick has been involved in the IT industry since 2002 and has exposure in both technical and non-technical area which includes customer service, marketing, web and graphic design and technical support.In IT training, Patrick started off as a course facilitator guiding users in an online E-Learning portal. He proceeded to classroom training, where he trained visually impaired students in using Access Technology and Microsoft Office; then moved on to train professionals from various manufacturing sectors in Microsoft Office; covering from basic to advanced level courses.Apart from technical training, Patrick is also involved in soft skill training. A member of the Toastmasters International since 2006 and an Advanced Communicator, he conducts public speaking courses for students as well as working professionals.


Read More

Course Reviews

No Remarks

0

0 Ratings