- Duration / Course length: Upto 6 Hours Start now
- Accredited by: CPDiAP
- Certificates:
- Course delivery: This course is delivered in video format
Course details
Looking for Microsoft Excel 2013 course for Advanced level? This online course is specially designed for the learners who have studied beginner or intermediate level course or are already confident with the basic features offered in Microsoft Excel. The advanced Excel course will surprise you, excellent teaching materials and lots of formulas to play around with. If you are looking to improve your Excel knowledge and your skills, this is the right course for you! What are you waiting for?If you know the basics of Excel, including entering data, formatting cells, using functions and formulae and inserting charts and graphs, this Advanced Excel course will really unlock the power of the programme and its advanced functionality. This advanced Microsoft Excel training course will teach you to use the advanced features of Excel to their full extent.
Microsoft Excel is a very powerful spreadsheet application designed to save you time and make easy work of calculating, displaying and sharing data. This Advanced Excel training course will introduce you to some of Excel's more powerful features.
This online training course is comprehensive and is designed to cover the following key topics are listed under the curriculum. This course has been designed for 15 guided learning hours.
COURSE CURRICULUM:
- Apply Conditional Formatting
- Trace Cells
- Troubleshoot Invalid Data and Formula Errors
- Watch and Evaluate Formulas
- Create a Data List Outline
- Create Sparklines and Scenarios
- Perform a Statistical Analysis with the Analysis ToolPak
- Create Interactive Data with Power View
- Consolidate Data
- Link Cells in Different Workbooks
- Erge Workbooks
- Export and Import Excel Data
- Integrate Excel Data with the Web
- Create a Web Query
You will have 12 Months access to your online study platform from the date you purchased the course. The course is self-paced so you decide how fast or slow the training goes. You can complete the course in stages revisiting the training at any time.
Method of Assessment:
At the end of the course learners will also take an online multiple choice questions assessment test. This online multiple choice questions test is marked automatically so you will receive an instant grade and know whether you have passed the course.
Certification:
Successful candidates will be awarded certificate for “Certificate in Microsoft Office Excel 2013 - Advanced”.
Benefits you will gain:
By enrolling in to this course, you’ll get:
- High quality e-learning study materials and mock exams.
- Tutorials/materials from the industry leading experts.
- Includes step-by-step tutorial videos and an effective, professional support service.
- 24/7 Access to the Learning Portal.
- Benefit of applying NUS extra Discount Card.
- Recognised Accredited Qualification.
- Access Course Content on Mobile, Tablet or Desktop.
- Study in a user friendly, advanced online learning platform.
- Excellent customer service and administrative support.
Ultima actualização em 10 December, 2024
Eligibility / Requirements
- To get the most out of this course, you will need to have completed our entry-level Microsoft Excel (Beginner level) or Intermediate course or have the equivalent experience of this extremely popular software.
- Learners should be ages 16 or over to undertake the qualification.
- Basic understanding of English language, literacy, numeracy and ICT are required to attend this course.