Course Includes
- Recorded Lessons: 13
- Total Hours: 01:42
- Duration: 2 days (Avg)
Course Features
- Access on mobile
- TDP Assessment Test
- 3 Jobs Available
Top Skills Covered
Overview
Course Description
EXCEL Course:-
In this course, we will start from basic of excel and we will learn practical & official use of excel.
also we will review some tricks which having videos.
If i talk more about excel,
MS Excel, also known as Microsoft Excel, is a widely used software in most companies or businesses worldwide. It provides various tools, functions, and features to make this software profitable for global companies in various fields. Therefore, to learn and properly organize data using Excel, we must know the definition and basics of this powerful software.
n simple words, MS Excel is a powerful spreadsheet program included with Microsoft Office and is mainly used to record data in tables. It consists of several rows and columns, which can be used to enter data. The program is considered helpful for various tasks, such as calculating weekly expenses, making payslips, accounting, and interactively sorting/filtering data by various criteria.
Excel played a crucial role in performing various financial operations for the enterprises, including bookkeeping and record-maintaining. However, it has received several updates over time, which typically helped in making excel a must-have software for business processes. The latest version of Excel comes with a wide range of features.
MS Excel is widely used to organize data and perform easy to complex calculations for getting outputs for financial analysis. It is preferred in almost all business sectors and at companies from small to large scale.
Despite this, it is also used for managing expenses and other data-based things for home requirements. It is not wrong to say that the uses of MS Excel are almost infinite. Different people use this powerful software as per their needs.
Some of the essential uses of MS Excel are listed below:
- Data Entry
- Data Management
- Financial Analysis
- Financial Modeling
- Accounting
- Time Management
- Task Management
- Programming (VBA)
- Customer Relationship Management (CRM)
- Charting, Graphing, and Reporting
What you'll learn
Requirements
Course Content
13 Lessons | 01:42 Total hours
Introduction & First Practical
-
Let's Start
00:10:00
Basic Functions & Formula
-
10 Most Usable Basic functions
00:08:26 -
Basic Tools in EXCEL
00:06:49
Graphical Format
-
Represent Data in Graphical Format
00:07:00
Text Function
-
10 Important Text Function in EXCEL
00:09:02
Conditional Function
-
Conditional Function in EXCEL
00:06:43 -
Sort & Filter
00:04:09
Security & Protection
-
Apply Security & Protection in EXCEL
00:05:49
Practical
-
Salary Sheet Job Level
00:14:04 -
ATTENDANCE SHEET
00:13:33
LOOKUP FUNCTIONS
-
LOOKUP FUNCTION in EXCEL
00:04:31 -
VLOOKUP Function in EXCEL
00:07:43 -
HLOOKUP Function in EXCEL
00:05:07