Best Excel Tutorial

The largest Excel knowledge base ✅ The best place to learn Excel online ❤️

Email Quick Access Toolbar

How To Send Email From Excel?

You might have Gmail or Yahoo accounts for sending and receiving emails. But, Excel offers the option to send emails directly from Excel itself. Suppose, you are busy with some Excel application and want to send an email to your manager or team member attaching the same Excel document you are working on. You can complete it in seconds without opening your Yahoo or Gmail inbox.

Read More

VBA own function table

How to Create Vba Function in Excel

Excel offers a large number of built-in functions that you can use to perform many different tasks easily and quickly. But at least once, you might have felt that the built-in functions provided by Excel are not enough for you to perform some complicated task.

In such cases, you will have to write your own functions, and this is done using VBA. VBA stands for Visual Basic for Applications. Moreover, whenever you have to use a block of code repeatedly, it is advisable to create a function so that you can reuse the code easily.

Read More

Monitor Stock Prices from web

How to Get Stock Quotes in Excel

If you are an investor who invests in stock, then you might be knowing how important is monitoring the stock prices. You might have to make wise and quick decisions based on the stock prices. There are a number of financial websites like Yahoo Finance, Forbes etc that you can view to monitor stock prices.

The happy news is that you can even use Microsoft Excel to monitor the performance of your investments. You can set up your Excel in such a way that all the details you need for the stocks of your interest can be viewed and updated easily and quickly.

Read More

Yahoo Apple

How to Calculate Beta of a Stock in Excel

Stock beta is a measurement of the risk of a particular stock relative to the risk of the entire stock market. Before choosing a particular stock for your portfolio, you can check the beta of that particular stock to decide how risky it is.

Though beta is not the only factor to consider before investing in a stock, you can make a wise decision by considering beta as well.

Read More

four axis chart example

How to make 4 Axis Graph

Radar charts, also known as spider charts, web charts or star charts, are used to evaluate multiple alternatives based on multiple criteria. You need to use a radar chart when you have to display multivariate data in the form of a chart that has three or more axis.

For example, you can use a radar chart to analyze the strengths and weaknesses of a number of supply chain strategies or to compare multiple projects graphically. Given below is a simple radar chart with 5 axes on a scale of 0 to 10.

Read More