Sale!

Certificate in Microsoft Excel

£595.00 £10.00

Course Level Professional Certificate
Awarding Body Training Qualifications UK
(TQUK)
Study Method Online – Self-Paced
Course Type Endorsed Course
Certificate Available to purchase separately

 


14 Days Money Back Guarantee
Money back guarantee

 

XO discounts

Description

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

Microsoft 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 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 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 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. Enrol in this Microsoft Complete course and open up the way to learn the most desired program in the world for visualising and analysing for becoming ( MOS ) Microsoft Office Specialist.

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. Customising 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
  • Analyse 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

Inspire London College Offers Endorsed Courses by Training Qualification UK (TQUK) under TQUK Endorsed Provision.

TQUK Endorsed Provision

This means that Inspire London College has designed and developed its courses and has gone through an external quality check by Training Qualification UK (TQUK) to ensure that the ILC and the courses it offers, meet the high standards quality criteria.

Training Qualification UK (TQUK)

TQUK is an Ofqual regulated Awarding Organisation, providing a wide range of vocational qualifications to FE Colleges and private training providers.

TQUK is an Awarding Organisation recognised by the Office of Qualifications and Examinations Regulation (Ofqual) in England, CCEA Regulation in Northern Ireland and by Qualifications Wales. TQUK offers qualifications which are regulated by Ofqual and, in some cases, by CCEA Regulation and/or Qualifications Wales, sit on the Regulated Qualifications Framework (RQF) and are listed on the Register of Regulated Qualifications.

Upon successful completion of the Course, learner needs to pay for Certificate of Completion from ILC (either in PDF format or Hardcopy) or Endorsed Diploma from TQUK (Hardcopy).

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

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

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

+
Overview

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

Microsoft 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 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 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 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. Enrol in this Microsoft Complete course and open up the way to learn the most desired program in the world for visualising and analysing for becoming ( MOS ) Microsoft Office Specialist.

+
Outline

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. Customising 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
  • Analyse 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
+
Accreditation

Inspire London College Offers Endorsed Courses by Training Qualification UK (TQUK) under TQUK Endorsed Provision.

TQUK Endorsed Provision

This means that Inspire London College has designed and developed its courses and has gone through an external quality check by Training Qualification UK (TQUK) to ensure that the ILC and the courses it offers, meet the high standards quality criteria.

Training Qualification UK (TQUK)

TQUK is an Ofqual regulated Awarding Organisation, providing a wide range of vocational qualifications to FE Colleges and private training providers.

TQUK is an Awarding Organisation recognised by the Office of Qualifications and Examinations Regulation (Ofqual) in England, CCEA Regulation in Northern Ireland and by Qualifications Wales. TQUK offers qualifications which are regulated by Ofqual and, in some cases, by CCEA Regulation and/or Qualifications Wales, sit on the Regulated Qualifications Framework (RQF) and are listed on the Register of Regulated Qualifications.

+
Certificate

Upon successful completion of the Course, learner needs to pay for Certificate of Completion from ILC (either in PDF format or Hardcopy) or Endorsed Diploma from TQUK (Hardcopy).

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

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

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

Additional information

Payment Mode

At Once, 10 Instalments