Advanced Excel Course

Microsoft Excel is one of the productivity tools for excellence at work. provides powerful tools to help you build, organize, share and analyze huge amounts of data. You and your team can work smarter, faster, and more accurately. Whatever data you are working on, Microsoft Excel helps organize it so that it's easily accessible and readily understandable. It gives you the capability to quickly analyze details and uncover critical relationships. This Training is entirely 'hands on', so those attending will get practice using practical examples.

Collecting, Organizing and summarizing Data-Introduction
  • Sources of Data
  • Challenges in Data Standardization
  • Organizing and Standardizing Data
  • Excel Tools to Standardize Data
  • Summarizing Data
  • Dynamic Reports Using Formulas
  • Tools and Tricks
Collecting, Organizing and Summarizing Data- Pivot Table
  • Introduction to PrivotTables and PivotCharts
  • Interactive Reporting Using PivotTable
  • Dragging and Dropping Data Elements
  • Adding One Column Multiple Time
  • Digging your Summary at the Last Level
  • Using Calculations in your PivotTable
  • Charting your data using PivotChart tools
  • Tools and Tricks
Designing Custom Automatic Reports
  • Working with Databases
  • Data and Reporting Separation concept
  • Analyzing data against your desired criteria
  • Consolidation of data from Different Workbooks
  • Database Functions
  • Tools and Tricks
Creating Powerful Formulas
  • Logical Functions
  • Lookup Functions
  • Count Functions
  • Date and Time Functions
  • Financial Functions
  • Tools and Tricks
Using Controls and Formula Auditing
  • Using Range Names
  • Formula Auditing
  • Using Controls
  • Combo Box, List Box
  • Scroll Bar, Spinner, Option Button
  • Tools and Tricks
Designing Custom Automatic Reports
  • Working with Databases
  • Data and Reporting Separation concept
  • Analyzing data against your desired criteria
  • Consolidation of data from Different Workbooks
  • Database Functions
  • Tools and Tricks
Getting Visual
  • Working with Charts
  • Formatting and Chart Types
  • Time Series and Categories
  • Components and other Charts
  • Advanced Types
  • Tools and Tricks
What if Tools, Security, Conditional Formatting
  • Data Table and Scenario Manager
  • Goal Seek and Solver
  • Security Different Options
  • Conditional Formatting
  • Using Group and Outline
  • Tools and Tricks

About Us

We are a training company that has expertise in providing trainings services:

   Online

   In-house

   One to One

We strongly believe in excellence.

Get in touch



Ali Asjad Trainings
86-C PCSIR Staff Cooperative Housing Society,
College Road, Lahore