Similar Posts
Find Duplicate Files In Excel Using VBA
How to Find Duplicate Files In excel using VBA? Yesterday I was working on my computer and cleaning the drives to make some more space. I was surprised to see so many files saved at…
How to Create Pie Chart in Excel (Complete Tutorial)
Pie Chart is one of the ways of visual presentation of your data sets. Sometimes it makes easier to understand the data while visualizing.
VBA Code to Get User Name
This Excel VBA Code helps to Get User Name. Here is an example environ(username) or Application.username.This macro gets the username from active directory.
Impress your Clients by Hiding these Simple Features
How to Hide Ribbon &Formula bar in excel? While preparing many projects, my clients always want me to make professional, good looking dashboards. So I hide few things like Gridlines, Column & Row headings and…
HOW TO COMPARE TWO COLUMNS IN EXCEL
How to Compare TWO Columns in Excel? Comparing Columns in Microsoft excel is much often feature that is used while managing database. We have many ways to compare the columns in excel and can be…
Lock Cells to avoid editing, Hide Formulas
Lock Cells to avoid editing, Hide Formulas Sometimes you create amazing projects, dashboards however people can make mistakes and edit the calculations, formats what you have made. Still you can protect the sheets, workbooks and…