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.
Building a folder generator app in Excel
In this tutorial I am going to show you how to create a Folder Generator App in Excel. We will be writing some VBA to perform the folder creation. Download the template Download Download the final file Download VBA Code:
read moreReporting Automation For Beginners (Code Included)
Microsoft Excel Reporting AutomationExcel VBA makes a amazing tool to automate reporting. If you work in Accounting or Finance, then being able to create a macro to automate a reporting that usually takes half hour to merely just a minute, and you can re-use the the...
read moreHow to create a progress bar userform with Excel VBA
Excel Progress Bar UserformA progress bar is a great way to presenting the current progress of something that is currently running. In Excel, the software does not come with a progress bar widget by default, but that does not mean we cannot create it on our own.In...
read moreGet the Unique Count From A Duplicate List Based On A Criteria
Believe or not, I have encountered this problem quiet many times - "How to get the count of unique items from a column from a table that has duplicate records or has multiple layers.In this tutorial I will show you how to use an array formula to get the unique count...
read moreVBA Function To Check If A File Is Open
In this tutorial I will share a VBA Function (User-Defined Function) that can detect whether if a file is currently opened.
read moreSave a Backup Every Time When You Save Excel File
If you are working on a very critical project (like an audit), and you would like to keep a record of things every time when you save your Excel file. Despite Excel doesn't provide the feature - save a backup when saving -, we however, can create the feature on our...
read moreSend an Email Every Time When You Save Excel File
With Excel VBA, you can implementing features that are not even exist in Excel. In this tutorial we will be creating an auto emailing feature every time when you save your Excel file a macro will automatically fire and sending an email either to yourself or to whoever...
read moreCreate an Excel Investment Portfolio Tracker Template
Excel has has improved much since the early day when I started using Excel 2003. With the latest Office 365 update, you can now use the stocks feature to import live stock information.In this tutorial, we will be learning how to build the a Investment Portfolio...
read moreHow to Align Any Excel Form Controls with Simple VBA
If you are someone who works with Excel Form Control a lot, then I think you will find the VBA script that I am going to share with you in this video to be very useful. Often times, one of the most painful steps when working with Form Controls is to align them; it is...
read moreHow 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...
read more