Course Details

 

 

CERTIFICATE COURSE IN SPREADSHEET (Using MS Excel)

Overview

What is Excel used for? Excel is a handy software that can be used to store and organize many data sets. Using its features and formulas, you can also use the tool to make sense of your data. For example, you could use a spreadsheet to track data and automatically see sums averages and totals.

These are some features of Ms excel, Pivot Tables Filtering and Sorting Data, Excel Tables, Conditional formatting, Lookup Excel, functions, Array Formulas & Data Analysis Excel Tools.

#
Target Audience
  • 10th Class Students
  • 12th Class Students
  • Graduates
  • Post Graduates
  • Job Aspirants
Course Outline
  • Formatting a Worksheet & Create Templates
  • Number formats
  • Understanding Cell References
  • Formula (More than 100)
  • Logical, Text, Math, Date & Time, Lookup, Accounting, Engineering, Statistic, Database & Other Functions
  • Formula Auditing
  • Name Manager
  • Table Style
  • Data Using Charts
  • Pivot Charts & Pivot Tables
  • Link Multiple Sheet & Files
  • Page Setup
  • Sorting, Advance Filtering data & Sub Total
  • Data Validation
  • Consolidating Data within Worksheets
  • What If Analysis
  • Get External Data Connection
  • Protect Sheet & Workbook
  • Track Changes
  • Using Save Workspace
  • Conditional Formatting
  • General Option for Working with Excel
  • Advance Option for Working with Excel
  • Customize the Ribbon
  • How to Create Module in Excel Macros
  • Excel shortcuts
  • Assignment
Course Duration

40 Hours to be covered 1 Month.

Certification

We provide National Skill Development Corporation (NSDC) certificate after successful completion of course.

Career Opportunities
  • Ms Excel Executive
  • Reporting Analyst
  • MIS Executive
  • Data Entry Operator
  • MIS Analyst

Enquiry