About the Course
This course has designed for working professional who work on Excel but face some problem to handle Excel Workbook.
2 Days Workshop of Advanced Excel 2010 & 2013
We are able to provide a projector and audio equipment for the class.
Classes will be scheduled on Sunday Only
Timing on :
29/06/2014 (Sunday) to 06/07/2014 (Sunday)
Batch 1 10:00 AM to 06:00 PM
Registration Date:15/06/2014 to 28/06/2014
Course Fees: Rs.2000/- Per Head
Registration Amount : Rs.500 (Remaining Rs 1500 at the time of join the class)
Book your seat hurry.
Topics CoveredModule 1
Introduction part of Excel 2010-2013
Basic Short Keys,
Worksheet Operations, Cell Operation, Format Cells, Freeze Panes, Techniques of Paste Special, Protect Worksheets & Workbooks ,Time Saving Utilities, Format Painter, Text to Columns with fixed and delimited parameters, Data Sorting using custom list, Summarizing data using Auto Outline, Concept of Cell Referencing, Relative Referencing, Absolute Referencing, Mixed Referencing,
Important Functions in Excel :
NETWORKDAYS,IS FUNCTIONS,MATCH,IF,VLOOKUP (2D lookup & 3D lookup),HLOOKUP,REVERSE LOOKUP,
Name Manager, Defining List using names, Use of Names in Advance Reports, Conditional Formatting, Conditional Formatting using Formulas & cell values, Highlighting Duplicates, Calculation based Conditional Formatting
Data Validation :--Different Data validation in Excel ,Using list in validation
Charts in Excel :--Elements of Charts ,Major charts used in Excel
Pivot Table :--Pivot Table creating Methods ,Rearranging a Pivot Table ,Filtering Pivot Table Data & Power Pivot Table,Performing Custom Calculation ,Creating Dynamic Dashboards using pivot charts and Slicer ,Consolidating Data from external source or multiple files in less than a minute ,Array Functions for quick conditional calculations
Data Filter :--Normal Data Filter ,Advance Filter ,Calculation based filter ,Filter using wild cards ,Summarizing data using Subtotal
Analyzing data with What-If Analysis ,Determine unknown with Goal Seek ,Analyze data with Data Table ,Sparklines for Data trends ,Error handling Tips and Tricks & many more..........
Who should attendBeginners and any working professional who want to learn Advanced Excel Functions.
Pre-requisitesBasic Computer Knowledge.
What you need to bringNO NEED TO BRING ANYTHING.
Add on Benefits:-
1.Free Study Material.
2.Notepad & pen
3.Excel 2010/2013 keyboard shortcut keys printout copy.
4.Free CD of all Session.
5.Refreshment,Study Material included in fees.
MONEY BACK GUARANTEE
If you are not entirely satisfied with workshop we will refund your training fees."
Key TakeawaysTo be expert in Advanced Excel 2010-2013