- Mailing Lists
- in
- GRAB 3 FREE 1 !!! LIVE ONLINE PROGRAM-USEFUL EXCEL FORMULAS AND FUNCTIONS (9 &10 Dec 2024)
Archives
- By thread 3667
-
By date
- June 2021 10
- July 2021 6
- August 2021 20
- September 2021 21
- October 2021 48
- November 2021 40
- December 2021 23
- January 2022 46
- February 2022 80
- March 2022 109
- April 2022 100
- May 2022 97
- June 2022 105
- July 2022 82
- August 2022 95
- September 2022 103
- October 2022 117
- November 2022 115
- December 2022 102
- January 2023 88
- February 2023 90
- March 2023 116
- April 2023 97
- May 2023 159
- June 2023 145
- July 2023 120
- August 2023 90
- September 2023 102
- October 2023 106
- November 2023 100
- December 2023 74
- January 2024 75
- February 2024 75
- March 2024 78
- April 2024 74
- May 2024 108
- June 2024 98
- July 2024 116
- August 2024 134
- September 2024 130
- October 2024 141
- November 2024 89
GRAB 3 FREE 1 !!! LIVE ONLINE PROGRAM-USEFUL EXCEL FORMULAS AND FUNCTIONS (9 &10 Dec 2024)
LIVE ONLINE PROGRAM
USEFUL EXCEL
FORMULAS AND FUNCTIONS
8 CPD Points Awarded by MBOT.
Venue : Online Training (Via Zoom) ( SBL KHAS / HRD Corp Claimable Course)
Date : 9 Dec 2024 (Mon) | 9am - 5pm By Siti
10 Dec 2024 (Tue) | 9am - 5pm .
.
INTRODUCTION
A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.
Every function has the same structure. It's not easy to remember which function and which arguments to use for each task. Fortunately, the Insert Function feature in Excel helps you with this.
BENEFIT
-At the end of this course you will have a greater understanding of building complex formulas using nested functions (such as IF statements).
-You will find quicker ways to customise formulas by taking advantage of the built-in functions available in Excel. Save time by learning more sophisticated search & auditing techniques when working with data-heavy spreadsheets.
WHO IS THIS COURSE FOR?
Our Microsoft Excel Formulas course is suitable for those with an advanced working knowledge of Excel who want a greater understanding of more sophisticated formulas & functions within Excel.
You may also wish to consider one of our finance for non financial managers courses.
OUTLINE OF WORKSHOP
1.0 Building complex formulas - Using nested IF statements - Creating compound logical tests using AND, OR, NOT functions with IF statements - Nesting LOOKUP functions - Source table structure information using CHOOSE function - Using MATCH function to locate data - The INDEX function for retrieving information by location - Using a nested formula containing INDEX, MATCH and MATCH (two-way lookup)
2.0 Advanced functions in formulas - Using COUNTIFS, SUMIFS & AVERAGEIFS for tabulating data based on single/multiple criteria - Statistical functions; MEDIAN, MODE, RANK, LARGE, SMALL, ROUND, MOD - AGGREGATE function to sum data in ranges with errors - Use a variety of Financial functions such PMT, FV, IRR
|
3.0 Data & Text Functions - Smarter ways to calculate date & time; TODAY - NETWORKDAYS, WORKDAY, DATEDIF - Use TYPE to identify data type of existing cell contents - Text functions; UPPER, PROPER, FIND, MID, SEARCH, LEFT, RIGHT, LEN - TRIM excess space in cells
4.0 Introduction to Array formulas - Using embedded Excel Array formulas - Create an Array formula
5.0 Auditing formulas - Tracing formula precedents, dependents, and errors - Correcting errors in formulas - Combining IF with VLOOKUP to suppress error messages - Using the IS information function - Error checking functions; ISERR, ISERROR, IFERROR |
** Digital Certificate of attendance will be awarded for those who completed the course
ABOUT THE FACILITATOR
Siti
Microsoft Office Specialist (MOS)
Siti started her career as an Information Technology Lecturer in few local colleges and universities back in year 1999. In her 8 years’ experience as a lecturer, she picks up various discipline in IT related subjects. She also involved in giving Microsoft Office Applications training to various companies.
Since 20 March 2006 till present, Siti Suriani decided for a career change. She moved to IT related training. As a Training Consultant, she focused more on Microsoft Office Applications training. She has facilitated training programs in link with broad-ranging groups of training institutes and clients. She is familiar and proficient with Microsoft Office Applications and during her training she will address the day to day issues faced by employees in today’s corporate environment.
In year 2007 till 2008 Siti Suriani had been appointed as one of the Master Trainer for The Teaching and Learning of Science and Mathematics in English (Pengajaran dan Pembelajaran Sains dan Matematik Dalam Bahasa Inggeris - PPSMI). Her role as a Master Trainer was to give training to all the trainers representing different states around Malaysia on how to deliver the training to all the teachers in various schools in Malaysia.
Aside to giving training, Microsoft Malaysia has engaged her to share her expertise on how to fully maximize the usage of Microsoft Office Applications since year 2008 till current. She had done many workshops around Malaysia for major Microsoft Malaysia customers mostly focusing on the Tips and Tricks and also best practices.
Siti was involved as a Handyman in Handyman Project under Shell Global Solutions, Malaysia since 2008 till 2011. To be given the opportunity to give One-to-one consultation with the client by looking, asking and solve problem related to the data provided by the clients. Examples of topics covered for Handyman sessions are E-mail and Calendar, Standard & Mobile Office, Archiving & Back-ups, NetMeeting, Livelink, Live Meeting? and Microsoft Office Applications.
Nov 2010 to Feb 2011 she was being given another golden opportunity by ExxonMobil Malaysiato be the lead trainer in the Migration from XME to GME project to train almost 3000 staffs. This training also includes Microsoft Office 2010 and Windows 7.
Academic Qualification
1999 – Bachelor of Computer Science (Honours) · Computing (Single Major) - USM
2001 – Master of Science · Distributed Computing - UPM
Working Experience
- Cybernetics International College of Technology · Lecturer · (June 1999 to May 2002)
- MARA University of Technology (UiTM Seri Iskandar) · Lecturer · (June 2002 to July 2003)
- Cosmopoint College of Technology · Lecturer · (September 2005 to March 2006)
- Iverson Associates Sdn Bhd · Senior Training Consultant · (March 2006 to February 2011)
- Info Trek Sdn Bhd · Senior Training Consultant· (February 2011 to April 2017)
- Fulltime Senior Training Consultant · (May 2017 to present)
Professional Certification
- Microsoft Certified Application Specialist for Office Excel 2007
- Microsoft Certified Application Specialist for Office PowerPoint 2007
- Microsoft Certified Application Specialist for Office Word 2007
- Microsoft Office Specialist for Office Excel 2016
- Microsoft Office Specialist for Office Word 2016
- PSMB Certified Trainer
( SBL KHAS / HRD Corp Claimable Course)
Online training Fee | |
14 hours online training |
RM 1,296.00/pax (excluded 8% SST) |
Group
Registration: Register
3 participants from the same organization, the 4th participant is FREE.
|
We hope you find it informative and interesting and we look
forward to seeing you soon.
Please act fast to grab your favorite training program! Please call 012-588 2728
or email to pearl-otc@outlook.com
Do forward this email to all your friends and colleagues who might be interested to attend these programs
If you would like to unsubscribe from our email list at any time, please simply reply to the e-mail and type Unsubscribe
in the subject area. We will remove your name from the list and you will not receive any additional e-mail
Thanks
Regards
Pearl
by "pearl@otcmarketing.com.my" <pearl@otcmarketing.com.my> - 08:57 - 10 Nov 2024