Advanced Microsoft Excel 2010

Excel 2010 Advanced Training Singapore

Advanced Microsoft Excel 2010 Course Singapore

Advanced Excel 2010 Course Objective: –
Click Here to Register

  • Our Advanced Excel 2010 Training Course is an interactive hands-on program.
  • We train participants step by step, from basic to advanced level functions of Excel.
  • It 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 2010 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
  • Deep knowledge to manage report, filter data 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 2010Expert 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.

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.

Enhance your skills on Microsoft Excel 2010 Course with hands-on training delivered by certified Microsoft trainers.

Who should learn Excel 2010 Advanced Training Course?

This course is meant for participants who would like to be told the fundamental operations of the Microsoft Word to perform their regular responsibilities, and who wish to use the application to be more productive in their work.

  • IT professionals
  • Business analysts
  • Project managers
  • Business owners and entrepreneurs

Prerequisites

  • Basic computer Skills and knowledge

Duration: 2 Days

Venue: 10 Anson Road, 26-08A International Plaza, Tanjong Pagar

Microsoft Excel 2010 Training Advanced 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 Your Seat Buy Now

Our Clients