Skip to content

Microsoft Excel

Microsoft Excel By TQUK l Essentials, Advanced & Expert Training I XO Student Discount | MCQs Assessment


Inspire London College Ltd

Summary

Price
Save 98%
£10 inc VAT (was £595)
Offer ends 25 June 2021
Study method
Online, self-paced
Duration
360 hours
Access to content
Access until course completion
Qualification
No formal qualification
CPD
30 CPD hours / points
Achievement
Additional info
  • Exam(s) / assessment(s) is included in price
  • Tutor is available to students
  • Certificate of completion available to purchase separately

1,815 students purchased this course

Add to basket or enquire

Overview

Microsoft Excel:

Microsoft Excel Endorsed by TQUK l Essentials, Advanced & Expert Training I XO Student Discount | 24/7 Tutor Support

Microsoft Excel Certificate - Eligible to Apply: XO Student Discount Card!!

This is a Complete Microsoft Excel Course, which contains Microsoft Excel Essentials, Microsoft Excel Advanced, and Microsoft Excel Expert level.

*****Microsoft Excel*****

Microsoft Excel Course Modules.

  • Microsoft Excel Essentials (Basic)
  • Microsoft Excel Advanced
  • Microsoft Excel Expert Plus (50+ spreadsheets for practice)

Microsoft Excel - Microsoft Excel is the most commonly used ( Spreadsheet ) software in business settings at all levels and for personal use in households. Further, Microsoft Excel use is a key managerial function in 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 the essential, advanced, and expert level has been combined for your ease. Microsoft Essential will start with the most basics of Excel and the Expert level will explain various functions 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 customize-able approach.

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

Microsoft Excel

Achievement

CPD

30 CPD hours / points
Accredited by Step Ahead CPD Qualifications

Course media

Description

Microsoft Excel:

Microsoft Excel by TQUK | 24/7 Tutor Support | Quiz Based Exam Included | 30 CPD Credits Modules Outline

****Microsoft Excel - Function 1 – Worksheet****

Microsoft Excel - Create Worksheets and Workbooks

  • Microsoft Excel - Create a Workbook
  • Microsoft Excel - Open a Comma Separated Values File
  • Microsoft Excel - Add a Worksheet to An Existing Workbook

Microsoft Excel - Navigate in Workbooks and Worksheets

  • Microsoft Excel - Search for Data
  • Microsoft Excel - Navigate to a Named Cell
  • Microsoft Excel - Insert and Remove Hyperlinks

Microsoft Excel - Modify Worksheets

  • Microsoft Excel - Insert and Delete Table Rows and Columns
  • Microsoft Excel - Adjust Row Height and Column Width
  • Microsoft Excel - Insert Headers and Footers

Microsoft Excel - Format Workbooks

  • Microsoft Excel - Copy and Move Worksheets
  • Microsoft Excel - Modify Page Setup

Microsoft Excel - Add a Tool to the Quick Access Toolbar

  • Microsoft Excel - Zoom
  • Microsoft Excel - Change Workbook Views
  • Microsoft Excel - Change Window Views

Microsoft Excel - Configure Worksheets and Workbooks for Distribution

  • Microsoft Excel - Print
  1. Microsoft Excel - Set a Print Area
  2. Microsoft Excel - Save in Another File Format
  • Microsoft Excel - Repeat Columns or Rows Across Multiple Pages
  • Microsoft Excel - Inspect a Workbook for Hidden Properties and Personal Information

****Microsoft Excel - Function 2 - Manage Data Cell****

Microsoft Excel - Insert Data in Cells and Ranges

  • Microsoft Excel - Replace Data
  • Microsoft Excel - Cut, Copy and Paste Data
  • Microsoft Excel - Paste Data Using Paste Options

Microsoft Excel - Format Cells and Ranges

  • Microsoft Excel - Merge Cells
  • Microsoft Excel - Align and Indent Cell Contents
  • Microsoft Excel - Wrap Text within Cells

Microsoft Excel - Apply Conditional Formatting

  • Format Cells using the Format Painter

Microsoft Excel - Summarize and Organize Data

  • Microsoft Excel - Insert Spark lines
  • Microsoft Excel - Grouping Data
  • Microsoft Excel - Adding Subtotals

Function 3 - Create Tables

Microsoft Excel - Create and Manage Tables

  • Microsoft Excel - Create an Excel Table from a Cell Range
  • Microsoft Excel - Add or Remove Table Rows and Columns

Microsoft Excel - Manage Table Styles and Options

  • Microsoft Excel - Apply Styles to Tables
  • Microsoft Excel - Configure Table Style Options

Microsoft Excel - Filter and Sort a Table

  • Microsoft Excel - Filter Records
  • Microsoft Excel - Clear Filters
  • Microsoft Excel - Use a Number Filter or Text Filter
  • Microsoft Excel - Change Sort Order

****Microsoft Excel - Function 4 - Operation with Formulas****

Microsoft Excel - Building Formulas

  • Microsoft Excel - Understand Math Basics of Excel
  • Microsoft Excel - Build a Formula
  • Microsoft Excel - Edit a Formula

Microsoft Excel - Perform Basic Functions

  • Microsoft Excel - Understand Formulas vs. Functions
  • Microsoft Excel - Calculate Using Status Bar
  • Microsoft Excel - Perform Basic Functions
  • Microsoft Excel - AutoComplete a Function

Microsoft Excel - Perform Conditional Functions

  • Microsoft Excel - Perform the IF Function
  • Microsoft Excel - Perform the SUMIF Function
  • Microsoft Excel - Perform the AVERAGEIF Function

Microsoft Excel - Format and Modify Text Using Functions

  • Microsoft Excel - Format Text Using UPPER, LOWER, and PROPER Functions
  • Microsoft Excel - Format Text Using the CONCAT Function

Microsoft Excel - Analyze Data with Quick Analysis

  • Microsoft Excel - Format with Quick Analysis
  • Microsoft Excel - Create Charts with Quick Analysis

Microsoft Excel - Create Charts

  • Microsoft Excel - Use Recommended Charts
  • Microsoft Excel - Create a New Chart
  • Microsoft Excel - Add Additional Data Series

Microsoft Excel - Format Charts

  • Microsoft Excel - Resize Charts
  • Microsoft Excel - Add and Modify Chart Elements
  • Microsoft Excel - Apply Chart Styles and Layouts
  • Microsoft Excel - Move Charts to a Chart Sheet

Microsoft Excel - Insert and Format Objects

  • Microsoft Excel - Insert Shapes
  • Microsoft Excel - Insert Text Boxes
  • Microsoft Excel - Add Alternative Text

****Microsoft Excel - Function 6 - Manage Workbook Option and Setting****

Microsoft Excel - Manage Workbooks

  • Microsoft Excel - Save a Workbook as a Template
  • Microsoft Excel - Reference Data in another Workbook
  • Microsoft Excel - Display Hidden Ribbon Tabs

Microsoft Excel - Manage Workbook Review

  • Microsoft Excel - Mark a Workbook as Final
  • Microsoft Excel - Protect a Workbook with a Password
  • Microsoft Excel - Protect a Worksheet to Restrict Editing

****Microsoft Excel - Function 7 - Apply Custom Data Formats and Layouts****

Microsoft Excel - Prepare a Workbook for Internationalization

  • Microsoft Excel - Apply International Currency Formats
  • Microsoft Excel - Apply Locale to Date or Time Formats

Microsoft Excel - Apply Custom Data Formats and Validation

  • Microsoft Excel - Create Custom Number Formats
  • Microsoft Excel - Populate Cells by Using Advanced Fill Series Options

Microsoft Excel - Apply Advanced Conditional Formatting and Filtering

  • Microsoft Excel - Create Custom Conditional Formatting Rules
  • Microsoft Excel - Create Conditional Formatting Rules that Use Formulas

Microsoft Excel - Create and Modify Custom Workbook Elements

  • Microsoft Excel - Create Custom Color Formats
  • Microsoft Excel - Create Custom Font Sets
  • Microsoft Excel - Create and Modify Cell Styles
  • Microsoft Excel - Create and Modify Custom Themes

Microsoft Excel - Work with Macros

  • Microsoft Excel - Enable Macros
  • Microsoft Excel - Record a Macro
  • Microsoft Excel - Run a Macro
  • Microsoft Excel - Edit a Macro

****Microsoft Excel - Function 8 - Create Advance Formulas****

Microsoft Excel - Define Named Ranges and Objects

  • Microsoft Excel - Name Cells
  • Microsoft Excel - Use Named Cells in a Formula

Microsoft Excel - Apply Functions in Formulas

  • Microsoft Excel - Perform the AND Function and the OR Function
  • Microsoft Excel - Perform NOT Function
  • Microsoft Excel - Perform Logical Operations by Using Nested Functions

Microsoft Excel - Look Up Data by Using Functions

  • Microsoft Excel - Look Up Data by Using the VLOOKUP Function
  • Microsoft Excel - Look Up Data by Using the HLOOKUP Function

Microsoft Excel - Apply Advanced Time and Date Functions

  • Microsoft Excel - Serialize Numbers by Using Date and Time Functions
  • Microsoft Excel - Reference the Date and Time Using the NOW and TODAY functions

Microsoft Excel - Perform Data Analysis and Business Intelligence

  • Microsoft Excel - Import, Transform, Combine, Display, and Connect to Data
  • Microsoft Excel - Consolidate Data
  • Microsoft Excel - Perform What-If Analysis by Using Goal Seek

Microsoft Excel - Troubleshoot Formulas

  • Microsoft Excel - Trace Precedence and Dependence
  • Microsoft Excel - Monitor Cells and Formulas using the Watch Window
  • Microsoft Excel - Evaluate Formulas

****Microsoft Excel - Function 9 - Create Advanced Charts and Tables****

Microsoft Excel - Create Advanced Charts

  • Microsoft Excel - Add Trendlines to Charts
  • Microsoft Excel - Create Dual-Axis Charts
  • Microsoft Excel - Save a Chart as a Template

Microsoft Excel - Create and Manage PivotTables

  • Microsoft Excel - Create Slicers
  • Microsoft Excel - Create PivotTables
  • Microsoft Excel - Modify Field Selections and Options
  • Microsoft Excel - Group PivotTable Data
  • Microsoft Excel - Reference Data in a PivotTable by Using the GETPIVOTDATA Function

Microsoft Excel - Create and Manage PivotCharts

  • Microsoft Excel - Create PivotCharts
  • Microsoft Excel - Drill Down into PivotChart Details

Who is this course for?

Microsoft Excel (TQUK Endorsed) - Course / Training Format

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

Training Manual contains several modules, each having specific knowledge and case study at the end. 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 (MCQ’s) will be based on modules of Microsoft Excel (TQUK Endorsed) - Training Manual.

Microsoft Excel (TQUK Endorsed) - Assessment

After studying through the training manual, Learner will have to attempt 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 first attempt.

Before attempting your Microsoft Excel (TQUK Endorsed) - Final Test, you will have the opportunity to test your proficiency with a Microsoft Excel (TQUK Endorsed) - 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.

Microsoft Excel (TQUK Endorsed) - Duration

The minimum time period to complete this training is 4 Weeks. But it is 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 Moodle 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.

Microsoft Excel (TQUK Endorsed) AND/OR CPD Accredited Certificate

Upon successful completion of the Microsoft Excel course, the learner needs to pay for an Endorsed Certificate from the awarding organisation or/and can claim CPD Accredited Certificate either in PDF format or Hardcopy.

CPD Accredited Certificate of Completion (PDF format) = £25

CPD Accredited Certificate of Completion (Hard-copy format) = £35 + postage charges £15

Endorsed Certificate from Awarding Body (Hard-copy) = £59 + postage charges £15

Microsoft Excel Endorsed by TQUK l Essentials, Advanced & Expert Training I XO Student Discount | 24/7 Tutor Support

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

Requirements

Microsoft Excel

Microsoft Excel Endorsed by TQUK l Essentials, Advanced & Expert Training I XO Student Discount | 24/7 Tutor Support

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

Microsoft Office (Excel) 2003 or 2016
Be age 16 years or above

Career path

Microsoft Excel

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

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

Questions and answers


No questions or answers found containing ''.


Joseph asked:

What time frame can you complete this course in?

Answer:

This 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 Moodle/VLE 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.

This was helpful. Thank you for your feedback.

Reviews

4.3
Course rating
88%
Service
83%
Content
86%
Value
Leave a review

{{ getTruncatedSinglePointScore(item.OverallCourseRating) }} Star Review by {{ item.ReviewerName }} for {{ item.Title }}


{{ getLongDate(item.CreatedOn) }}
{{ item.Title }}
Reviewed by {{ item.ReviewerName }}
|Purchased {{ getHumanisedPassageOftime(item.PurchasedOn) }}
{{ item.ProviderName }} responded to this review
{{ getLongDate(item.ProviderResponseDate) }}
{{ results.length }} out of {{ totalResultsCount }} reviews

FAQs

What does study method mean?

Study method describes the format in which the course will be delivered. At reed.co.uk courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

What are CPD hours/points?

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on reed.co.uk, many of which can be completed online.

What is a ‘regulated qualification’?

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

What is an ‘endorsed’ course?

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body’s logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.