This one-day course is designed to help a delegate to obtain the basic skills required to create and use a spreadsheet using Microsoft Excel.
MS Windows & Internet (Introduction)
English
Course is facilitated by a competent & experienced subject matter trainer, who utilises the following techniques to ensure that the session is practical and experiential:Â Questions; Discussion; Exercises & Assessments.
Any delegate wanting to obtain basic skills in using a spreadsheet.
1 Day
Module 1 | What is Microsoft Excel The Excel User Interface The Quick Access Toolbar Worksheet Elements The Backstage View Using the Ribbon Sheet Tabs Shortcut Menus Viewing Multiple Workbooks on the same Screen Tiling Multiple Worksheets on the same Screen |
Module 2 | Create a Spreadsheet Types of Information Autofill Feature Autofill Options Creating a Custom List of Data Importing Lists into Custom Lists Freezing Panes Grouping and Ungrouping Worksheets Inserting, Deleting and Renaming Sheets Autocorrect Feature Autocomplete Pick from Drop-Down List Find and Replace Hide and Unhide a Worksheet |
Module 3 | The Save and Save As Commands Automatically Saving Workbooks Recover Unsaved New Workbooks Create a New Workbook Opening an Existing Workbook Understanding Templates Closing Workbooks |
Module 4 | Create Worksheet Formulas Basic Concepts on Formulas Customize the Status Bar Display the Current Date Cut, Copy, Paste Format Painter Paste Special Additional Information - Relative & Absolute References Formula Errors |
Module 5 | Moving and Copying Sheets Format Painter Number Formatting Create a Custom Number Format Hiding Zeros Fonts and Font Sizes The Mini Toolbar Adjusting Row Heights and Column Widths Hide and Unhide Columns and Rows Wrapping Text Alignment Text Orientation Merge and Center Indent Cell Contents Fill Colour Adding Borders and Lines Adding Custom Borders & Lines using the Menu Command |
Module 6 | Check Spelling Preview a Worksheet Adjust the Print Scaling Page Margins Center on Page Page Breaks Changing the Print Order Headers and Footers Printing a Worksheet Printing Gridlines |