Dec 17

Major update

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

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 return the value that are located to the left columns of your ID and this, the VLOOKUP function is not able to do that. However, by using the INDEX …

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 the 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 …

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 the 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 …

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 the results of speed skating in Sochi, 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. Term of the problem Computing speed and …

Continue reading »

Dec 14

XLS or XLSX file ?

xlsx_1

With the release of Excel 2007, the extensions of Excel files (or Office in general) were changed. Previously, it was possible to save workbooks in xls. Since Excel 2007 you can also save your workbooks in xlsx or xlsm. It is now 6 years since the extensions xlsx and xlsm were created but many people are still saving their Excel file with the xls extension. This …

Continue reading »

Jul 19

Change the language of Microsoft Office

Change the language

In most of companies, Office is in English. But if you don’t feel comfortable with the functions name in English, you can easily switch the language of your Excel application to any other language. You just need to install an new Office Language pack. In this page, you will download the most common Language pack …

Continue reading »

Mar 10

[Survey] Which shortcut do you use the most ?

Survey

The future of Excel is Excel WebApp. Excel WebApp is simply an Excel workbook embedded in a browser. It is with this technology that you can make all the exercises in this site. The technology is new and a lot of things must be developped. One of them are the keyboard shortcuts. When you make …

Continue reading »

Older posts «