Online Excel
Certification Course Batch 3

Basics of MS excel, Formulas and Functions,
Data Visualization, Pivot Table & much more...

Registration Fee: 500/-
  • Beginner Level
  • E-Certificate
  • Individual Attention
  • Get Access to Class Recordings
  • 100% online courses
  • Expert Faculty

Class days and date

JANUARY: 20th - 23rd

Eligibility

Anyone with basic computer proficiency

Requirements for the Class

  • A system with Microsoft Excel - 2013 or above
  • A steady internet connection
Image
Image
Day 1

Introduction to Excel

  • Basics of Excel – Data Entry, Cell References etc.
  • Excel Ribbon - Familiarization
  • Worksheet Navigation and Copying
  • Hide and Unhide Columns and Rows
  • Formatting Tips - Alignment, Borders etc.
  • Delete Rows
  • Conditional Formatting etc.
  • Sorting, Filtering and Replacement
Day 2

Data Cleaning and Management

  • Remove Duplicates
  • Text to Columns
  • Flash Fill etc.

Calculations in Excel

  • Formulas and Functions – Commonly used Function
  • SUM
  • COUNT
  • AVERAGE
  • IF
  • Text functions
  • Combine values from two or more cells to one cell
Image
Image
Day 3

Data Visualization – Charts

  • Column Chart
  • Line Chart
  • Pie Chart
  • Pareto Chart, etc.

Pivot Table Creation for Data Analysis

Day 4

Data Analysis Using Excel

  • Basic Functions for Data Analysis - Mean, Median, Mode
  • Descriptive Statistics - Data Analysis Tool pack(example)
  • Printing Excel files and saving as PDF
Image
Resource Person
Image

Gloria Mathew

M.Tech Computer Science