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.

Excel training includes helpful features like 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
Advanced Excel Training 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.

Scope of Excel certification:
  • MS Excel Executive
  • Reporting Analyst
  • MIS Executive
  • Data Entry Operator
  • Data Analyst
  • Metrics and Analytics Specialist
  • Financial Analyst
  • Market Research Analyst
  • Big Data Engineer
  • Big Data Analytics Architect
  • Big Data Solution Architect and more
  • MIS Analyst

Enquiry