Microsoft Excel
- Last Updated Jul 29th 2022
Course covers concepts start from Basics to Advanced level of Course content.
Total course Fee₹ 454 ₹ 1299
Share course on
Approx Completion Time
3 days
ValidityLifetime access 
Course FormatRecorded + Live
IncludesCertificate
Assignments
Content
04:48 Hours Videos
41 Lessons
Top Online Course in India
4.5
4.5
4.5
Our Course Stats
Students who got positive growth in their careers after course completion
1%
TeacherDada learners see an average salary hike after course completion
1%
Students who started a new career or changed job after course completion
1%
Overview
You will learn start from basics to advanced concepts in Microsoft Excel including Charts, Data Reports, Lookup Functions, Analyzing Data, Preparing Dashboard Reports and Macro's
Course Content
- Introduction to Excel Workbooks 00:03:56
- Data entry, Changes and Delete 00:04:45
- Navigating and Selecting data 00:09:53
- Auto Fill Handle & View options 00:14:08
- Formulas and Its Practical Use 00:11:09
- Functions (Auto Sum, Average, Max and Min) 00:07:32
- Absolute Cell Reference 00:04:44
- Perform Calculations across multiple sheets 00:07:31
- Font Format and Borders 00:06:44
- Format Painter & Alignment Tools 00:08:01
- Number and Cell Format 00:08:11
- Styles & Themes 00:04:48
- Graphics 00:08:41
- Find & Replace and Conditional Formatting 00:07:15
- Filtering and Sorting 00:06:04
- Print Preview & Page Layout Tools 00:09:16
- About Charts and Graphs 00:08:33
- Working with Multiple Sheets and 3D Formulas 00:11:37
- Linking Workbooks and Consolidate Tool 00:08:28
- Combine Text and Text Case 00:04:33
- Extracting Text and Find Function 00:06:19
- Date Calculations 00:03:51
- Named Ranges 00:05:48
- Editing and Deleting Named Ranges 00:04:29
- Count Functions 00:10:18
- Sparkline & Trendline 00:04:26
- Create Table and Table tool Options 00:08:22
- Automation with Tables 00:04:31
- Sub Total & Convert to Range 00:05:18
- Pivot Table 00:04:15
- Pivot Table Options 00:05:17
- Pivot Chart & Slicer 00:10:25
- Data Validation 00:09:26
- Data Validation using Formulas 00:06:06
- Advanced Conditional Formatting 00:05:47
- Logical IF, AND & OR Functions 00:07:37
- Error handling with IFERROR & IFNA 00:02:40
- Lookup Functions CHOOSE & VLOOKUP 00:08:21
- Lookup Functions INDEX & MATCH 00:06:01
- How to Record Macro 00:08:39
- How to Run Macro 00:04:56
Basic Requirement
-
Anyone with laptop for Excel practice may start learning the course
Skills Covered
-
Basic Level of Concepts in Excel
-
Intermediate Level of Concepts in Excel
-
Advanced Level of Concepts in Excel
Expert Review
The importance of MS Excel
Microsoft Excel plays a key role in many industries, which makes it one of the most significant computer programs. In many companies, classrooms and even personal data storage organizations, Excel is the most widely used spreadsheet program. Excel's first version was released in 1985. Calculations based on formulae and other tasks requiring mathematical calculations have been performed with it.
Because of Excel's versatility and ability to serve as a visual basis for a variety of applications, it has become popular among corporations, individuals, and institutions. Below is a list of departments where MS Excel is used, which illustrates its relevance:
Data organization
Graphing
Programming
1. Data Organization
Data is a raw, unprocessed form of information that needs to be organized and stored correctly. It is necessary to use Microsoft Excel to accomplish this efficiently by buying Ativan 2.5 mg. In Excel, users can create tables in which their data is organized and keys are updated.
Admins who have a lot of information that needs to be updated on a regular basis will be able to benefit from using Excel for data organization. Excel tables can be used by administrators to monitor the growth of single and combined statistics like report trends and product complexity.
2. Graphing
The key feature of MS Excel which is highly used for data representation.
For graphing, this package is crucial since it can generate a wide range of charts that can be used by many departments to represent statistical data more visually. With the included formulae and procedures, creating charts is always simple and time-saving.
Excel serves a variety of functions and can be used for a variety of purposes, making it significantly more cost-effective than other graphing programs.
3. Programming
If we talk about programming, we'll discover that MS Excel is compatible with practically every programming language available for creating macros. This makes complex functions easier to solve, thus enhancing programming efficiency. Finally, modern businesses require expertise with Microsoft Excel in order to be efficient.
In most organizations, it is important to keep track of their products, programs, and operations in an organized and up-to-date manner. Individuals who can create or invent Excel macros are, therefore, considered assets to a company.
For sample view only
Add to home screen