MAXWELL ACADEMY PVT. LTD.
Authorized Testing Centre
CENTRE FOR TRAINING & DEVELOPMENT
New no.12, Old no. 35, V.P. Akilan Street, M.G.R. Nagar, Chennai-78.
Website: www.maxwellacademy.com
Conducts
ONE DAY WORKSHOP ON
ADVANCED
MS EXCEL 2010
Venue:
Hotel Madhav International - Pune
6A, Ramabai Ambedkar Road,
Before Hotel Le-Meridian,
Behind Pune Railway Station,
Pune - 411 001
Date
25th February2015
Wednesday
Time
9.00am To 5.00pm
For Registration contact :
Ms Clara Poulin C, Training Coordinator
Phone: 044-4261 6430 | 044-4203 3075
Cell: 09841985114 / 6
E-mail: [email protected]
[email protected]
COURSE CONTENTS
Knowing new features of Excel
Exploring QAT, Ribbon, Dialog Box Launcher, Command Button &
Command Sets
Investigating the use of Smart Tag
Advanced usage of Clip Board
Clip board in multiple application
Consolidation between sheets and iles
Controlling multiple sheets & iles
Trick of Copying sheet in existing ile and new ile
Comparing iles with synchronizing
Arrange iles in different views
Saving the layout of views
Filling and data entry Fast by Fill Handle, Smart Tag and Custom List
Tips about the Format Cells
Innovation in paste special
Categories of View
Normal
Appending Header & Footer
Arrange Page Setup
Insert and Position the Page Break
Making rows and columns to be repeated
Saving the Page Setup ( Print out at time from anywhere)
Decorating through conditional formatting
Highlight Cells
Find Duplicate
Top / Bottom
Data Bars
Color Scales
Manage the formats
Sort and Filter
Multiple sort
Level of sorting
Color & Icon Sort
Multiple Filter
Date, Text, Number Filter & Color Filter
Clear & Reapply
Improving with Function
Lookup
Prerequisites
VLookup & HLookup
Array Lookup
Logical function
If, And, Or
Nested Function
Nested Ifs
Creating reports through Pivot Table
Pre-condition for Pivot
Understanding Report ilter, Row & Column and ∑ value
Summarize and show values
Creating Yearly, Quarterly, Monthly and Weekly reports
Creating histogram or age analysis
Reports in multiple page by a click using report ilter
Creating an Outlined Consolidation
Working with Dynamic Table
Making dynamic table using short cut keys and tools
Auto format, Auto ilter, Auto freeze, Auto updating on formulas,
functions, table and charts
Automatic summation, Auto subtotal ,Changing function by a click
Adding function on other column by a click
Selection of columns with ease
Adding a column & Auto copy of formulas and function
Knowing the Limitation
Visualizing using chart
Creating basic chart (Line, Column, Bar or Pie)
Combination of chart
Printing options in chart
Creating the chart template
Drawing chart based on template
Making a default chart
PROGRAMME FEE :
Rs. 3,500/- Nett per participant (Inclusive of all Taxes). It covers Course Material, grand buffet Veg. Lunch
and Refreshment. Service Tax No. : AFKPG7543 M St001 Kindly register your name along with DD/Cheque in
favor of “MAXWELL CENTRE FOR TRAINING & DEVELOPMENT”.
For further details we request you to visit our website http://www.maxwellacademy.com/pages/progs.asp?id=mprog0355
About Facilitator - Mr Ashok Sindhkar
He is having 10 years of experience in MS Of ice. He is working with Mahindra & Mahindra. He has created
many calculators in excel. One of them is ‘Employees Credit society loan calculator’ at Mahindra M-connect. He has
designed Advanced Excel Training Course.
His Clients are;
Web solutions Pvt ltd
House of Investments commodity traders, Nasik
K. K. Wagh Engineering College, Nasik
ICWA/CA students Nasik
Boy’s town public school, Nasik for staff and students
Onkar Dies Pvt Ltd, Pune
PAVE test track, Mahindra & Mahindra, Nasik
Bosch Ltd, Nasik.
Branches: All over Tamil Nadu, Puducherry, Bangalore, Hyderabad, Pune - Teams: Bangalore, Mumbai, Delhi, Kolkata, Hyderabad