Excel is the most commonly deployed spreadsheet package in the world, partly because it comes as part of Microsoft Office. Participants will learn how to use multiple worksheets and workbooks efficiently, and they will start working with more advanced formatting options including styles, themes, and backgrounds.

They will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with tables. This course also covers advanced charting techniques, use of trendlines and sparklines, worksheet auditing and protection, file sharing and merging, and workbook templates. Finally, participants will learn to work with PivotTables and PivotCharts.

Certification by PEAK SUCCESS ABUNDANCE – Graduates Your Colleagues

Certification by PEAK SUCCESS ABUNDANCE – With Thanks

Congratulations on Completing the Training by PEAK SUCCESS ABUNDANCE

Upon completion of this program, participants should be able to:

  • Outline and Group Data
  • Work with PivotTables
  • Hyperlink Excel and The Internet
  • Creating and Using Shared Workbooks
  • Work with Visual Basic and Macros
  • Perform Advanced File Management
  • Customize Excel and Use Excel With Other Programs

This Excel training is designed for individuals who already have foundational knowledge and skills in Excel and are ready to advance their data analysis skills and abilities through the application of advanced Excel functionality such as advanced formula creation, tables, charts, PivotTables and PivotCharts

1. OUTLINING AND GROUPING YOUR DATA

  • Using Automatic Outlining
  • Displaying And Collapsing Levels
  • Grouping Data Manually
  • Creating Subtotals

2. PIVOT TABLES

  • What Is A Pivot Table?
  • Creating A Pivot Table Frame
  • Specifying Data In A Pivot Table
  • Rearranging Pivot Table Data

3. MORE ON PIVOT TABLES

  • Modifying Pivot Table Calculations
  • Formatting A Pivot Table
  • Refreshing A Pivot Table
  • Charting A Pivot Table
  • Creating A Pivot Table Based On Data From
  • An External Database

4. WHAT IF ANALYSIS

  • Using A One And Two Input Data Table
  • Using Goal Seek
  • Using Solver

5. HYPERLINK EXCEL AND THE INTERNET

  • Hyperlinks And The Internet
  • Inserting Hyperlinks
  • Modifying Hyperlinks
  • Using The Web Toolbar
  • Browsing Hyperlinks In Excel
6. CREATING AND USING SHARED WORKBOOKS
  • Sharing A Workbook
  • Requesting Reviews
  • Reviewing A Workbook
  • Tracking Changes
  • Merging And Revising A Shared Workbook

7. VISUAL BASIC AND MACROS

  • Adding Code To Your Macro
  • Adding Comments To VBA Code
  • Declaring Variables
  • Prompting For User Input
  • Iteration Over A Range
  • Using If Then Else Statements

8. ADVANCED FILE MANAGEMENT

  • Identifying File Properties
  • Searching For Files
  • Protecting Personal Information
  • Creating Back Up Files
  • Changing Auto-Recovery Settings

9. CUSTOM AND ADVANCED FEATURES IN EXCEL

  • Customizing Excel By Changing Options
  • Using Custom Auto-Fill Lists
  • What Is Text To Speech?
  • Using Detect And Repair

10. USING EXCEL WITH OTHER PROGRAMS

  • Using Excel In Word
  • Inserting Excel Data In Word
  • Modifying Excel Data After Insertion

COURSE METHODOLOGY

Please bring your laptop, hands-on practical sessions. Highly practical, easy to understand/apply with demonstrations, question & answer session, discussion, presentation, relevant exercise, revision sessions for total complete understanding

KENT LAU

Kent Lau holds a Degree (Hons) in Computing. He worked with several software companies as software developer. As a certified Microsoft Office Specialist (MOS Excel Core) and PSMB trainer, he is able to deliver a better, systematic training with proper training methods and trainer’s tool.

Kent had successfully trained more than 2500 participants from the following companies:

Bank Negara Malaysia TMF Group
TESCO Malaysia Qatar Petrochemical Company Ltd.
Maybank ECC KAF Investment Bank Berhad
LB Aluminium Berhad Panasonic Electronic Devices Malaysia S/B
Nokia Siemen Network Royal Selangor Golf Club
ERIKS Sdn Bhd AVNET Malaysia Sdn Bhd
ThaiExpress Sdn Bhd The Venetian Macao-Resort-Hotel
Dentsu Sdn Bhd SOMFY Sdn Bhd
SGS Malaysia Sdn Bhd UOP Malaysia Sdn Bhd
SGS Labuan Kawan Food Berhad
DataStream Solution (Brunei) Sdn Bhd Faber Castell Sdn Bhd
Goodrich Global (KL) Sdn Bhd ELTETE Malaysia Sdn Bhd
MERGE Energy Berhad Puratos Malaysia
Syngenta PUMA
TAR University College Nitritex Malaysia Sdn Bhd
MediTech Media Barry Callebaut Malaysia Sdn Bhd
Telepaper (M) Sdn Bhd TJ/H2b Analytical Services, Inc
BP Asia Pacific (Malaysia) Sdn Bhd Recron (Malaysia) Sdn. Bhd.
Pamir Development Sdn Bhd, Johor AA Mewah Sdn Bhd
Sam McCoy Engineering Sdn. Bhd GODELL
TOTO Malaysia Sdn Bhd Branson Ultrasonics
Barry Callebaut Services Asia Pacific S/B Norgren Sdn Bhd

OR

SHIVONNE LOUIS

Shivonne Louis is qualified with a City and Guilds 746 & 747 Diploma in Computer Programming and has 24 years of training specializing in Microsoft Office and Lotus Applications as well as Lotus Notes End User programs. She completed the Microsoft Office 2000 User Specialist Examination (MOUS) in 2001. She has also completed the Microsoft Office XP (2002) and 2003 Specialist (MOS) Exams.

Working Experiences ….

  • 2000 – 2005 (COMAT Horizon Training Services)

Joined as a Corporate Trainer where she trained corporate clients from various industries in Microsoft Office, Lotus Applications and Lotus Notes End User programs.

  • 1996 – 1998 (SEC System Education Centre Sdn Bhd)

Was a Corporate Trainer/Consultant conducting training for corporate customers on Microsoft Office 97 and Lotus Smart Suite’97 applications. Create training manuals on Lotus Smart Suite’97 applications as well as provide hotline support.

  • 1991 – 1996 (Glass Onion Sdn Bhd)

Joined as a Corporate Trainer/Manager. Job description included responsible for the overall setting up of the training labs (software & hardware), create training manuals on all Microsoft Office applications, scheduling training date, administrative duties e.g. preparing quotations and Invoices, Conducted training for corporate clients from multi-national companies and banks.

Certification

Microsoft Office Specialist – MASTER (2000 & XP)

Courses certified (Office 2000, XP & 2003)

  • Microsoft Word Expert
  • Microsoft Excel Expert
  • Microsoft Power Point
  • Microsoft Access
  • Microsoft Outlook

Specialized in the following courses:

Microsoft Office 97 Microsoft Office 2000
Microsoft Office XP Microsoft Office 2003
Microsoft Office 2007 Microsoft Office 2010
Microsoft Outlook Microsoft Project
Microsoft FrontPage Microsoft Visio
Lotus Smart Suite Lotus Notes End-User
Dreamweaver MX Flash

KENT LAU

1. LB Aluminium Bhd
“Kent is an extraordinary trainer. He has helped us to train our staff to reduce data analysis time in HR department”

2. Nitritex (M) Sdn Bhd
“He also does the extra miles for us to make sure we can immediately apply the knowledge seamlessly”

3. Puratos (M) Sdn Bhd
“He ensures participants able to pick up the skills and encourages participants from time to time”