Check out just a few key highlights for:
2021 Microsoft Excel from A-Z: Beginner To Expert Course.
Join a community of other students taking this course.
Each lecture is recorded in HD 1920x1080p with clear audio.
All courses are rated by fellow community members.
All YouAccel courses are recorded and produced in 1920x1080p HD Quality.
Have a question? Contact our support team at any time using our chat feature, or built-in messaging console.
All YouAccel courses come with a Certificate of Completion. This helps Showcase your proficiency in a subject to prospective employers.
All YouAccel courses include lifetime on-demand access. Class lecture are also available for offline viewing.
Join a community of over 600,000 learners. Connect & Communicate through YouAccel's networking tools.
YouAccel's integration with Indeed makes it easy to search through thousands of jobs and apply with just a click.
A comprehensive list of all sections & lectures for this course can be found below.
Introduction - 02:40 [Play]
Excel from A-Z Course Intro - 03:21
What is Microsoft Excel - 04:16
Who is This Course For - 03:30
Microsoft Excel Marketplace - 04:09
Excel Job Opportunities - 02:43
Excel Job Types - 03:51
Finding and Opening Excel - 01:04 [Play]
Excel_s Start Screen - 03:15
Explaining the Excel Interface - 02:43
Excel Interface Cont - 01:26
Excel Workbook vs. Excel Worksheet - 02:13
Saving and Opening Excel Documents - 03:33
Customizing the Quick Access Toolbar - 02:15
Customizing the Excel Ribbon - 03:04
Excel Shortcut Keys - 01:43
Creating Excel Labels - 02:32 [Play]
Entering Numeric Data in Excel - 03:25
Formatting Date Values in Excel - 05:19
Building Basic Formulas in Excel - 04:44
Order of Operation - 06:28
Relative vs Absolute Cell References - 07:24
Excel Functions Explained - 02:35 [Play]
The SUM Function - 07:31
The MIN and MAX Function - 03:44
The AVERAGE Function - 02:01
COUNT Functions - 04:57
Moving and Copying Data - 06:45 [Play]
Insert and Delete Rows and Columns - 05:04
Adjusting the Width and Height of Cells - 04:34
Hiding and Unhiding Excel Rows and Columns - 04:28
Renaming Moving and Deleting Excel Worksheets - 05:27
Adding Protection to Specific Cells - 04:24
Protecting the Structure of a Workbook - 02:11
Adding a Workbook Password to Open File - 02:10
Formatting Fonts and Cell Background Color - 04:55 [Play]
Adding Cell Borders - 04:47
Formatting Data Appropriately - 05:21
The Magic Behind Excel_s Format Painter - 03:30
Creating Styles for Formatting Efficiency - 05:56
Merging Cells for a Cleaner Look - 03:27
The Power of Conditional Formatting - 06:09
Grab Users Attention using Illustrations - 08:39 [Play]
Customizing Icons - 04:41
Create Compelling Graphics with SmartArt - 05:36
The Commonly Used Column Chart - 02:46 [Play]
Changing the Chart Design - 01:58
Formatting Elements of a Chart - 06:24
Modifying the Data Type and Location of a Chart - 06:06
Little Slice of Pie Charts - 05:12
Print Preview Options - 04:26 [Play]
Excels Page Layout View - 06:37
Printing a Specific Range of Cells - 02:38
Converting Spreadsheets to PDF Files - 02:28
Why Create an Excel Template - 01:23 [Play]
How to Create an Excel Template - 05:22
How to Prepare Data for Analysis - 04:01 [Play]
How to Sort Data in Excel - 02:38
Multi Level Sorting - 02:34
Custom Sorting Datasets in Excel - 02:27
Applying Filters to Datasets - 04:44
Creating Subtotals within a Dataset - 05:39
Converting Datasets into Tables - 05:55
Finding and Removing Duplicate Values - 07:29
The SUMIF Function - 08:42 [Play]
The DSUM Function - 07:47
The DSUM Function Cont - 07:06
The SUBTOTAL Function - 06:29
What is Excel Data Validation - 01:56 [Play]
Creating a Drop Down List with Data Validation - 07:09
Different Types of Data Validation - 05:39
Adding Custom Alerts to Data Validation - 06:53
Creating a Dynamic Drop Down List - 03:09
Complex Validation: Dependent Drop Down List! - 08:39
Creating an Excel Pivot Table - 05:31 [Play]
Modifying Excel Pivot Tables - 05:39
Grouping Filtering PivotTable Data - 06:30
Drilling Down into PivotTable Data - 02:00
Creating PivotCharts and Slicers - 08:00
What is PowerPivot - 03:46 [Play]
Activating the Excel PowerPivot Add-In - 01:34
Creating Relationships between Data Tables - 06:22
Using Data Models to Create PivotTables - 04:31
How to Create PowerPivot KPIs - 08:26
Excels IF Function - 05:17 [Play]
IF() Function with AND() Criteria - 05:23
IF() Function with OR() Criteria - 05:14
Nesting Multiple IF Functions - 07:24
The COUNTIF Function - 04:06
Key Benefits of Using Named Ranges - 04:11
VLOOKUP() Function - 09:00 [Play]
The Beauty of Excel's IFERROR() Function - 03:56
HLOOKUP() Function - 06:21
INDEX() Function - 04:43
MATCH() Function - 04:56
INDEX() and MATCH() Combined - 05:08
Two-Way Lookup with INDEX() and MATCH() - 04:10
LEFT(), RIGHT() and MID() Function - 07:08 [Play]
Extracting Specific Text using LEN() and SEARCH() - 12:44
Combining Text with CONCATENATE - 06:05
Quick Tips and Other Text Based Functions - 05:49
Tracing Precedents and Dependents in Formulas - 04:28 [Play]
Showing Formulas - 01:53
Grouping Data - 02:42
3D Referencing in Formulas - 05:04
Utilizing the Watch Window in Excel - 02:44
How to Freeze Panes in Excel - 02:56
Excel's Scenario Manager Tool - 05:55 [Play]
Goal Seek in Excel - 06:15
Compare Results with Excel Data Tables - 04:24
Solver Tool - 10:59
The Power Behind Excel VBA - 02:35 [Play]
A Look Inside the Visual Basic Editor (VBE) - 03:57
Recording a Macro - 09:11
Saving and Opening a Macro Enabled Workbook - 02:14
Modules and Procedures - 06:34 [Play]
Objects, Methods, and Properties - 05:59
Excel VBA Variables - 04:39
Referencing a Range - 13:30 [Play]
InputBox and MsgBox - 05:33
Using Variables in VBA Code - 04:32
If Then Else Statement - 10:23
Worksheet Functions inside VBA - 07:32
Creating User Defined Functions - 09:19
User Defined Functions within VBA Scripts - 06:09
Find Last Row of Data - 05:46 [Play]
Find Last Column of Data - 03:12
With Statement - 04:51
Debugging and Error Handling - 06:36
Debugging and Error Handling Cont - 06:45
For Next Loop - 09:12 [Play]
Do Until Loop - 06:03
For Each Loop - 03:36
Assigning Macros to Shapes - 03:33 [Play]
Form Controls vs Active X Controls - 07:50
Workbook Events - 02:54
Worksheet Events - 03:44
Fun with VBA Events - 06:55
Creating an Excel UserForm - 03:15 [Play]
Adding Controls to UserForms - 10:00
How to Show an UserForm - 03:01
Passing TextBox Values to Desired Cells - 06:37
Passing Option Buttons Values to Desired Cells - 06:50
UserForm ComboBoxes - 08:08
Clearing Values from UserForm Controls - 03:06
How to Close an UserForm - 01:34
UserForms and Protected Sheets - 04:40
Creating an Excel Resume - 04:51 [Play]
Getting Started with Freelancing - 06:16
How to Become an Excel Freelancer - 05:12
Top Freelance Sites - 05:12
Getting Your First Client - 07:45
Personal Branding - 06:47
Networking Do’s and Don’ts - 04:22
Importance of Website - 04:24
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 will have access to the full functionality of Excel, and will know how to use all formulas, functions, and capabilities.
You will 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.
All course reviews are written by students who have completed the course or are currently enrolled.
I already have experience with what has been taught, but as someone who teaches myself I thought it was well put together and covered well enough for learners at all levels.
Course exceeded my expectations! Skylar was amazing and helped me a lot to learn new things about excel. I will be going back to review some of the topics that I need to revisit!
loved this course beyond my expectation
Great overview and explanation of Excel. Even though I have years of experience with Excel, I was still able to learn so many options and features, which I did not know previously. Thanks.
Instructor is very good
I highly recommended this course for those who want to learn from zero like. I followed this course during about a month or more and I learned many. And now I ready to launch my career as an expert... All the courses are very well explained and easy to understand. Also the admins answer very quickly to question of students. Thanks to team and congratulations.
juan galvan is currently teaching 12 courses. All courses are currently open for enrollment.
juan galvan currently has 215,500 global enrollments across 12 courses that are active on the platform.
juan galvan has an average rating of 4.5/5 stars, across 12 courses.
Hi I'm Juan. I've been an Entrepreneur since grade school. My background is in the tech space from Digital Marketing, E-commerce, Web Development to Programming. I believe in continuous education with the best of a University Degree without all the downsides of burdensome costs and inefficient methods. I look forward to helping you expand your skillsets.
You have nothing to lose. Give the course a try. If it's not what you expected, get a full refund within 30 days of purchase.