The following Python courses are from our affiliates. List of Python courses Feel free to click on any of the links below to start learning how to code in Python. There is no particularly order to the list. So, just jump in and start learning and creating stuff. Python, baby steps Artificial intelligence Python 3 […]
Our quick access toolbar The quick access toolbar (or 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. […]
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 […]
Sample designs Below are some sample designs from Artplotty Grid 21 (or APG 21). If you take a long at these samples, then you would see, there are no grid lines or axes. So, we took thoses off so you could take a shot of creating them on your own. In addition, we hope these […]
We will show you some sample table designs in Excel. Sample table designs Because of Excel’s structure, you do not have the same flexibility as you would in a word processor. Or, in a desktop publisher app. However, with some creative thinking, designing fancy stuff is always possible. Also, the good thing about tables in […]
Scatter dots chart with trendline for Excel. Download Overview of scatter dots chart with trendline The scatter dots chart allows you to display data using x, y coordinates. It is a great way to show the spread of many data points. In addition, we include a trendline with the formula to help you see if […]
Scatter line chart with key stat lines for Excel The scatter line chart allows you to measure data in both directions, horizontally and vertically. Or, on an x/y scale. This kind of chart gives you more formatting options from a regular line chart. Overall, this chart is very popular in financial firms, particularly, investment banks. […]
Show developer ribbon in Excel. How to show developer ribbon in Excel This quick video tip shows you how to add the developer ribbon in Excel. The video Below is a video that shows you how to add the developer ribbon to the menu, in Excel. Related Developer ribbon in Excel – Quick glance Education […]
This quick tip video shows you how to show or hide an object with a shape in Excel. For the purpose of this tip, we use Excel 2007 or higher, on a Windows PC. In addition, we use a mouse with left and right button functionality. Show or hide an object with a shape So, […]
This quick tip shows you how to show the immediate window in Visual Basic for Applications (or VBA) for Excel . Show the immediate window The immediate window allows you to test single lines of code. In most cases, you use Debug.Print to run single line commands in VBA. The video So, here is a […]
Below are different tables and diagrams for SQL joins. So, these illustrations show seven connections between two tables. SQL joins table The diagram below shows the original table, and the results of each join structure. SELECT syntax for joining tables Related ASCII character code table – Reference guide Color scheme table for Excel Using the […]
