Picture this: it’s Friday afternoon, and you can just about taste the weekend. Then, you get an email from your executive asking for help pulling together a last-minute report for Monday morning based ...

Much of the data that you use Excel to analyze comes in a list form. You might need to sort the data, filter it, sum it, and perhaps even chart it. Excel tables provide superior tools for working with ...

This is a simple demo on how to perform basic operations like Create, Read, Update and Delete information stored in an Excel table with a userform, a listbox and some command buttons. To use it just ...

Microsoft Excel 2010 comes with an expansion pack called the Analysis ToolPak that includes a number of analylitical tools, like the ability to create a liner regression table. Even though the ToolPak ...

Following on from our time saving Excel shortcuts, we continue offering updated advice for the time-sensitive spreadsheet enthusiast. Back in 2013 John Gagnon wrote a very popular post about VLOOKUP ...