Advanced Excel Course

Advanced Excel Course in Singapore

advanced excel course singapore

Advanced Excel Course in Singapore to learn advanced functions and formulas to accelarate and automate your work. This course will help you to learn charts, file and data protection, Macros function, automate regular tasks and many more.

Duration: 1 Day

Advanced Excel Course Outlines

Getting master with Charts in Excel

  • Creation & Formatting a Chart
  • Adding Labels
  • Playing the Chart Type & Data Source
  • Updating Data Source
  • Changing the Chart Location

Hands-on with Worksheet Protection

  • 1. How to protect your Worksheets
  • 2. Using Consolidated Worksheets
  • 3. Consolidating by Category
  • 4. Consolidating by Position
  • 5. Practice – Consolidating Worksheets
  • 6. Protecting range with password
  • 7. How to protect your Workbook
  • 8. How to protect your Excel Files

Hands-on with Macros in Excel 2013

  • Recording a Macro
  • Display the Developers Tab
  • Changing Macro Security Setting
  • Using a Macro Button
  • Creating a Macro Button
  • Copying a Macro Button
  • Formatting a Macro Button
  • Moving/Sizing a Macro Button
  • Deleting a Macro Button
  • Running a Macro
  • Deleting a Macro

Sharing Workbook using Excel 2013

  • Opening and Editing a Shared Workbook
  • Tracking Changes
  • Resolving Conflicts in a Shared Workbook
  • Managing Conflicting Changes
  • Resolving Conflicting Changes
  • Setting Change History Options
  • Adding a History Worksheet
  • Reviewing Tracked Changes

Hands-on with Pivot Tables in Excel 2013

  • Creating a PivotTable & Filter Pages Report
  • Adding PivotTable Report Fields
  • Updating a PivotTable Report
  • Selecting a Report Filter Field Item
  • Changing the Summary Function
  • Publishing PivotTable Reports to the Web
  • Moving PivotTable Report Fields
  • Using Expand and Collapse Buttons
  • Hiding/Unhiding PivotTable Report Items
  • Practice – Creating/Revising PivotTables
  • Introducing Slicers
  • Using Slicers to Filter Data
  • Deleting PivotTable Report Fields
  • Formatting a PivotTable Report

Excel is the most important tool for all professional. This Advanced Excel Course in Singapore is launched to spread knowledge of Advanced Excel functions and formulas such as Pivot Table, Extensive Charts, Macros, Working with multiple worksheets.

No matter on which position you are working, you must need Advanced Excel Training to increase your career growth.