For managers, time management is a priority. A Gantt chart can easily present the delay of the tasks and end of the task. However, you must care of the weekends. So, to add exactly the number of workdays, you must use the WORKDAY function.

Follow these steps to see how to build a Gantt chart.

Excel offers a lot of chart models (curves, bars, Radars, ...). However, if you want to make a population pyramid, you can not find this representation in the different models.

But with a few tips, you can make a population pyramid like this.

In this tutorial, you can see the different steps to create a population pyramid.

When you work on columns that contain empty cells, the shortcut Ctrl + arrow does not work. But you can use the function keys F5 and F8, to select a huge range of non-continuous cells.

This 3-minute video shows you the technique and errors to avoid.

And find othet shortcut method in this page.

You can change easily the language of Excel and, in the same time, change the function's name. This video will show you how to do

If you work in several countries, it's not easy to find the name of the function in the local language.

Fortunately, this dutch website, display the correspondance between each function's name in most of the language in Europe.

http://wwwhome.ewi.utwente.nl/~trieschn/excel/excel.html

Often your Excel workbooks have a size of several mega as they contain only
limited information. How to explain this oddity?

The reason is very simple and you can even check it yourself.
Often, due to handling errors, the last used cell row is not 100 or 200 as you might think but to the last cell in Excel document is often equal to the row 65536 (corresponding to
the latest in Excel 2003). You can easily reach the last row in Excel by pressing Ctrl + Shift + End or press the F5 key and select Special...

In this dialog, you select last cell and, after validation, Excel moves to the last cell known.

Fortunately, there is a utility that allows you to reduce the size of your files and keep your files only to cells used. You can download it here.

Once the file is downloaded, you can install it wherever you want on your computer (it does not matter). By double-clicking it, you see that a new tab 'Adds-In' appears in your menu bar. You also open the file to clean and then you have either the ability to clean unnecessary formats as well as the unused columns and rows.

After the launch of the program, the size is always the same. But when you save, you can see that the size of your Excel file has changed