Intermediate Excel Training Course Singapore | Skillsfuture Eligible
Details
Intermediate Excel Training Course Singapore is a 1-day training focusing on Advanced Features, Functions and Commonly Used Formulas of Microsoft Excel.
Specifically, this Intermediate Excel Training help participants to learn Pivot Table, Chart, Sorting and Filtering Data as well as using Functions.
Learn Formulas, Function, Validations, Forms & Controls and many advanced features of Excel in our Intermediate Excel Course.
After completing this Intermediate Excel Courses, participants will have learned to:
- Creating Advanced Formulas
- Advanced Charting Techniques
- Automating Workbook Functionality
- Analyzing Data with PivotTables, Slicers, and PivotCharts
- Applying Conditional Logic
- Visualizing Data with Basic Charts
Outline
- Use Range Names in Formulas
- Use Specialized Functions
- Apply Data Validation
- Work with Forms and Controls
- Use Lookup Functions
- Combine Functions
- Create Charts
- Modify and Format Charts
- Use Advanced Chart Features
- Create Sparklines
- Create a PivotTable
- Analyze PivotTable Data
- Present Data with PivotCharts
- Filter Data by Using Slicers
Schedules
Thu | 09:00 AM — 06:00 PM |
No. of Days: | 1 |
No. of Participants: | 15 |
Excel Training is intended for current Microsoft Excel users who wish to deal with workbook and productivity features. It includes areas such as creating Complex Charts, Pivot Table, worksheet consolidation and linking with external data file, data analysis tools, and automating workbook operations using macros.
We have massive length of Excel courses to develop and improve your skills: Some are:
Microsoft Excel Course, Master Excel, Basic Excel, Intermediate & Advanced Excel and Many More..
Visit us - http://exceltraining.com.sg/