Total Training for Microsoft Excel 2007 : Essentials (PC DVD)DVD-ROM
About The Series Learning to use Excel has never been this simple. Our video tutorials quickly and thoroughly walk you step-by-step through all aspects Excel offers. This series begins with the simplest tasks and progresses to more difficult projects. Along the way, you will pick up tips and tricks of savvy Excel users. If you have ever wanted to learn how to use Excel to create better spreadsheets and improve spreadsheet analysis, now is the time! About The Lessons These lessons open with an introduction to working with the new Excel interface. Then as if looking over the shoulder of a pro, you will see how easy it is to enter and manage your data, while providing useful formatting techniques and basic formulas, giving you the tools to present high quality excel documents. About the Presenter Michael Alexander, a Microsoft Certified Application Developer ( M C A D), is the Senior Program Manager for a top Texas technology firm. Michael started his consulting and office development career with the White House Communications Agency and Military Office and later launched a successful private practice. Michael is the author of several books on analysis with Microsoft Access and Excel, and the principal behind Data Pig Technologies. com where he shares Access and Excel tutorials. Course Outline: Chapter 1: W O R K I N G W I T H T H E U S E R I N T E R F A C E (25 min) 1. Introducing the Ribbon User Interface 2. Introducing Workbooks & Worksheets 3. Introducing the Formula Bar 4. Saving with Different File Extensions 5. Customizing the User Interface Chapter 2: E N T E R I N G & M A N A G I N G D A T A (47 min) 1. Getting Data into Excel 2. Importing Text Files 3. Using the Freeze Panes Functionality 4. Using the Zoom Functionality 5. Using Hot Keys 6. Managing Rows & Columns 7. Finding Data 8. Matching Case & Enti
|