MS Excel 2007 - Level 2

Course details

This course is for participants who have a basic understanding of MS Excel 2007

Course Benefits

• Like the other applications in Microsoft Office 2007, Excel 2007 boasts upgraded features and a brand-new look. In Excel 2007 Essential Training, instructor introduces the new version in detail.
• The training begins with the essentials of using the program, including how and why to use a spreadsheet, how to set up and modify worksheets, and how to import and export data. Mahmoud then moves on to teach more advanced features, such as working with functions and macros.

Who Should Attend

• Any staff required to use MS Excel
• Course Outline
• Getting Started 
• Setting up Excel 2007
• Modifying Worksheets 
• Basic Formatting
• Advanced Formatting 
• Using Templates, Styles, and Auto Format
• Managing Lists in Excel
• Reviewing Worksheets
• Sharing Worksheets
• Printing Workbooks
• Enhancing Worksheets
• Using Templates
• Manipulating the Screen Display
• Importing Data
• Finding and Replacing Data
• Working with Formulas
• Working with Advanced Functions
• Charts
• Pivot Tables
• Working with Macros
• Workflow in Excel 2007
• Conclusions 

Course Prerequisite (s)

• Good English skills