List of places to get data and information Below is a list of some places to get data and information on a variety of subjects. American National Standards Institute Biography Black demographics Britannica ESPN analytics History IMDb Merriam Webster National Institute of Standards and Technology (NIST) NBA statistics Our World in Data Pew Research Center […]
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. […]
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 […]
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 […]
This short snapshot simply provides a reference of using the FILTER function in Excel. Keep in mind, this reference does not go into full detail of using this function. On the whole, it is a snapshot of the function. We pattern this example from the following function. LET function Snapshot of using the FILTER function […]
Who drinks in the United States by gender? These data visualization examples show various ways to depict who drinks in the United States by gender. According to data from Gallup.com, 63% of men drink, and 57% of women drink. The poll was taken from July 6-21, 2021. So, with this data, we will show the […]
Chart library Area charts Bar charts Bubble charts Column charts Combo charts Donut charts Line charts Math charts Pie charts Scatter charts Sheet charts Special charts
Learn new things or improve on the skills you already have.
