Advance Excel

Gathering and processing data for reports

• Arranging data in Tabular Form

  • Sorting

  • Custom Sorting

  • Filtering

  • Custom Filtering

  • Grouping and ungrouping data

• Formatting Data

  • Basic formating

  • Conditional Formating

  • Data validations

• ​​​​​​​Cell Referencing (Relative, Absolute, Mixed, 3D)

  • ​​​​​​​Defining cell names

  • VLookup

  • HLookup

• Performing Basic Calculation

• Performing Financial Calculation

Summarizing Data

• Creating Graphs of various types

• Customizing Graphs

• Pivot Table

• Pivot Chart

• Sparkline feature

• Trendline in graph

Analysing Data for making Decision

What-if Analysis

• Goal Seek

• Senario

• Solver

Exchanging Data between various Data Sources

• Importing data from Text files

• Importing data from Internet

• Importing data from different databases

• Exporting data in text format

• Publishing data in Internet

• Preparing data in PDF format

• Transfering Data to Powerpoint

Collaborating with other Users

• Protecting Information with password

• Sharing data

• Track Changes

• Compare and Merge data

Automating Business Operations

• Use of Macros

• Using VBA Codes

• Create VB  Forms