Excel Micro Course - Batch 7

  • Beginner Level
  • 100% Online
  • Individual Attention
  • E-certificate
  • Access to Recorded Class
  • Expert Faculty
Course Fee : ₹700.00/-
Request Call Back

Course Curriculum

Day 1
  • Introduction to Excel:
    • Basics of Excel – Data Entry, Cell References etc.
    • Excel Ribbon – Familiarisation
    • 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 Visualisation – Charts
Day 3
  • Data Analysis Using Excel
    • Pivot Table Creation
    • Basic Functions for Data Analysis – Mean, Median, Mode.
    • Descriptive Statistics – Data Analysis Toolpak
  • 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.

Rs 700.00

Request Call Back

Eligibility

Recommended for all with basic computer proficiency

System Requirements

This course requires a computer or a laptop with a steady internet connection

Class Timings

Date : 10th December 2022 - 12th December 2022

Time : 8:00 PM to 9:30 PM IST

Resource Person

Gloria Mathew

M.tech Computer Science