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.

My Calendar Insights - 2

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.

My Stock Analysis - 3

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.

My Cashflow - 4

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:

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:

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.

The post Use Excel 2016 like a boss appeared first on Office Blogs.
Source: Office Blog

%d bloggers like this: