This course is designed for those interested to learn everything there is to know about Microsoft Excel, how to become a professional Data Analyst, land your first job as an Excel Expert, and find values using VLOOKUP, HLOOKUP, INDEX MATCH.
Read more.Course Skill Level
Beginner
Time Estimate
12h 57m
Instructor
Hi I'm Juan. My background is in the tech space from Digital Marketing, E-commerce, Web Development to Programming.
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This 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.
What you’ll learn:
- 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
- Find a value with VLOOKUP, HLOOKUP, INDEX, MATCH
Who this course is for:
- Students who want to learn and master Microsoft Excel
Our Promise to You
By the end of this course, you will have learned Microsoft Excel.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about Microsoft Excel.
Course Curriculum
| Section 1 - Excel from A-Z Course Introduction | |||
| Excel from A-Z Course Section Overview | 00:00:00 | ||
| Downloadable Course Resources | 00:00:00 | ||
| What is Microsoft Excel? | 00:00:00 | ||
| Who This Course is For | 00:00:00 | ||
| Microsoft Excel Marketplace | 00:00:00 | ||
| Microsoft Excel Job Opportunities | 00:00:00 | ||
| Microsoft Excel Job Types | 00:00:00 | ||
| Section 2 - Getting Started With Excel | |||
| Finding And Opening Microsoft Excel | 00:00:00 | ||
| Excel’s Start Screen | 00:00:00 | ||
| Explaining The Excel Interface | 00:00:00 | ||
| Excel Interface Continued | 00:00:00 | ||
| Excel Workbook Vs Excel Worksheet | 00:00:00 | ||
| Saving And Opening Excel Documents | 00:00:00 | ||
| Customizing The Excel Quick Access Toolbar | 00:00:00 | ||
| Customizing the Excel Ribbon | 00:00:00 | ||
| Excel Shortcut Keys | 00:00:00 | ||
| Section 3 - Values, Referencing And Formulas | |||
| Creating Excel Labels | 00:00:00 | ||
| Entering Numeric Values In Excel | 00:00:00 | ||
| Formatting Date Values In Excel | 00:00:00 | ||
| Building Basic Formulas In Excel | 00:00:00 | ||
| Order Of Operations | 00:00:00 | ||
| Relative Vs Absolute Cell References | 00:00:00 | ||
| Section 4 - Intro To Excel Functions | |||
| Excel Functions Explained | 00:00:00 | ||
| The SUM() Function | 00:00:00 | ||
| The MIN() And MAX() Function | 00:00:00 | ||
| The AVERAGE() Function | 00:00:00 | ||
| COUNT() Functions | 00:00:00 | ||
| Section 5 - Adjusting Excel Worksheets | |||
| Moving And Copying Data | 00:00:00 | ||
| Insert And Delete Rows Or Columns | 00:00:00 | ||
| Adjusting The Width And Height Of Cells | 00:00:00 | ||
| Hiding And Unhiding Excel Rows And Columns | 00:00:00 | ||
| Renaming, Moving And Deleting Excel Worksheets | 00:00:00 | ||
| Adding Protection To Specific Cells | 00:00:00 | ||
| Protecting The Structure Of A Workbook | 00:00:00 | ||
| Adding A Workbook Password To Open File | 00:00:00 | ||
| Section 6 - Visually Pleasing Cell Formatting | |||
| Formatting Fonts And Cell Background Color | 00:00:00 | ||
| Adding Cell Borders | 00:00:00 | ||
| Formatting Data Appropriately | 00:00:00 | ||
| The Magic Behind Excel’s Format Painter | 00:00:00 | ||
| Creating Styles For Formatting Efficiency | 00:00:00 | ||
| Merging Cells For a Cleaner Look | 00:00:00 | ||
| The Power Of Conditional Formatting | 00:00:00 | ||
| Section 7 - How To Insert Images And Shapes | |||
| Grab User’s Attention Using Illustrations | 00:00:00 | ||
| Customizing Icons | 00:00:00 | ||
| Create Compelling Graphics With SmartArt | 00:00:00 | ||
| Section 8 - Visualize Data With Charts | |||
| The Commonly Used Column Chart | 00:00:00 | ||
| Changing The Chart Design | 00:00:00 | ||
| Formatting Elements Of A Chart | 00:00:00 | ||
| Modifying The Data, Type And Location Of A Chart | 00:00:00 | ||
| Little Slice Of Pie Charts | 00:00:00 | ||
| Section 9 - Excel's Printing Options | |||
| Print Preview Options | 00:00:00 | ||
| Excel’s Page Layout View | 00:00:00 | ||
| Printing A Specific Range Of Cells | 00:00:00 | ||
| Converting Spreadsheets To PDF Files | 00:00:00 | ||
| Section 10 - Benefits Of Using Excel Templates | |||
| Why Create An Excel Template | 00:00:00 | ||
| How to Create An Excel Template | 00:00:00 | ||
| Section 11 - Working With Excel Datasets | |||
| How To Prepare Data For Analysis | 00:00:00 | ||
| How To Sort Data in Excel | 00:00:00 | ||
| Multi-Level Sorting | 00:00:00 | ||
| Custom Sorting Datasets In Excel | 00:00:00 | ||
| Applying Filters To Datasets | 00:00:00 | ||
| Creating Subtotals Within A Dataset | 00:00:00 | ||
| Converting Datasets Into Tables | 00:00:00 | ||
| Finding And Removing Duplicate Values | 00:00:00 | ||
| Section 12 - Excel Database Functions | |||
| The SUMIF() Function | 00:00:00 | ||
| The DSUM() Function | 00:00:00 | ||
| DSUM() Function Continued | 00:00:00 | ||
| The SUBTOTAL() Function | 00:00:00 | ||
| Section 13 - Excel Data Validation | |||
| What Is Excel Data Validation? | 00:00:00 | ||
| Creating A Drop Down List with Data Validation | 00:00:00 | ||
| Different Types Of Excel Data Validation | 00:00:00 | ||
| Adding Custom Alerts To Data Validation | 00:00:00 | ||
| Creating A Dynamic Drop Down List | 00:00:00 | ||
| Complex Validation: Dependent Drop Down List! | 00:00:00 | ||
| Section 14 - Excel PivotTables | |||
| Creating An Excel Pivot Table | 00:00:00 | ||
| Modifying Excel PivotTables | 00:00:00 | ||
| Grouping And Filtering PivotTable Data | 00:00:00 | ||
| Drilling Down Into PivotTable Data | 00:00:00 | ||
| Creating Pivot Charts And Utilizing Slicers | 00:00:00 | ||
| Section 15 - Excel's PowerPivot Add-In | |||
| What Is PowerPivot? | 00:00:00 | ||
| Activating The Excel PowerPivot Add-In | 00:00:00 | ||
| Creating Relationships Between Data Tables | 00:00:00 | ||
| Using Data Models To Create PivotTables | 00:00:00 | ||
| How To Create PowerPivot KPI’s | 00:00:00 | ||
| Section 16 - Excel's Conditional Functions | |||
| Excel’s IF() Function | 00:00:00 | ||
| IF() Function With AND() Criteria | 00:00:00 | ||
| IF() Function With OR() Criteria | 00:00:00 | ||
| Nesting Multiple IF() Functions | 00:00:00 | ||
| The COUNTIF() Function | 00:00:00 | ||
| Key Benefits Of Named Ranges | 00:00:00 | ||
| Section 17 - Excel's Lookup Functions | |||
| VLOOKUP() Function | 00:00:00 | ||
| The Beauty Of Excel’s IFERROR() Function | 00:00:00 | ||
| HLOOKUP() Function | 00:00:00 | ||
| INDEX() Function | 00:00:00 | ||
| MATCH() Function | 00:00:00 | ||
| INDEX() And MATCH() Combined | 00:00:00 | ||
| Two-Way Lookup With INDEX() and MATCH() | 00:00:00 | ||
| Section 18 - Text Based Functions in Excel | |||
| LEFT(), RIGHT() And MID() Function | 00:00:00 | ||
| Extracting Specific Text Using LEN() & SEARCH() | 00:00:00 | ||
| Combining Text With CONCATENATE() | 00:00:00 | ||
| Quick Tips And Other Text Based Functions | 00:00:00 | ||
| Section 19 - Auditing Formulas And Custom Views in Excel | |||
| Tracing Precedents And Dependents In Formulas | 00:00:00 | ||
| Showing Formulas | 00:00:00 | ||
| Grouping Data | 00:00:00 | ||
| 3D Referencing In Formulas | 00:00:00 | ||
| Utilizing The Watch Window In Excel | 00:00:00 | ||
| How To Freeze Panes In Excel | 00:00:00 | ||
| Section 20 - Excel’s “What If?” Tools | |||
| Excel’s Scenario Manager Tool | 00:00:00 | ||
| Goal Seek In Excel | 00:00:00 | ||
| Compare Results With Excel Data Tables | 00:00:00 | ||
| Solver Tool | 00:00:00 | ||
| Section 21 - Welcome To Excel VBA | |||
| The Power Behind Excel VBA | 00:00:00 | ||
| A Look Inside The Visual Basic Editor (VBE) | 00:00:00 | ||
| Recording A Macro | 00:00:00 | ||
| Saving And Opening A Macro-Enabled Workbook | 00:00:00 | ||
| Section 22 - The VBA Language | |||
| Modules And Procedures | 00:00:00 | ||
| Objects, Methods And Properties | 00:00:00 | ||
| Excel VBA Variables | 00:00:00 | ||
| Section 23 - Writing VBA Code | |||
| Referencing A Range | 00:00:00 | ||
| InputBox And MsgBox | 00:00:00 | ||
| Using Variables In VBA Code | 00:00:00 | ||
| If Then Else Statement | 00:00:00 | ||
| Worksheet Functions Inside VBA | 00:00:00 | ||
| Creating User Defined Functions | 00:00:00 | ||
| User Defined Functions Within VBA Scripts | 00:00:00 | ||
| Section 24 - Important VBA Tools and Logic | |||
| Find Last Row Of Data | 00:00:00 | ||
| Find Last Column Of Data | 00:00:00 | ||
| With Statement | 00:00:00 | ||
| Debugging And Error Handling | 00:00:00 | ||
| Debugging And Error Handling Continued | 00:00:00 | ||
| Section 25 - Excel VBA Loops | |||
| For Next Loop | 00:00:00 | ||
| Do Until Loop | 00:00:00 | ||
| For Each Loop | 00:00:00 | ||
| Section 26 - Triggering Macros | |||
| Assigning Macros To Shapes | 00:00:00 | ||
| Form Controls Vs ActiveX Controls | 00:00:00 | ||
| Worksheet Events | 00:00:00 | ||
| Workbook Events | 00:00:00 | ||
| Fun with VBA Events | 00:00:00 | ||
| Section 27 - Excel User Forms | |||
| Creating An Excel UserForm | 00:00:00 | ||
| Adding Controls to UserForms | 00:00:00 | ||
| How To Show A UserForm | 00:00:00 | ||
| Passing TextBox Values To Desired Cells | 00:00:00 | ||
| Passing Option Buttons To Desired Cells | 00:00:00 | ||
| UserForm ComboBoxes | 00:00:00 | ||
| Clearing Values From UserForm Controls | 00:00:00 | ||
| How To Close A UserForm | 00:00:00 | ||
| UserForms And Protected Sheets | 00:00:00 | ||
| Section 28 - Starting A Career in Excel | |||
| Creating An Excel Resume | 00:00:00 | ||
| Getting Started With Freelancing | 00:00:00 | ||
| How To Become An Excel Freelancer | 00:00:00 | ||
| Top Freelance Websites | 00:00:00 | ||
| How To Get Your First Client | 00:00:00 | ||
| Personal Branding | 00:00:00 | ||
| Networking Do’s And Don’ts | 00:00:00 | ||
| Importance Of Having A Website | 00:00:00 | ||
Related Courses
Are you interested in higher education?