Microsoft Excel 2013 Advanced
Accredited by IAP | FREE Digital Certificate | Premium Quality Video Lessons | No Hidden Fees | Access for 365 Days
1 Training
Summary
- Exam(s) / assessment(s) not included in price, and must be purchased separately
Overview
Excel 2013 Advanced
Do you need to get to grips with Microsoft Excel 2013?
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 Excel 2013 Advanced 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 using Excel 2013 Advanced
- Learn how to create financial reports using excel
- Understand accounting formulas, functions & specialised functions
- Learn cell attributes & cell formatting in excel sheets
- 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
CPD
Course media
Description
COURSE CURRICULUM
➽ (Module 01) Apply Conditional Formatting
➽ (Module 02) Trace Cells
➽ (Module 03) Troubleshoot Invalid Data and Formula Errors
➽ (Module 04) Watch and Evaluate Formulas
➽ (Module 05) Create a Data List Outline
➽ (Module 06) Create Sparklines and Scenarios
➽ (Module 07) Perform a Statistical Analysis with the Analysis ToolPak
➽ (Module 08) Create Interactive Data with Power View
➽ (Module 09) Consolidate Data
➽ (Module 10) Link Cells in Different Workbooks
➽ (Module 11) Merge Workbooks
➽ (Module 12) Export and Import Excel Data
➽ (Module 13) Integrate Excel Data with the Web
➽ (Module 14) Create a Web Query
Method of assessment
- At the end of the course Microsoft Excel 2013 Advanced Training, 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.
Certification
Upon the successful completion of the Microsoft Excel 2013 Advanced Training course, you will be awarded the “Certificate in Microsoft Excel 2013 Advanced Training”.
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
Who is this course for?
- 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
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
Career path
- 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
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.