Summer training for engineering students! Admission open for IT training in kolkata      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

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


ACCP-PRO

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

COURSE DURATION

Advanced Excel is a 1-2 month course

ELIGIBILITY

Basic MS Excel knowledge

Exit Profile

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


INTERESTED TO JOIN IN ADVANCED MS 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 Counter for Website hit

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

/ APTECH BEHALA

Aptech Hazra
96L, S.P.Mukherjee Road,1st Floor,
Kolkata-700026,
Near Jatin Das Metro
033-40731111/9339408422

/ APTECH HAZRA

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

/ APTECH BUDGEBUDGE