LEARN PIVOT TABLES,VLOOKUP,ADVANCED FUNCTIONS & NEW FEATURES OF MICROSOFT EXCEL 2013
—————————————————————————————————————————————————————————————
Course Duration for Microsoft Excel 2013 Training: 2 day
SDF Funding is available to Singapore Companies (For company sponsored candidates).
“The Pivot table Techniques alone are priceless!The Advanced Excel training will help me get my job done very quickly and easily.Manual steps that used to take hours will now take only a few minutes with the use of advanced formulas,macros and other tricks I learnt in the Excel 2013 workshop.Absolutely essential training for every corporate user.”
– Standard Chartered Bank
We also have Advanced Excel training on older versions of Microsoft like:
- Advanced Microsoft Excel 2007 Training
- Advanced Microsoft Excel 2010 Training
Course Objectives
✓ Participants will learn to use advanced functions of Excel ® 2013 to improve productivity,enhance spreedsheets with templates,charts,graphics,and formulas and steamline their operational work.
✓ They will apply visual elements and advanced formulas to a worksheet to display data in various formats with Pivot Tables,Conditional Formatting,Advanced Filtering, and Sorting operations.
✓ Students will also learn how to automate common tasks,apply advanced analysis techniques to more complex data sets,collaborate on woksheets with others,and leverage on Excel’s advanced functionality to simplify and streamline their day-to-day work.
After Advanced Excel Course Completion:
After the successfull completion of the Intermediate to Advanced Excel 2013 Training program,participants will be able to:
● calculate with advanced functions & formulas.
● organize worksheet and table data using multiple techniques.
● summarize information quickly using Pivot Tables, and generate Management Reports.
● create and modify charts & graphs.
● analyze data using Pivot Tables and Pivot Charts.
● insert graphic objects.
● customize and enhance workbooks and the Microsoft ® Office Excel ® 2013 environment.
They will now learn to deploy Advanced Excel 2013 techniques to increase productivity and improve efficiency by streamlining the workflow.
● collaborate with others using workbooks
● audit worksheets
● analyze data with Excel 2013
● create and modify charts & garphs
● work with multiple worksheets & workbooks using Microsoft Excel 2013
● Import and export data in Excel
● Use Advanced Filters in Excel 2013
● Introduction to Excel Macro Programming
They will now learn to deploy Advanced Excel 2013 techniques to increase productivity and improve efficiency by streamlining the workflow.
● collaborate with others using workbooks
● audit worksheets
● analyze data with Excel 2013
● create and modify charts & garphs
● work with multiple worksheets & workbooks using Microsoft Excel 2013
● Import and export data in Excel
● Use Advanced Filters in Excel 2013
● Introduction to Excel Macro Programming
Target Audience
cddcvdvdvvdvd
Course Outline
vxsdvsdv
How to Register
How to Register
Enquiry
LEARNING FOR LIFE
Get Learning for Life Newsletter for Useful Articles & Training Updates
WHY TRAINING WITH US?
✓ Certified Expert Trainers
✓ Printed Course Manual
✓ Certificate of Completion
✓ Small Class Sizes
✓ Hands-on Training Methods
✓ Fully Set-Up Computer Labs
✓ Free email Support
✓ Most VALUE for Money
✓ Centrally Located
Our Clients
