Name: Microsoft Excel : Beginner, Intermediate & Advanced
Price: 299 GBP
Rating: 4.6 (5 reviews)

Overview

Undoubtedly Microsoft Excel is one of the most important and widely used workplace applications that helps to organise the business system and processes of data and information by using columns and rows with formulas, spreadsheets, charts and much more. So get your smart device on and learn the details of MS Excel with our exclusive Microsoft Excel: Beginner, Intermediate & Advanced course at your pace!

The Microsoft Excel : Beginner, Intermediate & Advanced course has been designed for those who want to improve their professional skillset and learn about MS Excel from the beginner to advanced level. This course will make you a pro in MS Excel within no time. Whether you are a newbie or a professional, this course is for you to become an expert who can confidently perform.

The Microsoft Excel : Beginner, Intermediate & Advanced course covers all the essential topics you need to learn. After completing this course, you will be able to present yourself with the dream career opportunities. Besides, having an addition of this course in your CV will definitely keep you one step ahead of others. So what are you waiting for!

Enrol now and become a master in MS Excel!

Aims & Goals Of Microsoft Excel : Beginner, Intermediate & Advanced Course

From the Microsoft Excel : Beginner, Intermediate & Advanced course, you will learn:

Master Microsoft Excel from Beginner to Advanced
Learn to build a solid understanding of the Basics of Microsoft Excel
Learn the most common Excel functions used in the Office
Create dynamic reports by mastering one of the most popular tools, PivotTables
Harness the full power of Microsoft Excel by automating your day-to-day tasks through Macros and VBA
Learn Dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more

What Inside?

Who is this course for?

Career possibilities

Data Analyst
Metrics and Analytics Specialist
MIS Executive
Financial Analyst
Market Research Analyst
Big Data Engineer
Big Data Analytics Architect
Big Data Solution Architect

Requirements

The Microsoft Excel : Beginner, Intermediate & Advanced course is open to all. There are no specific requirements and you can take the course from anywhere in the world. The course is accessible via any modern device with an internet connection and you can study at your own pace.

Certification

After successfully completing the course by passing the assessment, you will be qualified to get a CPD accredited certificate. We provide both PDF and hardcopy certificates.

You can get a PDF certificate for £4.99, hardcopy certificate for £9.99 and both for only £11.99.

Review

COURSE REVIEWS

Course Reviews

4.6

4.6

5 ratings

5 stars0
4 stars0
3 stars0
2 stars0
1 stars0

No Reviews found for this course.

Related Courses

SAGE 50 Payroll: Beginner to Advanced
~~£299.00~~ £50.00
50
4.9
Business Strategy Planning for Beginner to Advanced
£299.00
63
4.7
Banking and Finance Accounting with Financial Modelling
£299.00
58
4.7
6 Figure Business Course for Beginners
£299.00
61
4.7
Investment Banking for Startups
£299.00
58
4.9
Data Analysis - Hands On Training
£299.00
61
4.7

Related Courses

Business Strategy Planning for Beginner to Advanced
£299.00
63
4.7
Banking and Finance Accounting with Financial Modelling
£299.00
58
4.7
Investment Banking for Startups
£299.00
58
4.9

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:05: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:07: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 Cont.	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 from A-Z: Beginner To Expert	00:00:00

Cookie	Duration	Description
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.

Microsoft Excel : Beginner, Intermediate & Advanced

Course Curriculum

Overview

Aims & Goals Of Microsoft Excel : Beginner, Intermediate & Advanced Course

What Inside?

Who is this course for?

Career possibilities

Requirements

Certification

COURSE REVIEWS

Course Reviews

4.6

Related Courses

SAGE 50 Payroll: Beginner to Advanced

Business Strategy Planning for Beginner to Advanced

Banking and Finance Accounting with Financial Modelling

6 Figure Business Course for Beginners

Investment Banking for Startups

Data Analysis - Hands On Training

Related Courses

Business Strategy Planning for Beginner to Advanced

Banking and Finance Accounting with Financial Modelling

Investment Banking for Startups

This course includes

Certificate Code

LOGIN

Microsoft Excel : Beginner, Intermediate & Advanced

Course Curriculum

Overview

Aims & Goals Of Microsoft Excel : Beginner, Intermediate & Advanced Course

What Inside?

Who is this course for?

Career possibilities

Requirements

Certification

COURSE REVIEWS

Course Reviews

4.6

Related Courses

Related Courses

This course includes