Looking for a corporate training provider? Know more about the IT training courses in aptech hazra      100% job assured course for unplaced Engineer / MCA ! Know more about the IT training courses      Join Advance Networking- CCNA, RHCA, Learn with PHYSICAL ROUTER & SWITCHES! Know more about the IT training courses      Are You interested in Cabin Crew Training! Know more about aviation      introducing a path breaking FA courses Know more about aviation

Behala : 9330148679/033-24460725  |  Hazra : 033-24754424/033-40731111/9339408422   |  Budge Budge : 9804084486/033-24701025 icap


Advanced Excel

Learn basics of Advanced Excel

Advanced Microsoft Excel

Course Details

Sharing and Maintaining Workbook
  • Explain the new features of MS Excel 2013
  • Explain customization of the Ribbon and the Quick Access Toolbar
  • Explain the procedure to add data by using FlashFill, AutoFill, and AutoComplete
  • Explain proofing and management of Add-ins
  • Describe built-in and custom templates in Excel
  • Describe worksheet protection and locking/unlocking of cells
  • Explain protection, finalization, and encryption of a workbook
  • Explain the concept of shared workbooks
  • Explain the procedure for change tracking in a shared workbook
  • Explain the process of recovering unsaved versions of a file

Formulas and Functions
  • Trace formula precedents and dependents
  • Use the data validation tool and check for errors in a file
  • Implement iterative calculations
  • Use single cell and multi cell array formula
  • Use SUMIFS(), COUNTIFS(), and basic counting functions
  • Describe the Quick Analysis Tool for Data Analysis
  • Describe Data consolidation
  • Describe mathematical, trigonometry, statistical, and financial functions , Date, Time, Data Type and Conversion Functions
  • Describe Text, Logical, and LookUp functions
  • Conditional Formatting
Advanced Chart Features
  • Explain the importance of chart and the different types of chart
  • Explain Recommended Charts
  • Explain modification of chart elements, chart area, plot area, and chart axes
  • Describe formatting of chart title, legend, and gridlines
  • Explain trendline and data series
  • Explain dual axes and chart templates
  • Describe combination chart, error bars, and data tables
Presenting Data Visually
  • Explain conditional formatting
  • Explain Sparklines and list the steps to create it
  • Describe the importance of Pivot Table and its various features
  • Describe the procedure to create recommended PivotTables
  • Explain the concept of PivotCharts and list the steps to customize it
  • Explain slicers and list the steps to create it
  • Describe the procedure to use Power View
Data Analysis
  • Explain Analysis ToolPak
  • Explain single factor and two factor tool with and without replication
  • Describe Correlation and Covariance
  • Explain F-Test two-sample for variances
  • Describe Histogram and moving average
  • Explain Random number generation
  • Describe Regression, Sampling, Rank, and Percentile
  • Describe Exponential Smoothing
Macros and Forms
  • Describe Automatic Data Processing
  • Explain creation and running a macro
  • Explain assigning macro to a command button
  • Explain creation of a custom macro button on the Quick Access Toolbar
  • Describe macro security
  • Describe Macro Add-ins
  • Describe Form controls
  • Use of Solver, Subtotal, Goal Seek, Scenario
  • Describe the procedure to import and export XML data with Excel

Request a Call Back


Advanced Excel is a 1-2 month course


Basic MS Excel knowledge

Exit Profile

The individual will be competent in Advanced Microsoft Office -(Advanced Microsoft Excel)


Fill the enquiry form to get a call from our career counsellors.

Our Partners

Best computer training school in kolkata
Grade A certified institute in kolkata free counter

Aptech Behala
738,D.H.Road, 2nd Floor,
Kolkata -700008,
Above UBI Bank


Aptech Hazra
128/15, Hazra Road
Kolkata - 700025
Behind Ashutosh College


Aptech Budge Budge
74/A, D.P.J.M Road,
Kolkata -700137,
Above UCO Bank
033-24701025/ 9804084486