Intermediate Tutorial

Intermediate Tutorial

How To Add Developer Tab In Excel
Intermediate Tutorial

How To Add Developer Tab In Excel

The Developer tab enhances the power of Excel. This is a hidden menu, and you need to add it to the ribbon. In this tutorial, you’ll learn how to add developer tab to Excel Ribon.

How to Lock and Hide Formulas in Excel
Intermediate Tutorial

How to Lock and Hide Formulas in Excel

Locking a formula means no one can edit or delete your formula except you, and hiding a formula in Excel means no one can see your formula. In this tutorial, you’ll learn to do both at once.

How to Automatically Enter Date and Time After Data Entry in Excel
Intermediate Tutorial

How to Automatically Enter Date and Time After Data Entry in Excel

An automatic system using an excel formula that allows you to populate date and time when data is entered into a different cell, leaving you with endless opportunities in excel.

How to Import Each File Details from a Folder into Cells in Excel
Intermediate Tutorial

How to Import Each File Details from a Folder into Cells in Excel

In this Intermediate excel tutorial you'll learn to import important file details using Power query. This will be a dynamic Data table and you don't need any VBA to do this.


follow the MS Excel tutorial