Microsoft Excel 2007 Training Course

Microsoft Excel 2007 Training: Course Description

• Use features like AutoFill and Function AutoComplete to quickly populate a worksheet
• Learn the anatomy of a formula to create basic and advanced formulas of all types with three different types of cell references and named ranges
• Customize your worksheet with headers, print titles, backgrounds and custom number formats
• Create embedded charts and chart sheets
• Advanced data management techniques for working with long lists like AutoFilter, Advanced Filter, and Automatic Subtotals
• Perform hefty data analysis with Scenarios, PivotTables and PivotCharts
• Protect worksheets from common data entry errors with Data Validation and security

The Complete Microsoft Excel 2007 Training Solution (because you need a plan)

We think this Microsoft Office Excel 2007 training course is great, and we’ve got our fingers crossed that you’ll like it, too.  We could go on and on about the benefits of training and how it positively impacts user productivity ultimately resulting in a net gain of getting more done in a shorter amount of time. But, you already know all of that. 

What you don't know is what makes us different.

KeyStone Learning Systems offers comprehensive solutions for enterprise clients. What does that mean? If you’re a company looking for high quality Microsoft Office Excel 2007 end-user training you can track and assign with the ability to customize the off-the-shelf content, we can help.

The next you get a request for Excel 2007 Training, you can open your web browser, assign a user to a course and they have access... immediately. Our system tracks your users, what courses they've taken and sends that usage data right back to you.

Did we mention there's no software to buy or install? The news just keeps getting better. Does your organization have Internet access? Silly question, we know. But, if you have that, you can have KeyStone OnDemand.

Basically, you license it and we stream it.

That's 24/7 access for you and your company with no hidden IT, support or other technology costs that we all know tend to add up pretty quickly. We think it's revolutionary, but we wouldnít mind hearing your opinion.

Did we mention?

• Our trainers are MCTs with a passion for training that you'll feel from the first video
• We offer unlimited Tier 1 support via email for licensed users
• We provide complete training, migration and roll out support packages including Quick Reference Cards, Webinars, Posters, Pre and Post Assessments, Custom Introduction Videos (from your Management team), Awareness Campaigns, and Helpdesk Support Features.
• Your company could be up and running with our training within 2-4 business hours (there are some time zone requirements here, but you get the idea)
• You can add your own training content to our existing, and fabulous, off-the-shelf training

Key Learning Objectives for Microsoft Excel 2007 Training Essentials: 

• Make the transition from the old menu-based system to the new ribbon to reduce the decrease in productivity many experience when making this upgrade
• Quickly populate a new workbook with classic tools like AutoFill, AutoComplete and copy and paste
• Work with common Microsoft Office 2007 features like Themes, SmartArt, and Charts, all inside Microsoft Office Excel 2007
• Create and edit Excel workbooks using templates and quick navigation techniques
• Format text with key features like the Quick Format Mini Toolbar, Format Painter and custom number formats
• Manage large sets of data using features like AutoFilter, Automatic Subtotals and Advanced Filters using multiple sets of criteria
• Collaborate with team members through revisions, comments and workbook sharing and security

Microsoft Office Excel 2007 Training Outline

Microsoft Excel 2007 Training: Level 1 (Beginner)

Microsoft Excel 2007 Training Course Instructor

Deanna Reynolds

MCTS, Technical Trainer, Published Author

Deanna is an author and technical instructor residing in Bellingham, Washington. For close to 20 years, Deanna has trained students in all arenas, specializing in delivering enterprise training. Throughout her career, Deanna has led hundreds of computer productivity training sessions, from beginner through advanced levels.  These days, Deanna’s technical training has extended beyond the classroom to include more than 20 courses for KeyStone Learning Systems and three published books: Excel 2010: No Problem! (Wiley), Word 2007 Pocket Book (Prentice Hall), and Managing Projects with Microsoft Office Project 2007 (Microsoft Press).

In this Microsoft Excel 2007 Training course, Deanna will guide users of all levels to better spreadsheet productivity through a complete understanding of Excel 2007.

Some Quick Microsoft Excel 2007 Training Tips

Excel 2007 TRAINING TIP: create a custom autofill list 

Excel’s default AutoFill lists consist basically of the days of the week and the months of the year. But, you can add your own lists to making filling in future worksheets quite fast. But, you’ll need to open the Custom Lists dialog, first.

To start, open the Excel Options dialog from the Backstage menu and choose Advanced from the left Navigation pane. Scroll down to the General section and click the Edit Custom Lists button. Type your list entries in the big List entries box and click Add when the list is complete.

Or, if the list already exists on your worksheet, click in the box next to the Import button, select the list range back on your worksheet and then click Import. (Microsoft Excel 2007 Training Tips: © KeyStone Learning Systems)

EXCEL 2007 TRAINING TIP: CREATE A line break in a cell 

You can use the Wrap Text option on the ribbon’s Home tab in the Alignment group to show text in multiple lines in one cell. But, with this approach you don’t have control over where one line ends and the next line begins. And, since you can’t press ENTER to create a new line, you need a different way to create a new line within a cell. Next time, try [ALT]+[ENTER]. (Microsoft Excel 2007 Training Tips: © KeyStone Learning Systems)

EXCEL 2007 TRAINING TIP:  Whoops! did you hide column a?

If you accidentally hide Column A, since there is no column to select before Column A, you’ll need to click the Select All button in the upper-left corner of your worksheet before you can choose unhide from the shortcut menu. (Microsoft Excel 2007 Training Tips: © KeyStone Learning Systems)

EXCEL 2007 TRAINING TIP:  transpose columns & rows

When you copy and paste in Excel, the pasted values go into the new location in the same manner they were copied. But, from the Paste options menu on the ribbon’s Home tab, you can click the Transpose option to paste rows as columns and vice versa. (Microsoft Excel 2007 Training Tips: © KeyStone Learning Systems)

EXCEL 2007 TRAINING TIP:  print 1 page wide x ? pages tall

In the Page Setup dialog, which you can access by clicking the dialog box launcher arrow on the Page Setup group from the ribbon’s Page Layout tab, you can adjust the scale of a printed worksheet to designate the number of pages wide and tall a printout should be.

But, the default is 1 page wide by 1 page tall. This often creates a printout that is way too small to read. If you just need to squeeze all of the columns on one sheet but you r printout can be multiple pages long, in the width box, enter a 1, but remove the number in the tall box. Just delete the number 1 that’s in there.

Now when you print, the scaling will adjust automatically to 1 page wide and Excel will calculate the total number of pages from there. (Microsoft Excel 2007 Training Tips: © KeyStone Learning Systems)

Other Resouces on the Web

LinkedIn's Microsoft Learning Professionals Group
This is a group for Microsoft learning and training professionals, including desktop support managers, project managers, instructional designers, learning officers and classroom trainers.