Excel 2007
Office 2007
Office 2010
Windows 7
Project 2007
Browse all..."It has been a pleasure doing business with you and I will continue to do so."
| At A Glance |
|---|
| Total Combined Length 8 Hours |
| Level Beginner to Advanced |
| Format Online & DVD |
| Instructor Deanna Reynolds |
| Course Outline View |
| System Requirements Online Broadband connection • 512MB RAM • Windows 2000/XP/Vista/7 • Windows Media Player 9 or later | DVDWindows 2000/XP/Vista/7 • DVD-ROM drive • Pentium III, 128MB RAM or greater |
| Pricing |
| Multi-user Starting at /user |
| Single-user Online | DVD |
| View Pricing & Purchase |
Why Choose KeyStone?
- KeyStone instructors are Microsoft Certified Trainers (MCT)
- Fully hosted: no software to download or maintain
- Supplimental Keynotes provide text version of training
- Engaging Video Content
KeyStone News
Course Summary
This Microsoft Office Excel 2007 Essentials Training Course contains three levels of instruction to walk you through performing many time-saving tasks in Excel, beginning with an introduction to the new results-oriented interface. The course topics appeal to all Excel users – beginner through advanced. You will learn everything from creating professional-looking charts to sharing data with enhanced security and managing your spreadsheets more effectively.
In this course, you’ll learn from a combination of quick tips and detailed instruction on using Excel for team collaboration and creating templates to work smarter, not harder. You will learn how to create professional-looking spreadsheets through modifying the worksheet layout and formatting.
And, of course, you will learn about harnessing the power of Excel formulas with an entire section devoted to the anatomy of formula. To really understand formulas, there are additional lessons on advanced functions (such as Nested IF Statements, HLOOKUP, VLOOKUP and DSUM) and data consolidation using three dimensional formulas, position and category.
There are over 100 lessons in this Excel course – all designed to increase your productivity.
Highlights
- Quickly find old features within the new results-oriented user interface and Ribbon.
- Learn to write advanced formulas and use functions such as IF, HLOOKUP and DSUM.
- Collaborate with team members using Excel’s comments, security and data validation options.
- Save time with Excel’s table and list management features, including AutoFilter and Automatic Subtotals.
- Create and use interactive PivotTables to summarize and retrieve sets of data on the fly.
Instructor
Deanna Reynolds
MCTS, Technical Trainer, Published Author
Deanna Reynolds (MCTS) is an author and technical instructor living in Suffolk, Virginia. Since 1993, Deanna has been privileged to work with students traveling many different career paths on a multitude of software programs, including the entire Microsoft Office suite, project management, desktop publishing, and database development. Throughout her career, Deanna has led hundreds of computer productivity training sessions, from beginner through advanced levels.
Most recently, Deanna’s technical training has extended beyond the classroom to include more than 10 DVD-ROM courses for KeyStone Learning Systems and two published books: Word 2007 Pocket Book (Prentice Hall) and Managing Projects with Microsoft Office Project 2007 (Microsoft Press).
Related Courses
Pricing & Purchase Options
| Users | 1 | 10 | 25 | 50 | 100 | 250 | 500 | 1000+ |
|---|---|---|---|---|---|---|---|---|
| Pricing | /user | /user | /user | /user | -- | -- | -- | |
| Order | Order | Order | Order | Order | Order | Contact | Contact | Contact |
Looking for DVD? Single-user: (Add To Cart) | Lending-License: (Add To Cart)