<

About Advanced Excel Training

By the end of this Advanced Excel Training participants should be able to: Use outlines, range names, databases & the data form Use AutoFilter & advanced filters Work with Data Series Use advanced functions Modify charts Use Scenarios & Goal Seek Use templates, data tables & solve problems Use automatic formatting & styles Work with views, consolidate worksheets Create & revise PivotTables Use, record & edit macros


Advanced Excel Training Highlights

Course Duration

1 Month

Learners

50000

Delivery Mode

Classroom Training

Apply Online

Click Now

WHO WILL BENEFIT

Project Managers 80%
Students 70%
Developers 40%
Financial Analyst 50%
ERP Specialist 80%
Data Analyst 70%
Data Miners 40%

Advanced Excel Training Course Curriculum

1. Working with Outlines

  • Apply an Outline
  • Collapse/Expand an Outline,
  • Modify Outline Settings,
  • Clear an Outline,
  • Use Auto Outline,
  • Create Subtotals in a List,
  • Remove Subtotals from a List

2. Using Multiple Workbooks

  • Open and Arrange Multiple Workbooks
  • Save a Workspace, Create and Maintain Links

3. Using Range Names

  • Jump to a Named Range, Assign Names
  • Use Range Names in Formulas
  • Create Range Names from Headings
  • Apply Range Names
  • Delete Range Names
  • Use Range Names in 3-D Formulas
  • Create 3-D Range Names
  • Use 3-D Range Names in Formulas

4. Working with Tables

  • Use Tables, Create a Table from Existing Data
  • Change the Table Name, Change the Table Style
  • Change Table Style Options, Create a Total Row,
  • Add Table Rows and Columns, Insert/Delete Table Rows/Columns,
  • Create a Calculated Column, Select Parts of a Table,
  • Move a Table, Sort Data by Multiple Levels, Use Text Filters,
  • Use Number Filters, Use Data Validation, Validate Data using a List,
  • Create a Custom Error Message, Remove Data Validation
Feature Image
5. Working with Advanced Filters
  • Create a Criteria Range
  • Use a Criteria Range
  • Show All Records
  • Use Comparison Criteria
  • Use an Advanced And Condition
  • Use an Advanced Or Condition
  • Copy Filtered Records
  • Use Database Functions
  • Find Unique Records
  • Remove Duplicates from a Table
6. Using Advanced Functions
  • Use the VLOOKUP and HLOOKUP Function
  • Use the IF Function and Nested IF Function
  • Use the ISERROR Function, Use an AND Condition with IF
  • Use an OR Condition with IF
  • Use the ROUND Function
  • Limit the Precision of Numbers
  •  
  •  
  •  
7. Using Advanced Functions
  • Using the VLOOKUP & HLOOKUP Function
  • Using the IF Function & Nested IF Function
  • Using the ISERROR Function
  • Using an 'AND' Condition with IF
  • Using an 'OR' Condition with IF
  •  
  •  
  •  
  •  
  •  
Feature Image

8. Advanced Charting

  • Add, Remove and Format Gridlines
  • Format an Axis
  • Change the Axis Scale
  • Format the Data Series
  • Add Data - Different Worksheets
  • Use a Secondary Axis
  • Change Data Series Chart Types
  • Add a Trendline
  • Create User-defined Charts
  • Create
  • Customise
  • Remove Sparklines
9. Using Templates
  • Save a Workbook as a Template
  • Use a Template
  • Edit a Template
  • Delete a Template
  • Create Default Templates
10. Using Auditing Tools
  • Display the Formula Auditing Toolbar
  • Display/Remove Dependent and Precedent Arrows
  • Remove Tracer Arrows
  • Use Auditing Tools Buttons
11. Using Scenarios & Goal Seeking
  • Use the Scenario Manager
  • Create
  • Display and Edit a Scenario
  • Create a Scenario Summary Report
  • Use Goal Seek

12. Solving Problems

  • Use Solver
  • Save a Solution as a Scenario
  • Change a Constraint
  • Create a Solver Report
  • View Solutions using Scenarios
Feature Image
13. Using Automatic Formatting & Styles
  • Apply an AutoFormat
  • Change AutoFormat Options
  • Extend List Formats and Formulas
  • Create a Style by Example
  • Create a New Style
  • Edit an Existing Style
  • Merge Styles
14. Using Conditional and Custom Formats
  • Apply Conditional Formats
  • Change a Conditional Format
  • Add a Conditional Format
  • Create a Custom Conditional Format
  • Use Data Bars
  • Delete a Conditional Format
  • Create a Custom Number Format
15. Working with Views
  • Create, Display and Delete a Custom View
16. Consolidating Worksheets
  • Consolidating Worksheets by Category or by Position
Feature Image

17. Sharing Workbooks

  • Save a Shared Workbook
  • View Users Sharing a Workbook
  • View Shared Workbook Changes
  • Highlight Changes,
  • Resolve Conflicting Changes
  • Add a History Worksheet
  • Review Tracked Changes
  • Merge Shared Workbook Files
18. Creating/Revising PivotTables
  • Create a PivotTable Report
  • Add PivotTable Report Fields
  • Select a Report Filter Field Item
  • Refresh a PivotTable Report
  • Change the Summary Function
  • Add New Fields to a PivotTable Report
  • Move PivotTable Report Fields
  • Use Expand and Collapse Buttons
  • Hide/Unhide PivotTable Report Items
  • Delete PivotTable Report Fields
  • Create Report Filter Pages
  • Inserting & Using Slicers
  • Format a PivotTable Report
  • Create a PivotChart Report
  • Publish PivotTable Reports to the Web












19. Using, Recording, Editing Macros
  • Change Macro Security Settings
  • Open a Workbook Containing Macros
  • Run a Macro
  • Use a Shortcut Key
  • Use the Visual Basic Editor Window
  • Record a Macro, Assign a Shortcut key
  • Write a New Macro
  • Enter Macro Comments
  • Copy, Edit and Type Macro Commands
  • Run a Macro from the Code Window
  •  







20. Creating a Macro Button
  • Use, Create, Format, Move/Size & Delete a Macro Button