Advance MS-Excel Training Program

Training

In Mumbai

₹ 5,999 VAT incl.

Description

  • Type

    Training

  • Level

    Beginner

  • Location

    Mumbai

  • Class hours

    4h

  • Duration

    4 Days

This Advance Excel Program is specially designed for working professional to understand and implement the powerful use of MS-Excel.

Important information

Documents

  • Advance Excel Broucher

Facilities

Location

Start date

Mumbai (Mahārāshtra)
See map
A-202, Shanti Enclave, Opp.Railway Station, Mira Road (East).Mumbai., 401107

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Excel 2007

Teachers and trainers (1)

Vaishnavi Shetye

Vaishnavi Shetye

Sr.Faculty Member

Course programme

Program Contents - Topic Wise

1) Excel Quick Overview : Use of Excel, its boundaries & features. What’s latest in new releases.

2) Data Formatting & Custom settings : Number, Text, Date, Currency, Custom settings. Data formatting & cleaning

3) Conditional Formatting : Once defined, it will automatically change color of values e.g. up or down, high or low, pass or fail, profit or loss etc.

4) Filters, Queries & Data Sorting : Drill down your data to your desired level. Sort data based on your choice e.g. like North, East, West, South rather than alphabetically.

5) Formula Writing & Fixing Errors: Financial, Logical, Text, Day and Time, Statistical, Mathematical etc Sum, Average, Count, Minimum, Maximum, Absolute, Concatenate, Count, CountA, CountBlank, CountIf, Day, Today, Even, Exact, Exp, Find, Int, IsBlank, Left, Len, Lower, Upper, Proper, Now, Power, Rank, Right, Round, Trim etc.

6) If-Then-Else & Nested If commands : Produce different set of results based on slabs, conditions. Learn to use Nested if (if within if) for complex situations.

7) Vlookup / Hlookup : You have large amount of data placed at different locations & you want to merge it based on common values & it’s relevance.

8) Graphs & Charts : In this workshop you will learn how to create, modify & update graphs / charts like Column, Line, Pie, Bar, Area, Scatter, 3D etc.

9) Hyper / Data Linking : Hyper & data linking, within or outside Worksheet / Excel File is an important feature. This helps update data automatically.

10) Grouping - Ungrouping : Sometime data needs to be grouped for summarized results & crisp view. Grouping & ungrouping feature will help you do so.

11) Pivot Tables : Summarize your data as per your desire. You need to select data in a range & produce consolidated results in user defined reporting formats.

12) Macros Recording, use, editing, linking : Record, edit & use Macros with little or no programming knowledge. You can automate various day to day things using Macros which will help you save time and efforts.

13) Security & Protection : It will help you protect your cells, worksheet or an excel file from unauthorized use. You can create various kind of forms to enable users to fill date.

14) Data validation : prevent wrong data entry in your specified format. This will help you design various formats based on company requirements

Advance MS-Excel Training Program

₹ 5,999 VAT incl.