Introduction to Excel
Excel is the most commonly used tool in the workplace today for working with data. It is a massive application with 1000's of features and 100's of ribbon (menu) commands, and it's very easy to get lost if you've never used it before. In order to survive, the first step is to understand how to navigate Excel and access the features you are looking for.
Learn to create and work with workbooks, explore the menu options and learn to format the cells and spreadsheet. You will also be introduced to basic calculations and understand how important data integrity is.
Learn to create and work with workbooks, explore the menu options and learn to format the cells and spreadsheet. You will also be introduced to basic calculations and understand how important data integrity is.
On this one-day course you will learn the essential aspects of this powerful integrated spreadsheet product from Microsoft and gain a good understanding of Excel spreadsheets.
Workshop Content
Understanding Excel - creating a new workbook - opening an existing workbook - saving and Closing a workbook - Excel file types - understanding the Ribbon Working with and Formatting Spreadsheets - purpose of cells, rows and columns - types of cells and data types - change column and row height - data alignment and font selections - merge cells - add borders - change number formats Calculation and Formulas - calculations in Excel - the sum formula - practices to ensure data integrity Enhancing the Spreadsheet - autofill - replace and Find - spell check and grammar - print spreadsheets |
Unit Standards
SAQA US ID 116937: Use a Graphical User Interface (GUI)-Based Spreadsheet Application to Create and Edit Spreadsheets. NQF Level 2 4 Credits Duration
1 day Requirements
Basic knowledge of Windows and working with computers. Your own laptop with Excel 2007, 2010 or 2013. (If you do not have your own laptop, we can provide one for you to use for the course) Cost
R1 350 per person excluding VAT Price is for training in Gauteng. Price is for in-house training for 6 people or more. Assessment and Moderation R500 excluding VAT per person. Valid until 31 December 2017. We are happy to discuss all your training needs and work with you to meet your requirements. |