study overseas chennai +91 - 44 - 42115338
+91 - 9884987719 (Adyar)
+91 - 7550245795 (Velachery)
it training institutes in chennai job openings in chennai
Intermediate Excel 2010 Training

Intermediate Excel 2010

Training Name

:

Intermediate Excel 2010

Description

:

This course is meant for those desiring to gain advanced skill sets necessary for calculating data using functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks.

Weekend Batch

:

Available

Training Time

:

8 hrs per day (Sat & Sun)

Duration

:

16hrs

Venue

:

HB Educational Services, 39/40, 1st Main Road, Gandhi Nagar, Adyar, Chennai-20HB Educational Services, 2/189, 2nd Floor,100 Feet Road, Vijayanagar, Velachery, Chennai-42

Target Audience

Any persons with basic Excel knowledge

Training Overview

You will use advanced 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.

Training Content

Creating and Editing Formulae

  • Concept of Formulae
  • Creating Formulae, Editing Formulae
  • Mathematical Order
  • Copying Formulae
  • Using Functions - Sum, Average, Max, Min, Count, Counta
  • Applying Absolute (Fixed) Referencing

Formatting and Proofing

  • Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
  • Basic conditional formatting
  • Copying and Clearing Formats
  • Working with Styles
  • Spell Check, Find & Replace and AutoCorrect

Range Names

  • Concept and Purpose
  • Naming individual or range cells
  • Deleting and amending named ranges
  • Using named cells/ranges in formulae

Conditional Functions & Formats and Date Calculations

  • Benefits and purpose
  • If Statements, Nested If
  • And, Or, Not
  • Combining If, And, Or, Not
  • Sumif, Countif
  • Conditional Formatting
  • Entering Dates and Times
  • Different date/time formats
  • How dates are stored
  • Calculating working days
  • Using the DAY(), MONTH(), YEAR() functions

Formulae Auditing

  • Formula Auditing Tools
  • Revealing Formulae
  • Tracing Precedents/Dependents
  • Goto Special

Worksheet Management & Linking

  • Linking sheets in the same file
  • Linking different Excel files
  • Using Edit, Links
  • Viewing different files at once
  • Saving a workspace
  • Viewing different sheets at once
  • Window Split
  • Data consolidation

Basic List Management

  • Sorting Data
  • Adding Subtotals
  • Autofilter
  • Freeze Panes
  • Group and Outline
  • Data Form

Excel Charts / Graphs

  • Using the Chart Wizard
  • Editing and Formatting charts
  • Saving custom chart types
  • Setting a default chart type

Lookup & Information Functions

  • Vertical Lookup (Vlookup)
  • Horizontal Lookup (Hlookup)
  • Match and Index
  • IsText, IsValue, IsDate, IsNull, IsErr, IsError, IsNa

Advanced List Management

  • Advanced Filters
  • Using List Features
  • Dynamic Lists

Pivot Tables

  • Using the Pivot Table Wizard
  • Changing the pivot table layout
  • Formatting
  • Grouping items
  • Inserting calculated fields
  • Pivot Table Options
  • Display and hide data in fields
  • Lay out reports directly on worksheet
  • Pivot Chart

What If Analysis

  • Scenarios
  • Goal Seek
  • Solver

Protecting & Sharing Files

  • Sharing a file
  • Tracking changes
  • Protecting file
  • Accepting or rejecting changes
  • Applying Data validation rules
  • Inserting comments

Pre-Requisites

:

Basic Excel

Participant Fee

:

On Request

Please reach our Adyar Center @ +91-44-42115338, or 91-9884987719 (Whatsapp & Call Support)

Please reach our Velachery Center @ +91-7550245795 (Whatsapp & Call Support)

Live Chat Business

_+

Live Chat Business