Tutors

Mr. Pradeep Pandey

PROGRAM OVERVIEW

Microsoft Excel is the industry-standard spreadsheet program which is used for data calculations, analysis, visualization and much more. This course will let you know every detail of MS Excel software. It is an excellent tool for data modelling, statistics and financial calculations with built-in functions to quickly and easily perform common tasks. Proficiency in Excel is typically required for accounting, business analytics, data analysis and statistics jobs.


Syllabus:

  • MS-Excel Complete Course
  • Practical Test and Exercises
  • Practice Quizzes


After the completion of this course, you will learn to :

  • Understand and practice all the basics of Excel.
  • Build your own simple, AND complex formulas and use some of Excels built-in functions.
  • Build your spreadsheets from scratch, and understand how they work! Learn To Use Excel Like The Professionals
  • Build Powerful Advanced Excel Projects From Scratch
  • Create a fully functioning relational database using Excel
  • Build Gantt charts in Excel for project planning
  • Complete routine tasks thousands of times faster!
  • Fully automate report generation


After the completion of this course, you can get Employment in the following areas:

  • Colleges & Universities
  • Banks
  • Market research firms
  • public  firms
  • corporations
  • Consultancy Services
  • Research Organisations
  • Self-employed


Certificate in MS Excel Job Types:

  • Freelancer
  • Content Writer
  • Data Entry Operator
  • Computer Teacher/Computer Faculty
  • Instructional Designer
  • Computer Trainer
  • Home Tutor
  • Data Entry Clerk


Average Starting Salary: INR 1 to 4 lakhs per annum


CURRICULUM

  Introduction to MS Excel and Using Formula

  • Introduction to MS Excel and Using Formula
  • Exercise 1 (Hindi)

  Formula, Cut, Copy, Paste, Format Painter, Alignment

  • Formula, Cut, Copy, Paste, Format Painter, Alignment
  • Exercise 2 (Hindi)

  Wrap Text, Merge Center, Number

  • Wrap Text, Merge Center, Number
  • Exercise 3 (Hindi)

  Conditional Formatting, Format as table, Cell Style, Cell Insert, Cell Delete

  • Conditional Formatting, Format as table, Cell Style, Cell Insert, Cell Delete
  • Exercise-4 (Hindi)

  Format, AutoSum, Fill, Clear

  • Format, AutoSum, Fill, Clear
  • Exercise-5 (Hindi)

  Sort, Filter, Find, Select

  • Sort, Filter, Find, Select
  • Exercise-6 (Hindi)

  Pivot Table, Table, Picture, Clipart

  • Pivot Table, Table, Picture, Clipart
  • Exeercise-7 (Hindi)

  Shapes, Smart Art, Screen Shot, Charts

  • Shapes, Smart Art, Screen Shot, Charts
  • Exercise-8 (Hindi)

  Hyperlink, Text box, Header Footer, Word Art, Signature, Equation, Symbol

  • Hyperlink, Text box, Header Footer, Word Art, Signature, Equation, Symbol
  • Exercise-9 (Hindi)

  Page Setup, Scale to Fit, Sheet Options

  • Page Setup, Scale to Fit, Sheet Options
  • Exercise-10 (Hindi)

  Formulas

  • Formulas
  • Exercise-11 (Hindi)

  Text to Column, Remove Duplicate, Data Validation, Consolidate, What if analysis

  • Text to Column, Remove Duplicate, Data Validation, Consolidate, What if analysis
  • Exercise-12 (Hindi)

  Group, UN Group, Sub Total, Spelling, Thesaurus

  • Group, UN Group, Sub Total, Spelling, Thesaurus
  • Exercise-13 (Hindi)

  New Comment, Protect Sheet, Protect Work Book, Track Change

  • New Comment, Protect Sheet, Protect Work Book, Track Change
  • Exercise-14 (Hindi)

  Page Break, Full Screen, Zoom, Freeze Pane, Macros

  • Page Break, Full Screen, Zoom, Freeze Pane, Macros
  • Exercise-15 (Hindi)

  Practical Example

  • Practical Example
  • Exercise-16 (Hindi)