Advanced Excel Training
Advanced Excel Training in Chennai, Mumbai, Bangalore,
Pune, Delhi, Hyderabad and Kolkata
Pune, Delhi, Hyderabad and Kolkata
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