Advance Excel Course

by Vibrant Technologies & Computers

Module

Title

Contents

Module 1:

Microsoft Excel – Advance with Macros

Most managers often use Excel more as a calculator than a computing aid.

Module 2:

Using Multiple Workbooks

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

Module 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)

Module 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

Module 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

Module 6:

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

Module 7:

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 Trend line, Create User-defined Charts, Create, Customize, Remove Spark lines

Module 8:

Using Templates

Save a Workbook as a Template, Use a Template, Edit a Template, Delete a Template, Create Default Templates
VI.Using camera in iPhone

Module 9:

Using Auditing Tools

Display the Formula Auditing Toolbar, Display/Remove Dependent and Precedent Arrows, Remove Tracer Arrows, Use Auditing Tools Buttons

Module 10:

Using Scenarios & Goal Seeking

Use the Scenario Manager, Create, Display and Edit a Scenario, Create a Scenario Summary Report, Use Goal Seek

Module 11:

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

Module 12:

Working with Views

Create, Display and Delete a Custom View

Module 13:

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

Module 14:

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

Module 15:

Using, Recording, Editing Macros Creating a Macro Button

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
Use Relative References, Delete a Macro, Write a New Macro, Enter Macro Comments, Copy, Edit and Type Macro Commands, Run a Macro from the Code Window Use
Create, Format, Move/Size & Delete a Macro Button