reed.co.uk Courses

Header

Microsoft Excel

Microsoft Excel (TQUK Endorsed) complete course including essentials, advanced and expert level.


Inspire London College Ltd

Summary

Price
Save 98%
£10 inc VAT (was £595)
Offer ends 21 February 2020
Study method
Online, self-paced
Duration
10 Days
Access to content
Lifetime access
Certification
Microsoft Office Specialist (MOS) in Microsoft Excel
Professional What's this?
Additional info
  • Exam(s) / assessment(s) is included in price
  • Tutor is available to students

266 students purchased this course

Add to basket or enquire

Overview

It is a complete Microsoft Excel Course, which contains Microsoft Excel Essentials, Microsoft Excel Advanced and Microsoft Excel Expert level.

MS EXCEL -

Microsoft Excel is most commonly used ( Spreadsheet ) software in business settings at all level and for personal use in households. Further, Microsoft Excel use is a key managerial function in the modern organisations and every department in today’s organisations hires highly skilled professionals for management.

ILC is offering this ultimate course of Microsoft Excel, where essential, advanced and expert level has been combined for your ease. Microsoft Essential will start with the most basics of Excel and Expert level will explain various function and formulae in depth which will enable you to work with complex data and problems. You will be shown a practical way of learning with a hands-on and customisable approach.

This MS EXCEL course is equally beneficial for new learner as it start from very basic – opening the Microsoft Excel. Each module is explained with screenshots and various interactive activities are also included in this course. Enrol in this Microsoft Complete course and open up the way to learn most desired program in world for visualising and analysing for becoming ( MOS ) Microsoft Office Specialist.

Certification

Microsoft Office Specialist (MOS) in Microsoft Excel

Course media

Description

As mentioned above, this course is the combination of Essentials, Advanced and Expert Level of Microsoft Excel. Below is the breakdown for each level.

Microsoft Excel Essentials

Major Modules

  • Open and create Excel workbook files
  • Use the 2013 interface
  • Enter and edit data in a variety of ways
  • Understand basic formulas and functions
  • Use the Quick Analysis features new to the 2013 version
  • Format worksheets and data
  • Print and share workbooks

Further Breakdown of Microsoft Excel Essentials Course

  1. Creating a Blank Workbook in Microsoft Excel
  2. Creating a Workbook from a Template
  3. Entering Data In Excel Sheet
  4. Using Auto Fill
  5. Adding Rows and Columns
  6. Using Flash Fill Excel Function
  7. The Math Basics of Excel
  8. Building a Formula in Excel
  9. Relative vs. Absolute References
  10. Using the Status Bar to Perform Calculations
  11. Formulas vs. Functions
  12. Using the SUM Function in Excel
  13. Using AutoComplete
  14. Understanding the Formulas Tab
  15. Understanding Function Compatibility
  16. Formatting Data in Excel
  17. Creating Quick Analysis Charts
  18. Calculating Totals in Excel Sheet
  19. Working with Alignment Options
  20. Using Table Styles and Cell Styles
  21. Using Conditional Formatting
  22. Changing the Theme, Colors, and Fonts
  23. An Overview of the Page Layout Tab
  24. Previewing and Printing Your Excel Workbook
  25. E-Mailing Your Excel Workbook

Microsoft Excel Advanced

Major Modules

  • Use SmartArt and other objects in worksheets
  • Trace precedent cells and dependent cells, as well as use other auditing tools
  • Create and work with charts
  • Create Pivot Tables and Pivot Charts
  • Record and run macros
  • Solve formula errors
  • Use What If Analysis tools
  • Use tools to manage rows, columns, duplicates, and validation
  • Group and outline data

Further Breakdown of Microsoft Excel Advanced Course

  1. Inserting SmartArt in Excel Sheet
  2. Editing the Diagram in Excel
  3. Adding Textboxes
  4. Tracing Precedent Cells in Excel Sheet
  5. Displaying Formulas Within the Excel Sheet
  6. Adding, Displaying, Editing, and Removing Comments
  7. Overview of the Chart Tools Tabs
  8. Understanding Chart Elements
  9. Creating Pivot Tables and Pivot Charts
  10. Choosing Fields and Grouping Data in Excel Sheet
  11. Creating a Pivot Chart from a Pivot Table or Data
  12. Recording and Running Macros
  13. Changing the Security Level of Excel Sheet
  14. Customizing and Changing the Quick Access Toolbar
  15. Solving Formula Errors in Excel Sheet
  16. Evaluating Formulas
  17. Using What-If Analysis
  18. Using the Scenario Manager
  19. Using a One Input Data Table
  20. Using a Two Input Data Table
  21. Transposing Data from Rows to Columns
  22. Using the Text to Columns Feature
  23. Creating Data Validation Rules
  24. Consolidating Data in Excel
  25. Viewing Grouped and Outlined Data

Microsoft Excel Expert

Major Modules

  • Understand permissions, versions, and Excel Options
  • Track changes and share workbooks
  • Perform advanced formula auditing and calculation
  • Create arrays
  • Create additional ways to run a macro
  • Create a form using a variety of controls
  • Use trend lines, secondary axes, and chart templates
  • Work with slicers in PivotTables
  • Create and manipulate a PowerView sheet
  • Analyze data using multiple tables

Further Breakdown of Microsoft Excel Expert Course

  1. Marking a Workbook as Final
  2. Encrypting with a Password
  3. Adding a Digital Signature
  4. Saving a Workbook as an Microsoft Excel Template
  5. Sharing a Workbook
  6. Editing a Shared Workbook
  7. Tracking Changes
  8. About the Excel Calculation Process
  9. Setting Calculation Options
  10. Using the IFERROR Function to Evaluate Formulas
  11. About Array Formulas
  12. Creating One-Dimensional and Two-Dimensional Constants
  13. Assigning a Macro to a Command Button
  14. Configuring a Macro to Run Automatically Upon Opening the Workbook
  15. About Excel Forms, Form Controls, and Active X Controls
  16. Using a List Box Control
  17. About Trend Lines
  18. Add a Trend Line
  19. About Slicers and Timelines
  20. Creating a Slicer in an Existing Table
  21. Connecting to a New External Data Source
  22. Creating a PivotTable Using an External Data Connection
  23. Creating a Power View Sheet
  24. Add a Table to the Data Model
  25. Adding a Map to a Power View Report

Course / Training Format

After successful enrolment, the learner will get access to ILC Moodle, where all the study material / Training Manual will be available. Learning Platform can be accessed 24/7 anywhere, anytime.

All the courses material will be in the form of texts (images/illustrations), and there are no video or live lectures during the training course.

The Test (MCQs) will be based on modules of the Training Manual.

Assessment

After studying through the training manual, Learner will have to attempt the Final Test (online multiple-choice test – 2 attempts), if necessary, may attempt the test third times at no extra cost. Your test will be assessed automatically and straightaway so that you will directly know whether you have been successful or not. The passing score is 75%. You can retake the test in the case of not being successful at the first attempt.

Before attempting your Final Test, you will have the opportunity to test your proficiency with a Mock Test (online multiple-choice test - Unlimited attempts).

All test(s) / Assessment(s) are online and are taken either through or after the course; these are included in the course price.

Duration

The minimum time period to complete this training is 10 Days. But it is a self-paced course, and the duration of completion depends on the learner’s pace and ability to give time to study.

Learners will have access to their Training via Learning Platform for up to 12 months from the date of enrolment. During this period, flexibility will be given to learners for completing the course at any time.

Certification

Upon successful completion of the course, the learner needs to pay for an Endorsed Certificate from the awarding organisation or from Inspire London College (PDF format only).

Certificate of Completion from Inspire London College (PDF format) = £25

Certificate of Completion from Inspire London College (Hardcopy format ) = £35 + postage charges £15

Endorsed Certificate from Awarding Body (Hardcopy) = £59 + postage charges £15

Who is this course for?

Microsoft Excel is one of most used ( Spreadsheet ) programmes in the world to record, analyse and visualise data. So it is recommended of anyone working with data either it is receptionist, Personal Assistant, Secretary, Manager or any higher management position.

Requirements

There are no precise requirements for Microsoft Excel Course. Students seeking to enrol for this course should meet the following requirements;

Basic knowledge of English Language & Basic Computer Skills
Be age 16 years or above

Career path

As mentioned earlier that Microsoft Excel is one of most used ( Spreadsheet ) software in world and is used in every organisation, every department and even for household used. So, having Microsoft Excel Certificate will enable you to work in multiple sectors, including but not limited to;

  • management
  • Admin
  • Secretarial & PA
  • Accountancy
  • Accounting and Finance.

Questions and answers

Currently there are no Q&As for this course.Be the first to ask a question.

Rating and reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Modals

Mobile Navigation