WELCOME TO BIZSMART

JUMPSTART YOUR CAREER IN HR

Excel Course Content

1 Pivots and Pivot Graphs:

  • Creating of Pivot Table
  • Using Summary function in Pivot Table
  • Pivot Table Calculations
  • Creating own formulas in Pivots
  • Grouping and Ungrouping in Pivot Tables
  • Creating Pivot Graph
  • Custom Filter on Pivot Table
  • Formatting Pivot table (Removing old data, grand total, subtotal …etc.)

2 Working on Objects:

  • Inserting Objects
  • Inserting different files into Excel (like .doc, .pdf, .txt files)
  • Hyperlinking to different sheets
  • Providing screen tips in hyperlink
  • Hyperlink to send emails
  • Inserting symbols
  • Sending working file to an email

3 Data Management in Excel – Sorting:

  • Rearranging of Data
  • Sorting by alphabets, numbers and time

Filtering Data:

  • Using Auto filter option
  • Custom Filtering with different options
  • Advanced Filtering
  • Find Unique records using advanced filtering
  • Filter using operators AND/OR
  • Filter by color

Grouping and Outlining Data

  • Group and ungroup rows and columns
  • Auto outlining the data
  • Freezing and Unfreezing

Data Validation:

  • Use Data Validation in Excel
  • Using Input Message in Data validation
  • Using error message in Data Validation

Removing duplicate records:

  • Remove duplicate records in a spread sheet
  • Customize to remove the duplicate values

Split Texts:

  • Split texts to different columns
  • Remove special character from a string and split the string

Data Consolidation:

  • Combining different spreadsheet using data consolidation
  • Using summary function in data consolidation

Conditional Formatting:

  • Use of conditional formatting
  • Custom formatting

Copy Data:

  • Use of format painter
  • Use of paste special
  • Strike through a value
  • Find and Replace

View Multiple Files:

  • Arrange multiple windows to view in one time
  • Split big sheet into sub sheets for better analysis

Working on Tab:

  • Hide/ Unhide a tab
  • Color a tab
  • Move /Copy the tab to another sheet/workbook

4 Advanced Functions:

  • V-Lookup
  • H-Lookup
  • IF
  • ISERROR
  • Index Match
  • Rows
  • Columns
  • Match
  • Offset
  • Get Pivot Data
  • Date and Time Functions
  • Text Functions
  • Operators
  • Mathematical functions
  • Calculation options

Name Manager:

  • Define a name to a range
  • Use of name manager
  • Using formulas in name manager
  • Editing name range

5 Data Connection from External Data:

  • From access
  • From SQL
  • From Web
  • From ODBC

6 Customize your Excel view:

  • Customize Excel view
  • Developer Option
  • Trust Centre
  • Add-Ins
  • Save directory options
  • Language Setting
  • Quick access toolbar

7 Security options in excel:

  • Protecting the worksheet
  • Protecting the workbooks
  • Sharing the workbook
  • Allow users to edit ranges

COURSES

Students Trained
Placements
Years
Smiles

BIZSMART ADVANTAGE

Practical Training
PAYROLL COURSES IN BANGALORE
Flexible Timings
PAYROLL TRAINING IN BANGALORE
Placement Assistance
HR COURSE IN BANGALORE
Resume Preparation
HR TRAINING INSTITUTE IN BANGALORE
Diploma and Certification Courses
IELTS TRAINING IN BANGALORE
Mock Interviews
WE BRING 
SUCCESS
GROWTH
FOCUS
 TO YOUR CAREER

TESTIMONIALS

Training was Excellent. All the trainers are very helpful​. People say that the job of an HR Executive is very tough as the person has to take on multiple roles. Thanks to Bizsmart, I did not feel that I cannot take on multiple roles

Apr 2013

Course Material,Placement assistance etc. ,it's a complete package which can be best use for HR student.The trainers made me a superstar and I can deal with any HR issue right now as the trainers have shared extensive knowledge with me

Jul 2014

I dreamed of making a career in HR but I didnt want to get into a core recruitment job role. This is where Bizsmart helped me. The training made me a multitasker by teaching me all aspects of HR from payroll to compliances.

Sept 2015

This training helped me make my dream of working as a HR professional come true

Jan 2018

OUR STUDENTS ARE WORKING WITH

LEARN FROM THE VERY BEST

Join our course and start building the most wanted career available today. We make sure every class is easily understood, and that all students reach the same level of expertise needed for today’s hi-tech industry.

CONTACT ME
CONTACT ME
Scroll to Top
WhatsApp chat