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.

 

 

Merge Multiple CSV Files in Excel with VBA

Merge bunch CSV files into one single Excel file manually requires a lot of time and efforts, and on top of that, it's a painful task. What if you can automate the process with just a single macro?In this tutorial, I will teach you how to write a VBA script to merge...

read more

Delete Rows with Strikethrough Texts in with Excel VBA

Quiet often when you collaborate with a team member or group of people on a Excel spreadsheet, when the most commonly thing is people will apply strikethrough to the items or texts they want to remove from the file. Not sure why in Excel, there is no function to...

read more

Count Visible Rows in a Auto-Filtered List

When you apply an autofilter to a table or a cell range, you can use the SUBTOTAL function to count just the visible rows. The SUBTOTAL function is multiple functions built in one function with different methods (AVERAGE, COUNT, COUNTA, MAX, MIN, SUM, etc). In this...

read more

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

read more

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,...

read more