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 ...

Dana Miranda is a Certified Educator in Personal Finance, creator of the Healthy Rich newsletter and author of You Don't Need a Budget: Stop Worrying about Debt, Spend without Shame, and Manage Money ...

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 ...

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 ...

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 ...

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 ...

While Microsoft Excel is capable of countless tasks, sometimes it feels like we are only scratching the surface of what is truly possible. What if you could streamline your processes, improve ...

Excel in Office 365 is a very versatile app. The built-in features of Excel make it able to be the building block for so many projects. While we cannot predict or avoid all disasters, our response to ...

Claire Boyte-White is the lead writer for NapkinFinance.com, co-author of I Am Net Worthy, and an Investopedia contributor. Claire's expertise lies in corporate finance & accounting, mutual funds, ...