| Microsoft Excel 2007 | ||
| Level: Introductory | Level: Intermediate | |
| Duration - 1 Day | Duration - 1 Day | |
|
This course is designed to introduce the Student to the basic functions of the package. Delegates should be familiar with the Windows environment. What is Excel• The Window• The Ribbon • Dialog Box Launcher • Task Panes • Online Help • Using Different Views • Opening An Existing Document • Starting A New File • Exiting Excel Moving Around The Worksheet• Cursor Movement And Scrolling• Selecting Text • Shortcut Menus Entering Data In A Worksheet• Editing A Cell Autofill/Pick from List/Autocomplete• Smart Tags • Entering Formulae • Common Functions File Commands• Saving Files• Naming A File • Adding Files & Folders to My Places • Closing A Worksheet Moving And Copying Cells/Ranges• Copying Contents/Formats Only• Smart Tags • Undo & Redo Feature • Clearing Cell Contents Relative And Absolute References• Entering the Formula• Editing the Formula • Naming cells Formatting the Worksheet• Changing Column Widths• Changing Row Heights • Inserting Rows & Columns • Deleting Rows & Columns Formatting Cells• Formatting Text• Adding Borders • Using Numeric Formats • Using Date Formats • Conditional Formatting • AutoFormat • Format Painter Printing A Worksheet• Printing the Entire Worksheet• Printing a Selected Area • Using Page Layout view • Printing In Landscape • Aligning Text On The Page • Changing Margins/Scaling • Page Breaks • Inserting Headers/Footers/Page Numbers |
This course is designed to familiarise the Student with the more advanced techniques of the package. Delegates should have completed an Excel Introductory course prior to attending. Multiple Worksheets• Inserting/Deleting/Moving/Copying Worksheets• Naming Worksheets • Grouping & Ungrouping Sheets • Selecting 3D Ranges • Summing through multiple sheets • Printing Multiple Worksheets • Inserting Page Breaks Working With Windows• Freezing Window Panes• Splitting Window Panes Naming Cells• Naming Individual Cells• Naming a Range of Cells • Assigning a Value to a Name • Using Names in Formulae • Using Range Names in Navigation • Workbook v Worksheet names Creating Custom Number Formats• Creating a Custom FormatAdvanced Functions• Financial/Statistical Functions• Information Functions • Cell Test Functions • Logical/Lookup Functions • Text Functions Protecting Worksheets & Cells• Sheet Protection• Unlocking a range of cells • Hiding Formulae in Cells • Workbook Protection • Allow Users to Edit Ranges • Saving a file with a Password Excel Database• Sorting a Database• Producing SubTotals • Filtering the Database • Copying filtered data • Charting Filtered Data Creating Charts• Building a Chart Using The Wizard• Modifying the Chart • Legends/Titles • Adding & Deleting Data Series • Adding Text • Chart Types • Saving a Chart Template • Using a Chart Template • Changing The Default Chart • Embedded Charts & Chart Sheets • Adjusting Worksheet Data Via The Chart • Printing An Embedded Chart |
|
