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
Frequently Asked Questions
Is this course accredited?
BOTI offers a mix of SETA-accredited, internationally-certified (VMEdu) and non-accredited skills-programme courses. Please confirm a specific course's accreditation status with us when you enquire. All delegates receive a certificate of completion.
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?
Yes - skills development training can contribute to your B-BBEE scorecard, and where learnerships apply you may also access SETA grants and the Section 12H tax allowance. Ask us how to structure it for maximum points.
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.