Most people are still using Excel like it’s 2010 with functions like INDEX MATCH, SUMIFS, or VLOOKUP. In this video, we’ll explore 5 NEW Excel functions that can replace numerous old ones, allowing ...

Users will appreciate a chart that updates right before their eyes. In Microsoft Excel 2007 and Excel 2010, it’s as easy as creating a table. In earlier versions, you’ll need the formula method.

As an Excel pro, I could use the old Excel 2003 menus with my eyes closed. I knew where commands were located. I knew the Alt shortcut keys for the commands that I used frequently. Alt+E+S+V was Edit, ...

Steven Nickolas is a writer and has 10+ years of experience working as a consultant to retail and institutional investors. Charlene Rhinehart is a CPA , CFE, chair of an Illinois CPA Society committee ...

Office 2010 comes with a ton of great features, especially in its ability to connect with SharePoint 2010 and provide the collaboration capabilities that modern Office users need. However, that ...

Sean Ross is a strategic adviser at 1031x.com, Investopedia contributor, and the founder and manager of Free Lances Ltd. Samantha (Sam) Silberstein, CFP®, CSLP®, EA, is an experienced financial ...

Microsoft Office Excel 2010 allows you to create spreadsheets and analyze figures using an updated user interface. If you make any deletions to an Excel 2010 document, you have few options to recover ...

The unparalleled data manipulation and stats organizing tool Microsoft Excel is no doubt a time saving app, but just like its sister tools Word and PowerPoint, it too has some hidden features. By ...

When you multiply a number by a power, you are really just multiplying that number by itself a number of times equal to the power. This means that, for example, 2 multiplied by a power of 3 is the ...