Category: Excel 2016

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

New functions of Excel 2016

Function MAXIFS

With the new release of Excel 2016, six new very interesting functions have been added in three libraries. Library Text Function CONCAT Combines the text from multiple ranges and/or strings, but it doesn’t provide the delimiter or ignore empty argumentsThis function depreciates CONCATENATE Example of the function CONCAT – No delimiter between each cells Function …

Continue reading