fbpx

Applied Advanced Ms. Excel

1. Course Overview

In most of the training Institute Advanced Excel is taught by IT professional. They simply tell you to how to do “this” and “that”, which later you will find difficult to apply in your real office work. Our trainer from IT as well as management background who will teach you to connect excel in your real life works such as

2. Course Content

 

 

 

1.      Getting Started with Excel

·        Excel Interface

·        Quick Access Toolbar

·        Customization

2.      Filling Series

·        Fill Handle

·        Fill Series

·        Control and Right Click

3.      Cell Referencing

·        Relative Referencing

·        Absolute Referencing

·        Mixed Referencing

4.      Excel Operators

·        Order of precedence

·        Comparative operators

·        Other operators

5.      Advance Formatting

·        Align content

·        Indents

·        Apply Styles

6.      Avoiding Mouse

·        Multimedia Keyboard

·        Keyboard Short Cuts

·        Navigation

7.      Defined Names

·        Name bar

·        Create Name Range

·        Modify and delete name range

8.      Wild Cards

·        Concept

·        Empower with wildcards

·        Handling wildcard as text

9.      Find and replace

·        Finding within range

·        Replacing

·        Formatting

10.   Sorting data

·        Quick sorting

·        Sort Across Row

·        Custom Short

11.   Filtering Data

·        Multiple filter

·        Color Filter

·        Advanced Filter

 

 

 

 

 

 

12.   Excel Table

·        Creating Excel Table

·        Formatting and Calculating

·        Convert to range

13.   Easy Charting

·        Create right chart

·        Format Chart

·        Manipulate Chart

14.   Powerful Pivot

·        Creating Pivot Table

·        Advanced Data Analysis

·        Creating Pivot Chart

15.   Subtotal and Outline

·        Creating Subtotal

·        Multiple Subtotal

·        Outlining data

16.   Conditional Formatting

·        Applying Conditional Formatting

·        Removing Conditional Formatting

·        Conditional Formatting Using Formula

17.   Excel Formula and Functions

·        Understanding and Using Formula

·        Understanding and Using Functions

·        Creating Complex Formulas

18.   Advance worksheet Function

·        Logical Functions

·        Lookup Functions

·        Text Functions

19.   Worksheet and Workbook Techniques

·        Worksheet Techniques

·        Hiding Worksheet and workbook

·        Comparing Techniques

20.   Automation

·        Understanding Macros

·        Recording Macro

·        Introductory VBA

21.   Advanced Printing

·        Page Setup

·        Strategy to Print Large Sheet

·        Header and footer

22.   Problem Solving

·        Solving problem

·        Sharing Excel Tips

 

 

Close Menu