0
  • LOGIN

  • No products in the cart.

Microsoft Excel Complete Course – Beginners, Intermediate, Advanced

4.9( 12 REVIEWS )
433 STUDENTS

Description:

Improve your competency in Microsoft Office with this Microsoft Excel Complete Course – Beginners, Intermediate, Advanced. Microsoft Excel is the most widely used spreadsheet program in the world. It allows businesses to conduct data analysis, record expenditures and carry out simple to complex maths calculations. Want to master Excel? This complete training course will help you gain the practical skills and knowledge you need to perform everyday data-based tasks faster and more efficiently.

This course is designed to help you familiarise with the major functionalities of Excel, with step-by-step guidance. You will start with simple tasks like viewing excel data, working with the interface, using quick analysis and more. At an intermediate skill level, you will learn about macros, forms, slicers, timelines etc. Finally, at an advanced level, you will learn how to create charts, pivot tables, solve formula errors and manage your data more effectively. This online course is the ultimate online guide for learning MS Excel. Certify your skills in this leading office software and gain maximum career progression!

Who is the course for?

  • Professionals who want to learn how to use Microsoft Office Excel.
  • People who have a need to analyze and organise large amounts of data.

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 hardcopy at the cost of £39 or in PDF format at the 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:

Microsoft Excel Complete Course – Beginners, Intermediate, Advanced  is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as:

  • Accounting
  • Management consultant
  • Investment Banking Analyst
  • Marketing
  • Engineering
  • Researchering

Course Curriculum

Microsoft Excel - Beginners
Module One – Getting Started 00:30:00
Module Two – Opening and Closing Excel 01:00:00
Module Three – Working with the Interface 01:00:00
Module Four – Your First Worksheet 01:00:00
Module Five – Viewing Excel Data 01:00:00
Module Six – Building Formulas 01:00:00
Module Seven – Using Excel Functions 01:00:00
Module Eight – Using Quick Analysis 01:00:00
Module Nine – Formatting Your Data 01:00:00
Module Ten – Using Styles, Themes, and Effects 01:00:00
Module Eleven – Printing and Sharing Your Workbook 01:00:00
Module Twelve – Wrapping Up 01:00:00
Excel for Newbies – Activities 00:00:00
Microsoft Excel - Intermediate Level
Module One – Getting Started 00:30:00
Module Two – Working with Permissions and Options 00:30:00
Module Three – Sharing Workbooks 00:30:00
Module Four – Performing Advanced Formula and Function Tasks 00:30:00
Module Five – Working with Array Formulas 01:00:00
Module Six – Working With Macros 00:30:00
Module Seven – Working With Forms 00:30:00
Module Eight – Applying Advanced Chart Features 01:00:00
Module Nine – Working With Slicers and Timelines 00:30:00
Module Ten – Working With Multiple Tables, Relationships and External Data 00:30:00
Module Eleven – Working With PowerView 00:30:00
Module Twelve – Wrapping Up 01:00:00
Activities- Microsoft Excel – Intermediate Level 00:00:00
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-Microsoft Excel – Advanced Level 00:00:00
Mock Exam
Mock Exam- Microsoft Excel Complete Course – Beginners, Intermediate, Advanced 00:30:00
Final Exam
Final Exam- Microsoft Excel Complete Course – Beginners, Intermediate, Advanced 00:30:00

Course Reviews

4.9

4.9
12 ratings
  • 5 stars11
  • 4 stars1
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. Jack IngramSeptember 13, 2019 at 9:35 am

    Jack Ingram

    5

    muy buen curso, fue de mucha ayuda

  2. Mia GardinerAugust 2, 2019 at 9:44 am

    Mia Gardiner

    5

    my office inputs and data analysis got easier after taking this course. Enjoyed it to the fullest

  3. Louie WilkinsonMay 27, 2019 at 9:16 am

    Louie Wilkinson

    5

    Good one for the beginner’s!! not an advanced tier though. Must be a little bit more improved

  4. Megan CarrollMay 21, 2019 at 9:19 am

    Megan Carroll

    5

    A course well designed……..for professionals to amateurs

  5. Ethan SandersMay 8, 2019 at 9:18 am

    Ethan Sanders

    5

    A great course and long course. needed some external help to understand some advanced materials in the course, but voila it was gooood!

  6. Bethany MurrayApril 14, 2019 at 9:43 am

    Bethany Murray

    5

    John Academy can take the credit for pulling off such a well designed course so easily and smoothly. very much exhilarating

  7. Ellie CoatesMarch 19, 2019 at 9:42 am

    Ellie Coates

    5

    A great worth for money. tnx to the those who compiled these altogether

  8. Zoe PickeringMarch 17, 2019 at 9:39 am

    Zoe Pickering

    5

    This course has been taught very systematically. Enjoyed every bit. Totally relatable.

  9. Louise JohnstonMarch 17, 2019 at 9:38 am

    Louise Johnston

    5

    100% skilled, 50% effortless, maximum effect 100/100 teaching materials \m/

  10. Kian HallMarch 15, 2019 at 9:21 am

    Kian Hall

    5

    Excellant one. Highly appreciating the effort they put for this one. kudos!

  11. Declan TalbotMarch 8, 2019 at 11:23 am

    Declan Talbot

    4

    a good start for beginners, should continue to learn advanced xcel gradually with this.

  12. Mia EllisNovember 30, 2017 at 11:46 am

    Good Experience

    5

    As a person who wants to learn Excel as fast as I can for my career, I can say that this is the best complete course I have ever taken. I am now able to use the Excel program at ease and be more productive with my work.

Related Courses

TAKE THIS COURSE ...

Instructors

Profile Photo
Nicholas Alvarado
433 STUDENTS ENROLLED

30 DAYS MONEY BACK Guarantee

Buy For Your team

Get your team access to john’s top 1540+ courses anytime anywhere

try john academy for business

Our Course Awarding Bodies

ACCREDITED BY

 

OUR COURSE PARTNERS

Have you any inquiry?

  • By submitting your information, you agree to the terms and conditions stated in our Privacy Policy

© John Academy.