Choose Your Career  

Is an IT career good for you..

Click Here...

To take a free demo session on selected course. Only registered candidate can available free demo class.

Advance Excel

About

Microsoft Excel is the industry standard spreadsheet program used for data calculations, analysis, visualization and much more. It can be programmed to access data from external databases and is an excellent tool for data modeling, statistics and financial calculations with built-in functions to quickly and easily perform common tasks. Proficiency in Excel is typically required for accounting, business analytics, and data analysis and statistics jobs.

Duration : 60 Hours

Basics of Excel

Data Formatting in Excel like colors, fonts, Bullets etc

Basic Sorting and Filtering

Basic Formulae like SUM, AVERAGE, COUNT, MAX, MIN etc

Spreadsheet Basics

Creating, Editing, saving and Printing spreadsheets

Getting Advance in excel

Sorting Data by values, colors, etc

Filtering by numbers, text , values , logical functions ,colors

Using Filters to Sort Data | Using Auto filter

Creating a custom AutoFilter

Advance Filtering Options

Custom and Conditional Formats

Creating a custom format

Create a custom number format

Conditional Formatting

Creating Conditional Formatting

Editing Conditional Formatting

Adding Conditional Formatting

Deleting Conditional Formatting from the selected range

Data Validation

Specifying a valid range of value of a cell

Specifying a valid value for a cell

Specifying custom validation based on formula for a cell

Working with Range Names

Using Range names

Creating range names

Using range names in formulas

Creating range names from headings

Deleting range names

 Using Formulas and Functions

Text Function | Logical Functions

Date and Time Functions | Information Function

Database Functions

Math and Trigonometry Functions

Statistical Functions

Lookup and reference functions

Absolute and Relative cell reference

Relative cell reference

Absolute cell reference

Excel Auditing Tool

Trace precedents | Remove arrows

Explore more in Excel

Freeze of windows

Splitting of Windows | Paste Special

Spark lines | Remove duplicates

Go to function tab | Data Reconciliation

Managing Tables

Creating Tables | Naming the Tables

Changing the Table style | Creating a total row

Creating a calculated column

Using Filtering in Table

Removing the duplicate record

 Getting data

Creating subtotal

Using Automatically Outline

Grouping Data Manually

Working with Charts

Creating a chart | Formatting a chart

Adding Labels | Data source

Changing the chart type

Working with Pivot Tables

Creating | Adding | Refreshing

Changing the summary functions

Creating report filter page

Working with Reports

Creating | Multiple Level subtotals

Creating | Formatting | customizing Pivot tables

Using advanced options of pivot table

Pivot charts

Consolidating data from multiple sheets and files

Using external data source

Using data consolidation feature to consolidate data

Show value as (% of Rows, % of columns, Running Total)

Viewing subtotal under pivot | Creating Slicers

Worksheet Protection

Protecting your work sheet

Protecting range with password

Protecting your Workbook and Excel Files

 Using Shared Work Books

Sharing | Opening and editing

Tracking changes | Resolving conflict

Multiple workbooks

Linking workbooks

Editing the Link

Consolidating the workbooks

What-IF Analysis

Goal Seek | Data Tables

Scenario Manager

Working with Macros

Display the developer Tab

Changing Macro security Settings

Recording and running a Macro

Career Guidence 



Quick Links

100 Feet Scheme Road, Tatabad Coimbatore - 641012

info@indrainstitute.com | enquiry@indrainstitute.com

9043119111

Follow Us


©2018 IIE. All Rights Reserved.

Powered by Clouddreams