<

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

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

2. Using Multiple Workbooks

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

3. Using Range Names

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

4. Working with Tables

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

8. Advanced Charting

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

12. Solving Problems

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

17. Sharing Workbooks

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












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







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