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 »

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 »

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 »

Creation of a population pyramid

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 »

Excel for free

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 …

Continue reading »

Calculation of tenths, hundredths and thousandths with Excel

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 »

XLS or XLSX file ?

With the release of Excel 2007, 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 extensions xlsx and xlsm were created but many people are still saving their Excel file with the xls extension. This article will …

Continue reading »

Change the language of Microsoft Office

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 »

[Survey] Which shortcut do you use the most ?

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 exercises in this site. The technology is new and a lot of things must be developped. One of them are keyboard shortcuts. When you make the …

Continue reading »

Function SUMIFS

To complete the function COUNTIFS , the function SUMIFS allows you to add a part of your data based on some criteria. Because the formula is based on the function COUNTIFS, only exercises and their results are listed on this page. For explanations of the construction of the formula, please refer to the page COUNTIFS.

Older posts «

» Newer posts