Tag: Excel Tutorial

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:

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.