Writing macros in Excel is a great way to automate a a bunch of tasks. We have shown you before how to automate Excel with macros or VBA, but this post is about letting you see a progress bar while they run. As you probably already know, when you run macros in Excel you don’t really know when they are done or crashed, until its too late. Having a progress bar while running macros in Excel would be a big help. Here is how you create a user form that shows a progress bar for your macros.
Making a table is a great way to organize your data in Microsoft Excel. This feature is only available for Excel 2007 and up. If you still have an older version of Excel, you can use ranges to organize your data. But you will not get the added benefits for having a nice table. Here […]
If you spend a lot of time copying and pasting data from on Excel sheet to another you might want to think about automating the process. Automating task in Excel can be easily done by using a macro or with some VBA code. For this tutorial we will show you how to copy cell value in VBA […]
A PDF file is used a lot more of document distribution and publishing. Since it is a lot easier to deal with than the default file formats in Office. Luckily for us, Office 2010 has conversion tools to convert your documents to PDFs. Here is how to convert Office 2010 files to PDF using the built […]
Microsoft Excel has many functions. One of them is called the ISERROR function. With ISERROR you can return a true or false value if there is an error or not. Here is how to use the ISERROR function in Excel 2010.
Love using Excel as a financial tracking spreadsheet or a calculator? Here is an easy way to calculate a loan payoff in Excel 2010
Here is a quick Excel how to! Remove those hidden shapes or objects form your workbook to help speed it up or just reduce its file size.
Having a lot of Office documents open can be very counter productive especially if you only have one monitor. There is an easy and free way to create tabs in Word 2010, Excel 2010 and PowerPoint 2010 to help minimize the clutter on your computer. Here is how to add tabs in Word 2010, Excel […]
In Excel 2010 just like any other version of Excel you usually see letters, ABC, in the columns. If you want to change Excel 2010 columns to numbers, like 123, or change them back to letters here is how to do it. Change Excel 2010 Columns to Numbers Open Excel 2010 and click on the […]
Have you ever had the need to print each column header in Excel 2010 on every page in the workbook, here is how you can do this.