How to Autoformat an Excel Spreadsheet Instantly

May 15th, 2008

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

May 5th, 2008

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

May 1st, 2008

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

April 26th, 2008

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 […]