X
Search results for:
No result found! Try with different keywords!
Users
Organizers
Events
Advertisement
The event you are looking at is a past event. Check out this upcoming event Advanced Data Analysis and Dashboard Management using Excel 2010 happening on Fri Jul 14 2017 at 09:00 am at Meridian Hotel & Restaurant, C.D.A. Avenue. G.E.C. Circle, Chittagong, Bangladesh

Advanced Excel

Advertisement

Event Details

Advanced Excel


Introduction

Organizations today have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. Data analysis & representation is indispensible to facilitate decision making and strategy development. It’s very challenging to turn a huge amount of data to useful information without the help of Excel.

In this course, you will use Microsoft Office Excel to streamline and enhance your spreadsheets with templates, charts, graphics, data analysis and formulas. Demonstration will be based on MS Office version.

Prerequisites

Participant should familiar with basic excel that contain few functions like sum, max, min etc, formatting like borders, fonts, merge, etc, saving, printing techniques.

Participants need to bring their own laptop with MS Office installed, for better understanding and practical experience. The participants may also bring with them live data pertaining to their organization, so that these can be studied during the workshop, as to how it can be worked out with better solutions.

Course Contents

Chapter 1: OVERVIEW OF THE BASICS
• Arithmetic Operators
• Logical Operators
• Text Operators
• Range Operators
• Absolute and relative reference

Chapter 2: PRESENTING DATA USING CHARTS
• Creating a chart
• Modifying the axes
• Adding secondary axis
• Multiple location charting

Chapter 3: CONDITIONAL FORMATTING
• Conditional formatting with multiple conditions
• Using formulas in conditional
• Formatting

Chapter 4: DATA VALIDATION
• Validation for date
• Validation for list
• Validation using formulas

Chapter 5: NAME MANAGER
• Defining Names
• Creating Names Automatically
• Managing Names
• Using Names
• Applying Names
• Names in Formulae

Chapter 6: TEXT FUNCTIONS
• Concatenate()
• Left()
• Right()
• Mid(), find(), len()

Chapter 7: LOGICAL FUNCTIONS
• If Statements
• And, or
• Not
• Nested If

Chapter 8: DATE AND TIME FUNCTIONS
• Datedif()
• Weekday(), networkday()
• Today()
• Month()
• Year(), emonth()

Chapter 9: LOOKUP FUNCTIONS
• Lookup
• Hlookup
• Vlookup
• Index, match

Chapter 10: PIVOT TABLES
• Creating a Pivot Table
• Laying out the Pivot Table
• Grouping, value field setting
• Conditional formatting in pivot
• Consolidating the worksheets
• Adding calculated field
• Create pivot table from different source

Chapter 11: WHAT IF ANALYSIS
• Goal Seek; Scenarios;
• Table; PMT Function

Chapter 12: OTHER USEFUL FUNCTIONS
• Iserror
• Islogical
• Countif
• Averageif
• Averageifs
• Sumif
• Sumifs
• Countifs
• Database functions

Chapter 13: MACROS AND TEMPLATES
• What is Macro
• Recording Macro
• Storing macro, saving macro at secured location
• Adding command buttons, form controls
• Understanding VB Editor

Delivery Method

Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Medium: English, Hindi & Marathi

Fees and Registration:

Investment (Donation): Rs. 2,600/- + Service Tax 15% per person.
Incentive: Rs. 2,400/- + Service Tax 15% per person for a group of Three or more Members from the same Organization.

Fees include participation, course material (Hard copies), Breakfast, Lunch and tea / coffee.

Registration Process

Kindly provide below details through mail.
• Name of the workshop:
• Name of the participants:
• Company Name and address:
• Contact details of Participants (Email ID & Number)

REGISTRATION IS MANDATORY IN ORDER TO BE PART OF THE PROGRAM.

You can also call us on 8308459802 (Ms. Anushree).

Payments Details

The participation fee can be paid by way of DD/Cheque drawn in favour of “Indian Institute of Training & Development” payable at Pune or through NEFT.

NEFT/Bank Transfer details ‘Indian Institute of Training & Development’
Bank Name: Bank of India
Current Account No: 052320110000336
ISFC Code BKID0000523
Branch Kothrud (Gujarat Colony),Paud Road, Pune 411029
Service Tax No. BDNPK3328J SD001
PAN No. BDNPK3328J


Certification:

Certificate of Participation would be provided to all the participants.

We have many more new, exciting & innovative programs to share with you.
We look forward to your active participation and nominations.

With warm regards,

Rajiv Kolhe
Director
Indian Institute of Training & Development (IITD)
Website - www.iitdpune.com

You may also like the following events from Indian Institute of Training & Development (IITD):Also check out other Workshops in Pune.

Liked this event? Spread the word :

Map The Ambience Hotel, Shivajinagar, Pune, India
Loading venue map..
Questions or Comments? Post them here.
Event details from Report a problem
This event is listed in

Are you going to this event?

Yes

Organizer

Indian Institute of Training & Development (IITD)
  • 11 Followers
  • 1 Events
Who's going?
Login to see participants.
Advertisement
Create an Event