Courses

Programming & Multimedia Courses 10% Discount and 5% Discount on Office Skills Courses. Chinese New Year Offer ends on Feb 28, 2018 !!


More Info
MS Excel Advanced

courses

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

For alternate time slots, please call 63360244/96503505

Course Content

Module 1: Perform Calculations With Functions
  • Understand Functions, Understand the Components of a Function
  • Enter Functions in Worksheets, Type a Function Directly into a Cell
  • Use the AutoSum Drop-Down Menu Use the Insert Function Dialog Box
  • Nest One Function Inside Another Function, Date and Time Functions
  • Financial Functions
  • Logical Functions
  • Lookup and Reference Functions (V-Lookup and H-Lookup)
  • Mathematical Functions
  • Statistical Functions
  • Text Functions
  • Refer to Cells and Ranges in Formulas
  • Refer to Other Worksheets and Other Workbooks in Formulas
  • Use Range Names and Labels in Formulas
  • Troubleshoot Formulas
  • Understand and Fix Basic Errors in Formulas
Module 2: Sort And Filter Data With Excel
  • Sort, Perform a Quick Sort by a Single Field
  • Perform a Multi field Sort for Finer Sorting
  • Sort by a Custom Sort Order
  • Filter a to Find Records That Match Criteria
  • Perform Quick Filtering with AutoFilter Create Custom Filters
  • Using Advanced filter
Module 3: Create Effective Charts To Present Data Visually
  • Understand the Basics of Excel Charts
  • 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
Module 4: Working with Range Names
  • Using Range Names
  • Creating Range Names
  • Using Range Names in Formulas
  • Creating Range Names from Headings
  • Deleting Range Names
  • Creating 3-D Range Names
Module 5: Analyze Data Using Pivot Tables And Pivot Charts
  • Understand PivotTables
  • Create a PivotTable Framework Using the PivotTable and PivotChart Wizard
  • Create the PivotTable on the Framework
  • 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 6: Working with Multiple Workbooks
  • Linking Workbooks
  • Editing the Link
  • Consolidating Workbook & worksheets
Module 7: Protecting And Sharing The Work Book
  • Restrict Data and Protect Workbooks
  • Check Data Entry for Invalid Entries
  • Protect Cells, a Worksheet, or a Workbook
  • Protect a Workbook with Passwords
  • Work with Comments and Add a Comment to Cell
  • Display and Hide the Comments in a Worksheet
  • Edit and Format Comments, Delete a Comment
  • Insert Excel Objects in Word Documents
  • Insert a Chart in a Word Document
  • Insert Excel Objects in PowerPoint Presentations
  • Insert Word Objects in Worksheets
  • Insert PowerPoint Objects in Worksheets
Module 8: Use Macros To Automate Tasks
  • Display the Developers Tab
  • Changing Macro Security Setting
  • Running a Macro
  • Recording a Macro
  • Deleting a Macro
  • Assigning a Macro to an Object
Module 9: Proofing and Printing
  • Page setup, Setting print area, Print titles
  • Inserting custom Header and Footer
  • Inserting objects in the header and footer
  • Page Setup, Setting margins, Print Preview, Print
  • Enable back ground error checking
  • Setting AutoCorrect Options
  • Remove the appropriate check marks to disable any unwanted features

No data found

Course Name Duration Entry Requirement Fee (SGD)
MS Excel Advanced 15 hrs Basic Excel Knowledge S$320
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