Trusted Training Partners
Home / Non-Accredited / Software & IT Non-Accredited / Ms Office Excel Intermediate 2010 Sat Training Course
Quick Look Course Summary:Ms Office Excel Intermediate 2010 Sat 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 Intermediate 2010 Sat Training Course Course: Introduction
This is one of several Excel courses we offer. This is a practical course and all materials needed by participants will be provided. This is also one of our Saturday courses to accommodate participants who find other times difficult to attend.
Ms Office Excel Intermediate 2010 Sat Training Course Course :Course Outline
1. Performing Calculations
Named Ranges
Creating Formulas to Calculate Values
Summarising data using If function
Formula Auditing
Adding a watch Window
Tracing Formula Errors
Tracing Precedents and Dependent cells
2. Changing Workbook Appearance
Defining Styles
Making Numbers easier to read
Transposing data
Changing Cell Orientation and Merging Cells
Change appearance of data based on its value
Focusing on specific data by using filters
Inserting Filters
Sort A to Z using Filters
Number Filters
Clear Filters
Advanced Filtering
Summarising worksheets with hidden and filtered rows (subtotal and aggregate functions)
Data Validation
3. Reordering and Summarising Data
Sort Data
Custom Lists
Organising data into levels using subtotals
Creating an outline
Lookup Functions
4. Combining Data from Multiple Sources
Built-in Templates
Using workbooks as templates for other workbooks
Linking to data in other workbooks
Consolidating data
Saving workbooks as a workspace
Comments in cells and workbooks
Viewing Comments in a worksheet
Adding and Removing comments
Adding comments to a workbook
Password protect a worksheet and workbook
Unlock cells and protecting part of a worksheet
Track Changes
Mark a workbook as final
Ms Office Excel Intermediate 2010 Sat Training Course Course: Course Duration
1 day/s
Who should attend: Ms Office Excel Intermediate 2010 Sat Training Course Course
This course is intended for intermediate 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.