Course Description

Excel 2013 Advanced



Excel 2013 Advanced is a course run by 1 Training, Dublin. It is a 'Online Learning' course . For more information about Excel 2013 Advanced at 1 Training, please review the details below.

Excel 2013 Advanced

Do you need to get to grips with Microsoft Excel 2013?

Course Description:

Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organised with checklists. This course gives information on the advanced functions of Excel, so if you have experience with Excel, you can build expert knowledge.

Our learning material is available to students 24/7 anywhere in the world, so it’s extremely convenient. These intensive online courses are open to everyone, as long as you have an interest in the topic! We provide world-class learning led by IAP, so you can be assured that the material is high quality, accurate and up-to-date.

What skills will I gain?

  • Learn how to manage cell contents in a worksheet
  • Learn how to create financial reports
  • Understand accounting formulas, functions & specialised functions
  • Learn cell attributes & cell formatting
  • Gain a full understanding of printing excel sheets
  • Logging in to this course, you’ll learn how to insert & modify graphic objects
  • Learn conditional formatting and data validations
  • Learn how to export, import & integrate data with other sources

What is the target audience?

  • Job hunters & School leavers
  • College or University student, graduates & Teachers
  • Personal assistant & Receptionist
  • Assistant for company director
  • Office Administrators & Office managers
  • Office clerk, Marketing assistant & Administration Assistant
  • Secretary or Executive
  • Account assistance, Bookkeeper & Accountant
  • IT professionals & Businessman

How will I be assessed?

  • At the end of the course learners will take an online multiple choice question assessment test. This online multiple choice question test is marked automatically so you will receive an instant grade and know whether you have passed the course.
  • Those who successfully pass this course will be awarded a free e-certificate, and only need to pay £19 for your printed certificate.

What Certification am I going to receive?

If you pass the exam successfully then you will be awarded a  Advanced Microsoft Excel 2013 Training Certificate.

Course Curriculum Total Units : 16
1: Apply Conditional Formatting
2: Trace Cells
3: Troubleshoot Invalid Data and Formula Errors
4: Watch and Evaluate Formulas
5: Create a Data List Outline
6: Create Sparklines and Scenarios
7: Perform a Statistical Analysis with the Analysis ToolPak
8: Create Interactive Data with Power View
9: Consolidate Data
10: Link Cells in Different Workbooks
11: erge Workbooks
12: Export and Import Excel Data
13: Integrate Excel Data with the Web
14: Create a Web Query

The Excel 2013 Advanced course at 1 Training is listed in Courses.ie's national courses finder.
Training Provider1 Training
Course LocationDublin
Course TypeOnline Learning
Course Fee18
Entry Requirements• You must be 16 or over • You should have a basic understanding of English and basic IT knowledge • You will need a computer or tablet with internet connection (or access to one) • Learners must have Microsoft Excel 2013 installed onto their computer
Phone+44 208 610 9650
For more information about 1 Training, please visit our College page on Courses.ie by clicking here.

Course Provider

1 Training



63/66 Hatton Garden, 5th Floor, Suite 23, London. EC1N 8LE, Dublin, United Kingdom. Eircode: EC1N 8LE

Make Enquiry

Please insert your contact details and any additional information you require and we will forward your request to 1 Training




Captcha code        I confirm I have read the Cookie Information, Terms and Conditions and Privacy Policy and I agree to join the Courses.ie community.
 

Map