Check with seller Intensive Microsoft Advanced Excel Training Johor Bahru

Published date: 19/07/2017
Modified date: 13/02/2020
  • Location: Johor Bahru, Johor, Malaysia


- Learn how apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, & leverage on Excel’s advanced functionality to simplify your day-to-day work.


- The Advanced Excel Training Workshop course is tailored for managers & executives who are seeking practical solutions to their Excel problems in raw data management, business analysis & reporting.

- All persons involved in using Excel to process large datasets, especially those received from other systems, and converting them into reports to be utilized in the business.


Working With Custom And Conditional Formats

Using Formulas And Functions

Sort And AutoFilter Data
- Creating Custom AutoFilter
- Filter For A Specific Date Range
- Filter For A Dynamic Data Range

Using Advanced Filter
- Filter Unique Record

Consolidation Data
- Combine Data In Excel

Conditional Logic And Functions Wizard
- Using IF Functions
- Using SumIF Functions

Lookup & References Formula
- Using VLookup Functions

Scenarios In Excel
- What If Analysis
- Create A Report From Scenario

Data Validation

Working With Multiple Worksheet
- File linking

Working With Pivot Tables In Excel

Working With Pivot Charts In Excel

Worksheet Protection & Security

Training detail:
Duration: 2 days

Venue: Johor Bahru

Should you have further enquiry regarding our course information, upcoming training schedule & time availability, please call or set up an appointment for registration via phone contact at:
+6 012 – 7461582

Copyright © 2020. All Right Reserved

IT Training
0 votes

Contact seller Share

Useful information

  • Avoid scams by acting locally or paying with PayPal
  • Never pay with Western Union, Moneygram or other anonymous payment services
  • Don't buy or sell outside of your country. Don't accept cashier cheques from outside your country
  • This site is never involved in any transaction, and does not handle payments, shipping, guarantee transactions, provide escrow services, or offer "buyer protection" or "seller certification"

Related listings

  • Adobe Training Course for Graphic Design (Photoshop & Illustrator)
    Adobe Training Course for Graphic Design (Photoshop & Illustrator)
    Computer - Multimedia Classes - Johor Bahru (Johor) - 19/07/2017 Check with seller

    INTERACTIVE GRAPHIC DESIGN SUITE TRAINING SHORT COURSE MODULES: • Adobe Photoshop (PSD) • Adobe Illustrator (AI) * - Photo Retouch & Editing Effect - Special Design Effect For Digital Graphic - Name Card Design - Logo Design - Leaflet & Broch...

    Computer - Multimedia Classes - Johor Bahru (Johor) - 02/07/2017 Check with seller

    Microsoft Office Package Suite: Microsoft Word - Word Processing 1: Managing Documents 2: Inserting Text and Graphics 3: Editing Content 4: Using Automated Tools 5: Formatting Paragraphs 6: Formatting Columns 7: Formatting Pages 8: Inserting Bullet a...

  • Pusat Latihan Komputer Johor Bahru - Kursus Komputer (Jangka Pendek)
    Pusat Latihan Komputer Johor Bahru - Kursus Komputer (Jangka Pendek)
    Computer - Multimedia Classes - Johor Bahru (Johor) - 02/07/2017 Check with seller

    Antara Senarai Kursus Komputer Yang Ditawarkan: KURSUS MICROSOFT OFFICE: Module 1: MICROSOFT WORD Module 2: MICROSOFT EXCEL Module 3: MICROSOFT POWER POINT (Pakej Yang Berkenaan Untuk Bidang Kerja Admin, Kerani,Data Entry, Documentation Clerk, Human ...