Excel
How to Create a New Formula in Excel
The level 1 comprehensive tutorial for understanding the usage of SumProduct Excel Function
SumProduct Function
The level 1 comprehensive tutorial for understanding the usage of SumProduct Excel Function
Excel Filter Basics to Advanced
Filter Basic to Advanced including, modern usage of filter such as Slicer, Timeline, and the new Formula to filter required content along with a...
Pivot Table for Basic MIS Executive
16+ Pivot Table Lessons included – A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns,...
Master in Vlookup
A complete tutorial for mastering in VLOOKUP which is suitable for MIS Executive, Accountants, Managers, Admins, Students and Freshers.
How to Protect Excel Files
Protecting your Excel file prevent the access of the content from other users
Excel Data Validation & Drop-down
Basics of Data Validation along with a Simple Drop Down List, Data Validation with Vlookup, Dependent Drop-down, Circle Invalid Data Using Data Validation, Restrict...