Overview
Our Microsoft Excel Essentials program is designed for students who wish to advance their computer skills by learning to work with Microsoft Excel. The course is aimed at those who have no or limited experience with Excel.
Course facilitators are knowledgeable in all levels of Excel and use the software on a daily basis. You will receive hands-on training by our patient, experienced facilitators, and easy to ready printed courseware for future reference.
At the conclusion of the training, you will be issued with a Certificate of Completion.
Included Topics
Navigating Excel
- Basic Excel concepts and uses
- Ribbon, Status Bar and Quick Access toolbar
- Create and Save a Workbook
- Insert, Delete, Copy and Move Worksheets
- Naming and colouring worksheets tabs
Editing and Formatting in Excel
- Insert or Delete Cells/Rows/Columns
- Use AutoComplete and AutoFill
- Cut, Copy, and Paste text
- Wrap, Merge and Centre Text
- Number and text formatting and alignment
- Borders and Shading
Basic Excel formulas
- Use Math Operators
- AutoSum
- Relative and Absolute references
- Copying formulas
Work with Rows and Columns
- Set Row Height and Column Width
- Hide and Unhide Rows and Columns
- Freeze Panes
Useful Functions
- Find and Replace Data
- Sort Data
- Create and Use Comments
Print Worksheets
- Page Orientation
- Set and Clear Print Area
- Set Margins
- Print Scaling
- Headers and Footers
- Print to PDF
Basic Charts
- Create, Format, and Move Charts
- Print Charts
Using Help
- Online Help
- Smart Lookup
- Tell Me