Excel Lessons Online

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

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

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

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 and open an existing or a new spreasheet. Then go to Format>Style, and the Style pop up window will appear – as you can see, there are general specifications next to the formatting titles: Number, Alignment, Font, Border, Patterns, and Protection. Click on the Modify button, and the Format Cells pop up window will appear.

2.Next, make formatting changes within any of the tabs (Number, Alignment, Font, Border, Patterns and Protection) and click OK.

3.Now, you will see your new formatting specifications next to the Style’s main categories.

4.Finally, click on the Add button and give your new style specifications a name and click OK. Now the next time you create a spreadsheet and if you want to add this specific style to an existing spreadsheet, all you have to do is select the range of cells or the whole sheet, go to Format>Style, select the Style name and click OK. And the selected range or sheet will be automatically formatted to the style specifications previously saved.

Well Done! This table formatting feature can save you lots of time and make you look like a star in front of your co-workers.

|| tags: Excel Lessons author: Joanna comments: No Comments