ALTITI.COM

Creating Basic Charts

User Rating:  / 5

As you become more skilled with Excel, you'll realize that entering numbers, organizing your layout, and formatting cells aren't the most important parts of spreadsheet creation. Instead, the real work lies in analyzing your datain other words, figuring out a way to tell the story that lies behind your numbers. Excel's charting tools may be just what you need.

Charts depict data visually, so you can quickly spot overall trends. They're a fabulous way to help you find the meaning hidden in large amounts of data. You can create many different types of charts in Excel, including pie charts that present polling results, line charts that plot rising or declining assets over time, and three-dimensional area charts that show relationships between environmental conditions in a scientific experiment.

Excel's charting tools are enormously flexible: You can generate a simple chart with standard options in a couple of mouse clicks, or you can painstakingly customize every aspect of your chart's appearance (including colors, scale, titles, and even 3-D perspective).

 Create chart

Create tables for a new Access database

User Rating:  / 2

You’re creating a database because the spreadsheet you’ve been using is too big to manage. This course explains how to build the tables for your new database.

Why tables? They’re the central component of your database. Without them, you can’t store data.

If you’re feeling intimidated, relax. We assume you’re a beginner.

Create queries for a new Access database

User Rating:  / 4

It’s time to create queries, one of the most powerful tools in your database.

Say you want to know how many computers you own. You can build a query to fetch that data and total the numbers. Queries can also provide data for your forms and reports, which can help make your database easier to build and use.

This course introduces queries and explains how to create the most common type, a select query. Presentation Here