Trusted Training Partners
Home / Non-Accredited / Software & IT Non-Accredited / Ms Office Excel Beginners 2010 Satur Training Course
Quick Look Course Summary:Ms Office Excel Beginners 2010 Satur Training Course
-
Next Public Course Date:
-
Length: 1 day(s)
-
Price (at your venue): 1 Person R 4,811 EX VAT 3 Person R 3,654 EX VAT 10 Person R 2,719 EX VAT
-
Certification Type:Accredited
-
Locations & Venues: Off-site or in-house. We train in all major city centres throughout South Africa.
Get Free & personalised
Training Advice
Ms Office Excel Beginners 2010 Satur Training Course Course: Introduction
This is a Saturday course for beginner’s in Excel, it is one of several Saturday courses we provide. This is intended for novices who have no prior knowledge of Excel. It is a practical course and all course materials will be provided. We will discuss topics such as workbooks, Excel terminology, cells, rows and columns and the features to edit them. Other topics include tables, workbook appearance and printing.
Ms Office Excel Beginners 2010 Satur Training Course Course :Course Outline
1. Setting Up a Workbook
Creating Workbooks
Terminology
Excel Environment
Customising Quick Access Toolbar
Creating a New Workbook
Entering Data into Workbook
Saving a workbook
Open a workbook
Zoom
Insert a new worksheet
Renaming a new worksheet
Changing the tab colour of worksheet
Rearranging the order of worksheets
Move or Copy worksheets
Hide or Unhide Worksheets
Switch windows
Modifying Workbooks and Worksheets
Changing column widths and row heights
Insert Columns or Rows
Delete Columns or Rows
Hide or Unhide columns or rows
Insert Cells
Moving Data by dragging
Customising Excel 2010
Arranging multiple workbook windows.
Customising the ribbon
Minimising the ribbon
2. Working with Data and Excel Tables
Entering Data
Copy, Cut and Paste
Pick from drop down list
Find and Replace data
Spell Check
Thesaurus
Defining an Excel Table
Format as table
Table design
Basic Formulas
How to create a basic formula
Operators
Copy formula down
Absolute cell reference
Basic Functions
Insert a function
Autosum, sum, min, max and average
3. Changing Workbook Appearance
Format Cells
Changing Font, Font size and Font Colour
Borders
Bolt, Italic and Underline
Fill Colour
Themes
Format Numbers as percentage, currency and general
Insert a Picture
Picture Styles, remove background, picture effects
Insert Background
4. Printing
Inserting Headers and Footers
Print Preview
Page Setup
Page break preview
Print active worksheets
Print entire workbook
Print Selection
Print titles
Set Print area
Centre data on page
Ms Office Excel Beginners 2010 Satur Training Course Course: Course Duration
1 day/s
Who should attend: Ms Office Excel Beginners 2010 Satur Training Course Course
This course is intended for novice users of Microsoft Excel.
**Quote does not include Any Exam Fees (if applicable)
IMPORTANT ACTION: Do Not Wait To Improve Your Skills. Â
Book Now By Completing Online Booking Form / Customised Proposal or Obtain Approval For Your Already Received Customised Proposal
About this course
This course is not accredited. It is delivered as a professional skills programme, and delegates receive a BOTI certificate of attendance.
If you need a credit-bearing outcome for B-BBEE skills development, SETA grant or learnership purposes, please see our accredited qualifications and skills programmes, or read about BOTI accreditations.
Frequently Asked Questions
Is this course accredited?
No. This course is delivered as a practical, facilitator-led skills programme and delegates receive a BOTI certificate of attendance. If you need a credit-bearing outcome for B-BBEE skills development, SETA grant or learnership purposes, ask us about our accredited qualifications, skills programmes and unit standards.
Can this course be delivered in-house at our premises?
Yes. Every BOTI course can be delivered on-site at your offices anywhere in South Africa, or at a scheduled public venue, and can be customised to your team and industry.
How do I book or get a quote?
Use the enquiry form on this page for a tailored quote, or call 011 882 8853 / email [email protected]. The course length and next public course date are shown in the Quick Look summary.
Can this training count towards our B-BBEE scorecard?
Spend on this course still counts as skills development expenditure for B-BBEE purposes, but it does not count as accredited training spend, and the Codes limit how much non-accredited training can contribute. Please confirm the treatment with your skills development facilitator or B-BBEE verification agency.
Do you tailor the training to our industry?
Yes. Our training is built around your business, using practical, real-world examples relevant to your team and sector.