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

Course Images

Microsoft Excel Complete Course - Beginners, Intermediate, Advanced

Microsoft Excel Complete Course - Beginners, Intermediate, Advanced

By John Academy

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

Highlights

  • On-Demand course

  • 33 hours

  • All levels

Description

[vc_row][vc_column][vc_column_text]

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

[/vc_column_text][/vc_column][/vc_row]

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

Certificate and Transcript

Order Your Certificates and Transcripts

00:00:00

About The Provider

Tags

Reviews