Dennis O'Reilly began writing about workplace technology as an editor for Ziff-Davis' Computer Select, back when CDs were new-fangled, and IBM's PC XT was wowing the crowds at Comdex. He spent more ...

If you are looking to improve your Microsoft Excel spreadsheet and data analysis skills you may be interested in this Advanced Excel Tips & Tricks tutorial from the team over at SSIT. Mastering ...

If you have to deal with boring spreadsheets on a daily basis, every tiny little trick that saves you time is worth it—and the Pointy Haired Dilbert blog runs down a whole list of useful tricks. The ...

One of the most common problems with some Excel workbooks (and other types of spreadsheets) is painfully slow load times and updates. There are three typical cuprits: too many calculations, too much ...

If you work in a corporate environment, you'll most likely have to work with an Excel spreadsheet from time to time. It may even be a requirement for some jobs. But so many of us don't know how to use ...

In this article I am going to show off five top Excel tricks for making your spreadsheets sing and to help edit and refine your sales and commissions spreadsheet. These tricks make it easier to create ...

If you work with data much, you don’t need a statistical model to predict that the odds of consistently getting data in the format you need for analysis are pretty low. Those who do a great deal of ...

You're currently following this author! Want to unfollow? Unsubscribe via the link in your email. Follow Nathan McAlone Every time Nathan publishes a story, you’ll get an alert straight to your inbox!

Excel macros allow you to automate all sorts of tasks, from entering commonly used data to automatic printing and saving of files. Once you start to use Excel, it takes no time at all to create a ...