082 940 0940
  • Home
  • Microsoft Power BI
    • Power BI Workshop
    • Microsoft Power BI User Group
  • Excel
    • What is Excel Business Intelligence?
    • Introduction to Excel
    • Intermediate Excel
    • Advanced Excel: PivotTables & Pivot Charts
    • Excel Powers Workshop
    • Excel BI Boot Camp
    • PowerPivot
    • Power View
    • Power Query
    • Online Excel Courses
  • Our Clients
  • Online Courses
    • ExcelBusinessIntelligence.com
    • Partners >
      • Udemy.com
      • Shaw Academy
      • Coursera
      • Ed2Go
    • Business Courses
    • Personal Courses
  • Contact Us

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.
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.
Enquire now...
ICP Training                                                                                                                                                                          Terms and Conditions
Tel: 082 940 0940
E-Mail: info@icptraining.co.za

MICT Seta Accreditation 2015/02/0005
​