Tag: Excel Applications

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

Using the Gridlines in an Excel Worksheet

How to use the Gridlines in Excel Worksheets

You can make your worksheet look cleaner and make the worksheet text easier to read by turning off the sheet gridlines. When you do this, Excel displays the worksheet with a plain white background, which often makes the worksheet easier to read.

If you find you have trouble selecting ranges with the gridlines turned off, you can easily turn them back on again.

How to make a Supply and Demand Chart

How to Make a Supply and Demand Chart

 

 

One of the basics concepts in the economic class in the high school and in the university were the supply and demand law that is useful to know the price and the product quantity to satisfied a specific market

The supply and demand curve is usually plotted using the product price on the vertical axis and the quantity of the product on the horizontal axis. This time we will learn how to make a supply and demand curve in Excel.

SUPPLY CURVE

In simple words, the law of supply refers to producers and to maximize their profits. Therefore, the higher the price of a product, the greater the amount that the product want to provide. And conversely, the lower the price the lower the quantity supplied. The following table contains the data to graph a supply curve in Excel:

Supply Table

To create the corresponding graph is sufficient to select any cell in the table and go to the Chart tab and select the button Line, then Marked Line. Now you must pay attention because it is very likely to get a graph like this:

Supply Chart 1

To correct this graph we can click right on it and choose the Select data. Then we select the series called Quantity and click the Remove button:

Select Data for Supply Demand Chart

Then you have to put in the label Category (X) axis labels the range A3:A7 choosing the cells. As a final step we can change the name of the series Price by select the data source and set the cell A1 as the name of the series in the Name label. At the end we list changes a graph with the supply curve:

Initial Supply Chart

DEMAND CURVE

The law of demand states: Few people want expensive products. But if we have cheap products (almost given away), many people want them. See the following table for the data to graph a demand curve in Excel:

Demand Table

To include a line in our chart representing the demand curve must right click on the graph and select the Select data and add a new series whose values are in the range E3: E7.

Add a Serie for the Supply Chart

By accepting the changes we have ready our chart with a supply and demand curve in Excel.

Supply and Demand Chart in Excel