Tag: Excel MOOC

The Microsoft Excel Quick Access Toolbar

Microsoft Excel Quick Access Toolbar

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.

The Microsoft Excel Quick Access Toolbar

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:

Using the Menu System: Microsoft Excel

Using the Menu System in Microsoft Excel

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.

The Excel Ribbon in Microsoft Excel
You can find button about formatting, inserting objects, about formulas, about data, view and review, and the file management options.

The Microsoft Excel File Tab Menu

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:

What is Microsoft Excel Used For

What is Microsoft Excel Used For?

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 …

Simple Spreadsheet for Business Tracking
2. Make big tables with complex budgets of incomes and expenses in business or in your home …

Complex Business Budget Excel Spreadsheet
3. Manage big bunch of data in organized databases …

Manage Databases in Microsoft Excel
4. Create and manage lists, of clients, products, employees, etc …

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

Create Microsoft Excel Charts

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

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

Use Excel Smart Tags
8. Analyze your data and show tables with filtered data with the Pivot Tables …

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

Create a Marimekko Chart in Excel

How to Create a Marimekko Chart in Excel

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.

How to Create a Marimekko Chart in Excel

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

Create a Basic Chart in Microsoft Excel

Create a Basic Chart in Microsoft Excel

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

Using the Excel Counting Functions

Using the Excel Counting Functions

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.

How to Create Target Lines in Excel Charts

How to Create Target Lines in Excel Charts

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.

Rounding in Microsoft Excel

How to Rounding Data in Microsoft Excel


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.

Rounding Data Options in Excel

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)


How to Edit & Delete Data in Excel

How to Edit & Delete Data in Excel




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.