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. Each element (chart, map, table of value) can interacted with the others. For instance, if you select a slice of the pie chart, this will …

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 arguments This function depreciates CONCATENATE Function TEXTJOIN Better than the CONCAT function (it’s strange that Microsoft …

Continue reading