Mastering Microsoft® Excel®
Packed with shortcuts, tips, and straight answers to all your Excel questions!
Covers Excel 2007 and all previous versions
 In just 2 days, become a more confident, accomplished Excel user, banish "spreadsheet phobia" forever, and discover how to get more out of this powerful program than you ever thought possible!
Can you really "master Excel" in just two days of training? You bet you can! This is training at its most efficient and effective. You will learn how to create spreadsheets; input data; perform mathematical calculations; develop workbooks; edit cells; and use formulas, functions, Wizards, and much more — all under the watchful eye of your expert trainer.
This is the kind of real-life, practical experience that lectures or book learning alone just can't deliver
If you think training means slow-paced learning, time-consuming keyboard input, and lots of waiting around for the group to catch up, think again! This course is a fast-paced, intensive journey through Excel's exciting capabilities — combining lectures, trainer demonstrations, and group discussions — will develop your Excel skills like no other seminar.
Benefits of this program:
- Expertly create colorful, eye-catching charts, tables, and graphs
- Become a whiz at creating and maintaining workbooks and worksheets
- Speed up your productivity and spend less time troubleshooting
- Organize all types of information and data
- Get a handle on macros
- Print with professional results
Course Objectives:
- Manage and navigate an Excel working window
- Customize Excel to meet your needs
- Perform calculations and manipulate data using formulas and references
- Cut, copy, and paste data into an Excel document
- Use database functions to create lists, use forms, and filter records
- Add graphics, borders, shading, and more to spreadsheets
- Integrate Excel and other Microsoft Office programs
- Present a finished project using protection options, web options, and print options
As a result of this training, you will be able to …
- Use Excel's many Help features like a pro — no more slogging through manuals or calling tech support when you get stuck
- Create lively spreadsheets packed with all kinds of "bells and whistles" — charts, graphs, attention grabbing fonts, borders, shading, and more!
- Customize the toolbar and formula bar to help you breeze through the spreadsheets that you build most frequently
- Use formulas and references to perform calculations and manipulate data
- Learn how to integrate Excel with PowerPoint®, Word, Access®, and the Internet
- Create and design databases to store, sort, and analyze any type and amount of data
- Gain tips for managing large, unwieldy spreadsheets
Who should attend?
This course is perfect for beginner to intermediate users who want to better understand and make the most of Excel's many features and functions. It's also a great supplemental course for advanced users interested in learning additional shortcuts and tips. If you want to tap into Excel's immense capabilities and take your skills to a higher level, you'll benefit from this course!
Read Program Overview
Program Overview
Navigating the Excel Working Window
- Discover the critical difference between workbooks and worksheets
- Create, name, open and close a brand-new workbook
- Use the pull-down menus to select the commands you need
- Find your way around Excel's many toolbars and decipher the Status Bar
- Scrolling secrets for moving around your worksheet and accessing cells that are out of view
- Shortcuts that save you time, effort, and unnecessary mouse clicks
- Freeze/Unfreeze Columns or Rows — great for keeping track of document information as you move around your worksheet
- Hide/Unhide columns and rows (important if you're working with sensitive or confidential material)
Getting Help When You Need It
- The Office Assistant, Index, and Office on the Web — other help sources to make life easier
- Asking the Excel Answer Wizard for help — talk to the Wizard in "plain English," not "computerese!"
- Microsoft Excel's Table of Help Topics is packed with information, just waiting for your questions!
Customizing Excel to Work with You
- General Setup — Create your own toolbars and menus to reflect the commands and tools you use most frequently
- Page Setup — Design your worksheets with the margins, headers, footers, rows, and columns exactly the way you want them to appear
- Let AutoCorrect catch and correct the mistakes you make most often!
- Learn to insert hyperlinks
- Convert worksheet data into HTML documents
Back to Program Overview
Working with Cells
- Learn how to select the right cell format for the right cell data
- Learn the difference between typing a date in a general cell versus typing a date in a date/time cell
- Use the Format Painter to quickly and effortlessly format entire cell blocks, with just a keystroke or mouse click!
Formulas and References
- Simple Cell References — Make one cell of the sheet refer to information in another location
- Discover the differences between cell references and formulas and learn how and when to use each
Workbooks and Worksheets
- Learn to name, rearrange, insert, and delete worksheets within a workbook
- How to copy worksheets and move them from one place to another
- Creating and editing column and row headings
Back to Program Overview
 Back to the "Corporate Seminars" Index
Contact us and bring this Seminar to your organization
|
Seminars
