Excel Lessons Online

How to Autoformat an Excel Spreadsheet Instantly

Joanna — Thu, 15 May 2008 02:11:13 +0000

In this short tutorial, you’ll learn how to use the AutoFormat feature. The Autoformat feature lets you pick from a group of pre-canned table formatting options to format your table or spreasheet instantly. 1.Go to File>Open to open a new or existing workbook. Enter the data or select the already existing data, and [...]

How to Insert Graphics, Pictures or WordArt into an Excel Table or Chart

Joanna — Mon, 05 May 2008 01:56:37 +0000

In this tutorial, you’ll learn how easy it is to insert graphics, pictures, or WordArt to your tables or charts. The thing to remember is to do it with taste and a purpose so that your audience is not overwhelmed or distracted from the data highlights that you want to emphasize. 1.Go to [...]

How to Combine Two Different Chart Types for Maximum Impact

Joanna — Thu, 01 May 2008 04:20:26 +0000

In this tutorial, I’ll show you how to combine two chart types to better present two different sets of data. 1.Go to File>Open and open the workbook containing the data that you want to combine in one chart. 2.Next go to Insert>Chart Type. The Chart Wizard pop up window will appear, so click on the [...]

How to Quickly Change Chart Types

Joanna — Sat, 26 Apr 2008 04:06:06 +0000

In this tutorial, you’ll learn how to quickly switch from one chart type to another. 1.Go to File>Open and open the workbook containing the chart that you want to change. 2.Next, click on the chart area to select it and right click it, and go down to Chart Type. Now you will see the Chart Type [...]

How to Create Your Own Formatting Style Template for Future Spreadsheets

Joanna — Fri, 18 Apr 2008 00:59:06 +0000

In this short tutorial, you’ll learn how to create and save a styled template for your spreadsheets. If you want, for example, your future spreasheets to be written in red, bold, 14 pt. Comic Sans font and any other formatting specification, you can make this happen with the Style feature within Excel. 1.Go to File>Open [...]