Intermediate Tutorial
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.
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.
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.
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.