Microsoft Excel - Course

Inspire London College Ltd

Certificate in Microsoft Excel

Digital certificate - £29

Certificate in Microsoft Excel

Hard copy certificate - £55

Quiz based assessment

Included in course price

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

Certificate in Microsoft Excel

As mentioned above, this course is a 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
• Enter and edit data in a variety of ways
• Understand basic formulas and functions
• Format worksheets and data
• Print and share workbooks

Further Breakdown of Microsoft Excel Essentials Course

• Creating a Blank Workbook in Microsoft Excel
• Creating a Workbook from a Template
• Entering Data In Excel Sheet
• Using Auto Fill
• Adding Rows and Columns
• Using Flash Fill Excel Function
• The Math Basics of Excel
• Building a Formula in Excel
• Relative vs. Absolute References
• Using the Status Bar to Perform Calculations
• Formulas vs. Functions
• Using the SUM Function in Excel
• Using Auto Complete
• Understanding the Formulas Tab
• Understanding Function Compatibility
• Formatting Data in Excel
• Creating Quick Analysis Charts
• Calculating Totals in Excel Sheet
• Working with Alignment Options
• Using Table Styles and Cell Styles
• Using Conditional Formatting
• Changing the Theme, Colors, and Fonts
• An Overview of the Page Layout Tab
• Previewing and Printing Your Excel Workbook
• E-Mailing Your Excel Workbook

Major Modules

• Use Smart Art 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

Microsoft Excel Advanced Course Further Breakdown

• Inserting Smart-Art in Excel Sheet
• Editing the Diagram in Excel
• Adding Text-boxes
• Tracing Precedent Cells in Excel Sheet
• Displaying Formulas Within the Excel Sheet
• Adding, Displaying, Editing, and Removing Comments
• Overview of the Chart Tools Tabs
• Understanding Chart Elements
• Creating Pivot Tables and Pivot Charts
• Choosing Fields and Grouping Data in Excel Sheet
• Creating a Pivot Chart from a Pivot Table or Data
• Recording and Running Macros
• Changing the Security Level of Excel Sheet
• Customizing and Changing the Quick Access Toolbar
• Solving Formula Errors in Excel Sheet
• Evaluating Formulas
• Using What-If Analysis
• Using the Scenario Manager
• Using a One Input Data Table
• Using a Two Input Data Table
• Transposing Data from Rows to Columns

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

Microsoft Excel Expert Course Further Breakdown

• Marking a Workbook as Final
• Encrypting with a Password
• Adding a Digital Signature
• Saving a Workbook as a Microsoft Excel Template
• Sharing a Workbook
• Editing a Shared Workbook
• Tracking Changes
• About the Excel Calculation Process
• Setting Calculation Options
• Using the IF-ERROR Function to Evaluate Formulas
• About Array Formulas
• Creating One-Dimensional and Two-Dimensional Constants
• Assigning a Macro to a Command Button
• Configuring a Macro to Run Automatically Upon Opening the Workbook
• About Excel Forms, Form Controls, and Active X Controls
• Using a List Box Control
• About Trend Lines
• Add a Trend Line
• About Slicers and Timelines
• Creating a Slicer in an Existing Table

Course / Training Format

After successful Enrollment, the learner will get access to ILC (Inspire London College) 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 80%. 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) for this MS Excel course is online and are taken either through or after the course; these are included in the course price.

Duration

Ms EXCEL Complete training 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 the Learning Platform for up to 12 months from the date of enrollment. During this period, learners will have the flexibility to complete this MS EXCEL course at any time.

Certification

Upon successfully passing the course, the Learner needs to pay for a CPD-accredited Certificate of Completion, either in PDF format or Hardcopy From ILC.

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

CPD Accredited Certificate of Completion (Hardcopy) = £40 + postage charges £15 = £55

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.

There are no precise requirements for the Certificate in Microsoft Excel as no prior knowledge and experience of Management is required.

Students seeking to enroll for this Microsoft Excel course should meet the following requirements;

• Be aged 16 years or above
• Solid knowledge of English Language
• Working Knowledge of Information Communication Technologies for studying online that is the Internet and Microsoft Office
• A genuine desire to study and succeed.

After completing the Microsoft Excel course, you will be able to grip yourself with specific knowledge and skills with the highest level of confidence to improve yourself and enhance your skills for your career in the relevant employment sector.

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