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 go to Format>AutoFormat.
2.Next, the Autoformat pop up window appears, and you’ll be able to review a group of templates.
3.Once you select one and click OK, the selected sheet or range of data will be automatically formatted like the template that you just selected from the AutoFormat list.
Great! Now you’ve discovered how useful the Autoformat feature can be to your everyday business ritual, specially when you don’t have time to play around with formatting a spreadsheet.
|| tags: Excel Lessons author: Joanna comments: No Comments
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 File>Open to open the workbook containing the table or chart where you want to insert a graphic or picture.
2.Click on the cell or chart area to select it and go to Insert>Picture>WordArt – You can also select ClipArt or From File, but for this example we’ll use WordArt. Next, select one of different WordArt options and click OK. Now, enter the text and click OK. Once the WordArt box is inserted, you can click on the actual image and move it around or click on its handles to minimize or maximize its size.
3.The key to remember with adding any type of graphic, wordArt or photos to an Excel table or chart is that it does not take away from the impact of the data, but that it works harmonously with the data.
Well Done! Adding graphics, pictures, or WordArt to anything that will be presented or viewed if done tastefully can only enhance what’s being presented.
|| tags: Excel Lessons author: Joanna comments: No Comments
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 Custom Types tab. Now go down to the chart type called “Lines on 2 Axes,” select it and click Next.
3.Next, select the range with the two different types of data and click Next.
4.Add titles and any other pertinent information, and click Next.
5.Finally click on the “place chart as new sheet” option and hit Finish.You’ll see the two sets of data nicely combined in one chart -as in the example below.
Fantastic! Sometimes it makes sense to combine two charts into one to really emphasize the relationship of the data and their impact.
|| tags: Excel Lessons author: Joanna comments: No Comments
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 pop up window appear, under Chart Type, select another chart and click OK.
3.Your chart will automatically change to the new chart that you just selected.
Great Job! If one chart type stops working for you, now you know how to quickly change it.
|| tags: Excel Lessons author: Joanna comments: No Comments
