Fun quiz on Microsoft Excel love. So, how deep does you love go for Excel? Will you be able to find love with this spreadsheet program? Who knows. In any case, do not take this quiz seriously. Once you are done, click on the love points button to see where you stand. There are 14 […]
Overall, the MID worksheet function in Excel returns the characters from the middle of a text string, given a starting position and length. MID worksheet function Here is the syntax of the MID function. Syntax =MID(Text, Start_num, Num_chars) Arguments Below are the arguments of the MID function. Argument Description Text A text string from which […]
I am Alex Shaw, Founder of Excel Effects, and I will discuss my journey with Microsoft Excel across decades. Table of contents Before starting my journey with Excel To really understand my journey, I must go back to my first computing days, which lead up to my interest in Excel. It starts with BASIC, or […]
Pill Bar overview The pill bar with average line chart is similar to a regular bar chart. Instead, with this chart, the two endpoints are round. Thus, you get what looks like a pill. Of course, as with the bar chart, this chart is shows everything in a horizontal manner. Now, with all that said, […]
Overview of price volume charts Price volume charts show the relation of shares traded to its price. For the most part, you see this chart in financial institutions, particularly investment banks and the stock market. Excel is the primary app to create this chart type. However, creating it is not necessarily easy. Therefore, feel free […]
Overview of project schedule template So, the project schedule template (or PST) is one of our long-running organizational tools. Originally, it is an Excel creation. However, you should be able to open it in compatible spreadsheet programs. Basically, the PST helps you organize your projects, reports, and other tasks you may have going on. Overall, […]
How to put average line on a bar chart in Excel This quick tip shows you how to put average line on a bar chart in Excel. Set target goal So, you may hear people say “target line” for this type of chart. For the most part, it is the same idea. Except, we use […]
Welcome to the Quarterly Analysis Report The Quarterly Analysis Report (or QAR) is a user-friendly dynamic Excel data dashboard. Moreover, users of any level can work with this reporting tool. Overall, QAR is clean and very easy-to-use. QAR works with different types of data. For example, you can work with sales data or other metrics […]
Our quick access toolbar The QAT allows you to quickly access commands that you use often. Overall, it helps you work more efficiently. So, this QAT is actually the one we actually use in Excel. Since we are into graphics and data, we have commands that work with objects and numbers. An example would be […]
The rounded column chart with average line is very similar to our column with average line chart. Basically, it shows data across categories. In addition, the average line shows the central tendency of the values. Moreover, you can visually view which categories are above or below average. Adjusting the Rounded Top Now, depending on the […]
This tutorial shows you how to run a macro from a form button in Excel. If you do not have a macro to use, then create one. Or, just go through our Hello World lesson. In fact, we will use the macro from our Hello World lesson, in this tutorial. Steps to run a macro […]
This sample sales data comes from our Excel data room. Basically, we use this data for practice. Thus, you should do the same. Overview of sample sales data Again, this data is mainly for practice. Use it for pivot tables, formula creation, and learning how to work with data. Also, this data contains fake numbers. […]
