|
Microsoft Certified Application Specialist (MCAS) 
1 Day CourseCourse Description In this course, students create and edit basic Microsoft Office Excel 2007 worksheets and workbooks. The class will cover formatting, editing, printing and an introduction to basic formulas and functions. Performance-based objectives - 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 This course is designed for people preparing for certification as a Microsoft Certified Application Specialist in Excel, who already have knowledge of Microsoft Office, Windows 2000 (or above), and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007 worksheets. Students should have a working knowledge of the Windows Operating System. Course Content Lesson 1: Exploring the Excel Environment - Explore the User Interface
- Explore the Ribbon
- Obtain Help
- Customize the Quick Access Toolbar
Lesson 2: Working with an Excel Worksheet - Navigate in Excel
- Select and Enter Data
- Save a Workbook
Lesson 3: Modifying a Worksheet - Manipulate Data
- Insert and Delete Cells, Columns, and Rows
- Search for Data in a Worksheet
- Spell Check a Worksheet
Lesson 4: Performing Calculations - Create Basic Formulas
- Calculate with Functions
- Copy Formulas and Functions
- Create a Mixed Reference
Lesson 5: 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
Lesson 6: Developing a Workbook - Format Worksheet Tabs
- Reposition Worksheets in a Workbook
- Insert and Delete Worksheets
- Copy and Paste Worksheets
Lesson 7: Printing Workbook Contents - Set Print Titles
- Create a Header and a Footer
- Set Page Margins
- Change Page Orientation
- Set Page Breaks
- Print a Range
Lesson 8: Customizing Layout
For more information on Microsoft Office 2007 Classes
Please contact Rhuann Heimann at 618-523-4893 or
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
For a full listing of Acumen's courses please click here.
|
