Advanced Excel Course in Singapore

Advanced Excel Course Singapore

Duration: 2 Days Advanced Excel 2010 Course

  • One Time Free Refresh Class in 6 Month
  • SkillsFuture Approved Course
  • Hands-On Exercises
  • Attention to each participants
  • Interactive Class
  • Step-By-Step Course
  • 100% Satisfactory Record
  • Trained more than 10000 Participants
  • 10 Year Experienced Trainer
  • ACTA & Microsoft Certified Trainer

SkillsFuture Claimable Course

2 Days Advanced Excel Course in Singapore, Claim Your SkillsFuture Credit. Singaporeans No Need to pay the upfront Fees. Inspizone is a best Training Center in Singapore. In this Advanced Excel training course you will learn formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.

Target Student: Those who want to be perfect with MS Excel advanced skill sets necessary for reports or calculating data using functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks.

Prerequisites: Participant should have basic Knowledge of Excel.

Course Objectives

After completing this Advanced Excel course, you will be able to:

  • familiar with advanced formulas of Excel.
  • able to organize & customize worksheet and table data using various techniques.
  • analyze data using PivotTables, Slicers, and PivotCharts.
  • able to create and modify charts in Excel.
  • insert and modify graphic objects in a worksheet.
  • customize and enhance workbooks and the Microsoft Office Excel environment.

Advanced Excel Course Outline

Lesson 1: Calculating Data with Advanced Formulas

  • Apply Cell and Range Names
  • Calculate Data Across Worksheets
  • Use Specialized Functions
  • Analyze Data with Logical and Lookup Functions

Lesson 2: Organizing Worksheet and Table Data

  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Data
  • Use Functions to Calculate Data

Lesson 3: Presenting Data Using Charts

  • Create a Chart
  • Modify Charts
  • Format Charts

Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts

  • Create a PivotTable Report
  • Filter Data Using Slicers
  • Analyze Data Using PivotCharts

Lesson 5: Inserting Graphic Objects

  • Insert and Modify Pictures and ClipArt
  • Draw and Modify Shapes
  • Illustrate Workflow Using SmartArt Graphics
  • Layer and Group Graphic Objects

Lesson 6: Customizing and Enhancing the Excel Environment

  • Customize the Excel Environment
  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates

Lesson 7: Streamlining Workflow

  • Update Workbook Properties
  • Create a Macro
  • Edit a Macro
  • Apply Conditional Formatting
  • Add Data Validation Criteria

Lesson 8: Collaborating with Other Users

  • Protect Files
  • Share a Workbook
  • Set Revision Tracking
  • Review Tracked Revisions
  • Merge Workbooks
  • Administer Digital Signatures
  • Restrict Document Access

Lesson 9: Auditing Worksheets

  • Trace Cells
  • Troubleshoot Invalid Data and Formula Errors
  • Watch and Evaluate Formulas
  • Create a Data List Outline

Lesson 10: Analyzing Data

  • Create a Trendline
  • Create Sparklines
  • Create Scenarios
  • Perform a What-If Analysis
  • Perform a Statistical Analysis with the Analysis ToolPak

Lesson 11: Working with Multiple Workbooks

  • Create a Workspace
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Edit Links

Lesson 12: Importing and Exporting Data

  • Export Excel Data
  • Import a Delimited Text File
  • Import and Export XML Data

Lesson 13: Integrating Excel Data with the Web

  • Publish a Worksheet to the Web
  • Import Data from the Web
  • Create a Web Query