| Microsoft Excel 2002 XP | ||
| 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• Entering Excel• The Window • Toolbars • Task Panes • Online Help • Opening An Existing Document • Starting A New File • Exiting Excel Moving Around The Worksheet• Cursor Movement And Scrolling• Selecting Text 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• Undo & Redo Feature • Clearing Cell Contents Relative And Absolute References• Entering the Formula• Editing the Formula • Naming cells Formatting Data• Changing Column Widths• Changing Row Heights • Inserting Rows & Columns • Deleting Rows & Columns Worksheet Formatting• Formatting Text• Adding Borders • Using Numeric Formats • Using Date Formats • Conditional Formatting • Format Painter Printing A Worksheet• Printing the Entire Worksheet• Printing a Selected Area • Using Print Preview • 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 Graphs• Building A Graph Using The Wizard• Modifying The Graph • Legends/Titles • Adding & Deleting Data Series • Adding Text • Chart Types • Saving Graphs • Default Chart Format • Changing The Default Chart • Embedded Charts & Chart Sheets • Adjusting Worksheet Data Via The Chart • Printing An Embedded Chart |
|
