2. Mailing Lists
  3. in
  4. LAST CALL !!! LIVE ONLINE PROGRAM-MICROSOFT EXCEL (ADVANCED LEVEL) (4-5 Dec 2024)

Archives

You have too many messages on hold

The CEO’s essential checklist: Questions every chief executive should be able to answer

LAST CALL !!! LIVE ONLINE PROGRAM-MICROSOFT EXCEL (ADVANCED LEVEL) (4-5 Dec 2024)

LIVE ONLINE PROGRAM

MICROSOFT EXCEL

(ADVANCED LEVEL)

Venue : Online Training (Via Zoom)                       (HRD Corp/SBL KHAS Claimable)

Date : 4 Dec 2024 (Wed)  |  9am - 5pm                       By Siti

 5 Dec  024 (Thu)    |  9am - 5pm                     .  

                 .  

 

DESCRIPTION

This course will give you a deep understanding of the useful Excel functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. Focus on what each Functions does, hands-on, contextual examples designed to showcase why these Functions are awesome and how they can be applied in several ways and how to troubleshoot formulas. Manipulating data using analysis tools, password settings and record actions using macros.

 

OBJECTIVES

-        Mastering the use of some of Excel's most popular and highly sought-after functions (VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more...)

-        Audit Excel Worksheet formulas to ensure clean formulas

-        Worksheets and Workbooks protection

-        Usefulness of the What-If Analysis

-        Automate your day-to-day Excel tasks by mastering the power of Macros

 

REQUIREMENT

-        A working knowledge of creating/formatting simple spreadsheets, basic formulas and functions

-        Excel Introduction course or equivalent knowledge or experience.

 

FOR WHOM

Those wishing to increase their knowledge of Excel to create more in-depth worksheets and improve the presentation of data.

 

OUTLINE OF WORKSHOP

 

1. Excel List Functions

1.1 Introduction to Excels Function: DSUM()

1.2 Excel DSUM Function Single Criteria   Continued

1.3 Excel DSUM Function with OR Criteria

1.4 Excel DSUM Function with AND Criteria

1.5 Excel Function: DAVERAGE()

1.6 Excel Function: DCOUNT()

1.7 Excel Function: SUBTOTAL()

 

2. Working with Excel’s Conditional Functions

2.1 Using Excel's IF() Function

2.2 Excel's IF() Function with a Name Range

2.3 Nesting Functions with Excel

2.4 Nesting Excels AND() Function within the IF() Function

2.5 Using Excel's COUNTIF() Function

2.6 Using Excel's SUMIF() Function

2.7 Using Excel's IFERROR() Function

 

3. Working with Excel’s Lookup Functions

3.1 Microsoft Excel VLOOKUP() Function

3.2 Microsoft Excel HLOOKUP() Function

3.3 Microsoft Excel INDEX() Function

3.4 Microsoft Excel MATCH() Function

3.5 Microsoft Excel INDEX() and MATCH() Function Combined

3.6 Microsoft Excel INDEX() and MATCH() Function Combined Continued

3.7 Creating a Dynamic HLOOKUP() with the MATCH() Function

4. Auditing an Excel Worksheet

4.1 Tracing Precedents in Excel Formulas

4.2 Tracing Dependents in Excel Formulas

4.3 Working with the Watch Window

4.4 Showing Formulas

  

5. Protecting Excel Worksheets and Workbooks

5.1 Protecting Specific Cells in a Worksheet

5.2 Protecting the Structure of a Workbook

5.3 Adding a Workbook Password

 

6. Mastering Excel’s “What If?” Tools

6.1 Working with Excel's Goal Seek Tool

6.2 Working with Excel's Solver Tool

6.3 Building Effective Data Tables in Excel

6.4 Creating Scenarios in Excel

 

7. Automating Repetitive Tasks in Excel with Macros

7.1 Understanding Excel Macros

7.2 Activating the Developer Tab in Excel

7.3 Creating a Macro with the Macro Recorder

7.4 Creating Buttons to Run Macros

 

 

 

** 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 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 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)

 

(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.
(Buy 3 Get 1 Free) if Register before 25 Nov 2024. Please act fast to grab your favorite training program!

  

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@otcsb.com.my" <pearl@otcsb.com.my> - 09:10 - 19 Nov 2024