0

ecommerce/course.login

ecommerce/course.or, ecommerce/course.create_accountCreate an account in checkout page
Excel

Microsoft Excel from A-Z: Beginner To Expert Course

Master pivot tables, formulas, macros, vba, data analysis and learn how to land your first job as an Excel expert!

4.1
(189 ratings) 534 students



Enroll now


What you will learn

Learn to master Excel from A-Z
How to become a professional Data Analyst
How to be a better, faster, stronger Excel user
How to land your first job as an Excel Expert
How to save hours of time and boost your productivity in Excel
How to find a value with VLOOKUP, HLOOKUP, INDEX, MATCH
How to use math, statistical, logic and text functions
How to use VBA and Macros
How to use VLOOKUP/HLOOKUP in formulas
How to create basic and advanced formulas
Mastering Pivot Tables
Creating Charts from your data

Who should take this training

Prerequisites

  • Basic computer skills

Target audience

  • Students who want to learn and master microsoft excel

About this training

This course will fully prepare you for virtually any Excel related career path, including those that require advanced skills with this software. Once you complete the course, you’ll have access to the full functionality of Excel, and will know how to use all formulas, functions, and capabilities.

Whether you are brand new to the world of Excel, or you have training and knowledge of the software and are looking to improve your skills, this masterclass will take you to the next level. By the time you finish the beginner, intermediate and advanced portions, you too will be an expert in Excel.

Together we’re going to give you the foundational education that you need to know not just on how to use Excel at an expert level, but also how to get paid for your newly developed skills.

Course Language : EN
On-demand video
Full lifetime access to videos
Downloadable resources
Assignments
Certificate of Completion
Enroll now

Training options

Only Videos

$ 30

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • Hours of Individual Coaching

Blended

$ 630

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 10 Hours of Individual Coaching
Save 10%

Blended

$ 1200 $ 1107

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 20 Hours of Individual Coaching
Save 20%

Blended

$ 1830 $ 1464

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 30 Hours of Individual Coaching

Course Content

Section 1 : Introduction to Excel
Excel from A-Z Introduction 03:21 mins
Excel Job Opportunities 02:43 mins
Excel Job Types 03:51 mins
Microsoft Excel Marketplace 04:09 mins
What is Microsoft Excel 04:16 mins
Who is this Course for 03:30 mins
Section 2 : Getting Started with Excel
Customizing the Excel Ribbon 03:04 mins
Customizing the Quick Access Toolbar 02:15 mins
Excel's Start Screen 03:15 mins
Excel Interface Continued 01:26 mins
Excel Shortcut Keys 01:43 mins
Excel Workbook vs Excel Worksheet 02:13 mins
Explaining the Excel Interface 02:43 mins
Finding and Opening Excel 01:04 mins
Saving & Opening Excel Documents 03:33 mins
Section 3 : Values, Referencing and Formulas
Creating Excel Labels 02:32 mins
Entering Numeric Values in Excel 03:25 mins
Formatting Date Values in Excel 05:19 mins
Building Basic Formulas in Excel 04:44 mins
Order of Operations 06:28 mins
Relative vs Absolute Cell References 07:23 mins
Section 4 : Intro to Excel Functions
Excel Functions Explained 02:34 mins
The SUM() Function 07:31 mins
The MIN() & MAX() Function 03:44 mins
The AVERAGE() Function 02:01 mins
COUNT() Functions 04:57 mins
Section 5 : Adjusting Excel Worksheets
Moving & Copying Data 06:45 mins
Insert & Delete Rows/Columns 05:04 mins
Adjusting the Width & Height of Cells 04:34 mins
Hiding and Unhiding Excel Rows and Columns 04:28 mins
Renaming, Moving & Deleting Excel Worksheets 05:27 mins
Adding Protection to Specific Cells 04:24 mins
Protecting the Structure of a Workbook 02:11 mins
Adding a Workbook Password to Open File 02:10 mins
Section 6 : Visually Pleasing Cell Formatting
Formatting Fonts and Cell Background Color 04:55 mins
Adding Cell Borders 04:47 mins
Formatting Data Appropriately 05:21 mins
The Magic behind Excel's Format Painter 03:30 mins
Creating Styles for Formatting Efficiency 05:56 mins
Merging Cells for a Cleaner Look 03:27 mins
The Power of Conditional Formatting 06:09 mins
Section 7 : How to insert Images and Shapes!
Grab User’s Attention using Illustrations 08:39 mins
Customizing Icons 04:41 mins
Create Compelling Graphics with SmartArt 05:36 mins
Section 8 : Visualize Data with Charts
The Commonly used Column Chart 02:46 mins
Changing the Chart Design 01:58 mins
Formatting Elements of a Chart 06:24 mins
Modifying the Data, Type & Location of a Chart 06:06 mins
Little Slice of Pie Charts 05:12 mins
Section 9 : Excel's Printing Options
Print Preview Options 04:26 mins
Excel's Page Layout View 06:36 mins
Printing a Specific Range of Cells 02:38 mins
Converting Spreadsheets to PDF Files 02:28 mins
Section 10 : Benefits of Using Excel Templates
Why Create an Excel Template 01:23 mins
How to Create an Excel Template 05:22 mins
Section 11 : Working with Excel Datasets
How to Prepare Data for Analysis 04:01 mins
How to Sort Data in Excel 02:38 mins
Multi-Level Sorting 02:34 mins
Custom Sorting Datasets in Excel 02:27 mins
Applying Filters to Datasets 04:44 mins
Creating Subtotals within a Dataset 05:39 mins
Converting Datasets into Tables 05:55 mins
Finding & Removing Duplicate Values 07:29 mins
Section 12 : Excel Database Functions
The SUMIF() Function 08:42 mins
The DSUM() Function 07:47 mins
DSUM() Function Cont 07:06 mins
The SUBTOTAL() Function 06:29 mins
Section 13 : Excel Data Validation
What is Excel Data Validation? 01:56 mins
Creating a Drop Down List with Data Validation 07:09 mins
Different Types of Excel Data Validation 05:39 mins
Adding Custom Alerts to Data Validation 06:53 mins
Creating a Dynamic Drop Down List 03:09 mins
Complex Validation: Dependent Drop Down List! 08:39 mins
Section 14 : Excel PivotTables
Creating an Excel Pivot Table 05:31 mins
Modifying Excel PivotTables 05:39 mins
Grouping & Filtering PivotTable Data 06:30 mins
Drilling Down into PivotTable Data 02:00 mins
Creating PivotCharts & Utilizing Slicers 08:00 mins
Section 15 : Excel's PowerPivot Add-In
What is PowerPivot? 03:46 mins
Activating the Excel PowerPivot Add-In 01:34 mins
Creating Relationships between Data Tables 06:22 mins
Using Data Models to Create PivotTables 04:31 mins
How to Create PowerPivot KPI’s 08:26 mins
Section 16 : Excel's Conditional Functions
Excel’s IF() Function 05:17 mins
IF() Function with AND() Criteria 05:23 mins
IF() Function with OR() Criteria 05:14 mins
Nesting Multiple IF() Functions 07:24 mins
The COUNTIF() Function 04:06 mins
Key Benefits of Named Ranges 04:11 mins
Section 17 : Excel's Lookup Functions
VLOOKUP() Function 09:00 mins
The Beauty of Excel’s IFERROR() Function 03:56 mins
HLOOKUP() Function 06:21 mins
INDEX() Function 04:43 mins
MATCH() Function 04:56 mins
INDEX() and MATCH() Combined 05:08 mins
Two-Way Lookup with INDEX() and MATCH() 04:10 mins
Section 18 : Text Based Functions in Excel
LEFT(), RIGHT() and MID() Function 07:08 mins
Extracting Specific Text using LEN() & SEARCH() 12:44 mins
Combining Text with CONCATENATE() 06:05 mins
Quick Tips & Other Text Based Functions 05:49 mins
Section 19 : Auditing Formulas & Custom Views in Excel
Tracing Precedents & Dependents in Formulas 04:28 mins
Showing Formulas 01:53 mins
Grouping Data 02:42 mins
3D Referencing in Formulas 05:04 mins
Utilizing the Watch Window in Excel 02:44 mins
How to Freeze Panes in Excel 02:56 mins
Section 20 : Excel’s “What If?” Tools
Excel’s Scenario Manager Tool 05:55 mins
Goal Seek in Excel 06:15 mins
Compare Results with Excel Data Tables 04:23 mins
Solver Tool 10:59 mins
Section 21 : Welcome to Excel VBA!
The Power Behind Excel VBA 02:35 mins
A Look Inside the Visual Basic Editor (VBE) 03:57 mins
Recording a Macro 09:11 mins
Saving & Opening a Macro-Enabled Workbook 02:14 mins
Section 22 : The VBA Language
Modules and Procedures 06:34 mins
Objects, Methods and Properties 05:39 mins
Excel VBA Variables 04:39 mins
Section 23 : Writing VBA Code
Referencing a Range 13:30 mins
InputBox & MsgBox 05:33 mins
Using Variables in VBA Code 04:32 mins
If Then Else Statement 10:23 mins
Worksheet Functions inside VBA 07:32 mins
Creating User Defined Functions 09:19 mins
User Defined Functions within VBA Scripts 06:09 mins
Section 24 : Important VBA Tools and Logic
Find Last Row of Data 05:46 mins
Find Last Column of Data 03:12 mins
With Statement 04:51 mins
Debugging & Error Handling 06:36 mins
Debugging & Error Handling Cont. 06:45 mins
Section 25 : Excel VBA Loops
For Next Loop 09:12 mins
Do Until Loop 06:03 mins
For Each Loop 03:36 mins
Section 26 : Triggering Macros
Assigning Macros to Shapes 03:33 mins
Form Controls vs ActiveX Controls 07:50 mins
Worksheet Events 02:54 mins
Workbook Events 03:44 mins
Fun with VBA Events! 06:55 mins
Section 27 : Excel UserForms
Creating an Excel UserForm 03:15 mins
Adding Controls to UserForms 10:00 mins
How to Show an UserForm 03:01 mins
Passing TextBox Values to Desired Cells 06:37 mins
Passing Option Buttons to Desired Cells 06:50 mins
UserForm ComboBoxes 08:08 mins
Clearing Values from UserForm Controls 03:06 mins
How to Close an UserForm 01:34 mins
UserForms and Protected Sheets 04:40 mins
Section 28 : Starting a Career in Excel
Creating an Excel Resume 04:51 mins
Getting Started with Freelancing 06:16 mins
Top Freelance Websites 05:12 mins
Personal Branding 06:47 mins
Networking Do's and Don'ts 04:22 mins
Importance of Having a Website 04:24 mins
How to Become an Excel Freelancer 05:12 mins
Getting your First Client 07:45 mins

Request more information

Similar courses

Join our mail list for news