All in One Offer! | Access Unlimited Courses in any category starting at just $29. Signup today. Offer Ends in: 3 Days!

Browse Library

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!

Instructed by Juan Galvan

7 days left at this price!
Get Unlimited Courses Access $29
$29
It Includes
  • Get Full Access to the platform
  • Access to 16000+ online courses
  • High Quality Recorded Lectures
  • Learn Online from Mobile/PC/Tablet
  • Assignments & Projects
  • Online iLab Access
  • Certificate of Completion
  • Download for offline viewing
  • Free Instructor Support
  • Access valid for 1 user only
  • Cancel Anytime
  • 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

Early Bird Release for the full upcoming 2021 Microsoft Excel from A-Z: Beginner To Expert Course!

Please note! This is currently in Early Bird Beta access, meaning we are still going to be continually adding content to the course (even though we are already at over 13 hours of content!) Since we're still adding content and taking student feedback as we complete the course through the start of 2021, students who enroll now will get access to a wide variety of benefits!

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.

  • Basic Computer Skills
  • Students who want to learn and master Microsoft Excel
View More...

Section 1 : Introduction

  • Lecture 1 :
  • Lecture 2 :
  • What is Microsoft Excel?
  • Lecture 3 :
  • Who is this course for?
  • Lecture 4 :
  • Microsoft Excel Marketplace
  • Lecture 5 :
  • Microsoft Excel Job Opportunities
  • Lecture 6 :
  • Microsoft Excel Job Roles
  • Lecture 7 :
  • Course Resources

Section 2 : Getting Started with Excel

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

Section 3 : Values, Referencing and Formulas

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

Section 4 : Intro to Excel Functions

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

Section 5 : Adjusting Excel Worksheets

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

Section 6 : Visually Pleasing Cell Formatting

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

Section 7 : How to insert Images and Shapes!

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

Section 8 : Visualize Data with Charts

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

Section 9 : Excel's Printing Options

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

Section 10 : Benefits of Using Excel Templates

  • Lecture 1 :
  • Why Create an Excel Template
  • Lecture 2 :
  • How to Create an Excel Template

Section 11 : Working with Excel Datasets

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

Section 12 : Excel Database Functions

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

Section 13 : Excel Data Validation

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

Section 14 : Excel Pivot Table

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

Section 15 : Excel's PowerPivot Add--In

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

Section 16 : Excel's Condtionals Functions

  • Lecture 1 :
  • Excel’s IF() Function
  • Lecture 2 :
  • IF() Function with AND() Criteria
  • Lecture 3 :
  • IF() Function with OR() Criteria
  • Lecture 4 :
  • Nesting Multiple IF() Functions
  • Lecture 5 :
  • The COUNTIF() Function
  • Lecture 6 :
  • Key Benefits of Named Ranges

Section 17 : Excel's Lookup Functions

  • Lecture 1 :
  • VLOOKUP() Function
  • Lecture 2 :
  • The Beauty of Excel’s IFERROR() Function
  • Lecture 3 :
  • HLOOKUP() Function
  • Lecture 4 :
  • INDEX() Function
  • Lecture 5 :
  • MATCH() Function
  • Lecture 6 :
  • INDEX() and MATCH() Combined
  • Lecture 7 :
  • Two-Way Lookup with INDEX() and MATCH()

Section 18 : Text Based Functions in Excel

  • Lecture 1 :
  • LEFT(), RIGHT() and MID() Function
  • Lecture 2 :
  • Extracting Specific Text using LEN() & SEARCH()
  • Lecture 3 :
  • Combining Text with CONCATENATE()
  • Lecture 4 :
  • Quick Tips & Other Text Based Functions

Section 19 : Auditing Formulas & Custom Views in Excel

  • Lecture 1 :
  • Tracing Precedents & Dependents in Formulas
  • Lecture 2 :
  • Showing Formulas
  • Lecture 3 :
  • Grouping Data
  • Lecture 4 :
  • 3D Referencing in Formulas
  • Lecture 5 :
  • Utilizing the Watch Window in Excel
  • Lecture 6 :
  • How to Freeze Panes in Excel

Section 20 : Excel's What if? Tools

  • Lecture 1 :
  • Excel’s Scenario Manager Tool
  • Lecture 2 :
  • Goal Seek in Excel
  • Lecture 3 :
  • Compare Results with Excel Data Tables
  • Lecture 4 :
  • Solver Tool

Section 21 : Welcome to Excel VBA!

  • Lecture 1 :
  • The Power Behind Excel VBA
  • Lecture 2 :
  • A Look Inside the Visual Basic Editor (VBE)
  • Lecture 3 :
  • Recording a Macro
  • Lecture 4 :
  • Saving & Opening a Macro-Enabled Workbook

Section 22 : The VBA Language

  • Lecture 1 :
  • Modules and Procedures
  • Lecture 2 :
  • Objects, Methods and Properties
  • Lecture 3 :
  • Excel VBA Variables

Section 23 : Writing VBA Code

  • Lecture 1 :
  • Referencing a Range
  • Lecture 2 :
  • Using Variables in VBA Code
  • Lecture 3 :
  • If Then Else Statement
  • Lecture 4 :
  • Worksheet Functions inside VBA
  • Lecture 5 :
  • User Defined Functions within VBA Scripts

Section 24 : Important VBA Tools and Logic

  • Lecture 1 :
  • Find Last Row of Data
  • Lecture 2 :
  • Find Last Column of Data
  • Lecture 3 :
  • With Statement
  • Lecture 4 :
  • Debugging & Error Handling
  • Lecture 5 :
  • Debugging & Error Handling cont.

Section 25 : Excel VBA Loops

  • Lecture 1 :
  • For Next Loop
  • Lecture 2 :
  • Do Until Loop
  • Lecture 3 :
  • For Each Loop

Section 26 : Triggering Macros

  • Lecture 1 :
  • Assigning Macros to Shapes
  • Lecture 2 :
  • Form Controls vs ActiveX Controls
  • Lecture 3 :
  • Worksheet Events
  • Lecture 4 :
  • Workbook Events
  • Lecture 5 :
  • Fun with VBA Events!

Section 27 : Excel User Forms

  • Lecture 1 :
  • Creating an Excel UserForm
  • Lecture 2 :
  • Adding Controls to UserForms
  • Lecture 3 :
  • Passing TextBox Values to Desired Cells
  • Lecture 4 :
  • Passing Option Buttons to Desired Cells
  • Lecture 5 :
  • UserForm ComboBoxes
  • Lecture 6 :
  • Clearing Values from UserForm Controls
  • Lecture 7 :
  • UserForms and Protected Sheets

Section 28 : Starting a Career in Excel

  • Lecture 1 :
  • Creating an Excel Resume
  • Lecture 2 :
  • Getting Started with Freelancing
  • Lecture 3 :
  • How to Become an Excel Freelancer
  • Lecture 4 :
  • Top Freelance Websites
  • Lecture 5 :
  • How to Get Your First Client
  • Lecture 6 :
  • Personal Branding
  • Lecture 7 :
  • Networking Do's and Don'ts
  • Lecture 8 :
  • Importance of Having a Website
  • How do i access the course after purchase?

    Once you purchase a course (Single course or Subscription), you will be able to access the courses instantly online by logging into your account. Use the user name & password that you created while signing up. Once logged in, you can go to the "My Courses" section to access your course.
  • Are these video based online self-learning courses?

    Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
  • Can i play & pause the course as per my convenience?

    Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
  • How do i contact the instructor for any doubts or questions?

    Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
  • Do i need a pc to access the course or can i do it on mobile & tablet as well?

    Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
  • Do i get any certification after completing the course?

    Yes. Once you succesfully complete any course on Learnfly marketplace, you get a certiifcate of course completion emailed to you within 24 hours with your name & the Learnfly badge. You can definately brag about it & share it on your social media or with friends as one of your achievement. Click here to view the sample certificate Click Here
  • For how long can i access my course after the purchase?

    If you buy a single course, that course is accessible to you for a lifetime. If you go for a premium subcription, you can access all the courses on Learnfly marketplace till your subscription is Active.
  • Whats the difference between Single Course Purchase & Go Premium option?

    With Single Course Purchase, you only get an access of one single course. Whereas, with premium monhtly or annual subscription, you can access all the existing or new courses on learnfly marketplace. You can decide what option suits you the best and accordingly you can make your purchase.
  • Is there any free trial?

    Currently, we don't have any free trial but it may be available in near future.
  • What is the refund policy?

    We would hate you to leave us. However, if you are not satisfied, you can ask for a full refund within 30 days & we will be happy to assist you further.

Juan Galvan,

Hi I'm Juan. I've been an Entrepreneur since grade school. I've started several companies, created many products and sold on various online marketplaces with great success. I'm currently a Digital Marketing Consultant and help businesses all over the world generate more leads and sales through digital marketing strategies. ​ I've learned the strategies, philosophies, methodologies, principles and core values from the most successful people in the world. I believe in continuous education with the best of a University Degree without all the downsides of burdensome costs and inefficient methods.
View More...
vba-web-connect-ms-office-to-the-web

VBA WEB - Connect MS Office to the ...

By : Daniele Protti

Lecture 223

excel-vba-from-beginner-to-expert

Excel VBA from Beginner to Expert

By : Daniele Protti

Lecture 66

mastering-office-365

Mastering Office 365

By : Chip Reaves

Lecture 70

excel-tips-and-tricks

Excel tips and Tricks

By : Muhammad Ali Yasin

Lecture 16

microsoft-powerpoint-2016-self-publishing-ebook-book-covers

Microsoft PowerPoint 2016 Self-publ...

By : Brian Jackson

Lecture 34

powerpoint-2013-2016-beginner-to-advanced-with-animation

PowerPoint 2013/2016 Beginner to Ad...

By : Brian Jackson

Lecture 114

Sign up and start learning
By signing up, you agree to our Terms of Use and Privacy Policy
Reset Password Request
Enter your email address and we'll send you a link to reset your password.