4.5 out of 5
4.5
892 reviews on Udemy

2021 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!
Instructor:
Juan E. Galvan
54,097 students enrolled
English [Auto]
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

Welcome to the Learn Microsoft Excel from A-Z: Beginner To Expert Course

In this practical, hands-on course our main objective is to give you the education not just to understand the ins and outs of Microsoft Excel, but also to learn exactly how to master pivot tables, formulas, macros, vba, data analysis, and how to land your first job as an Excel expert!

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.

You’ll also learn about calculating depreciation, calculating interest, and even calculating EMI for loans, all by using Excel functions. The course also features information on INDEX and MATCH functions as well as using the CHOOSE formula, and how to create special charts.

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.

We understand that theory is important to build a solid foundation, we understand that theory alone isn’t going to get the job done so that’s why this course is packed with practical hands-on examples that you can follow step by step. Even if you already have some experience, or want to learn about the advanced features of Excel, this course is for you!

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.

The course covers 4 main areas:

1: INTRO TO EXCEL

This intro section gives you a full introduction to Microsoft Excel, the data analyst industry and marketplace, job opportunities and salaries, and the various Excel-related job roles.

  • Intro to Microsoft Excel

  • Excel Industry and Marketplace

  • Excel Job Opportunities

  • Getting Started with Excel

  • Excel Functions

2: INTERMEDIATE EXCEL

This section gives you a full introduction to the Intermediate Excel functions with hands-on step by step training.

  • Data Visualization

  • Datasets

  • Databases

  • Data Validation

  • PivotTables

  • Conditional Functions

  • Lookup Functions

  • Formulas, + more!

3: EXCEL MACROS & VBA

This section gives you a full introduction to the Excel Macros and VBA with hands-on step by step training.

  • VBA Language

  • VBA Code

  • VBA Loops

  • Macros

  • User Forms

4: STARTING AN EXCEL CAREER

This section gives you a full introduction to starting a career as an Excel Programmer with hands-on step by step training.

  • Creating a Resume

  • Freelancing + Freelance websites

  • How To Get Your 1st Client

  • Personal Branding

  • Importance of Having a Website

  • Networking

By the end of the course you’ll be a professional Excel programmer and confidently apply for jobs and feel good knowing that you have the skills and knowledge to back it up.

Excel from A-Z Course Introduction

1
Excel from A-Z Course Section Overview
2
What is Microsoft Excel?
3
Who This Course is For
4
Microsoft Excel Marketplace
5
Microsoft Excel Job Opportunities
6
Microsoft Excel Job Types

Getting Started with Excel

1
Finding & Opening Microsoft Excel
2
Excel's Start Screen
3
Explaining the Excel Interface
4
Excel Interface Continued
5
Excel Workbook vs Excel Worksheet
6
Saving & Opening Excel Documents
7
Customizing the Excel Quick Access Toolbar
8
Customizing the Excel Ribbon
9
Excel Shortcut Keys

Values, Referencing and Formulas

1
Creating Excel Labels
2
Entering Numeric Values in Excel
3
Formatting Date Values in Excel
4
Building Basic Formulas in Excel
5
Order of Operations
6
Relative vs Absolute Cell References

Intro to Excel Functions

1
Excel Functions Explained
2
The SUM() Function
3
The MIN() & MAX() Function
4
The AVERAGE() Function
5
COUNT() Functions

Adjusting Excel Worksheets

1
Moving & Copying Data
2
Insert & Delete Rows/Columns
3
Adjusting the Width & Height of Cells
4
Hiding and Unhiding Excel Rows and Columns
5
Renaming, Moving & Deleting Excel Worksheets
6
Adding Protection to Specific Cells
7
Protecting the Structure of a Workbook
8
Adding a Workbook Password to Open File

Visually Pleasing Cell Formatting

1
Formatting Fonts and Cell Background Color
2
Adding Cell Borders
3
Formatting Data Appropriately
4
The Magic behind Excel's Format Painter
5
Creating Styles for Formatting Efficiency
6
Merging Cells for a Cleaner Look
7
The Power of Conditional Formatting

How to Insert Images and Shapes!

1
Grab User’s Attention using Illustrations
2
Customizing Icons
3
Create Compelling Graphics with SmartArt

Visualize Data with Charts

1
The Commonly used Column Chart
2
Changing the Chart Design
3
Formatting Elements of a Chart
4
Modifying the Data, Type & Location of a Chart
5
Little Slice of Pie Charts

Excel's Printing Options

1
Print Preview Options
2
Excel's Page Layout View
3
Printing a Specific Range of Cells
4
Converting Spreadsheets to PDF Files

Benefits of Using Excel Templates

1
Why Create an Excel Template
2
How to Create an Excel Template

Working with Excel Datasets

1
How to Prepare Data for Analysis
2
How to Sort Data in Excel
3
Multi-Level Sorting
4
Custom Sorting Datasets in Excel
5
Applying Filters to Datasets
6
Creating Subtotals within a Dataset
7
Converting Datasets into Tables
8
Finding & Removing Duplicate Values

Excel Database Functions

1
The SUMIF() Function
2
The DSUM() Function
3
DSUM() Function Cont.
4
The SUBTOTAL() Function

Excel Data Validation

1
What is Excel Data Validation?
2
Creating a Drop Down List with Data Validation
3
Different Types of Excel Data Validation
4
Adding Custom Alerts to Data Validation
5
Creating a Dynamic Drop Down List
6
Complex Validation: Dependent Drop Down List!

Excel PivotTables

1
Creating an Excel Pivot Table
2
Modifying Excel PivotTables
3
Grouping & Filtering PivotTable Data
4
Drilling Down into PivotTable Data
5
Creating Pivot Charts & Utilizing Slicers

Excel's PowerPivot Add-In

1
What is PowerPivot?
2
Activating the Excel PowerPivot Add-In
3
Creating Relationships between Data Tables
4
Using Data Models to Create PivotTables
5
How to Create PowerPivot KPI’s

Excel's Conditional Functions

1
Excel’s IF() Function
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.5
4.5 out of 5
892 Ratings

Detailed Rating

Stars 5
468
Stars 4
312
Stars 3
92
Stars 2
7
Stars 1
7
ec76bdfb66e5f8304ddcebddb9c61213
Course available for 2 days
30-Day Money-Back Guarantee

Includes

13 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion

External Links May Contain Affiliate Links read more

Never Miss Any Course Join Our Telegram Channel Join Channel
+ +