In this course, you will learn advanced techniques for working with Excel 2013*. You will import and export data and use style sheets. You will learn how to deal with filters and functions. In addition, you will deal with the topic of Pivot Tables and Pivot Charts, which allow flexible and intelligent evaluation of your data. You will find out how calculations can be visualised using professional-looking charts. In your calculations, you will draw on values from various spreadsheets. Finally, you will learn about the wide range of options for working with the date and time
*2007 and 2010 versions also available - please make a note in the comment section at the checkout if you require either of these.
Using special design options
Pivot tables and Pivot Charts
Working with the date and time
Approx. study time:
Lessons : 54
Learning hours : approximately 6
Audio hour : 3
The course is delivered entirely online.
The course can be started at any time.
The course contains 54 lessons with interactive content elearning content. There are practise sessions and end of chapter tests to check your progress.
The course is self-certified. You may print a certificate directly from the course, upon successful completion of a 'Final Test'
Access is for a period of 12 calendar months from date access is granted.
No tutor support is available for this package
Previous knowledge from the course Excel 2013 - Basic is required
Operating System requirements:
Microsoft Windows Vista / 7 / 8
Internet Explorer 7.0 or above
Under the browse Security Settings, enable the setting “Script ActiveX controls marked safe for scripting"
Firefox 2.0 or above
General system requirements:
CPU at least 1,5 GHz
At least 1 GB RAM
If applicable sound card and loudspeakers or ear phones
Price for this course is £59.95
By purchasing this course, you accept the following terms and conditions of our external training content provider, Expand Global:
Acceptance of EXPAND Global Online E-Learning Terms and Conditions
Your attention is drawn to the attached terms and conditions. In submitting this form you are confirming your
agreement and acceptance to the EXPAND Global Terms and Conditions.
Once your order is received, there are no refunds or cancellations. All sales are final.
A confirmation of your order will be provided to the contact identified in the order form.
Once access is made available, a notification will be provided via fax or e-mail.
If you have any difficulties with your access, follow the instructions on the access notification.
Access to the e-learning product will be provided within 5 business days following the receipt of full payment.
Access duration will be twelve (12) months from the date access is established.
This course is not yet eligible for ILA Scotland funding.