Menu
Menu
  • No products in the basket.

Excel 2013 Advanced

4.5( 2 REVIEWS )
451 STUDENTS
ACCREDITED BY
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

Key Features

Gain an accredited UK qualification

Access to excellent quality study materials

Learners will be eligible for TOTUM Discount Card

Personalized learning experience

One year’s access to the course

Support by phone, live chat, and email

  • 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
  • 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
  • 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.

Upon the successful completion of the course, you will be awarded the “Certificate in Microsoft Excel 2013 Advanced Training”.

This Course is based on Microsoft Excel 2013

 

Career Path

Microsoft Excel is a very useful application which is used by all organisations now. Learn the software I an advanced level, so that even if you are a beginner, you could learn all the aspects of this software from the beginning. Learn to use this package for making reports, data analysis and many other organisational functions. A career with bright prospects await you with the completion of this course. According to www.payscale.uk, some of the key job positions along with the average UK salary per annum you can go for after completing this course will be as follows.

  • Administrative Assistant – £16,876 per annum
  • Personal Assistant – £25,144 per annum
  • Secretary – £19,554 per annum
  • Accounts Administrator – £18,669 per annum
  • Payroll Administrator – £20,025 per annum
  • Accountant – £28,571 per annum
  • Accounts Assistant – £18,876 per annum
  • Bookkeeper – £20,786 per annum
  • Office Manager – £24,447 per annum
  • Junior Accountant – £17,750 per annum
  • 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
  • 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
  • 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.

Upon the successful completion of the course, you will be awarded the “Certificate in Microsoft Excel 2013 Advanced Training”.

This Course is based on Microsoft Excel 2013

 

Career Path

Microsoft Excel is a very useful application which is used by all organisations now. Learn the software I an advanced level, so that even if you are a beginner, you could learn all the aspects of this software from the beginning. Learn to use this package for making reports, data analysis and many other organisational functions. A career with bright prospects await you with the completion of this course. According to www.payscale.uk, some of the key job positions along with the average UK salary per annum you can go for after completing this course will be as follows.

  • Administrative Assistant – £16,876 per annum
  • Personal Assistant – £25,144 per annum
  • Secretary – £19,554 per annum
  • Accounts Administrator – £18,669 per annum
  • Payroll Administrator – £20,025 per annum
  • Accountant – £28,571 per annum
  • Accounts Assistant – £18,876 per annum
  • Bookkeeper – £20,786 per annum
  • Office Manager – £24,447 per annum
  • Junior Accountant – £17,750 per annum
Course Curriculum Total Units : 17
1: Apply Conditional Formatting
Apply Conditional Formatting
2: Trace Cells
Trace Cells
3: Troubleshoot Invalid Data and Formula Errors
Troubleshoot Invalid Data and Formula Errors
4: Watch and Evaluate Formulas
Watch and Evaluate Formulas
5: Create a Data List Outline
Create a Data List Outline
6: Create Sparklines and Scenarios
Create Sparklines and Scenarios
7: Perform a Statistical Analysis with the Analysis ToolPak
Perform a Statistical Analysis with the Analysis ToolPak
8: Create Interactive Data with Power View
Create Interactive Data with Power View
9: Consolidate Data
Consolidate Data
10: Link Cells in Different Workbooks
Link Cells in Different Workbooks
11: erge Workbooks
erge Workbooks
12: Export and Import Excel Data
Export and Import Excel Data
13: Integrate Excel Data with the Web
Integrate Excel Data with the Web
14: Create a Web Query
Create a Web Query
Mock Exam
Mock Exam: Microsoft Excel 2013 – Advanced
Final Exam
Exam: Microsoft Excel 2013 – Advanced
Certificate Download Guide
Certificate Download Guide
WhatsApp chat