Microsoft Excel 2016 Advanced
Print in

Objective:

Participants will learn more advanced feature of Microsoft Excel 2016. Participants must know basis function of Ms Excel 2013 or Excel 2016 before joining this course.

Course Outline

  • Creating and Using Functions
    • Round a Number
    • Create a Conditional Formula
    • Calculate a Conditional Sum
    • Vlookup and Hlookup
    • Perform Time Calculations
    • Perform Date Calculations
    • Using Text Functions
  • Organizing Worksheet Data
    • Filter Duplicate Records
    • Perform Simple Sorts and Filters
    • Perform Complex Sorts
    • Using a custom list
    • Sort by Cell Color, Font Color, or Icon
    • Perform Complex Filters
    • Subtotal Sorted Data
    • Database Functions
  • Analyzing Data Using a PivotTable or PivotChart
    • Creating a Pivot Table
    • Updating Pivot Table or Pivot Chart
    • Modify Pivot Table
    • Formatting Pivot Table
    • Creating A Pivot Chart
    • Creating Groups and Outlines
    • Converting Text to Columns
  • Sharing Workbook with Others
    • What is Data Validation?
    • When is data validation useful?
    • Data Validation messages
    • Creating Drop-Down List
    • Working with Comments
    • Track Changes
    • Protect Your Worksheets
    • Locking or Unlocking Worksheet Cells
    • Adding Security Encryption to a Workbook
    • Adding Password Protection to a Workbook
  • Automating with Macro
    • Introducing Macros
    • Setting Macro Security Options
    • Recording a Macro
    • Run a Macro
    • Saving a Workbook with Macros
    • Opening a Workbook with Macros
    • Assign a Macro to the Quick Access Toolbar
  • Useful Data Analysis Tools and Techniques
    • Optimize result with Goal Seek
    • Using the Solver
    • Solve a Formula with a Data Table
    • Consolidate Data
    • Conditional Formatting Your Worksheet

For individial, you may submit your claim via http://www.skillsfuture.sg/credit.

Register online @ http://one.pa.gov.sg

SDF Applicant, please register @ https://www.skillsconnect.gov.sg

IT Centre reserves the right to reschedule the course without prior notice due to class size or unforeseen circumstances.