Microsoft Office 2013 has a bunch of new features into it. One of them is called the Start Screen. The Start Screen is a quick way to open recent documents and files, open templates, and even open other files. The Start Screen is good for those who like seeing this interface. But if you prefer […]
Various how to, help, tutorials and tip articles about all version of Excel, Word, PowerPoint, Outlook, Access and other Microsoft Office Products.
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.
Due to the advanced and efficient features of MS Outlook almost every organization uses it for their official communication and so does ours. Yes, my organization too uses MS Outlook as email client for professional communication. As we all know this robust application, time to time launches its various versions which have some or the […]
Microsoft Outlook has a new attachment size limit of 20 MB. If this doesn’t seem like a whole lot, or you are constantly getting this error “The attachment size exceeds the allowable limit.” it might be time to fix fix that. Here is how to increase the Outlook attachment size limit with a quick and […]
In Outlook 2010 the default size limit of a Personal folder or PST file is 50 GB while Office 2007 and 2003 have a 20 GB limit. That is a lot of email if you chose to fill them. While this space looks like a great alternative to your limited exchange account, if you have […]
Tried of Outlook blocking certain attachments. Here is how to unblock Outlook 2010 blocked attachments with Attach Unblocker.