Have you ever wanted to manage your time like a CEO, understand your cashflow like a CFO or analyze your NASDAQ stock performance like a Wall Street pro? Executives get a lot of help from others to build insights, and now Excel 2016 can do the same for you with a few clicks.
Several new business analysis feature tours highlight how you can use Excel 2016 to Get & Transform data, use Power Pivot to model and analyze data and visualize that data in new ways. You can find these feature tours in the Excel template gallery.
The new business analysis feature tours
To access the new feature tours in Excel, you should be running the new Office 2016 that is available with Office 365. When you open Excel you will see the feature tours as shown in the image below.
Manage your time like a CEO
You probably asked yourself more than once, “How am I spending my time and with whom?” The My Calendar Insights tour can answer these questions for you.
The My Calendar Insights tour seamlessly connects to your Exchange account and surfaces how much time you spend in meetings, who you meet with the most, who you do not meet very often and the times of the day you frequently meet.
Analyze your NASDAQ stock performance like a Wall Street pro
Ever wanted an online stock analysis tool that you can customize to fit your needs? The My Stock Analysis tour gives you a snapshot of NASDAQ stock performance—in real time.
Using freely available NASDAQ historical data, the My Stock Analysis tour allows you to quickly analyze and compare the performance of three symbols over a selected period of time. If you like, you can also easily customize it to look the way you want.
Get insights about your year-over-year cashflow like a CFO
Ever wondered if you cut spending as much as you predicted or how an increase in your annual bonus can improve your financial state? The My Cashflow tour can figure it out for you.
Once you are done entering your expenses and income to a dedicated table in the My Cashflow tour, it immediately provides you with year-over-year insights to help you balance your home or business budget and meet your financial goals.
Learn more about the business analysis feature tours
Click the Learn More tab to learn more about each tour and how each one can be customized, or just click the following links:
- How to use the My Calendar Insights tour with Excel 2016
- How to use the My Stock Analysis tour with Excel 2016
- How to use the My Cashflow tour with Excel 2016
You can also expand your knowledge on the technologies that were used to create the business analysis feature tours by exploring the content in the following links:
- Learn more about Get & Transform features
- Learn more about Power Pivot, a powerful data modeling and analytics tool in Excel
- Take a free course on Analyzing and Visualizing Data with Excel at Microsoft Virtual Academy
Tell us what you think
This is just a glimpse of how you can benefit from the new business analysis feature tours in Excel 2016 for desktop. Try them out yourself and let us know what you think at the Excel UserVoice or leave a comment. Please note that the business analysis feature tours are currently only available in English.