In this one-day instructor-led course, students will use Excel 2007 to streamline and enhance spreadsheets with templates, charts, graphics and formulas. They will apply visual elements and advanced formulas to a worksheet to display data in various formats 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:
• Calculate with advanced formulas • Organise worksheet and table data using various techniques • Create and modify charts • Analyse data using PivotTables and PivotCharts • Insert graphic objects • Customise and enhance workbooks and the Microsoft Office Excel environment
Revision Exercises • Creating Formulas • Formula Summary • Creating a Worksheet • Editing a Worksheet
Absolute Cell Referencing Functions • Function Syntax • The MAX Function • The MIN Function • The IF Function • Financial Functions • Date Functions
Range Names • Defining Range Names • Names in Formulas • Navigating with Names • Using Named Constants • Documenting Range Names
Lists • Extended Formatting and Formulas • Adding Records • Sorting Data • Using a Data Form • Filtering Records • Subtotals • Outline Symbols • Using other Functions • Using Page Breaks • Removing Subtotals
Charts • Changing the Chart • Type • The Legend • Gridlines
Formatting Charts • Printing Charts • Separate Chart Sheets • Coloured Sheet Tabs • Printing Separate Chart Sheets
The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web. In addition, this course helps prepare students who desire to take the Microsoft Office Specialist exam in Excel and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.
Before attending this course it is recommended participants have completed the Excel 2007 - Level 1 course or have the equivalent working experience.
