Online Excel
Certification Course

Beginner Level

100% Online

Individual Attention

E-Certificate

Access to Recorded Class

Expert Faculty

Buy Now

Course Curriculum

Day 1
  • Introduction to Excel:
    • Basics of Excel – Data Entry, Cell References etc.
    • Excel Ribbon - Familiarization
    • Worksheet Navigation and Copying - Copy and Move Worksheet, Copying and Pasting Data
    • Hide and Unhide Columns and Rows
    • Formatting Tips - Alignment, Borders etc.
    • Conditional Formatting
    • Data Cleaning and Management:
      • Sorting, Filtering and Replacement
      • Deleting Rows
      • Removing Duplicates
Day 2
  • Calculations in Excel:
    • Formulas and Functions
  • Combine Values From Two or More Cells to One Cell
  • Data Visualization - Charts
Day 3
  • Data Analysis Using Excel:
    • Pivot Table Creation
    • Basic Functions for Data Analysis - Mean, Median, Mode.
    • Descriptive Statistics - Data Analysis Tool Pack
  • Printing Excel Files and Saving as PDF

About the course

Spreadsheet software remains one of the most widely employed pieces of software in workplaces. Professional training on such software would be an asset to your employability portfolio. This course is intended for candidates who seek to develop basic excel analytical skills.

Eligibility

Recommended for all with basic computer proficiency

System Requirements

This course requires a computer or laptop with steady internet connection

Class Timings

Date : 27th, 28th and 29th July 2022

Timing : 8.00 PM to 9.30 PM IST

Resource Person

Gloria Mathew

M.tech Computer Science