Request availability or book by selecting a date: England
Berkshire
Manchester (Greater)
Shropshire
Yorkshire (West)
Prices exclude VAT.
Why do prices vary? Using CourseMonster, you search the schedules of over 100 training companies in one convenient location. Choose the city, date and price that best suits you.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.
|
Course Overview This course is designed for people who wish to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007 worksheets and maybe preparing for certification as a Microsoft Office Specialist in Excel, who already have knowledge of Microsoft Office, Windows 2000 or above. Audience For users new to Excel 2007, this course provides the ideal introduction. Skills Gained 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.
- customize the layout of the Excel application window.
Prerequisites It is recommended that you take the Microsoft Office Windows XP Introduction course or have equivalent knowledge. This course is rated as a Fundamentals Course, suitable for novice computer users and beginners. Course Outline Exploring the Excel Environment - Explore the User Interface
- Explore the Ribbon
- Obtain Help
- Customize the Quick Access Toolbar
Working with an Excel Worksheet - Navigate in Excel
- Select and Enter Data
- Save a Workbook
Modifying a Worksheet - Manipulate Data
- Insert and Delete Cells, Columns, and Rows
- Search for Data in a Worksheet
- Spell Check a Worksheet
Performing Calculations - Create Basic Formulas
- Calculate with Functions
- Copy Formulas and Functions
- Create a Mixed Reference
Formatting a Worksheet - Convert Text to Columns
- Modify Fonts
- Add Borders and Color to Cells
- Change Column Width and Row Height
- Merge Cells
- Apply Number Formats
- Align Cell Contents
- Find and Replace Formats
- Apply AutoFormat
- Apply Cell Styles
- Apply Themes
Developing a Workbook - Format Worksheet Tabs
- Reposition Worksheets in a Workbook
- Insert and Delete Worksheets
- Copy and Paste Worksheets
Printing Workbook Contents - Set Print Titles
- Create a Header and a Footer
- Set Page Margins
- Change Page Orientation
- Set Page Breaks
- Print a Range
Customizing Layout - Split a Worksheet
- Arrange Windows
- Freeze and Unfreeze Rows and Columns
- Hide and Unhide Worksheets
How to make a booking for the MEX07-22 course
|
