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.
Calculate How Long Does It Takes For A Macro To Run using VBA
For various reasons, you want to calculate how long does it take for a macro to run from start to finish. Using few lines of simple VBA, we can quickly figure out how long does it take for a macro to execute.
Files and Folders Management with FileSystemObject in VBA
In general when we write VBA scripts we either trying to automate an office application task like in Excel, Outlook, Word, or Access, or we are trying to implement a functionality to an existing program. One thing makes VBA versatile is its ability to work with...
A Better Way to Perform a Vlookup (or just any lookup) in VBA
Knowing how to perform a lookup task is important and critical in Excel. Majority of the spreadsheets out there probably have some sort of lookup formula embedded. Perform a Vlookup task is pretty easy on the Excel UI, you simply use the VLOOKUP (or INDEX/MATCH)...
List Hyperlinks From All The Worksheets with VBA
If you work with an Excel workbook that contains many hyperlinks across many worksheets, and you want to create a report to list out the information of each hyperlink, doing that manually sounds crazy to me (I have seen that in real live that actually...
Conditionally Change a Symbol Based Different Values
In Excel, you can insert different symbols using the Webdings, Wingdings font styles. But a major drawback using those font styles is, if a user change the font style to something else, the symbol will then disappear. In this tutorial, I will show you an elegant way...
Send Email From Your Gmail Account with VBA
Gmail, the world most popular email service developed by Google. Today just about almost everyone owns a Gmail account. We know it is pretty easy to create a VBA script in Microsoft Excel to integrate with Microsoft Outlook, from there, we can send an Outlook email,...
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...
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...
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...
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...
