 |
 |
 |
Training Courses for Excel 2010
Which of the following coursed would you be interested in learning more about?
|
|
|
- BEGINNER COURSE
Excel 2010 keyboard shortcuts I: CTRL key shortcuts
Learn Excel 2010 keyboard shortcuts. Specifically, learn how to use CTRL key shortcuts that let you do everything from selecting and editing cells, to inserting items and formatting.
|
- BEGINNER COURSE
How to create a basic chart in Excel 2010
Charts make data visual. With a chart you can transform spreadsheet data to show comparisons, patters and trends.
|
- BEGINNER COURSE
Office 2010 Security: Protecting your files
In Microsoft Office 2010, when files open, Message Bars can alert you to useful information and potential problems with your files. Security Message Bars provide the opportunity to consider the potential security risks that may be in your file, and then the ability to open or read the file while reducing the risks that can occur.
|
- INTERMEDIATE COURSE
Excel 2010 keyboard shortcuts II: ALT key shortcuts
Learn how to use ALT key shortcuts that let you access almost any command in Excel 2010. These keyboard shortcuts are also called access keys, and they are handy when a CTRL shortcut isn't available for a command.
|
- INTERMEDIATE COURSE
Sparklines: Use tiny charts to show data trends
As you look at rows and rows of data, sometimes it's hard to immediately make sense of it. Add tiny charts called sparklines next to data to give readers a picture of what the data means, making it easy to spot patterns and trends.
|
- INTERMEDIATE COURSE
The IF Function: What it is, and how to use it
The IF function checks to see if a condition you specify is true or false. If true, one thing happens; if false, something else happens. For example, if you use the IF function to see if amounts spent are under or over budget, the result for True could be "Within Budget," while the result for False could be "Over Budget."
|
- INTERMEDIATE COURSE
Understand data at a glance with conditional formatting
Sometimes it's hard to read and interpret data by scanning rows and rows of information. But you can use conditional formatting to make certain data stand out, helping you to analyze data, identify patterns and trends.
|
- INTERMEDIATE COURSE
Use Excel tables to manage information
Manage information by using Excel tables, which make it easy to format data, sort, filter, add totals and use formulas.
|
- INTERMEDIATE COURSE
VLOOKUP: What it is, and when to use it
Learn how to use VLOOKUP to look up a value you want to find in an Excel list or table. Using VLOOKUP is similar to looking up a person's name in a telephone book to get a telephone number. VLOOKUP looks at a value in one column, and finds its corresponding value on the same row in another column.
|
- ADVANCED COURSE
Save time by creating and running macros in Excel 2010
Do you find yourself doing the same actions over and over again in your spreadsheets? Did you know that you can create macros so that Excel can do that repetitive work for you? Macros are sets of instructions based on actions that you record while you work in your spreadsheet. After you record a macro, you can use it again as the need arises.
|