Online Advance Excel Training for HR and Payroll

Our Advanced Excel Training Course is delivered in classroom and online batches held on weekdays and weekends. Batches are held in regular class-room and fast-track mode.

Course Description

The Advanced Excel program is designed to lead the participant to understand how this works and to successfully work in this domain.
There are multiple courses available to fit the requirement of students and working Professionals.
1. Advanced Excel on weekends.
2. Advanced Excel on weekdays  
3. Advanced Excel on weekdays - fast-track 
What skills will the student gain?
After the completion of this course, the student will be able to:

The course outline delivered during the class is as follows -

Introduction

  1. Freeze panes
  2. Charts (Bar, Column, Line, Pie, Area, 3d
  3. Auto Sum on the Task-bar
  4. Usage of Top Ribbon Menu

Using Sort, Filter, Text-to-Column

  1. Sorting (number. alphabets, color, date, custom)
  2. Filter, Advanced Filter
  3. Text to column: Importing .txt files / CSV into excel (Bhav Copy)
  4. What-If Scenarios
  5. Solver
  6. Grouping and Sub-grouping

Creating Graphs & Chart

Formula Writing & Fixing Errors

  1.  Time Value of Money (PV, FV, nper, rate, PMT) + IRR, NPV
  2. Lookup: Vlookup, Hlookup
  3.  Sum, Sumproduct, Absolute, Integer, Round, Average, Count, Minimum, Maximum
  4.  IF, nested if, sumif, Count, CountIf, CountBlank, iferror and, or,
  5. Case, Position, Search, Trim, Right, Left, Concatenate
  6. Date & Time: Day and Time, Representation of Date in Excel, Conversion, Today, Day
  7.  Even, Exact, Exp, Find, Int, IsBlank, Left, Len, Lower, Upper, Proper, Now, Power

Working with Data

  1. Data Validation (List, Error Message)
  2. Identifying Invalid Data
  3. Dependent Data List
  4. Pivot Table (Pivot Chart)

Review and Security

  1. Password Protection
  2. Cells Lock
  3. Making excel as a form
  4. Track Changes

Using Macros

  1. Recording macros
  2. Running macros

0

Year Of Experience

0

Trainees Enrolled

0

Batch Completed

Placement Track Record

Unlimited Interview

ISO 9001:2015 Certified Company