Cart

No products in the basket.

Home
Course
Microsoft Office
Microsoft Excel Complete Training

Microsoft Excel Complete Training

4.9

★ ★ ★ ★ ★

7 Reviews

stds 195 Students

GET THIS COURSE AND 3000+ OTHERS FOR ONLY £49. FIND OUT MORE

Course Highlights

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step training course. This Microsoft Excel Complete Training has been specially designed to help learners gain a good command of Microsoft Excel, providing them with a solid foundation of knowledge to become a qualified professional.

Through this Microsoft Excel Complete Training, you will gain both practical and theoretical understanding of Microsoft Excel that will increase your employability in this field, help you stand out from the competition and boost your earning potential in no time.

Not only that, but this training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. This qualification is fully accredited, broken down into several manageable modules, ideal for aspiring professionals.

Learning outcome

Familiar yourself with the recent development and updates of the relevant industry
Know how to use your theoretical knowledge to adapt in any working environment
Get help from our expert tutors anytime you need
Access to course contents that are designed and prepared by industry professionals
Study at your convenient time and from wherever you want

Course media

Review

Marketplace Review

Why should I take this course?

Affordable premium-quality E-learning content, you can learn at your own pace.
You will receive a completion certificate upon completing the course.
Internationally recognized Accredited Qualification will boost up your resume.
You will learn the researched and proven approach adopted by successful people to transform their careers.
You will be able to incorporate various techniques successfully and understand your customers better.

Requirements

Curriculum

Unit Module 01: Excel from A-Z Course Introduction

Excel from A-Z Course Intro

00:03:00
Excel Job Opportunities

00:03:00
Excel Job Types

00:04:00
Microsoft Excel Marketplace

00:04:00
What is Microsoft Excel?

00:04:00
Who is This Course For?

00:04:00

Unit Module 02: Getting Started With Excel

Finding & Opening Excel

00:01:00
Excel’s Start Screen

00:03:00
Explaining the Excel Interface

00:03:00
Excel Interface Continued

00:01:00
Excel Workbook vs. Excel Worksheet

00:02:00
Saving an Excel Document

00:04:00
Customizing the Quick Access Toolbar

00:02:00
Customizing the Excel Ribbon

00:03:00
Excel Shortcut Keys

00:02:00

Unit Module 03: Values, Referencing and Formulas

Creating Excel Labels

00:03:00
Entering Numeric Values in Excel

00:03:00
Formatting Date Values in Excel

00:05:00
Building Basic Formulas in Excel

00:05:00
Order of Operations

00:06:00
Relative vs. Absolute Cell References

00:07:00

Unit Module 04: Intro to Excel Functions

Excel Functions Explained

00:03:00
The SUM() Function

00:08:00
The MIN() & MAX() Function

00:04:00
The AVERAGE() Function

00:02:00
COUNT() Functions

00:05:00

Unit Module 05: Adjusting Excel Worksheets

Moving & Copying Data

00:07:00
Insert & Delete Rows and Columns

00:05:00
Adjusting the Width and Height of Cells

00:05:00
Hiding and Unhiding Excel Rows and Columns

00:04:00
Renaming, Moving & Deleting Excel Worksheets

00:05:00
Adding Protection to Specific Cells

00:04:00
Protecting the Structure of a Workbook

00:02:00
Adding a Workbook Password to Open File

00:02:00

Unit Module 06: Visually Pleasing Cell Formatting

Formatting Fonts and Cell Background Color

00:05:00
Adding Cell Borders

00:05:00
Formatting Data Appropriately

00:05:00
The Magic behind Excel’s Format Painter

00:04:00
Creating Styles for Formatting Efficiency

00:06:00
Merging Cells for a Cleaner Look

00:03:00
The Power of Conditional Formatting

00:06:00

Unit Module 07: How to Insert Images and Shapes!

Grab User’s Attention using Illustrations

00:09:00
Customizing Icons

00:05:00
Create Compelling Graphics with SmartArt

00:06:00

Unit Module 08: Visualize Data with Charts

The Commonly Used Column Chart

00:03:00
Changing the Chart Design

00:02:00
Formatting Elements of a Chart

00:06:00
Modifying the Data, Type & Location of a Chart

00:06:00
Little Slice of Pie Charts

00:05:00

Unit Module 09: Excel’s Printing Options

Print Preview Options

00:04:00
Excel’s Page Layout View

00:07:00
Printing a Specific Range of Cells

00:03:00
Converting Spreadsheets to PDF Files

00:02:00

Unit Module 10: Benefits of Using Excel Templates

Why Create an Excel Template

00:01:00
How to Create an Excel Template

00:05:00

Unit Module 11: Working with Excel Datasets

How to Prepare Data for Analysis

00:04:00
How to Sort Data in Excel

00:03:00
Multi-Level Sorting

00:03:00
Custom Sorting Datasets in Excel

00:02:00
Applying Filters to Datasets

00:05:00
Creating Subtotals within a Dataset

00:06:00
Converting Datasets into Tables

00:06:00
Finding & Removing Duplicate Values

00:07:00

Unit Module 12: Excel Database Functions

The SUMIF() Function

00:09:00
The DSUM() Function

00:08:00
The DSUM() Function Cont.

00:07:00
The SUBTOTAL() Function

00:06:00

Unit Module 13: Excel Data Validation

What is Excel Data Validation?

00:02:00
Creating a Drop Down List with Data Validation

00:07:00
Different Types of Excel Data Validation

00:06:00
Adding Custom Alerts to Data Validation

00:07:00
Creating a Dynamic Drop Down List

00:03:00
Complex Validation: Dependent Drop Down List!

00:09:00

Unit Module 14: Excel PivotTables

Creating an Excel Pivot Table

00:06:00
Modifying Excel PivotTables

00:06:00
Grouping & Filtering PivotTable Data

00:07:00
Drilling Down into PivotTable Data

00:02:00
Creating Pivot Charts & Utilizing Slicers

00:08:00

Unit Module 15: Excel’s PowerPivot Add-In

What is PowerPivot?

00:04:00
Activating the Excel PowerPivot Add-In

00:02:00
Creating Relationships between Data Tables.mp4

00:06:00
Using Data Models to Create PivotTables

00:05:00
How to Create PowerPivot KPI’s

00:08:00

Unit Module 16: Excel’s Conditional Functions

Excel’s IF() Function

00:05:00
IF() Function with AND() Criteria

00:05:00
IF() Function with OR() Criteria

00:05:00
Nesting Multiple IF() Functions

00:07:00
The COUNTIF() Function

00:04:00
Key Benefits of Named Ranges

00:04:00

Unit Module 17: Excel’s Lookup Function

VLOOKUP() Function

00:09:00
The Beauty of Excel’s IFERROR() Function

00:04:00
HLOOKUP() Function

00:06:00
INDEX() Function

00:05:00
MATCH() Function

00:05:00
INDEX() and MATCH() Combined

00:05:00
Two-Way Lookup with INDEX() and MATCH()

00:04:00

Unit Module 18: Text Based Functions in Excel

LEFT(), RIGHT() and MID() Function

00:07:00
Extracting Specific Text using LEN() & SEARCH()

00:13:00
Combining Text with CONCATENATE()

00:06:00
Quick Tips & Other Text Based Functions

00:06:00

Unit Module 19: Auditing Formulas and Views in Excel

Tracing Precedents & Dependents in Formulas

00:04:00
Showing Formulas

00:02:00
Grouping Data

00:03:00
3D Referencing in Formulas

00:05:00
Utilizing the Watch Window in Excel

00:03:00
How to Freeze Panes in Excel

00:03:00

Unit Module 20: Excel’s “what If?” Tools

Excel’s Scenario Manager Tool

00:06:00
Goal Seek in Excel

00:06:00
Compare Results with Excel Data Tables

00:04:00
Solver Tool

00:11:00

Unit Module 21: Welcome to Excel VBA

The Power Behind Excel VBA

00:03:00
A Look Inside the Visual Basic Editor (VBE)

00:04:00
Recording a Macro

00:09:00
Saving & Opening a Macro-Enabled Workbook

00:02:00

Unit Module 22: The VBA Language

Modules and Procedures

00:07:00
Objects, Methods and Properties

00:06:00
Excel VBA Variables

00:05:00

Unit Module 23: Writing VBA Code

Referencing a Range

00:14:00
InputBox & MsgBox

00:06:00
Using Variables in VBA Code

00:05:00
If Then Else Statement

00:10:00
Worksheet Functions inside VBA

00:08:00
Creating User Defined Functions

00:09:00
User Defined Functions within VBA Scripts

00:06:00

Unit Module 24: Important VBA Tools and Logic

Find Last Row of Data

00:06:00
Find Last Column of Data

00:03:00
With Statement

00:05:00
Debugging & Error Handling

00:07:00
Debugging & Error Handling Cont.

00:07:00

Unit Module 25: Excel VBA Lopps

For Next Loop

00:09:00
Do Until Loop

00:06:00
For Each Loop

00:04:00

Unit Module 26: Triggering Macros

Assigning Macros to Shapes

00:04:00
Form Controls vs ActiveX Controls

00:08:00
Worksheet Events

00:04:00
Workbook Events

00:03:00
Fun with VBA Events!

00:07:00

Unit Module 27: Excel User Forms

Creating an Excel UserForm

00:03:00
Adding Controls to UserForms

00:10:00
How to Show an UserForm

00:03:00
Passing TextBox Values to Desired Cells

00:07:00
Passing Option Buttons to Desired Cells

00:07:00
UserForm ComboBoxes

00:08:00
Clearing Values from UserForm Controls

00:03:00
How to Close an UserForm

00:02:00
UserForms and Protected Sheets

00:05:00

Unit Module 28: Starting a Career in Excel

Creating an Excel Resume

00:05:00
Getting Started with Freelancing

00:05:00
How to Become an Excel Freelancer

00:05:00
Top Freelance Websites

00:05:00
How to Get Your First Client

00:08:00
Personal Branding

00:05:00
Networking Do’s and Don’ts

00:04:00
Importance of Having a Website

00:04:00

Resources

Resources – Microsoft Excel Complete Training

Certification

Order Your Certificate

£25

Save 92% - Grab Now!

Offer Ends in

TAKE THIS COURSE

All Courses for £49

14-Day Money-Back Guarantee

This course includes:

Duration:

13 hours, 3 minutes
Access:

1 Year
Units:

156