Frédéric LE GUEN

Most commented posts

  1. Power View — 2 comments
  2. New release of Excel — 1 comment
  3. What’s new with Excel 2013 — 1 comment

Author's posts

Tree Map chart

Tree map chart

A tree map chart gives you a vision of the size of your data by area. The more then area is big, the more the data is important. With a tree map chart you can see at a glance which element has the biggest size, percentage, value. You can have and example with the New …

Continue reading

Sunburst chart

Sunburst chart

With a Sunburst chart you can present your hierarchy data in a very comprehensive way. In this article, we will see how to visualise the contain of a folder and sub-folder but a sunburst chart could be also the best chart to see the hierarchy in a company (for the number of employees, for the …

Continue reading

Export folder or file list to Excel

Export files from folder

Export the list of files contained in a folder or sub-folders has always been a difficult task. Now with Power Query this job is as easy as 1-2-3 😎😃😍 But more, if you don’t want the list of files but just the folder and sub-folders name, it’s also easy. Connect Power Query to a path …

Continue reading

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

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

The logic of Power Pivot

Working with Power Pivot it isn’t hard. In fact it’s easier than Excel but the logic is totally different. But if you respect the next 3 rules, you will be able to build measures for your model Rule 1: Structure of the data When you want to create a measure, your data must be stored …

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

Load more