1
Introduction to MS Excel 2016 interface
2
Excel Functions (String Functions)
3
Excel Function (LOOKUP)
4
Excel Function (Number)
5
Pivot table and Pivot chart in details
6
GETPIVOTDATA Function
7
Slicers
8
Spark lines
9
Conditional Formatting
10
Power Query and Power Pivot
11
Introduction to Excel Data Modelling
12
Date functions in Excel
13
Creating custom format
14
How to handle date values in string format
15
Creating a Dashboard in Excel
16
Macro Recorder Introduction
17
Introduction to VBA Macro
18
Excel Visual Basic Editor
19
Types of Errors in VBA
20
Writing simple codes in VBA editor
21
Concept of variables
22
Example codes
23
Loops
24
Conditional logic
25
Creating user defined functions
26
Application MIS Data
27
Creating user form from scratch
Related Courses
Application Development
Full stack Development with Java refers to the process of utilizing Java to develop front end and back end of web applications. Developers can get ...
Free
Datascience and Analytics
Data Science is the science of mining and analyzing available data at a granular level using various known algorithms and techniques. It helps to u...
Free
Ethical Hacking
Ethical hacking is an authorized practice of detecting vulnerabilities in a system or an application by gaining unauthorised access to that system ...
Free