Microsoft Excel 2007 Level 1 Training Course
Microsoft Excel 2007 Level 1 Training Course Summary
Training Course Price : £249
Training Course Length : 1 Day
This level 1 training course for Microsoft Excel 2007 is the first step of a 3 part training course series. It is for anyone who either wants to learn Microsoft Excel from the start, or who already has a very basic grasp of Excel, but wants to cement their knowledge and build upon it.
Upon successful completion of this course, students will be able to:
- Explore the Excel 2007 environment.
- Work with an Excel worksheet by entering and selecting the data in it. You will also save the data in the worksheet.
- Modify a worksheet.
- Perform calculations.
- Format a worksheet.
- Develop a workbook.
- Print workbook contents
- Customise the layout of the Excel application window.
Price: £249
Entry Level for Participants wanting to attend Microsoft Excel 2007 Level 1 Training Course
As this is the basic entry level course, there are no barriers to entry, however we do recommend that all participants have a basic knowledge of using Microsoft Windows, or have taken the Microsoft Office Windows X.
Who is this Microsoft Excel 2007 Level 1 Training Course aimed at?
Microsoft Excel Level 1 training is ideal for those who want to grasp the basics of using a spreadsheet - this course will guide you through creating, editing, formatting and printing a basic worksheet.
The course is also an ideal starting point for those who wish to progress to taking their certification as a Microsoft Office Specialist in Excel, and who already have knowledge of Microsoft® Office, Windows® 2000.
Training Course Overview/Content:
Lesson 1: Exploring the Excel Environment
Topic 1A: Explore the User Interface
Topic 1B: Explore the Ribbon
Topic 1C: Obtain Help
Topic 1D: Customise the Quick Access Toolbar
Lesson 2: Working with an Excel Worksheet
Topic 2A: Navigate in Excel
Topic 2B: Select and Enter Data
Topic 2C: Save a Workbook
Lesson 3: Modifying a Worksheet
Topic 3A: Manipulate Data
Topic 3B: Insert and Delete Cells, Columns, and Rows
Topic 3C: Search for Data in a Worksheet
Topic 3D: Spell Check a Worksheet
Lesson 4: Performing Calculations
Topic 4A: Create Basic Formulas
Topic 4B: Calculate with Functions
Topic 4C: Copy Formulas and Functions
Topic 4D: Create a Mixed Reference
Lesson 5: Formatting a Worksheet
Topic 5A: Convert Text to Columns
Topic 5B: Modify Fonts
Topic 5C: Add Borders and Color to Cells
Topic 5D: Change Column Width and Row Height
Topic 5E: Merge Cells
Topic 5F: Apply Number Formats
Topic 5G: Align Cell Contents
Topic 5H: Find and Replace Formats
Topic 5I: Apply AutoFormat
Topic 5J: Apply Cell Styles
Topic 5K: Apply Themes
Lesson 6: Developing a Workbook
Topic 6A: Format Worksheet Tabs
Topic 6B: Reposition Worksheets in a Workbook
Topic 6C: Insert and Delete Worksheets
Topic 6D: Copy and Paste Worksheets
Lesson 7: Printing Workbook Contents
Topic 7A: Set Print Titles
Topic 7B: Create a Header and a Footer
Topic 7C: Set Page Margins
Topic 7D: Change Page Orientation
Topic 7E: Set Page Breaks
Topic 7F: Print a Range
Lesson 8: Customising Layout
Topic 8A: Split a Worksheet
Topic 8B: Arrange Windows
Topic 8C: Freeze and Unfreeze Rows and Columns
Topic 8D: Hide and Unhide Worksheets
For more general information on Microsoft Excel, check out the Wikipedia Microsoft Excel information page.
