Booking options
£18
Course Images
Microsoft Excel Masterclass in 2021
By John Academy
(43)- 30 Day Money Back Guarantee
- Completion Certificate
- 24/7 Technical Support
Highlights
On-Demand course
13 hours 1 minutes
All levels
Description
Course Overview
Grasp the opportunity to learn Microsoft Excel from the ABCs to an advanced level within one course. The Microsoft Excel Masterclass in 2021 course will start with the basics with MS excel and gradually turn you into an expert user.
The Microsoft Excel Masterclass in 2021 course will first focus on the tools and functions of excel. You will comprehend the skills to create basic formulas in excel. In this step by the step learning process, you will have the adequate knowledge and ability to make all sorts of adjustments to your worksheets. The course will teach you many strategies for cell formatting. From the easy to follow modules, you will grasp the techniques to insert shapes and images into your sheets. You will also understand how to visualize your data in charts. In the end, you will study the benefits of using excel templates.
The Microsoft Excel Masterclass in 2021 course will provide you with first-hand training on excel. Enroll in the course and take your excel skills to the next level.
Learning Outcomes
Get an introduction to Microsoft Excel and its functions
Understand the process of data validation and data visualization
Learn how to adjust excel worksheets
Know about the conditional functions
Familiarize yourself with the process of inserting images and shapes
Who is this course for?
Those who want to learn Microsoft Excel.
Entry Requirement
This course is available to all learners, of all academic backgrounds.
Learners should be aged 16 or over to undertake the qualification.
Good understanding of English language, numeracy and ICT are required to attend this course.
Certification
After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24.
PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days.
Why choose us?
Affordable, engaging & high-quality e-learning study materials;
Tutorial videos/materials from the industry-leading experts;
Study in a user-friendly, advanced online learning platform;
Efficient exam systems for the assessment and instant result;
The UK & internationally recognized accredited qualification;
Access to course content on mobile, tablet or desktop from anywhere anytime;
The benefit of career advancement opportunities;
24/7 student support via email.
Career Path
The Microsoft Excel Masterclass in 2021 course is a useful qualification to possess and would be beneficial for any related profession or industry such as:
Business Professional
Data Operator
Administrative Officer
Data Analyst
Unit 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 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 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 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 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 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 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 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 | ||
Unit 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 10: Benefits of Using Excel Templates | |||
Why Create an Excel Template | 00:01:00 | ||
How to Create an Excel Template | 00:05:00 | ||
Unit 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 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 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 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 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 | 00:06:00 | ||
Using Data Models to Create PivotTables | 00:05:00 | ||
How to Create PowerPivot KPI's | 00:08:00 | ||
Unit 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 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 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 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 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 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 22: The VBA Language | |||
Modules and Procedures | 00:07:00 | ||
Objects, Methods and Properties | 00:06:00 | ||
Excel VBA Variables | 00:05:00 | ||
Unit 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 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 25: Excel VBA Lopps | |||
For Next Loop | 00:09:00 | ||
Do Until Loop | 00:06:00 | ||
For Each Loop | 00:04:00 | ||
Unit 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 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 28: Starting a Career in Excel | |||
Creating an Excel Resume | 00:05:00 | ||
Getting Started with Freelancing | 00:06: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:07:00 | ||
Networking Do's and Don'ts | 00:04:00 | ||
Importance of Having a Website | 00:04:00 | ||
Resources | |||
Resources - Microsoft Excel Masterclass in 2021 | 00:00:00 | ||
Certificate and Transcript | |||
Order Your Certificates and Transcripts | 00:00:00 |
About The Provider
John Academy
London
(43)Reviews
There are no reviews for Microsoft Excel Masterclass in 2021 yet.Why not be the first one to review this course?