Course Objective | Project Outline | Target Audience
Advanced Excel Course Objective
Advanced Excel Course includes all Features, Functions and Formulas of Microsoft Excel . This Advanced Excel Training help participants to learn Pivot Table, VLookup, Hlook up, Filtering Data using Functions, Exporting and importing data, Basic Macros and many more tricks in Microsoft Excel. This is a hands-on Advanced excel training where you will be working on live exercises of each topic.
Duration: 2 Days Advanced Excel Course
- One Time Free Refresh Class in 6 Month
- SkillsFuture Approved Course
- Hands-On Exercises
- Attention to each participants
- Interactive Class
- Step-By-Step Course
- 100% Satisfactory Record
- Trained more than 10000 Participants
- 10 Year Experienced Trainer
- ACTA & Microsoft Certified Trainer
SkillsFuture Claimable Course
Target Audience For Advance Excel Course
This Advanced Excel training course is highly recommended for all, who use Microsoft Excel in their day routine job and want to enhance the skills to get more productivity. This course recommended to all the job like Admin, clerk, analyst, data interpreter, who work to accumulate data and get report with more advanced functions of Excel to become more productive and make the most of Excel.
Be prepared to do a lot of Exercises, to learn the concepts and techniques of Microsoft Excel.
Advanced Excel functions and formulas
- Logical functions
- Conditional functions
- Financial functions
- Text functions
- Date functions
- Array formulas
PivotTables and PivotCharts
- Working with Pivot Tables
- Rearranging Pivot Tables
- Formatting Pivot Tables
- PivotCharts
Lookups and data tables
- Using lookup functions
- Using MATCH and INDEX
- Creating data tables
Exporting and importing data
- Exporting and importing text files
- Getting external data
Analytical tools
- Goal Seek
- Scenarios
Advanced data management
- Validating cell entries
- Advanced filtering
Macros and Visual Basic
- Running and recording a macro
- Working with VBA code
Advanced charting
- Chart formatting options
- Combination charts
- Graphical objects
Accessibility and language features
- Accessibility consideration
- Internationalization
Call us at +65 92705162 or email us at [email protected]