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.
How to Copy and Paste Only the Visible Cells in Excel
In general, when you hide rows or columns or rows and columns, and you are trying to copy just the visible cells in your table to somewhere else, instead of copy just the visible cells on your table, Excel is going to copy everything.In this tutorial I will be showing...
Break Excel WORKSHEET Password Without VBA and 3rd Party Software
It is normal for people to forget their password these days since there are so many things we need to track, Excel password is one of them. In this tutorial I am going to show you how to crack the Excel worksheet password without the need of using a 3rd party software...
Create and Delete Multiple Worksheets with VBA
If one day your manager hand you an Excel file and ask you can you create worksheets for each of the company list in a column, and you see that there are approximately 100 items. And image if you have to create them one by one for a 100 times, that must be a super...
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...
