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

ADVANCED EXCEL TRAINING:

OBJECTIVE:
- 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.


WHO SHOULD ATTEND:

- 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.



TRAINING OUTLINE:

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...

  • MICROSOFT OFFICE APPLICATION TRAINING PROGRAM
    MICROSOFT OFFICE APPLICATION TRAINING PROGRAM
    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 ...