Corporate Training
Project Training
Thank you so much Mr Raju. 2 Days of Class is super, worth it! Learned so much in a super short period of time. ...
AUTO CAD 3D COURSE SCHEDULE ON DEC 19TH TO DEC 24TH 2024 ( EVENING CLASSES)
MS EXCEL ADVANCE CLASSES SCHEDULE ON JAN 6TH AND JAN 7TH OF 2025
More Info
MS Excel Advanced
| Course Name | Duration | Entry Requirement | Fee (SGD) |
|---|---|---|---|
| MS Excel Advanced | 15 hrs | Basic Excel Knowledge | S$499 |
For alternate time slots, please call 63360244/96503505
Course Content
Module 1: Calculations With Functions
- Setting up your own formula
- Calculations between worksheets
- Mathematical Functions
- Statistical Functions
- Text Functions
- Logical IF Function
- Logical functions with multiple conditions
- Lookup Functions (V-Lookup and H-Lookup)
- Using range names in formulas
- Conditional summary function
- Countif, Sumif, Averageif functions
Module 2: Create Effective Charts To Present
Data Visually
Data Visually
- Create a Chart with the Chart Wizard
- Choose the Right Type of Chart for Your Data
- Use the Chart Toolbar, Select Objects in a Chart
- Configure Chart Options, Change the Chart Type
- Change a Chart's Source Data
- Change the Format, the Chart Area, Plot area
- Configure and Change the Scale of an Axis
- Liven Up Charts with Patterns, Fills, and Pictures
- Format Individual Chart Elements, Print Charts
- Editing Chart data series, Advanced Chart options
Module 3: Analyze Data Using PivotTables
And Pivot Charts
And Pivot Charts
- Understand PivotTables
- Create a PivotTable Framework
- Using the PivotTable and PivotChart Wizard
- Create the PivotTable on the Framework
- Grouping and Ungrouping Data
- Choose PivotTable Options to Configure a PivotTable
- Create Pivot Charts from PivotTables
- Create a Conventional Chart from PivotTable Data
- Creating Calculated fields, Inserting Slicer
Module 4: More Excel Functions
- Automatic Rounding of Long Numbers
- Round Function
- Round Down Function
- Round Up Function
- Excel Text Functions
- Using Excel TEXT with other functions
- Separate Strings, Logical functions
- AND function, OR Function
- Combining logical functions with other functions
Module 5: Index & Match functions
- Index Function,Match Function
- Combination of Index and Match Function
- VLOOKUP and match formulas in excel
- Indirect & Offset functions
- Using dynamic lookup tables
- Using range names.
- Applying range names in formulas.
Module 6: Financial Functions
- Financial Function
- PMT,IPMT,PPMT,RATE, NPER
- Calculating Present Value(PV)
- Calculating Future Value(FV)
- Loan Amortization Schedule.
Module 7: Excel Data Tools
- Data Validation,Circle Invalid Data
- Clear Validation Circles
- Excel Goal seek function
- Data Table,Group, Outline
- Ungroup, Clear outlineSorting
- Using Subtotal, Removing subtotals
- Advanced filtering
Module 8: Informative functions
- Informative functions,Iferror, Iserror
- Isn, Isnumber, Istext, Isblank
- Combinations of informative functions with other Functions
Module 9: Excel Dashboard
- Dashboard Design Tips
- Visual Dashboarding Techniques
- Data Sources
- Interactivity with Slicers
- Build a Sales Dashboard
Module 10: Recording & Editing Macros
- Writing a New Macro, Recording Macro
- Running a Macro, Using a Shortcut Key
- Using the Visual Basic Toolbar
- Using the Visual Basic Editor Window
- Assigning a Shortcut Key
- Using Relative References
- Assigning a Macro to a Menu
- Deleting a Macro from a Menu
- Deleting a Macro from work book
- Editing Macro Commands
- Creating a Custom Button
- Adding a Button to Quick Access Toolbar
- Assigning a Macro to a Button
- Changing a Button Image
No data found
| Course Name | Duration | Entry Requirement | Fee (SGD) |
|---|---|---|---|
| MS Excel Advanced | 15 hrs | Basic Excel Knowledge | S$499 |
| Time Slot | |||
| Please call 63360244/96503505 or mail to info.sg@gteceducation.com We also provides flexible timing to meet the customer's requirement |
|||
Request For Brochure
Frequently asked questions
No data found
