Trusted Training Partners
Home / Non-Accredited / Software & IT Non-Accredited / Ms Office Excel Intermediate 2013 Sat Training Course
Quick Look Course Summary:Ms Office Excel Intermediate 2013 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 2013 Sat Training Course Course: Introduction
This course is intended for all users of Excel. This course incorporates some new features and connectivity options in efforts to make collaboration and production as easy as possible. Also included are advanced formulas, data analyzing, tables, data charts, graphics and enhancing workbooks.
Ms Office Excel Intermediate 2013 Sat Training Course Course :Course Outline
1. Introduction
Creating advanced formulas
Apply range names
2. Tables
Create and modify tables
Sort and filter data
Use subtotal and database functions to calculate
3. Visualising data with charts
Create charts
Modify and format charts
Create a trend line
Create advanced charts
4. Inserting graphics
Insert and edit graphics
Layer and group graphics
Add and edit SmartArt
5. Enhancing workbooks
Customise workbooks
Manage themes
Create and use templates
Protect files
Preparing a workbook for multiple audiences
6. Auditing worksheets
Trace cells
Invalid data and formula errors
Evaluate and monitor formulas
Create a data list outline
7. Multiple workbooks
Consolidate data
Link cells in different workbooks
Merge workbooks
Managing large workbooks
Format and rename worksheet tabs
Edit and monitor worksheets
Ms Office Excel Intermediate 2013 Sat Training Course Course: Course Duration
1 day/s
Who should attend: Ms Office Excel Intermediate 2013 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.