Excel Exercise

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 the exercises of this site, you’ve seen the classic Ctrl + C and Ctrl + V work fine. But if you want to lock a reference with F4, this shortcut doesn’t work. For the moment, only these shortcuts work with Excel WebApp

This is why Microsoft makes a survey to know what is your most favorite shortcuts

Hi all

Before the release of Office 2013 I decide to upgrade the website. Do you like it ?

I have change the structure of the menu and also the design. All the exercises are now embed in this website. That’s mean less screenshots but more interactivity to make the exercises

Soon, a lot of new videos to present Excel 2013

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 the exercises and their results are listed on this page. For the explanation of the construction of the formula, please refer to the page COUNTIFS.

Since Excel 2007, a new useful feature allows you to count the number of rows that meet multiple criteria (multiple column).

In the following document, we are able to count the number of orders for a specific client (cell K1) for a time period (cell K2 and K3)

You will find in the function COUNTIFS page how to use this function through several exercises. All examples are real Excel spreadsheets and you can make inside the cells, all the changes you want.

For the managers, the 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.

I can not resist to share with you this Windows gadget developed by John Walkenbach. This tool adds directly with your other gadgets (like the watch, the weather, …). All your Office files are now visible on your desktop and to open one of these files, you just have to click on its name.

You can download this gadget on the page of the author.

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.

The shortcut key F9 allows you to view the result of a part of your formulas. For example, if you have a very complex formula (as in the video below) and this formula returns an error, the F9 key will help you to easily find which part of your formula is responsible for the error.

At this address , you’ll find the parsing tool, created by Roberto Mensa, Krisztina Szabó and Gábor Madács. You can download it for free And you can review other Shorcut method to improve your speed with Excel