Microsoft Excel A to Z in Hindi

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Introduction to Microsoft Excel Getting started with Microsoft Excel Basic formatting Formula / in bult function Conditional formatting Graph Practical usage like EMI calculations

What Will You Learn?

  • Introduction to Microsoft Excel
  • Getting started with Microsoft Excel
  • Basic formatting
  • Formula / in bult function
  • Conditional formatting
  • Graph
  • Practical usage like EMI calculations

Course Content

Getting Started with MS Excel

  • Getting started with MS Excel
    14:30

Basic operations in Excel like sum, divide, count etc.

Vlookup / Auto filters etc. through exercise
This lecture will have six exercise, which will show you part 1 - text filters (starts with / ends with / contains) part 2 - If else , nested if else or condition part 3 - sumif, counif, count part 4 - vlookup / hlookup / fix part of the formula (make it static) and transpose data part 5 - sorting data, paste special values part 6 - text to column (break text into parts) and reverse (concatenate ) texts

Pivot Table and it’s various options through exercise

Bar Chart / Pie Chart / Donut Chart / Dashboard design

Some other advance usage

Student Ratings & Reviews

No Review Yet
No Review Yet