This one-day instructor-led course will provide a thorough understanding of introductory and intermediate concepts and skills that will enable the participant to effectively use Microsoft Excel 2007 through group and individual instruction, hands-on practical exercises, visual aids, and comprehensive training manuals and materials.
Upon successful completion of this course, students will be able to:
• Create basic worksheets • Perform calculations • Modify a worksheet • Format a worksheet • Print workbook contents • Manage large workbooks
Starting Excel • The Excel Screen • The Ribbon • The Microsoft Office Button
Moving around a Sheet • Displaying other Areas • Mouse Movements • Viewing other Sheets • Selecting Cells
Inserting Text and Numbers • Typing the Text • Adjusting Column Widths • Typing Numbers
Saving a Workbook • The My Places Bar • The My Places Bar • File Properties
Alignment & Indenting • Indenting • Centre Aligning • Merge and Centre
Calculations • BEDMAS Rule • AutoSum • Filling the Formula • Basic Formulas • AutoCalculate • Cell Editing
Multiple Worksheets • Copying Sheet Contents • Data Entry Ranges • Calculating across Worksheets • Copying Formulas
Functions • Function Syntax • The AVERAGE Function • The MAX Function • The MIN Function
Working with Worksheets • Renaming Sheets • Inserting a Sheet • Deleting Sheets
Formatting • Fonts and Fonts Sizes • Number Formatting • Formatting a Group of Sheets • Borders • The Format Painter • Cell Shading • Font Colour • Inserting Images
Print Preview • Page Break Preview • Adjusting the Page Breaks • Previewing the Workbook • Zoom • Margins and Column Widths • Column Widths in Print Preview
Page Setup • Orientation • Scaling • Margin Settings • Headers and Footers • Built-In Headers and Footers • Custom Headers and Footers • Sheet Options • Print Areas
This course is designed for people preparing for certification as a Microsoft Certified Application Specialist in Excel, who already have knowledge of Microsoft Office, and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007 worksheets.
Microsoft Excel 2007 Level 1 assumes little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system.