Learn to use the Min and Max functions in Excel to find the highest and lowest values and to use the Small and Large functions to return the nth ranked value in a range of cells.

ExcelMOOC > Excel MOOC

Posted on by Juan David

Learn to use the Min and Max functions in Excel to find the highest and lowest values and to use the Small and Large functions to return the nth ranked value in a range of cells.

Posted on by Juan David

Learn how to use the Quick Access Toolbar, showed in the left upper corner of the Excel Window.

In this bar you can put every excel command that you use frequently. The most common are the Save button, Print Preview button, Undo and Redo commands, and so on.

But if you right-click you can enter to the customizing menu, and put the Excel command that you use very often. See in the following video how to customize the Quick Access Toolbar:

Posted on by Juan David

The excel menu system is a basic knowledge that you have to learn initially. In the ribbon, you can find almost every command to use in Microsoft Excel; you can find all that commands organised in tabs, according to each command use.

You can find button about formatting, inserting objects, about formulas, about data, view and review, and the file management options.

Put the mouse cursor in each button without clicking and you can find an explanation of the button, try to explore all this commands and you can learn what are all the powerful tools that Microsoft Excel has. Learn more about the Microsoft Excel Ribbon in the following video:

Posted on by Juan David

Microsoft Excel is one of the most used software by people in professional and personal level. It is a powerful tool for productivity that allows you to keep you data organised.

The most common uses are: 1. You can make simple spreadsheets and tables to keep tracking you business indicators …

2. Make big tables with complex budgets of incomes and expenses in business or in your home …

3. Manage big bunch of data in organized databases …

4. Create and manage lists, of clients, products, employees, etc …

5. Create one of the different types of Charts to analyze data in a simple way …

6. Make complex calculation with one of the more than 300 functions that Excel has …

7. Show graphs and visual objects with the Excel Smart Tags …

8. Analyze your data and show tables with filtered data with the Pivot Tables …

These are some of million of uses for Microsoft Excel, Learn more with Microsoft Excel MOOC

Posted on by Juan David

Marimekko charts encode two variables: one along the height of the vertical axis and another using the width of the bars or columns. This one from The Economist, for example, has GDP per capita ($) on the vertical axis and share of global population (%) along the horizontal axis.

There are alternatives, of course; they could have used a scatterplot or maybe two column charts. But the Marimekko, I think, does a nice job extending the standard column chart in another dimension.

Learn How to construct it in the following link: Marimekko Chart in Excel

Posted on by Juan David

When you have organized data in a table is very useful to show it in a better way than the simple data table.

You can create a Microsoft Excel Chart and show the data in a graphical way. In this video you can learn step by step how to do it.

In this example you can see a kind of Chart in Excel, but you can create a lot of different types of Chart to show your informacion

Posted on by Juan David

The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.

The COUNTA function counts the number of cells that are not empty in a range.

The COUNTBLANK function counts empty cells in a specified range of cells.

Posted on by Juan David

In this video, you can Learn how to add a target line in bar chart. You can do that for make an evaluation of the results of a variable compared with a target.

The way to do that is adding the column of the target values to the chart. Then you have to select the new target serie from the chart. Finally change the chart type, from bars to line.

Posted on by Juan David

The ROUND, ROUNDUP and ROUNDDOWN functions are useful when rounding numbers in Excel. These functions are categorize Math and trigonometry.

The ROUND function in Excel

We use the ROUND function to work with any number of decimal places. Unlike when we apply a format on the cell to display more or fewer decimal, the ROUND function effectively modifies the stored value in the Excel cell. The syntax for the ROUND function is: ROUND(number, num_digits)

The function only requires two arguments, the first of them the number we want to round, the second is the number of decimal places that we need. Consider the following examples: = ROUND (3.1416, 0). It returns the value 3, because we are indicating zero as the number of decimals we need. = ROUND (3.1416, 3). It returns the value 3,142 because we specified three decimal places.

ROUNDUP and ROUNDDOWN functions in Excel

These functions have the same arguments that the ROUND function and the difference is that ROUNDUP always rounds up the specified number and the ROUNDDOWN function makes rounding down.

In the next picture you can see the difference between each of the three functions by applying rounding the value of the mathematical constant PI.

Each function applies a different rounding even if you applied the same number of decimal places. Notice how the result of the function ROUND sometimes agrees with the result and sometimes ROUNDUP agrees with the result ROUNDDOWN. The next time you need round in Excel know that there are three functions that can help you get the desired result. (Source: Excel Total)

Posted on by Juan David

Edit Cell Data: Once you enter text, a number, a date, or a time into a cell, that cell data is not set in stone.If the data you entered into a cell has changed or is incorrect, you can edit the data to the updated or correct value. You can edit cell data either directly in the cell or by using the Formula bar.

Delete Data from a Cell: If your worksheet has a cell that contains data you no longer need, you can delete that data. This helps to reduce worksheet clutter and makes your worksheet easier to read.