MICROSOFT ADVANCED EXCEL TRAINING WORKSHOP Johor Bahru

  • Location: Johor Bahru, Johor, Malaysia

Check with Advertiser

OBJECTIVE:

Understand how you can apply Advanced functions of Microsoft Excel to improve productivity, enhance spreadsheets with charts & formulas and streamline your work.

Learn how you can automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and 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 and executives who are seeking practical solutions to their Excel problems in raw data management, business analysis and reporting.

It is conducted based on business case studies with the aim of maximizing your benefits (e.g. productivity, report accuracy) in the use of Excel. Its purpose is to equip you with foundational skills and competence to explore Excel on your own.

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.



OUTCOMES:

- By the end of the course delegates will recognize areas where they could improve their own spreadsheet.

- They will be in a position to immediately apply the lessons learnt to their own models in their own environment.

- They will immediately to be able to save time on their everyday Excel tasks.




MICROSOFT ADVANCED EXCEL COURSE OUTLINE:

Working With Custom And Conditional Formats
- Creating Conditional Formatting

Using Formulas And Functions

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

Using Advanced Filter
- Filter Unique Record

Processing Data
- Data Tables

Consolidation Data
- Combine Data From Several Worksheets Into Master Worksheet

Conditional Logic And Functions Wizard
- Using IF Functions
- Using SumIF Functions
- 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

Creating Pivot Charts In Excel

Working With Worksheet Protection



Training detail:
Duration: 2 days
Training hour: 4 hours per day





Please set up an appointment for registration via phone contact at: +6 012 7461582

Send me a message More from ITTraining

Published date: February 11, 2020 Modified date: February 14, 2020

Related listings

  • Convert NSF to PST Software
    Convert NSF to PST Software
    SGD59

    Kuala Nerang Kedah - April 2, 2020

    Online Computer, Multimedia Classes NSF to PST converter tool has a best progressive feature which comforts you to export data from NSF file like calendar, ...
  • Convert OST file to PST
    Convert OST file to PST
    SGD10

    Gurun Kedah - March 14, 2020

    No need to worry just in case you have a corrupted OST file and want to convert into the PST file. I recommended you dow...
  • Computer Training Course In Johor Bahru - Part Time Intensive IT Short Courses
    Computer Training Course In Johor Bahru - Part Time Intensive IT Short Courses
    Check with Advertiser

    Johor Bahru Johor - February 11, 2020

    Courses Offered: BASIC COMPUTER APPLICATION COURSE BASIC MICROSOFT OFFICE SKILL TRAINING: (MS Word/ Excel/ PowerPoint) A...

Useful information

  • Avoid scams by acting locally, face-to-face
  • Never pay with any kind of Bank Transfer services
  • 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"
Top