• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Microsoft Excel - Advanced Level

Microsoft Excel - Advanced Level

By John Academy

4.3(43)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 13 hours 40 minutes

  • All levels

Description

Description:

The Microsoft Excel program was designed to help people in their worksheets and spreadsheets. This course will teach you how to use SmartArt, pictures, text boxes and shapes to enhance your ability. You will learn to utilize many objects which have contextual tool tabs that appear when you select an object. Learn how to solve formula errors before they happen by using named ranges instead of cell references.

Who is the course for?
  • Professionals who want to learn about the Microsoft Excel 2013 advanced features.

  • People who have an interest in knowing all the functions of Microsoft Excel 2013.

Entry Requirement:
  • This course is available to all learners, of all academic backgrounds.

  • Learners should be aged 16 or over to undertake the qualification.

  • Good understanding of English language, numeracy and ICT are required to attend this course.

Assessment:
  • At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful.

  • Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.

Certification:
  • After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.

  • PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days.

Why choose us?
  • Affordable, engaging & high-quality e-learning study materials;

  • Tutorial videos/materials from the industry leading experts;

  • Study in a user-friendly, advanced online learning platform;

  • Efficient exam systems for the assessment and instant result;

  • The UK & internationally recognized accredited qualification;

  • Access to course content on mobile, tablet or desktop from anywhere anytime;

  • The benefit of career advancement opportunities;

  • 24/7 student support via email.

Career Path:

The Microsoft Excel Advanced course is a useful qualification to possess and would be beneficial for any Office job, such as:

  • Admin Assistant

  • PA

  • Secretary

  • Administrator

  • Account Assistant

  • Bookkeeper

  • Accountant

  • Office Manager.

Microsoft Excel - Advanced Level

Module One - Getting Started

01:00:00

Module Two - SmartArt and Objects

01:00:00

Module Three - Auditing

01:00:00

Module Four - Creating Charts

01:00:00

Module Five - Working with Charts

01:30:00

Module Six - Creating Pivot Tables and Pivot Charts

01:00:00

Module Seven - Macros

01:00:00

Module Eight - Solving Formula Errors

01:00:00

Module Nine - Using What If Analysis

01:00:00

Module Ten - Managing Your Data

02:00:00

Module Eleven - Grouping and Outlining Data

01:00:00

Module Twelve - Wrapping Up

00:30:00

Activities

Activities-Microsoft Excel - Advanced Level

00:00:00

Mock Exam

Mock Exam- Microsoft Excel - Advanced Level

00:20:00

Final Exam

Final Exam- Microsoft Excel - Advanced Level

00:20:00

Certificate and Transcript

Order Your Certificates and Transcripts

00:00:00

About The Provider

Tags

Reviews