• ADVANCED EXCEL TRAINING IN JOHOR BAHRU

ADVANCED EXCEL TRAINING IN JOHOR BAHRU

Computer - Multimedia Classes

Check with seller

Add to watchlist
    City area: Nuasajaya City: Johor Bahru Region: Johor Country: Malaysia
August 31, 2017 September 7, 2017

INTENSIVE ADVANCED MICROSOFT EXCEL - TRAINING WORKSHOP


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 learn 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 CONTENT:


Working With Custom And Conditional Formats
- Creating Conditional Formatting
Using Formulas And Functions
Sort And AutoFilter Data
- Creating A 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 Duration: 4 days 


Training Venue:


130A, Jln Layang 16, Tmn Perling, 81200, JB 
(Upper Floor) (Next To C Wave Shipping Sdn Bhd)
(Same row With Petronas Station - Facing Nusajaya Iskandar Coastal Highway)


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




 


Copyright © Infomedia ComputerTraining Centre. All Rights Reserved.


All Intellectual properties not limited to patents, trademarks, industrial designs, copyrights, know-how including layout of images and contents contained herein belong to Infomedia Computer Training Centre. 

WARNING!
- Re-post our material on your website, facebook, twitter, instagram or blog are strictly prohibited!
- We will prosecute all internet theft of our copyrighted material


 


 


 


 


 


 

Vote
Result 10 votes
IT Training
0 votes
Share by email Share on Facebook Share on Twitter Share on Google+ Share on LinkedIn Pin on Pinterest
More information

    Enter the words above:
    Comments
      Leave your comment









      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"

      Top