Courses

Special Discount of 5% For Selected Courses!  Offer is Valid Till 17 August 2020! *T & C Apply!

More Info
MS Excel Advanced

courses

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

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$450
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