- Dedicated trainers
- Maximum 6 per class
- Superb courseware
Phone (01457) 858877 or email
10 EXCEL QUICK TIPS
Part seven of a ten-part series of blogs
Some tasks in Excel always seem to take longer than they should - if only you knew a bunch of quick shortcuts to speed up the simple things. Read on to see how much time you could save!
- Excel Quick Tip #1 - Copying a Formula
- Excel Quick Tip #2 - Putting Dollar Signs in a Formula
- Excel Quick Tip #3 - Adding Totals to Columns
- Excel Quick Tip #4 - Selecting a Table
- Excel Quick Tip #5 - Sorting a List
- Excel Quick Tip #6 - Creating Range Names
- Excel Quick Tip #7 - Creating a Chart (this article)
- Excel Quick Tip #8 - Copying a Worksheet
- Excel Quick Tip #9 - Entering Today's Date
- Excel Quick Tip #10 - Copying Days and Months
Excel Quick Tip #7 - Creating a Chart
You can create a chart in Excel by pressing a single key on the keyboard!
- Select the cells you want to provide the data for the chart.
Here we'll create a chart with two data series - one for each column of numbers we have selected.
- Press the F11 key on the keyboard.
You can now edit and format the chart in any way you like.
You can see the technique in action in this short video on Wise Owl's YouTube channel.
10 EXCEL QUICK TIPS
Part seven of a ten-part series of blogs
Some tasks in Excel always seem to take longer than they should - if only you knew a bunch of quick shortcuts to speed up the simple things. Read on to see how much time you could save!
- Excel Quick Tip #1 - Copying a Formula
- Excel Quick Tip #2 - Putting Dollar Signs in a Formula
- Excel Quick Tip #3 - Adding Totals to Columns
- Excel Quick Tip #4 - Selecting a Table
- Excel Quick Tip #5 - Sorting a List
- Excel Quick Tip #6 - Creating Range Names
- Excel Quick Tip #7 - Creating a Chart (this article)
- Excel Quick Tip #8 - Copying a Worksheet
- Excel Quick Tip #9 - Entering Today's Date
- Excel Quick Tip #10 - Copying Days and Months
Comments on this blog
This blog currently has no comments.