MS Excel Blogposts

Entering data, applying a formula here and there, and formatting a worksheet by hand works fine for small, one-off tasks. It starts to break down once the work involves larger…

Anyone who works with Excel regularly runs into the same problem: certain tasks repeat every week or month without changing much. Reformatting a report before sending it out, copying data…

A formula that worked fine last week sometimes breaks today, and nothing in the sheet looks different at first glance. Someone added a row, deleted a column, or pasted data…

An interactive dashboard in Excel brings large amounts of data into one clear, visual report that updates as filters change. Instead of scrolling through rows of raw numbers, a manager…

Did you know that you can actually use Microsoft Excel for a variety of other activities, including invoice templates? While it seems incredibly complicated, the actual process of creating invoice…

Microsoft Excel is a treasure mine of hidden goodies- everywhere you look, there are functions, features and formulas waiting to be discovered. The possibilities of what one can achieve with…

If you are looking for Excel 2013 videos in order to brush up on your skills and effectively learn through visual engagement, you don’t have to spend too much time…

Prevent yourself from getting overwhelmed when working with large amounts of data everyday by learning to keep track of your data with Excel worksheet annotation. Not only will it be…

Nested functions can potentially improve your Excel project quality, only if you understand it and use it well. Keep these in mind and you will be able to use it…