Online Excel
Certification Course

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

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

Class days and date

OCTOBER: 08 - 10

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.
  • Conditional Formatting
  • Data Cleaning and Management
  • Sorting, Filtering and Replacement
  • Delete Rows
  • Remove Duplicates
Day 2

Calculations and Visualization in Excel

  • Calculations in Excel
    • Formulas and Functions
    • Combine Values From Two or More Cells to One Cell
  • Data Visualization – Charts:
    • Column Chart
    • Line Chart
    • Pie Chart
    • Pareto Chart etc.
Image
Image
Day 3

Data Analysis Using Excel

  • Pivot Table Creation
  • Basic Functions for Data Analysis Mean, Median, Mode
  • Descriptive Statistics - Data Analysis Tool Pack (Example)
  • Printing Excel Files and Saving as PDF
Resource Person
Image

Gloria Mathew

M.Tech Computer Science