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. A delegate will learn to enter and edit data, create formulas and format elements of a worksheet.
| This course consists of 6 modules | |
|---|---|
| Module 1 | What is an Excel Spreadsheet?Start Excel Minimize/Maximize/Restore/Close The Excel Application Window The Quick Access Toolbar The Ribbon Sheet Tabs Backstage View Shortcut Menus Using Dialog Boxes Using Help Tiling Windows and Sheets |
| Module 2 | Create a New Spreadsheet Types of Information Enter Information Delete Information Undo & Redo Edits Selecting cell(s), Column(s), Row(s) Edit the Text in a Worksheet Using Autofill to Copy or Fill a Series Freezing Panes, Grouping Sheets Insert/Delete/Rename Sheets AutoCorrect AutoComplete Pick List, Find & Replace Hide & Unhide Worksheets |
| Module 3 | Saving Workbooks Recover Unsaved Files Saving with File Properties Password Protection Closing Workbooks Create a New Workbook Understand Templates Open an Existing Workbook |
| Module 4 | AutoSum – Total Rows & Columns Create Simple Formulas Basic Concepts on Formulas Date/Time Function Name Ranges Cut/Copy/Paste Paste Special Move Data between Cells Inserting/Deleting Rows & Columns Formula Error Messages |
| Module 5 | Copy & Move Sheets Format Data Format Painter Change Number Formats Hiding Zeros Formatting Cells (Front, Size, Colour) Row Height/Column Width Wrapping Text in a Cell Shrink Text to fit in Cell Merge Cells Alignment Merge & Center Text Indent Cell Contents Cell Background Colour Borders |
| Module 6 | Spell Check Preview a Worksheet, Adjust the Scaling of a Worksheet Print Titles Page Breaks Headers & Footers Print Worksheet Data Print Gridlines Exercise Glossary |
Any delegate wanting to obtain basic skills in using a spreadsheet, such as updating data, applying formatting, printing and making basic calculations.
1 Day
R1 270,00 (excl. VAT)
View the available course dates
