Advanced Microsoft Excel 2010

Advanced Microsoft Excel 2010 Course in Singapore

Advanced Excel Course Objective:-

Our Advanced Excel Training Course is an interactive hands-on program. We train participants step by step, from basic to advanced level functions of Excel. This Advanced Excel Course includes all essential skills like cell formatting, creating pivot tables, Macros, Templates, and using what-if equations plus explore how to visually represent data with charts and graphs, and even best practices for sharing your data on the web.

Advanced Excel Training participant will get:

  • 100% confidence over Excel
  • know tips and tricks of Excel
  • how to minimize extra work using automated regular daily tasks using advanced functions
  • in-depth knowledge to manage, filter and generate reports from Excel database
  • right use advanced functions of Excel 2010 to increase productivity
  • knowledge Augment data in spreadsheets using Pivot Table, Macros, templates, charts, graphics, and formulas and be work efficient.
Microsoft Excel 2010 – Expert Level is for participants who want to add more sophistication and automation to excel gain a solid understanding of advanced features of spreadsheets and attain expertise in complex operations.

Duration: 2 Days

Inspizone’s Advanced Excel Course is intended for current Microsoft Excel users who wish to deal with workbook and productivity features. It includes areas such as creating Complex Charts, Pivot Table, worksheet consolidation and linking with external data file, data analysis tools, and automating workbook operations using macros. Click Here to Register

Advanced Microsoft Excel 2010 Course Outline

How to do Custom & Conditional Formats in Excel 2010

  • Working with Custom Format
  • Creating and editing Conditional Formatting in Excel 2010
  • Working with Templates
  • Deleting Conditional Formatting from the Selected Range

Hands-on with Pivot Tables in Excel 2010

  • 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

How to use Advanced Formulas & Functions in Excel 2010

  • Working with Cell Reference and Absolute Cell Reference
  • Working by using Functions like Text, Left, Upper, Date, Today, Sum Function
  • How to Concatenate the text values
  • Calculating using Functions
  • Working with IF function
  • Using Logical Functions
  • Using the Vlookup and Hlookup Functions

Sharing Workbook using Excel 2010

  • 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

Working with Range Names in MS Excel 2010

  • How to create, delete & use Range Names
  • How to use Range Names in Heading & Formulas
  • Working 3-D Range Names
  • Modifying Range Names
  • Calculate data across worksheets

Hands-on with Worksheet Protection

  • How to protect your Worksheets
  • Using Consolidated Worksheets
  • Consolidating by Category
  • Consolidating by Position
  • Practice – Consolidating Worksheets
  • Protecting range with password
  • How to protect your Workbook
  • How to protect your Excel Files

How to do data Sorting and Filtering in Excel 2010

  • Using Filter, Advance Filter
  • Using Database function
  • How to Sort Data
  • How to AutoFilter
  • Creating a Custom AutoFilter
  • Using Advanced Filter
  • Using Database Functions

Hands-on with Macros in Excel 2010

  • 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

Fetch result from your data

  • Creating Subtotal
  • Using Automatic Outline
  • Grouping Data Manually
  • Using Data Validation

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

Click Here to Pay Course Fee & Reserve Seat Buy Now

Our Clients