load-gif
Invest in Yourself: Start Learning Now!

Ms Excel

Master Microsoft Excel from basics to advanced! Learn data entry, formulas, functions, charts, pivot tables, data analysis. Boost your productivity and become an Excel pro!

Satyajit Pattnaik

Instructor

What you will learn?

  • Understand the Excel interface, ribbon, and toolbar.
  • Apply lookup functions like VLOOKUP, HLOOKUP
  • Create and customize charts (bar, line, pie, etc.) for data visualization.
  • Use Excel for budgeting, financial modeling, and data-driven decision-making.

This Course Includes

  • Recorded Lessons:  17
  • Recorded Hours:  4
  • Duration:   4 days (Avg)
  • TD Assessment Available
  • 2 Jobs Available
  • Access on Mobile

Course Description

Microsoft Excel is a spreadsheet program that allows users to organize, calculate, and format data. It's a key tool for professionals in finance, accounting, and other fields that require data analysis and organization. 

Here are some features of Excel:

Cells

Users can put data in cells, which can contain numbers, text, or formulas. Cells can be grouped into rows and columns. 

Data organization

Users can add up data, sort and filter it, put it in tables, and build charts. 

Pivot tables

Users can create pivot tables to help them visualize and compute complex data sets. 

Macro programming

Excel supports a macro programming language called Visual Basic for Applications (VBA). 

Functions, formulas, and shortcuts

Excel supports various functions, formulas, and shortcuts to enhance productivity and efficiency. 

Excel is available for Windows, macOS, Android, iOS, and iPadOS. It's part of the Microsoft 365 and Microsoft Office suites of software. 

Some common uses of Excel include: 

Budgeting, Forecasting, Analysis, Data entry, Data management, Accounting, Financial modeling, Charting and graphing, Time management, and Task management.


Course Content

17 Lessons | 3hr 47min


Frequently Asked Questions

You will learn the fundamental and advanced features of MS Excel, including data entry, formatting, formulas, pivot tables, data analysis tools, charts, and more. By the end of the course, you will be able to efficiently use Excel for personal, professional, and business purposes.

No, this course is designed for beginners. Even if you're completely new to Excel, you'll start with the basics and gradually advance to more complex topics.

The course is structured with step-by-step lessons that include theoretical explanations, followed by practical exercises. The course covers various levels, from beginner to advanced, allowing you to progress at your own pace.

Absolutely! The course includes advanced topics such as pivot tables, data analysis tools, and charting, enabling you to effectively analyze and present data.

The course length depends on your pace
Ms Excel
(4.9)
3hr 47min
₹499