Category: Excel 2013

Power BI with Excel

Power BI is the name gives by Microsoft to a bunch of tools to create amazing dashboard. Limitation of Excel For many people Excel is a tool that is used for its formulas, graphs or macros. I can’t blame them, I’ve worked that way myself for years. However, no one will have missed that an …

Continue reading

Power View

Power View

POWER VIEW has been deprecated. Now you must use Power BI Desktop Presentation of Power View Power View was a tool in Excel 2013 Pro Plus to create interactive dashboard. Dashboard generated with Power View Each element (chart, map, table of value) can interacted with the others. For instance, if you select a slice of …

Continue reading

Move between workbooks

SDI is the abbreviation for Single Document Interface. SDI means that each workbook opens in its own window and has its own interface. This provides a lot of useful functionalities. Benefits of dual screen with SDI When you work with two monitors in a dual screen setup, showing two workbooks in the same Excel instance …

Continue reading

Discontinued features in Excel 2013

In Excel 2013, 13 features of Excel 2010 have been discontinued or significantly changed. Here is the list and the links. Browser View Options are in a different location Pyramid and cone chart types have changed to column and bar chart shapesSave as Template is no longer on the Chart Tools ribbonThe blank workbook on …

Continue reading

Presentation of Power Pivot

Power Pivot is a new tool of Excel 2013 that allows you to perform calculations on an unlimited number of rows. The calculation can be done with calculated columns, like in Excel, or with measures. It all starts with SQL Server Before to explain how to use Power Pivot, it is important to know that …

Continue reading

50 new functions in Excel 2013

With Excel 2013, 50 new functions have been added. Here they are and for some of them, few extra explanations. Most of them are dedicated for top level engineers or statisticians. But there is also some very useful functions for a daily practice of Excel. Date and time 2 new Date and time functions. ISOWEEKNUM …

Continue reading

What’s new with Excel 2013

A lot of changes have been made to the Excel 2013 user interface. Let’s see them 😃 Modern User Interface (UI) First time you open Excel, you could be surprised to discover the new color set. Only 24 colors are used in the ribbon and the Excel window presentation. 24 is not a lot but …

Continue reading