Location
Online
Dates
Can be taken anytime
Course Type
Professional Training Course
Accreditation
Yes (Details)
Language
English
Price
$279 $32 only

Course Overview

Microsoft Excel is the most used spreadsheet program in the world. It can be used in almost any industry as you can carry out large numbers of data analysis, simple to complex maths and tabulating data streams. Well if that intrigues you and you want to learn more about MS Excel, this is the ideal course for you.

This Microsoft Excel Complete Course - Beginners, Intermediate, Advanced can help you realise all of the functionalities in the program, as you take a step by step approach to learning MS Excel. You will initially learn of simple tasks like viewing excel data, how to work with the interface, using quick analysis and more. Then you move onto more intermediate level work like using macros, forms, slicers and timelines etc. Finally you reach the advanced level section where you will be able to create charts, pivot tables, solve formula errors and so much more.

This is truly the ultimate guide to for people wanting to learn to use MS Excel. Given the popularity of this program in all industries, you will be head and shoulders above your competition when seeking work.

Who should take this course

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

Accreditation

CPD

Course content

Microsoft Excel - Beginners

  • Module One - Getting Started
  • Module Two - Opening and Closing Excel
  • Module Three - Working with the Interface
  • Module Four - Your First Worksheet
  • Module Five - Viewing Excel Data
  • Module Six - Building Formulas
  • Module Seven - Using Excel Functions
  • Module Eight - Using Quick Analysis
  • Module Nine - Formatting Your Data
  • Module Ten - Using Styles, Themes, and Effects
  • Module Eleven - Printing and Sharing Your Workbook
  • Module Twelve - Wrapping Up
  • Activities - Microsoft Excel for Beginners

Microsoft Excel - Intermediate Level

  • Module One - Getting Started
  • Module Two - Working with Permissions and Options
  • Module Three - Sharing Workbooks
  • Module Four - Performing Advanced Formula and Function Tasks
  • Module Five - Working with Array Formulas
  • Module Six - Working With Macros
  • Module Seven - Working With Forms
  • Module Eight - Applying Advanced Chart Features
  • Module Nine - Working With Slicers and Timelines
  • Module Ten - Working With Multiple Tables, Relationships and External Data
  • Module Eleven - Working With PowerView
  • Module Twelve - Wrapping Up
  • Activities- Microsoft Excel - Intermediate Level

Microsoft Excel - Advanced Level

  • Module One - Getting Started
  • Module Two - SmartArt and Objects
  • Module Three - Auditing
  • Module Four - Creating Charts
  • Module Five - Working with Charts
  • Module Six - Creating Pivot Tables and Pivot Charts
  • Module Seven - Macros
  • Module Eight - Solving Formula Errors
  • Module Nine - Using What If Analysis
  • Module Ten - Managing Your Data
  • Module Eleven - Grouping and Outlining Data
  • Module Twelve - Wrapping Up
  • Activities-Microsoft Excel - Advanced Level

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 a cost of GBP39 or in PDF format at a cost of GBP24.
  • 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 recognised accredited qualification;
  • Access to course content on mobile, tablet or desktop from anywhere anytime;
  • The benefit of applying for NUS Extra Discount Card;
  • 24/7 student support via email.

About Course Provider

We are a company who is best known for offering awarding body accredited online courses that are available for anyone who wishes to acquire a certification and take their professional life to the next level.

As an online learning site, we are aware of the fact that there are a lot of people out there who considers themselves to be a curious learner but the courses that they are interested in are not available in the area. So, we have decided to give them a chance to learn in a convenient way – in their own convenient place and time.

Frequently asked questions

{{ item.question }}