Courses

Until June 1, 2020, all training is provided through Online Live Interactive Classes

More Info
MS Excel Advanced

courses

Course Name Duration Entry Requirement Fee (SGD)
MS Excel Advanced 15 hrs Basic Excel Knowledge S$395

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
  • 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
  • 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$395
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

Captcha

Frequently asked questions

No data found