Upcoming Events

Learning Catalyst

Loading Events

« All Events

  • This event has passed.

Open House Training on Advanced Excel (Mumbai, Pune, Bengaluru, Delhi NCR, Hyderabad & Chennai)

19 January @10:00 am - 20 January @6:00 pm

19 January 2018 – 20 January 2018 (10:00 AM to 6:00 PM)

Venue: Hotel Pride, Pune

Fees : Rs 6,000 Per Participant + Tax

Course Overview

This course covers all the Excel Features used to improve the efficiency and the speed of the work performed in Excel.
Features covered: Working with Data retrieving Functions and Options, Managing & Controlling the Worksheet using Data Validation, Summarizing the data using Sorting, Subtotaling and Conditional Formatting. Generating MIS Reports using Pivot Tables and Charts.

Who Should Attend this course:

This course is designed for all those who are already familiar with or who has attended the Basic MS Excel Training Program and would like to work with more Advanced Excel Features for improving their efficiency at work by performing complex calculations more efficiently.

Pre – Requisites: :

The delegates must have experience working with basic Excel Functions and Options.
Suggested proficiency in basic skills includes: Moving around a spreadsheet, selecting a range or multiple ranges, Copying and pasting with various options, filling a series of values, Inserting and deleting rows and columns, Using the summation button and some simple functions etc.

Content Outline :

Advance Excel
Duration 2 Days
Day1
SL No Topics Duration (In Hrs) Timing
1 Pre Assessments 30 Mins 9:00 – 9:30
2 Expectation Setting 120 Mins 9:30 – 11:30
Data Entry and Formatting
4 Using Fill Handle, Fill Series and Custom Lists
5 Number/Date/Time Formatting
6 Conditional Formatting
7 Inserting Comments and Hyperlinks
8 Using Paste Special Dialog Box
9 Freeze Panes
10 Viewing multiples workbooks simultaneously
Tea Break 15 Mins 11:30 – 11:45
Build Summary Reports using Pivot Tables 90 Mins 11:45 – 1:00
11 Create Pivot Table
12 Referesh Pivot Tables and Change Source Data
13 Sorting and Filtering Data
14 Adding Slicer
15 Extracting Source data from a Pivot Table
16 Formatting Pivot Table reports
17 Creating Pivot Charts
Lunch Break 60 Mins 1:00 – 2:00
Protecting data via Validation, Protect Sheet and Protect Workbook 120 Mins 2:00 – 4:00
18 Data Validation
19 Apply data validation to cells – only numeric data, fixed width text, dropdown list of values
20 Copy and Paste validation rules to other cells
21 Highlight cells with invalid data
22 Clear Data Validation
23 Workbook and Worksheet Protection
24 Understanding Locked/Hidden Properties of a cell
25 Disable editing contents of a worksheet
26 Providing edit rights to a limited range of cells
27 Disable adding/copying/moving/deleting sheets from a workbook
Tea Break 15 Mins 4:00 – 4:15
What-If Analysis and other Statistical tools 90 Mins 4:15 – 5:30
28 What-If Anlaysis using Goal Seek and Data Tables
29 Calculating goal/target value using Goal Seek
30 Build one-input and two-input data tables
31 Analysis ToolPak – Histogram, Moving Average, Regression, Correlation
32 Live Examples / Question & Answers 30 Mins 5:30 – 6:00
Day2
Operator based calculations 90 Mins 9:00 – 10:30
1 Basic Calculations using Formulas and AutoSUM
2 Understanding referencing a cell or a range of cells
3 Differentiate between Relative/Absolute/Mixed Cell Reference
4 Using mathematical operators – +, -, /, *, %, ^
5 Using Name Manager to define and manage cell names
6 Trace Precedents and Dependents in a formula
7 Using AutoSUM for quick calculation
Tea Break 15 Mins 10:30 – 10:45
Function based calculations 120 Mins 10:45 – 12:45
8 Statistical – COUNTIF, COUNTIFS, MEDIAN, MODE, AVERAGEIF, AVERAGEIFS
9 Text – UPPER, LOWER, TRIM, CONCATENATE, DOLLAR, SEARCH, REPLACE, SUBSTITUTE
10 Date & Time – TODAY, NOW, YEAR, MONTH, DAY, HOUR, MINUTE, DATEVALUE
Lunch Break 60 Mins 12:45 – 1:45
11 Logical – IF, AND, OR, IFERROR 120 Mins 1:45 – 3:45
12 Lookup – VLOOKUP, HLOOKUP
13 Mathematical – SUM, SUMIF, ROUND, RAND, INT
14 Information – INFO, ISNA, ISBLANK, ISERROR
Tea Break 15 Mins 3:45 – 4:00
Build charts 90 Mins 4:00 – 5:30
15 Creating Charts
16 Creating Column, Bar, Pie and Line charts
17 Creating combo charts using Secondary Axis
18 Adding Trend Lines
19 Creating Chart Templates
20 Creating Sparklines
21 Post Assessments 30 Mins 5:30 – 6:00
22 Live Examples / Question & Answers 30 Mins 6:00 – 6:30

FACILITATOR :

With 16 years of experience in Training, Automation &Business Analysis. Practical problem solving experience and exposure to vast spectrum of audience from different sectors, trainer has given edge in Training. Enthusiasm and energy in his training sessions are evident. His sessions are lively and result oriented. He has regularly conducting trainings on latest version of MS Office, Advanced & Expert Level of Excel, MS –Access, MS Outlook, MS OneNote, MS Office 365. Trainer has trained more than 15000 participants from varied background, levels and experience including C-Suite and Sr. Management Training for Piramal Industries, Jewelex, L&T Technology Services, Axis Bank Ltd, 3D PLM Software Solutions, ACC Ltd, JP Morgan Services, JLL India, Bombay Dyeing, Marico Industries, L&T Ltd, CEAT Ltd, DBS Bank, Lubrisol India Ltd and many many more companies he has delivered such Corporate Trainings.

Terms and Conditions:

  • InnoServ reserves the right to change the date, time and venue if required, the participants will be notified of the same at least two days before the event.
  • In Case the required nominations are not met, InnoServ reserves the right to cancel the event, this would be notified at least 4 days before and the registration amount will be refunded. The company will not be responsible for bookings related to travel/stay etc.

For Registrations or Queries, Please Contact Us

Preeti Saxena:
preeti@innoserv.co.in/ 9923293751, 020-60121215
Pooja Zadbuke:
pooja@innoserv.co.in/ 020-60121233

Details

Start:
19 January @10:00 am
End:
20 January @6:00 pm