Advanced Excel Training

Advanced Excel Training in Chennai, Mumbai, Bangalore,
Pune, Delhi, Hyderabad and Kolkata

[fc id=’3′][/fc]

1200px-microsoft_office_excel_2013present

Customized In-House Training program for Corporate, B-Schools across India & International

Excel is an essential tool for any business. Effective application of this powerful tool allows the users to compile and manipulate huge amount of data, deliver comprehensive results, and present complex information with ease.

Course Content

  • Intro Excel 2013
  • Auto Fill, Custom List & Fill Series
  • AutoComplete Option
  • Different methods of selecting Range
  • Useful Shortcuts
  • Special Formats – Numbers & Dates
  • Different File Format (XLS, XLSX, XLSM)
  • Insert, Delete & Rename Sheets
  • Copy and Move Sheets
  • Worksheet Groups
  • Using the Clipboard Group
  • Using Paste Special
  • Problems using Relative References
  • Using Absolute References
  • Using Mixed Reference
  • Basic IF statement
  • Nested IF statements
  • Combining IF with AND, OR, NOT
  • IFERROR & ISNA Function
  • UPPER(), LOWER(), PROPER()
  • LEFT(), RIGHT(), MID(); LEN()
  • TRIM(), SUBSTITUTE()
  • Join Cells using & (ampersand), CONCATENATE()
  • VLOOKUP – Exact Match
  • VLOOKUP – Approximate Match
  • HLOOKUP
  • Nested VLOOKUP
  • Tracing precedent & dependants
  • Display/Hide formulas
  • Error Checking
  • Evaluate Formulas
  • Fixing Formulas Errors
  • Worksheet linking
  • Workbook linking
  • COUNT(), COUNTA(), COUNTBLANK()
  • COUNTIF(), SUMIF(), AVERAGEIF()
  • COUNTIFS(), SUMIFS(), AVERAGEIFS()
  • PivotTable layout
  • Rearranging data
  • Filtering a report
  • Adding fields
  • Field settings
  • Refreshing data
  • Formatting a PivotTable
  • Showing detail
  • Create a calculated field
  • Advanced data field settings
  • Creating a PivotChart
  • Creating PivotChart Reports from scratch
  • Adding fields to a PivotChart
  • Creating a PivotChart
  • Creating PivotChart Reports from scratch
  • Adding fields to a PivotChart
  • Attaching a password
  • Modifying a password
  • Protecting cells/Range
  • Hide Formulas
  • Protecting Worksheet
  • Protecting Workbook
  • Printing
  • Importing CSV files
  • Text import wizard
  • Highlight & Remove Duplicate
  • Compare Reports
  • Converting Text to Number/Date
  • Find & Replace
  • Go To (Special) Options
  • Slicer
  • Spark Lines
  • Custom & Multiple Sort
  • Subtotals
  • Advanced Filtering
  • Create automatic Subtotals
  • Text to Columns
  • Use the Group and Outline feature
  • Cell Rules
  • Top-Bottom Rules
  • Data bars, Gradient fills, Icon sets
  • Managing multiple conditional formata
  • Limiting the range of values
  • Drop down lists
  • Error alerts
  • Limiting the range of values
  • Drop down lists
  • Error alerts
  • Choosing a specific format
  • Exporting to word
  • Pasting data with a link
  • Copying a graph with a link
  • Using Goal Seek

Why Choose Us

0 +

Industry Expert Trainer

0 +

Edu-aspirant

0 +

Branches

0 +

Award and Recognition

Our Clients

Call Us

+91 72991 00354
+91 80 720 78791
+91 44 4551 2828

Mail Us

info@excelprodigy.com

Visit us

109, Chowdri Nagar Main Road,
Valasaravakkam,
Chennai- 600 087

[fc id=’2′][/fc]