For the most part, you're probably accustomed to using Microsoft Excel for tasks such as preparing reports, forecasts, and budgets. However, Excel is much more powerful than that. It can be used to ...

While Excel is renowned for its versatility in calculations and data visualization, it can also do the job just fine as a database. Small businesses, non-profits, and even departments within larger ...

While Microsoft Excel is widely recognized for its spreadsheet functionality and calculation capabilities, it’s often ...

We have users who cook up little Excel sheets for simple things such as logging a bit of data or events (e.g. products received from suppliers that are non-conformant). It usually starts as 1 person's ...

Inserting a pivot table in a sheet in Excel 2013. Image: Screenshot by Susan Harkins/TechRepublic When is the last time you opened Microsoft Excel to do some data science? If it's been a while, you're ...

Simplify your data transformation by skipping complex parsing expressions and instead using Flash Fill and Power Query in Microsoft Excel. Image: IB Photography/Adobe Stock If you work with imported ...

If you have to jointly author a spreadsheet with a colleague, what is the first thing that you do? Email it back and forth. This can be painful, particularly as you try to keep track of your partner’s ...

How to reverse and transpose Excel data with this powerful but simple solution Your email has been sent Reversing and transposing an Excel data set doesn't have to be a complicated process. Susan ...

LongJump, a Sunnyvale, Calif. company is the latest company offering a simple “database as a service” product, following on the heels of similar services announced by Amazon (see its S3/SimpleDB ...