MS-Excel

MS Excel

MS-Excel is the most widely used software across the globe. Knowledge of excel is not enough but Mastering knowledge of Excel will distinguish you in today’s competitive work environment.

Course Highlights:

The course covers from the Basics to Advanced topics of MS-Excel
Securing and protecting information
Editing and managing collaborative data
Presenting data in Business model design
Analyzing, Auditing and Reporting data
Combining, linking and sharing information

Pre requisite:

Basic knowledge of computer

About Trainer

Experience: 25 years
Conducted Training for Corporate, Universities and Foreign Banks
Appreciation by Indian Army where more than 10,000 Army IT Professional Trained and Certified

Price: INR 9500/– | $128 (USD)

Offer Price: INR 6500/- Pay Now

Offer Price: $88 (USD) Pay Now

(WhatsApp @ +91 9650226185 for Special Price Discount Coupons and Corporate Offer)

Learning mode:

Instructor led Online training
Classroom training is available for corporate and universities

Course Content:

Pre skill test

New features in Excel

Understanding Ribbon, Tabs, Mini tool bar & QAT

Clipboard utilities

Tool tips and Smart tags

Tips, Tricks and shortcut keys

All features in Paste and paste special

How to frame a good data?

Hands on

Exercises

Naming individual or range cells’s

Deleting and amending named ranges

Using named cells/ranges in formulae

Advanced levels in Find and replace

Multiple ways of selection

Cell referencing (Absolute & Relative)

View with multiple sheet & workbook

Working with workspace

Hands on

Exercises

Conditional Functions

Benefits and purpose

If Statements , Nested If

And, Or, Not

Combining If, And, Or, Not

Sumif , Countif

Hands on

Exercises

Basic List Management

Sorting Data

Adding Subtotals

AutoFilter

Freeze Panes

Group and Outline

Data Form

Hands on

Exercises

Course content continue….

Click for Demo Session

Please feel free to submit your Question

Course content continued…

Conditional Formatting

Highlight cells, Top / Bottom, Data bars, Color scales & Icon sets

Advanced level of conditional formatting

Using formulas and function in conditional formatting

Format cells

Advanced level of Sort

Levels of sorting

Sort by Values, Colors and Icons

Custom sort

Filter

By Text, Number and Date

By Color and Icon

Hands on

Exercises

Excel Charts / Graphs

Using the Chart Wizard

Editing and Formatting charts

Saving custom chart types

Setting a default chart type

Hands on

Exercises

Advanced Concepts in Pivot Table

Creating a basic report

Working with design & layout

Summarize data with different functions

Creating formulas

Field setting

Report filter

Grouping data

Creating Yearly , Quarterly, Monthly, Weekly reports

Consolidation of sheet

Hands on

Exercises

What if analysis

Goal seek, Scenarios Data Table – Forecasting

Hands on

Exercises

Formulae Auditing

Formula Auditing Tools

Revealing Formulae

Tracing Precedents/Dependents

Goto Special

Hands on

Exercises

Worksheet Management & Linking

Linking sheets in the same file

Linking different Excel files

Using Edit, Links

Viewing different files at once

Saving a workspace

Viewing different sheets at once

Window Split

Data consolidation

Hands on

Exercises

Lookup function

Vlookup

Hlookup

Hands on

Exercises

Date Calculations

Entering Dates and Times

Different date/time formats

How dates are stored

Calculating working days

Using the DAY(),MONTH(),YEAR() functions

Time calculations

Hands on

Exercises

Concept, Recording and Running Macros, the VBE Environment

The Project Window

Code Window

Properties Window

Navigating between Excel and the VB Editor

Hands on

Exercises

Post skill test and Certification

After completing this training participants can upgrade for next level 48 hour’s training programme