How to Hide Columns in Excel
Beginner's Tutorial

How to Hide Columns in Excel

Hiding columns can come in handy in different situations. It could be for presentation, organizing data, privacy, or simply to avoid a column from printing. Here you’ll learn 3 ways to hide columns in excel.

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 Copy An Entire Row To Another Worksheet Based On Cell Value In Excel
Advanced Tutorial

How To Copy An Entire Row To Another Worksheet Based On Cell Value In Excel

In this advanced Excel tutorial, you’ll learn how to copy data from one sheet to another based on cell value in Excel using VBA. It is easy and takes only two minutes.

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 Lock Cells with Formulas in Excel
Formula & Functions

How To Lock Cells with Formulas in Excel

Locking or protecting cells with formulas is crucial for calculations. This will stop other people from deliberately or mistakenly editing or deleting your formula in Excel.

How To Hide Formulas in Excel
Formula & Functions

How To Hide Formulas in Excel

Sometimes we need to hide sensitive formulas so that no one can see them. You can hide formulas with and without a password, and it only takes a minute.

How to Capitalize the First Letter of a Sentence in Excel
Formula & Functions

How to Capitalize the First Letter of a Sentence in Excel

Capitalizing the first word of a sentence in Excel is really easy and you can do that using a formula. In this article, you’ll learn the quickest way to do it.

How to Create Multiple Folders on Your PC Automatically Using Excel
Advanced Tutorial

How to Create Multiple Folders on Your PC Automatically Using Excel

Learn to create thousands of folders on your computer automatically using excel. You can either add a list of names or type them one by one.

6 ways to remove formulas and keep values in Excel
Beginner's Tutorial

6 ways to remove formulas and keep values in Excel

Converting formula results into value is crucial. Every now and then we need to remove formulas, keeping the results as values, and here you’ll learn 6 ways to do that.

How To Subtract Dates in Excel
Formula & Functions

How To Subtract Dates in Excel

In this Excel tutorial for beginners, you’ll learn how to get the number of days, months, or years between two dates in Microsoft Excel using a formula.


follow the MS Excel tutorial