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
  1. 2 Days
  1. All of our private classes are customized to your organization's needs.
  2. Click on the button below to send us your details and you will be contacted shortly.

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

Azrulnizam Bin Ahmad

Azrulnizam Bin Ahmad

Azrulnizam Ahmad has been working in the business industry since 2004 and has been exposed to all the common challenges faced by business personnel. With his years of experience working with business and management, IT services and end users, he understands the importance of business value, infrastructure efficiency and user productivity.He shares his training passion in Microsoft Office 2007 Application - Excel, PowerPoint, and Word; Microsoft Office 2010 Application - Excel, PowerPoint, and Word and also emphasizes on the criticality of this aspect in any implementation.He is an energetic, independent, goal-oriented individual that has a high work standard and is committed to his work. He is also a good planner, is creative and resourceful, has great leadership charisma and works well with others. Read More

Amelia Dillon

Amelia Dillon

Having experienced many years in acquiring skills and knowledge in the related fields, the trainer is among a few of extraordinary trainers in the local training arena. The one thing that makes her a prominent trainer is her knowledge and exposure gathered over many years in IT industry. She is well known to have the ability to enlighten participants by not only leading them towards the subject matter but also by allowing them to relate to the subject matter and at the same time make the process of learning a lot more easier. Over the years, she has developed many training modules and had extended her service to various companies. Some of these modules include the PPSMI manual that was used by the Ministry of Education to train teachers nation-wide on how to use the PPSMI equipment. Read More

Jarina Muhamad Ismail

Jarina Muhamad Ismail

Since 2005, Jarina is involved in delivering learning programmes for Microsoft Excel, PowerPoint, Project, Outlook, Access, Word, Publisher and Visio. As a Microsoft Office Specialist (MOS) in all versions (2003-2013), she is using her expertise to provide timely solutions to the end-user which ranges from basic to advanced level including power users. She has experience in training and coaching various teams of professionals like executives, engineers, managers and directors to organize, analyze, create report and present business data more efficiently.
Read More

Izham Fariz Ahmad Jinan

Izham Fariz Ahmad Jinan

Izham Fariz experience in IT includes creating systems using Visual Basic and Power Builder as front-end and MS-SQL 2000 and MS Access as database. Other programming languages are C++ and Cobol. He is also exposed to Rational Rose and Microsoft Transaction Server. Read More

Mazlita Binti Mat Hassan

Mazlita Binti Mat Hassan

Mazlita has a vast experience in teaching and training in various Computer Applications software and other subjects. Her relaxed but thorough teaching skills makes her extremely popular with her participants and clients. She is passionate about disseminating knowledge and always ensures that the learning environment and resources provided support the participants' needs.

Apart from teaching, she is also involved in database development projects. Her recently completed database development project was with Corporate Services Division, Tenaga Nasional Berhad, where she developed four database systems for their Training Unit, Administration Unit, Human Resource Unit (Compensation & Benefits).

Previously, Mazlita spent 11 years in London, studying and working at various companies, mainly providing consultancy work regarding Web Data Mining. Her previous clients include Gabriel Securities Limited, Yoga Therapy Centre, Beer & Young Limited and The London Transport Museum.

Mazlita has written several research papers that appeared in renowned international journals and conferences, aside from providing teaching assistance and designing course materials for undergraduate students whilst studying for her PhD.

Read More

Siti Suriani Shih Othman

Siti Suriani Shih Othman

With more than 10 years of working experience to her belt, Siti Suriani is currently doing corporate trainings for various public and private sector, mainly on Microsoft Office Application. She was previously a lecturer with Cosmopoint College of Technology and University Technology MARA, supervised students' laboratory sessions, prepared lecture notes, modules and materials. Some of the courses taught by her included Multimedia Development Methods, Digital Media For Interactive Application, Computing Fundamentals, Object Oriented Programming II, PC Maintenance, Computer Architecture, Database Management, System Analysis and Design, Java Programming and many more.She has also attended instructors training workshop organized by UPM and was involved in Centralized Exam Paper Marking conducted by UPM. Other short courses that she has also attended are Train The Trainer and soft skills trainings. Read More

Shalina Hj Mohd Salleh

Shalina Hj Mohd Salleh

Shalina has 20 years of experience in IT related fields including 11 years in conducting public courses. She specializes in Corporate IT infrastructure planning (networking, troubleshooting and system integration), conducts applications training programs such as Microsoft Office, Adobe, Lotus and COMPtia products as well as organizes and conducts exhibitions and seminars.She has conducted training courses in Malaysia, Indonesia and Brunei using programs developed by her and others based on the “competency" approach which ensures successful learning through “drawing out " hidden ideas during the training session. Her training programs have consistently been rated as “excellent“ by her course participants and corporate clients. Read More

Ricky Chan Chee Ho

Ricky Chan Chee Ho

Ricky have extensive knowledge in software application, management skills, leading edge technology planning and implementation as well as superior strategic thinking & communication skills.His expertise are in Exchange Server, SQL Server 2000, 2005, 2008, 2012, Windows 2000, Microsoft Windows Server 2003, 2008, 2012, Window XP, Vista, 7, 8, Window NT server, Microsoft offices 2003, 2007, 2010, Microsoft Project 2013, 2007 and 2010.


Read More

Tern Zhi-Guang

Tern Zhi-Guang

Tern Zhi-Guang is a certified professional trainer for both creative and professional courses. He has 3 years' experience in the multimedia industry as a Web Designer cum Trainer and is well-verse in content management system for the web. As an Adobe Certified Expert, he lives up to his standard and has never failed to make his class an active and lively one. He is a highly motivated person and his involvement in martial arts has also helped him to be mentally strong as well as a highly disciplined. The organizations that have benefited from his training are UTM, POLIKU, Chung Hwa, Osram, CIDB Construct Service S/B, Holiday Tours & Travel S/B, I&P Group S/B, Sunway Education Group S/B Software, TBWA-ISC Malaysia Sdn Bhd, Net Business Solution, Public Mutual Berhad, Universiti Malaysia Pahang, University Malaya, University Malaysia Sabah, University Malaysia Sarawak, Polytechnic Arau, UITM Puncak Perdana, Sony Malaysia, Jabatan Landscape Malaysia, Polytechnic Dungun, Universiti Malaysia Pahang and Institute Latihan Perindustrain Selandarb(Malacca). Read More

Chin Chee Chong

Chin Chee Chong

Chin Chee Chong has been in the Information Technology industry for the past 21 years starting and is well-versed in troubleshooting, assembling of PCs, IT software applications, IT training and development for Microsoft Office users.

He is one of the pioneer certified Microsoft Word, Excel, PowerPoint, Access and Outlook trainers in Malaysia having attained his Microsoft Office Specialist Master Instructor (MOS) and Microsoft Certified Trainer (MCT) by Microsoft USA.

His extensive tutelage experiences spanning over 12 years stem from conducting courses for corporate companies such as American Insurance Group Berhad (AIG), Allianz General Insurance Malaysia Berhad, Citibank Berhad, Favelle Favco Berhad, EC-Council Academy,HSBC Bank Malaysia Berhad, Institute of Bankers Malaysia (IBBM), Jerneh Insurance Berhad, OCBC Bank Berhad, Proton Holding Berhad, Shell Information Technology International, Sime Darby Plantation Sdn Bhd, SP Setia Berhad, Wong Engineering Electronics Berhad and many more.

Read More

Sylvia Sharon Anthony

Sylvia Sharon Anthony

She began her career as a Corporate Trainer and her personal areas of expertise are wide; encompassing Database and Graphic applications. In addition to that; she also specializes in corporate coaching for government, multi-national companies to local SMEs.

Sylvia has acquired immense knowledge and skill in the training field. Since becoming a trainer, her work has involved design, delivery and developing training programmers. In her 16 years of experience in the training arena she has delivered and customized training programmers specifically to tailor for organization's unique training needs and to maximize the participant's learning outcomes.

As a trainer, Sylvia constantly strives to improve herself and learn new methods and skills. She is passionate about building new programs that meet the upcoming challenges of the IT industry. She is currently developing a customized Excel programme which will emphasize on the advanced features of Microsoft Excel i.e. Mastering Charts, Functions and Pivot Tables.

Read More

Kua Su-Ann

Kua Su-Ann

Su-Ann has been in the IT training industry for the 20 years and has trained thousands of people on the use of Microsoft Office. As Microsoft Office application is her area of specialization, she is an expert in all versions of the software and is capable of teaching at the basic, intermediate and advanced level. She has provided training to a variety of people: bankers, IT Personnel, young and old office workers, managers, senior managers, directors and corporate C-level executives. Su-Ann is the trainer of choice for many of our Blue Chip clients. Besides training, she has also been deeply involved in courseware development. In addition to developing generic courseware on Microsoft Office Applications, she has developed customized courseware to meet the unique requirements of the clients.


Read More

M. Angeline ap P. Morgis

M. Angeline ap P. Morgis

Angeline Morgis has been training corporate clients from various industries, namely manufacturing, financial institutions and advertising companies on customized and end-user computer training programmes. She has developed manuals for Microsoft Word (Beginner to Advanced), Microsoft Excel (Beginner to Intermediate), Microsoft Outlook, Windows, FrontPage, Paintshop Pro, Windows NT Supporting, Microsoft Access, Microsoft Powerpoint (Beginners to Advanced), Visio and Photoshop.She was the Project Manager for the development of trainer's manual for HP's Large Format Printers which were used for training for the whole of Asian Region. She also developed a Learner's Guide for Selangor Human Resource which was a government project; coordinated and oversee SAP projects implementation for Shell Malaysia. The project involved the documentation of the SAP Financial and Procurement modules and she personally conducted training for them using SAP for their Financial and Procurement Process. Read More

Habibah Binti Shaari

Habibah Binti Shaari

As a leader and trainer, Habibah brings with her more than 20 years of corporate experience from diverse industries. She is an experienced, versatile, dynamic and passionate trainer.

Her work with Mesiniaga Sdn. Bhd. and Institute Tadbiran Awam (INTAN) has given her invaluable experience in handling all aspects of ITC training including planning, developing, delivering and managing training programs. Her work experience as a System Analyst and Analyst Programmer adds to her credentials as an IT specialist. She is instrumental to the growth of the company and her long list of satisfied clients bears testimony to her leadership qualities.

Her diverse background, sound analytical skills and IT qualification accelerates her role as an in-house consultant and her overall training effectiveness. Her commitment to her work, passion in people development and a strong track record adds value in building human capital with the various organisations she works with. Organisations she has worked for include Kementerian Pendidikan Malaysia, Kementerian Sumber Manusia, PROTON, National Panasonic, Usahanita to name a few.

Read More

Course Reviews

No Remarks

0

0 Ratings