Master pivot tables, formulas, macros, vba, data analysis and learn how to land your first job as an Excel expert!
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
Description
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.
English
Language
Content
Excel from A-Z Course Introduction
Excel from A-Z Course Section Overview
What is Microsoft Excel?
Who This Course is For
Microsoft Excel Marketplace
Microsoft Excel Job Opportunities
Microsoft Excel Job Types
Getting Started with Excel
Finding & Opening Microsoft Excel
Excel’s Start Screen
Explaining the Excel Interface
Excel Interface Continued
Excel Workbook vs Excel Worksheet
Saving & Opening Excel Documents
Customizing the Excel Quick Access Toolbar
Customizing the Excel Ribbon
Excel Shortcut Keys
Values, Referencing and Formulas
Creating Excel Labels
Entering Numeric Values in Excel
Formatting Date Values in Excel
Building Basic Formulas in Excel
Order of Operations
Relative vs Absolute Cell References
Intro to Excel Functions
Excel Functions Explained
The SUM() Function
The MIN() & MAX() Function
The AVERAGE() Function
COUNT() Functions
Adjusting Excel Worksheets
Moving & Copying Data
Insert & Delete Rows/Columns
Adjusting the Width & Height of Cells
Hiding and Unhiding Excel Rows and Columns
Renaming, Moving & Deleting Excel Worksheets
Adding Protection to Specific Cells
Protecting the Structure of a Workbook
Adding a Workbook Password to Open File
Visually Pleasing Cell Formatting
Formatting Fonts and Cell Background Color
Adding Cell Borders
Formatting Data Appropriately
The Magic behind Excel’s Format Painter
Creating Styles for Formatting Efficiency
Merging Cells for a Cleaner Look
The Power of Conditional Formatting
How to Insert Images and Shapes!
Grab User’s Attention using Illustrations
Customizing Icons
Create Compelling Graphics with SmartArt
Visualize Data with Charts
The Commonly used Column Chart
Changing the Chart Design
Formatting Elements of a Chart
Modifying the Data, Type & Location of a Chart
Little Slice of Pie Charts
Excel’s Printing Options
Print Preview Options
Excel’s Page Layout View
Printing a Specific Range of Cells
Converting Spreadsheets to PDF Files
Benefits of Using Excel Templates
Why Create an Excel Template
How to Create an Excel Template
Working with Excel Datasets
How to Prepare Data for Analysis
How to Sort Data in Excel
Multi-Level Sorting
Custom Sorting Datasets in Excel
Applying Filters to Datasets
Creating Subtotals within a Dataset
Converting Datasets into Tables
Finding & Removing Duplicate Values
Excel Database Functions
The SUMIF() Function
The DSUM() Function
DSUM() Function Cont.
The SUBTOTAL() Function
Excel Data Validation
What is Excel Data Validation?
Creating a Drop Down List with Data Validation
Different Types of Excel Data Validation
Adding Custom Alerts to Data Validation
Creating a Dynamic Drop Down List
Complex Validation: Dependent Drop Down List!
Excel PivotTables
Creating an Excel Pivot Table
Modifying Excel PivotTables
Grouping & Filtering PivotTable Data
Drilling Down into PivotTable Data
Creating Pivot Charts & Utilizing Slicers
Excel’s PowerPivot Add-In
What is PowerPivot?
Activating the Excel PowerPivot Add-In
Creating Relationships between Data Tables
Using Data Models to Create PivotTables
How to Create PowerPivot KPI’s
Excel’s Conditional Functions
Excel’s IF() Function
IF() Function with AND() Criteria
IF() Function with OR() Criteria
Nesting Multiple IF() Functions
The COUNTIF() Function
Key Benefits of Named Ranges
Excel’s Lookup Functions
VLOOKUP() Function
The Beauty of Excel’s IFERROR() Function
HLOOKUP() Function
INDEX() Function
MATCH() Function
INDEX() and MATCH() Combined
Two-Way Lookup with INDEX() and MATCH()
Text Based Functions in Excel
LEFT(), RIGHT() and MID() Function
Extracting Specific Text using LEN() & SEARCH()
Combining Text with CONCATENATE()
Quick Tips & Other Text Based Functions
Auditing Formulas & Custom Views in Excel
Tracing Precedents & Dependents in Formulas
Showing Formulas
Grouping Data
3D Referencing in Formulas
Utilizing the Watch Window in Excel
How to Freeze Panes in Excel
Excel’s “What If?” Tools
Excel’s Scenario Manager Tool
Goal Seek in Excel
Compare Results with Excel Data Tables
Solver Tool
Welcome to Excel VBA!
The Power Behind Excel VBA
A Look Inside the Visual Basic Editor (VBE)
Recording a Macro
Saving & Opening a Macro-Enabled Workbook
The VBA Language
Modules and Procedures
Objects, Methods and Properties
Excel VBA Variables
Writing VBA Code
Referencing a Range
InputBox & MsgBox
Using Variables in VBA Code
If Then Else Statement
Worksheet Functions inside VBA
Creating User Defined Functions
User Defined Functions within VBA Scripts
Important VBA Tools and Logic
Find Last Row of Data
Find Last Column of Data
With Statement
Debugging & Error Handling
Debugging & Error Handling Cont.
Excel VBA Loops
For Next Loop
Do Until Loop
For Each Loop
Triggering Macros
Assigning Macros to Shapes
Form Controls vs ActiveX Controls
Worksheet Events
Workbook Events
Fun with VBA Events!
Excel User Forms
Creating an Excel UserForm
Adding Controls to UserForms
How to Show an UserForm
Passing TextBox Values to Desired Cells
Passing Option Buttons to Desired Cells
UserForm ComboBoxes
Clearing Values from UserForm Controls
How to Close an UserForm
UserForms and Protected Sheets
Starting a Career in Excel
Creating an Excel Resume
Getting Started with Freelancing
How to Become an Excel Freelancer
Top Freelance Websites
How to Get Your First Client
Personal Branding
Networking Do’s and Don’ts
Importance of Having a Website