Microsoft Excel Tutorial
Microsoft Excel, probably one of the most important software ever created. With more than one billion Microsoft Office users worldwide, it is hard to live without Excel these days. You can use Excel for so many things; organizing personal finance information, building customizez caulcuator, performing different types of analysis, making stunning graphs, and much more.
I hope from my blog, you will learn many new Excel skills to help you to work more efficiently.
Password Protect and Unprotect a Group of Worksheets with Excel VBA
Protecting a single worksheet is pretty easy, you simply hover your mouse, right click, and select Protect Sheet. But what happens if you are working on a Excel workbook that has like 50 worksheets and you want to password protect just certain worksheets?In this...
Turn Off the Privacy Warning Notification
When you work with Excel files that contain macros, ActiveX Control, userforms, or connect to an external data source, sometimes, you will get those annoying Privacy Warning message "Be careful! Parts of your document may include personal information that can't be...
5 Lesser Known Excel Features to Boost Productivity
As we all know, Excel is a very useful application that has many features. You can use Excel to do things like a building a database, a data entry sheet, creating pivot table and more. Because there are way too many features in Excel sometimes it can get a little bit...
3 Ways To Work With Duplicate Data in Microsoft Excel
Sometimes when we perform data entry task, or copying data from somewhere, we occasionally encounter the issue where some data are duplicate. Unfortunately, In Excel, dealing work duplicate records aren't that difficult.In this tutorial, I will show you 3 ways of my...
Format Date To Quarter and Year
In Excel, there no built-in formatting that converts date as quarter (plus year). In this quick video, I will show you how you can easily format dates to quarter and year in Excel using simple formula.
Implement Audit Trail Feature to Track Changes
An audit trail is a record or log captures a change. For example, when you change a product price from $10 to $15, the change in the $5 difference is a trail. Audit trail is commonly used in accounting, finance, retail, and other industries. Unfortunately in Excel,...
Perform a Lookup Based On a Value Between Two Values
By default, when you perform a look up (VLOOKUP or INDEX/MATCH) in Excel, you can only match a value either by exact match or approximate match. If you want to look up a value in a range or between two dates, you can use something called array formula. In this...
Find the Last Row and Last Column in Excel using VBA
When writing VBA, one of the most important things is to figure out the table dimension, like figuring out the last row and last column of a table. Using VBA, we can easily write just few lines of code to find the last row and last column index.
Create a Vlooup Function To Extract All The Associated Values
One of the limitations with Excel VLOOKUP function is that, when you have multiple matched values, the function will return the first matched record. In this tutorial, I will show you how to create a Used Defined Function (UDF) to perform VLOOKUP that can extract...