Feb 22

Create an online survey with Excel

Survey_3

Since it is possible to use Excel from a web browser, new special features are available with Excel Online. This is particularly the case for creating, posting and collecting the results of a questionnaire. And not only is it very easy to implement a surver but it is free. Click on this link to see …

Continue reading »

Jan 23

How to round in k$ without formula?

Round_K$_1

In many companies, it is difficult to present in a worksheet, big numbers. So, to avoid that, it is better to present  your figure rounded in kilo dollar (k$) or million (m$). But how to round in k$? In this article you will find 3 techniques to display a result in k$ (or m$ for the millions]. Each …

Continue reading »

Dec 17

Major update

Recently Microsoft has announced a new public update to Excel 2013. This new release includes major stability and usability improvements in Self Service BI scenarios – especially when Power Query, Power Pivot and Power View are involved. For this one we eliminated over 120 bugs, crashes and hangs. On the other hand, we introduced two new …

Continue reading »

Dec 08

How to Lookup Values to left column?

Function_INDEX_MATCH_1

The VLOOKUP function searches for data in a table by returning data always to the right of the column containing your ID. However, it is sometimes necessary to us to return the value that is located into the left columns of your ID. As the VLOOKUP function is not able to do, we can solve the problem …

Continue reading »

Nov 26

How to make automatic calendar in Excel

  Creating a new calendar each month is a waste of time, but many people do as they think they need to rebuild it to get correct weekends and public holidays. But in fact, with few formulas, 2 conditional formatting rules, 1 dropdown list and 5 lines of VBA code, you can create an automatic …

Continue reading »

Nov 17

Excel on your mobile …….. for free!

Using Excel from a mobile seems to be a bit of a joke, but after using it, it is easy to get caught in the game. Of course, we will never create great worksheets as we can do with Excel desktop, but to open its files from any location (street, subway, bus) is very interesting. This …

Continue reading »

May 02

The most popular post of Excel in 2013 comes from this site

  The most popular Excel blog posts of 2013 reflect your interest in new capabilities we’ve added to Excel this year, including exciting updates to Web Excel and the release of Power Map for Excel. Other favorite posts offer valuable Excel tips and tricks for Excel beginners and experts alike. Have a look on them …

Continue reading »

Mar 11

Creation of a population pyramid

Chart_Pyramide_Age_1

It is common to have to create a population pyramid in Excel, in order to identify the distribution of its customers. Unfortunately, Excel doesn’t have this pattern in the Chart’s ribbon. Nevertheless, you can create your own population pyramid chart by following these steps.   The data for a Population Pyramid Data for a population pyramid …

Continue reading »

Feb 24

Excel for free

excel-for-free_7

Excel for Free! It was the dream for all and now it’s real For years, the only way to use for free microsoft Excel was to download it and use a “hack” serial key. Very risky technique especially in accordance with the law. Now, this “technique” is difficult to use because the new version of Office …

Continue reading »

Feb 19

Calculation of tenths, hundredths and thousandths with Excel

3_milliemes_1

3 Thousandths Looking at results of speed skating in the Olympic winter games at Sochi 2014, I found that the gap between the first and second of the 1500m event was only 3 thousandths. Decide athletes with thousandth is extremely unusual and this give me the idea to measure the gap between them. Why and …

Continue reading »

Older posts «