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