About Lesson
Basic Mathematical Functions
In this session, we are going to learn some basic mathematical functions.
0/7
Absolute and Relative References
In this session, we will learn most common but important concept of cell referencing.
0/3
Conditional Formatting
In this session, we will learn feature which will make boring data table into colorful, stylish and dashing table.
0/5
Group and Ungroup
In this session, we will learn how to use grouping and ungrouping of columns as well as rows.
0/3
Text Functions
In this session, we will learn various text functions to clean and organize the text data properly in analyzable format.
0/5
Advanced Text Functions
Here, we will learn some advanced text functions such as find, search, replace etc...
0/3
Date Functions
We will learn some basic and advanced date functions to use date and time dynamically. Also, we will cover calculation of working days by setting up holidays dynamically.
0/5
Paste Special
Paste Special is a wonderful tool to increase productivity specially while copying data from some other table or sources.
0/1
Logical Functions
We will learn one of the most efficient functions to perform calculations dynamically based on the condition called IF.
0/6
Data Validation
We will learn data validation functionality in Excel. It will cover how we can set specific inputs in the cells so that data entry errors can be avoided.
0/5
Lookup Functions
In this session, we will learn how to use various lookup functions such as VLOOKUP and HLOOKUP with various examples.
0/6
Is Functions
In this session, we will learn IS function which is used to validated/ check current data for specific format/ type.
0/1
Round Functions
It is very important to round up values specially in accounting. There are various ways you can round up the values. We will learn that.
0/3
Sorting
We will learn various sorting options in this session such as sorting yb text, numeric, date etc...
0/3
Pivot Tables
Pivot tables are the magical tools in the Excel to summarize large data in a concise format.
0/4
Varieties of Charts and its importance
There are various charts can be prepared in excel but we need to know which chart can be prepared for which type of data.
0/3
Interactive Dashboards
Data visualization is one of the key elements of report/MIS presentation nowadays, which can be done through a modern tool like interactive dynamic dashboards.
0/11