Microsoft Excel 2007 Level 2 Training Course
Microsoft Excel 2007 Level 2 Training Course Summary
This is the 2nd in the 3 part Microsoft Excel 2007 trining series. In Microsoft® Office Excel® 2007: Level 1, you would have already learned how to creat, edit, format, and print basic spreadsheets.
This second course now takes you to the next level and helps you to make your workflow more efficient by helping you to streamline repetitive tasks and display your spreadsheet data in more visually effective and professional ways. You will also learn to use Microsoft® Office Excel® 2007 to enhance yourworksheets with templates, charts, graphics, and formulas.
Upon successful completion of this course, students will be able to:
- Enhance the workbook.
- Automate workbook creation by using templates.
- Organize data using tables.
- Create and modify charts.
- Analyze data using PivotTables and PivotCharts.
- Work with graphic objects.
- Calculate with advanced formulas
- Sort and filter data.
Price: £249
Entry Level for Participants wanting to attend Microsoft Excel 2007 Level 2 Training Course
To gain maximum benefit from this course, attendee's should have already completed Microsoft Office Excel 2007: Level 1, or have the equivalent working knowledge of it.
Who is this Microsoft Excel 2007 Level 2 Training Course aimed at?
The training course is aimed at people who want to increase their Microsoft Excel knowledge to enable them to create templates, sort and filter data, import and export data, analyse data, and work with Excel on the web.
This course is ideal for any students wish to work towards taking their Microsoftsoft Office Specialist exam in Excel. Students who take this exam, and participate in this course will already have a good basic knowledge of Excel and know how to create, edit, format and print a basic spreadhseet from the start.
Training Course Overview/Content:
Lesson 1: Enhancing Workbooks
Topic 1A: Customize the Excel Environment
Topic 1B: Customize an Excel Worksheet
Topic 1C: Enhance Worksheets Using Themes
Topic 1D: Work with Comments
Topic 1E: Access External Resources Using Hyperlinks
Topic 1F: Use Web-Based Research Tools
Lesson 2: Creating Workbooks Using Templates
Topic 2A: Create a Workbook from a Template
Topic 2B: Create a Custom Template
Lesson 3: Organizing Data Using Tables
Topic 3A: Create Tables
Topic 3B: Modify Tables
Topic 3C: Format Tables
Lesson 4: Presenting Data Using Charts
Topic 4A: Create a Chart
Topic 4B: Modify Charts
Topic 4C: Format Charts
Topic 4D: Create a Chart Template
Topic 4E: Share Excel Charts
Lesson 5: Analyzing Data Using PivotTables and PivotCharts
Topic 5A: Create a PivotTable
Topic 5B: Perform Calculations Using PivotTables
Topic 5C: Analyze Data Using PivotCharts
Lesson 6: Enhancing Visual Appeal Using Graphic Objects
Topic 6A: Insert Graphics
Topic 6B: Modify Graphic Objects
Topic 6C: Emphasize an Area of a Worksheet
Topic 6D: Illustrate Workflow Using SmartArt Graphics
Topic 6E: Format Graphic Objects
Topic 6F: Change the Order of Layered Graphic Objects
Topic 6G: Group Graphic Objects
Topic 6H: Organize Graphic Objects
Lesson 7: Calculating Data with Advanced Formulas
Topic 7A: Refer to a Range of Cells
Topic 7B: Calculate Data Across Worksheets
Topic 7C: Perform Date and Time Calculations
Topic 7D: Format Text Using Formulas
Topic 7E: Perform Numeric Calculations
Topic 7F: Calculate Data with Lookup and Reference Functions
Topic 7G: Perform Logical Analysis
Topic 7H: Print Formulas
Lesson 8: Sorting and Filtering Data
Topic 8A: Sort Data in a Spreadsheet
Topic 8B: Filter Data in a Spreadsheet
Topic 8C: Calculate Large Volumes of Data
Topic 8D: Add Subtotals to a Worksheet
For more general information on Microsoft Excel, check out the Wikipedia Microsoft Excel information page.
