Lunes Online Learning
Add to basket or enquire
- 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 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.
- How to land your first job as an Excel Expert.
- 7: Finding and Opening Excel 01:04
- 8: Excel's Start Screen 03:15
- 9: Explaining the Excel Interface 02:43
- 10: Excel Interface Continued 01:26
- 11: Excel Workbook vs. Excel Worksheet 02:13
- 12: Customizing the Excel Ribbon 03:04
- 13: Customizing the Excel Quick Access Toolbar 03:33
- 14: Customizing the Quick Access Toolbar 02:15
- 15: Excel Shortcut Keys 01:43
- 16: Creating Excel Labels 02:32
- 17: Entering Numeric Data in Excel 03:25
- 18: Formatting Date Values in Excel 05:19
- 19: Building Basic Formulas in Excel 04:44
- 20: Order of Operation 06:28
- 21: Relative vs Absolute Cell References 07:23
- 22: Excel Functions Explained 02:35
- 23: The SUM Function 07:31
- 24: The MIN and MAX Function 03:44
- 25: The AVERAGE Function 02:01
- 26: COUNT Functions 04:57
- 27: Moving and Copying Data 06:45
- 28: Insert and Delete Rows and Columns 05:04
- 29: Adjusting the Width and Height of Cells 04:34
- 30: Hiding and Unhiding Excel Rows and Columns 04:28
- 31: Renaming Moving and Deleting Excel Worksheets 05:27
- 32: Adding Protection to Specific Cells 04:24
- 33: Protecting the Structure of a Workbook 02:11
- 34: Adding a Workbook Password to Open File 02:10
- 35: Formatting Fonts and Cell Background Color 04:55
- 36: Adding Cell Borders 04:47
- 37: Formatting Data Appropriately 05:21
- 38: The Magic Behind Excel's Format Painter 03:30
- 39: Creating Styles for Formatting Efficiency 05:56
- 40: Merging Cells for a Cleaner Look 03:27
- 41: The Power of Conditional Formatting 06:09
- 42: Grab User's Attention Using Illustrations 08:39
- 43: Customizing Icons 04:41
- 44: Create Compelling Graphics with SmartArt 05:36
- 45: The Commonly Used Column Chart 02:46
- 46: Changing the Chart Design 01:58
- 47: Formatting Elements of a Chart 06:24
- 48: Modifying the Data Type and Location of a Chart 06:06
- 49: Little Slice of Pie Charts 05:12
- 50: Print Preview Options 04:26
- 51: Excel's Page Layout View 06:36
- 52: Printing a Specific Range of Cells 02:38
- 53: Converting Spreadsheets to PDF Files 02:28
- 54: Why Create an Excel Template 01:23
- 55: How to Create an Excel Template 05:22
- 56: How to Prepare Data for Analysis 04:01
- 57: How to Sort Data in Excel 02:38
- 58: Multi-Level Sorting 02:34
- 59: Custom Sorting Datasets in Excel 02:27
- 60: Applying Filters to Datasets 04:44
- 61: Creating Subtotals within a Dataset 05:39
- 62: Converting Datasets into Tables 05:55
- 63: Finding and Removing Duplicate Values 07:29
- 64: The SUMIF Function 08:42
- 65: The DSUM Function 07:47
- 66: The DSUM Function Continued 07:06
- 67: The SUBTOTAL Function 06:29
- 68: What is Excel Data Validation? 01:56
- 69: Creating a Drop Down List with Data Validation 07:09
- 70: Different Types of Data Validation 05:39
- 71: Adding Custom Alerts to Data Validation 06:53
- 72: Creating a Dynamic Drop Down List 03:09
- 73: Complex Validation: Dependent Drop Down List! 08:39
- 74: Creating an Excel Pivot Table 05:31
- 75: Modifying Excel Pivot Tables 05:39
- 76: Grouping & Filtering PivotTable Data 06:30
- 77: Drilling Down into PivotTable Data 02:00
- 78: Creating PivotCharts and Utilising Slicers 08:00
- 79: What is PowerPivot? 03:46
- 80: Activating the Excel PowerPivot Add-In 01:34
- 81: Creating Relationships between Data Tables 06:22
- 82: Using Data Models to Create PivotTables 04:31
- 83: How to Create PowerPivot KPIs 08:26
- 84: Excel's IF Function 05:17
- 85: IF() Function with AND() Criteria 05:23
- 86: IF() Function with OR() Criteria 05:14
- 87: Nesting Multiple IF() Functions 07:24
- 88: The COUNTIF() Function 04:06
- 89: Key Benefits of Using Named Ranges 04:11
- 90: VLOOKUP() Function 09:00
- 91: The Beauty of Excel’s IFERROR() Function 03:56
- 92: HLOOKUP() Function 06:21
- 93: INDEX() Function 04:43
- 94: MATCH() Function 04:56
- 95: INDEX() and MATCH() Combined 05:08
- 96: Two-Way Lookup with INDEX() and MATCH() 04:10
- 97: LEFT(), RIGHT() and MID() Function 07:08
- 98: Extracting Specific Text using LEN() & SEARCH() 12:44
- 99: Combining Text with CONCATENATE() 06:05
- 100: Quick Tips and Other Text Based Functions 05:49
- 101: Tracing Precedents and Dependents in Formulas 04:28
- 102: Showing Formulas 01:53
- 103: Grouping Data 02:42
- 104: 3D Referencing in Formulas 05:04
- 105: Utilizing the Watch Window in Excel 02:44
- 106: How to Freeze Panes in Excel 02:56
- 107: Excel's Scenario Manager Tool 05:55
- 108: Goal Seek in Excel 06:15
- 109: Compare Results with Excel Data Tables 04:23
- 110: Solver Tool 10:59
- 111: The Power Behind Excel VBA 02:35
- 112: A Look Inside the Visual Basic Editor (VBE) 03:57
- 113: Recording a Macro 09:11
- 114: Saving and Opening a Macro Enabled Workbook 02:14
- 115: Modules and Procedures 06:34
- 116: Object, Methods and Properties 05:59
- 117: Excel VBA Variables 04:39
- 118: Referencing a Range 13:30
- 119: InputBox and MsgBox 05:33
- 120: Using Variables in VBA Code 04:32
- 121: If Then Else Statement 10:23
- 122: Worksheet Functions inside VBA 07:32
- 123: Creating User Defined Functions 09:19
- 124: User Defined Functions within VBA Scripts 06:09
- 125: Find Last Row of Data 05:46
- 126: Find Last Column of Data 03:12
- 127: With Statement 04:51
- 128: Debugging and Error Handling 06:36
- 129: Debugging and Error Handling Continued 06:45
- 130: For Next Loop 09:12
- 131: Do Until Loop 06:03
- 132: For Each Loop 03:36
- 133: Assigning Macros to Shapes 03:33
- 134: Form Controls vs Active X Controls 07:50
- 135: Worksheet Events 03:44
- 136: Workbook Events 02:54
- 137: Fun with VBA Events 06:55
- 138: Creating an Excel UserForm 03:15
- 139: Adding Controls to UserForms 10:00
- 140: How to Show an UserForm 03:01
- 141: Passing TextBox Values to Desired Cells 06:37
- 142: Passing Option Buttons Values to Desired Cells 06:50
- 143: UserForm ComboBoxes 08:08
- 144: Clearing Values from UserForm Controls 03:06
- 145: How to Close an UserForm 01:34
- 146: UserForms and Protected Sheets 04:40
- 147: Creating an Excel Resume 04:51
- 148: Getting Started with Freelancing 06:16
- 149: How to Become an Excel Freelancer 05:12
- 150: Top Freelance Sites 05:12
- 151: Getting Your First Client 07:45
- 152: Personal Branding 06:47
- 153: Networking Do’s and Don’ts 04:22
- 154: 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’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
2: INTERMEDIATE EXCEL
This section gives you a full introduction to the Intermediate Excel functions with hands-on step by step training.
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.
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
Importance of Having a Website
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.
Who is this course for?
- Students who want to learn and master microsoft excel
basic computer skills
Questions and answers
No questions or answers found containing ''.
I accessed the resources from the google link, but could not find and locate the Excel Practice copy datasets to download, so where can you find it?
Hi Prince, all the resources have no been added to the lesson for download, thanks.This was helpful. Thank you for your feedback.
Can you download the Excell program for free.
Hi Khalid, you'll have lifetime access to the on-demand course through the platform. You will not be able to download, thanks.This was helpful. Thank you for your feedback.
What version of Excel do you need for the course?
Any version but best with the latest version.This was helpful. Thank you for your feedback.