Upgrading To Microsoft Office Excel 2007 Training Manual 

 

Description

This training manual provides an overview of the redesigned user interface and introduces the interactive new features and functionality of Microsoft Office Excel 2007. Upon completing this course, you will be able to use the new and enhanced feature of Excel 2007, organize data in Excel worksheets using enhanced tables and table formats, analyze Excel data by applying enhanced conditional formatting, and generate specific information using the sort and filter options and also present Excel data using enhanced charts and illustrations, as well as work with the enhanced options of PivotTables for conducting selective analysis.

Pre-requisites

This training manual is designed for experienced users who have worked with earlier versions of Excel, and who have, or about to upgrade to Microsoft Office Excel 2007. This training manual covers the commonly used new features for a typical user.

Course Duration

6-7 hours (1 Day course)

File Format and File Size

Microsoft Word, 4,354 KB

Table Of Contents

GETTING STARTED What's New In Excel 2007 Viewing the Excel 2007 Window Using the Excel 2007 Ribbon How To Work With The Ribbon How To Customize The Status Bar How To Change The Views How To Show And Hide Workbook Elements How To Use The Zoom How To Use The Compatibility Checker How To Save A Workbook How To Save With A Different File Format How To Document Workbook Properties How To Change The Margin In The Page Layout View How To Add A Header How To Add An Image As A Watermark   PERFORMING CALCULATIONS How To Resize The Formula Bar How To Use AutoComplete To Create Formulas How To Turn Formula AutoComplete on or off How To Insert Other Functions Using AutoSum Button How To Create Names Using Create From Selection Button How To Insert A Name In A Formula How To Manage Names Using The Name Manager How To Evaluate A Nested Formula How To Use The Watch Window   FORMATTING WORKSHEET How To Format The Data How To Draw A Border To Cells How To Use The Conditional Formatting To Highlight Cells How To Use The Data Bars How To Use The Color Scales How To Use The Icon Sets How To Edit The Rules How To Change The Precedence Of The Rules How To Stop A Rule How To Clear The Rules How To Apply A Built-in Cell Style How To Create A Custom Cell Style How To Apply A Custom Cell Style How To Modify / Delete A Cell Style How To Apply A Theme How To Create New Theme Colors How To Create New Theme Fonts How To Select The Theme Effects How To Save The Custom Theme   WORKING WITH TABLES Working With Tables How To Create A Table How To Format A Table How To Create A New Table Style How To Show Or Hide Table Elements How To Create A Calculation In A Table How To Insert And Delete Rows In A Table How To Resize A Table How To Sort The Data In A Table How To Convert A Table To A Range How To Create A PivotTable How To Change The Layout Of A PivotTable How To Change The Value Settings How To Show Filtered Data How To Change A PivotTable Options   WORKING WITH ILLUSTRATIONS AND CHARTS Working With Illustrations And Charts How To Insert An Object And Apply A Style To It How To Apply Shape To A Picture How To Apply An Effect How To Rearrange Objects Using The Selection Pane How To Insert A SmartArt How To Use The SmartArt Text Pane How To Change  The Shape In A SmartArt How To Insert A Chart How To Edit Chart Data Source How To Change A Chart Layout And Style How To Modify  The Chart Elements How To Format The Chart Elements   USING SECURITY How To Inspect A Workbook How To Apply Password Protection To The Editable Cells