<
  • Home
  • Advance EXcel
advanced excel training institute in bangalore

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
Advanced Excel Training Course Outcome
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
RELATED PROGRAMS

Hadoop Big Data

Hadoop is a framework which is designed to solve the problems related to Big Data. Each and everyday numerous amount of raw data is generated from different kinds of sources

Read More

PHP MYSQL

PHP is a powerful language for writing server-side Web applications, while MYSQL is the popular open source database. These two applications together helps building database-driven

Read More

Android

Android is a rich, ready-to-use software stack that is easily adaptable to different hardware platforms. It includes an operating system, middleware and key applications.

Read More