Trusted Training Partners
Home / Non-Accredited / Software & IT Non-Accredited / Ms Office Excel Advanced 2010 Satur Training Course
Quick Look Course Summary:Ms Office Excel Advanced 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 Advanced 2010 Satur Training Course Course: Introduction
This is the Advanced Saturday course in Excel, it is intended for intermediate Excel users who wish to gain an expert level of knowledge about Excel. We will discuss advanced functions and features, including pivot tables. This is a practical course and all materials needed by participants will be provided.
Ms Office Excel Advanced 2010 Satur Training Course Course :Course Outline
1. Analysing Alternative Data Sets
Scenario Manager and Scenario Summary
Goal Seek
Solver
Analysing Data by using statistics
Creating custom views
2. Advanced Functions
If Statements
Other functions
Nested If Statement
SumIf, CountIf, AverageIf
Round function
PMT Function
Showing and or Hiding Formulas
3. Creating Dynamic Worksheets by Using Pivot Tables
Working with Pivot Tables
Adding Fields to Pivot Tables
Filter, Show and Hide Pivot Table data
Using Slicers to filter data
Rearranging Pivot Tables
Moving fields
Collapsing and Expanding Fields
Refreshing Data
Editing Pivot Table
Show Value As
Get Pivot Data function
Adding Subtotals and Grand Totals
Formatting field settings
Applying a Pivot Table Style
Creating a new custom Pivot table Style
Creating Pivot Tables from external data import
4. Creating Charts and Graphics
Customising the appearance of charts
Trend lines
Sparklines
Pivot Charts
Smart Art
Insert Shapes and Mathematical Equations
5. Automation of Repetitive Tasks Using Macros
Enabling and Examining Macros
Creating Macros
Editing Macros
Add Macros button to Quick Access Toolbar
Run a macro when a workbook is opened
6. Working with Other Microsoft Office Programs
Linking and or Embedding other office files
Hyper linking
Pasting charts into other documents
Ms Office Excel Advanced 2010 Satur Training Course Course: Course Duration
1 day/s
Who should attend: Ms Office Excel Advanced 2010 Satur Training Course Course
This course is intended for advanced 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.