Excel Introduction Course Outlines
Pre requisitDuration:1 Day (8:30 am - 3:30 pm)
Objective: To gain an understanding of the potential of Excel. Be able to create basic formulas apply formatting and print successfully. Essential: Have Mouse Skills, an awareness of keys on keyboard e.g.: Shift, space bar, and Enter key. Learning Outcomes: By the end of the day you will be able to have an understanding of what Excel is capable of. Create your own spread sheets, apply formatting, perform basic Formulas/Functions and print. |
TopicsModule 1 Getting Started: Opening an Existing Spreadsheet Using Templates Understand Compatibility Mode Getting to Know the Environment Saving.
Module 2 Navigating: Cell Pointers Navigation Techniques Selection Techniques Freezing Panes Splitting Zoom. Module 3 Editing: Worksheets Entering Data Editing Data Undo & Re Do Deleting Data Deleting Columns & Rows Inserting Columns & rows Change Column Width. Module 4 Automated Features: AutoComplete Auto Fill Module 5 Formulas & Functions Basic Formulas Basic Functions:- Sum, Average, Max, Min, Count, Counta Using the Function Wizard Relative Cell Referencing Basic Absolute Cell referencing. Module 6 Formatting: Cells Font Formatting Conditional Formatting Formatting $ % Decimals Using Clear Format Using Clear all Using Format Painter Merge Cells, Text Wrap Apply Borders Cut, Copy, Paste Paste Special :- Keep source column width. Module 7 Printing: Work in Page Break Preview Insert page breaks Set headers to repeat Understand Page Setup settings Print – Selection. |