Course Badgei dont have words to explain but my overall experience is going well with you guys.
Microsoft Excel
This course will fully prepare you for virtually any Excel-related career path
Created By
13 STUDENTS ENROLLED
Loading video…
Learning Outcome
- Master Excel from A-Z
- Save time and boost your productivity in Excel
- Find a value using VLOOKUP, HLOOKUP, INDEX, and MATCH
- Become proficient in math, statistics, logic, and text functions
- Get started with VBA and macros
- Learn to use VLOOKUP/HLOOKUP in formulas
- Create basic and advanced formulas
- Master Pivot Tables
- Create Charts from your data
- Learn how to become a professional data analyst
- Become an Excel expert and land your first job
Course Overview
For educational purposes or during job interviews, you must have a fundamental understanding of Microsoft Excel. Today’s world requires a solid grasp of these skills. This course teaches you everything you need to know about Microsoft Excel to succeed in the job market.
The Microsoft Excel course covers all the skills needed to become a master of this widely popular spreadsheet application. We will teach you expert data analysis skills using Microsoft Excel if you’re tired of other sophisticated data analysis tools. Using a few simple functions and formulas, you can finish complex calculations within a blink of an eye. You’ll be an expert at pivot tables and macros, which will make your professional tasks ten times easier. To sum it up, this course will help you become proficient in Microsoft Excel so that you can start your career immediately.
An expert instructor designed this “Microsoft Excel” course to provide you with the best learning experience possible. Our goal is for you to learn and apply the lessons from this course to improve yourself.
Grab the course. Enrol Now!
Course Description
This course is an excellent learning opportunity for those who are passionate about the topic and who are interested in a successful career within the relevant industry. Professionals currently working in this field who wish to brush up on their knowledge and advance their careers may also enrol in this program.
In the Microsoft Excel Course, you will find a number of engaging, in-depth modules that will provide you with comprehensive theoretical knowledge that will enable you to succeed in your career. As proof of your completion, you will receive a free e-certificate from Learndrive.
Using computers, tablets, smartphones, and other internet-enabled devices, you can access the course modules at your own pace. Invest in your professional development today and learn skills that will lead to your dream job. Become a career leader by taking this course online.
What Do You Get With The Microsoft Excel Course?
- Premium Video Materials in bite-sized format for the most accessible learning experience
- Free e-certificate after completing the course
- Flexible study time and pace
- Instructor-led Course
Course Design
Students can access the course using any internet-connected device through our online learning platform. You may study at your own pace since there are no formal deadlines or teaching schedules.
Certification
The learners who pass the course will receive a Learndrive Certificate as a badge of accomplishment. The e-certificate is free of charge. There is a small fee, however, if you want a hard copy of your certificate.
Who Is This Course For?
The course is right for you if you already work in this industry or want to make the transition. This Microsoft Excel Course is designed to enhance your expertise and improve your CV.
Requirements
Students from all backgrounds are welcome to participate in the online training. There are no requirements for participation. The only prerequisite for studying this Microsoft Excel Course is an interest in learning and a good grasp of English, mathematics, and computer skills.
Course Instructor
Juan Galvan
Juan Galvan has been an aspiring entrepreneur. Throughout his career, he has gained experience in a wide variety of areas, including Digital Marketing, E-Commerce, Web Development, and Programming. Juan believes that continuous education and improvements in skills and learning is the key to acquiring the best of a university degree without all the downsides that come with them, such as burdensome costs and inefficient methods. As a lifelong teacher, Juan is passionate about sharing his knowledge and helps enthusiastic learners enhance their skill sets.
Accreditation
This course is accredited by CPDQE. The demand for professionals to engage in Continuing Professional Development is escalating, irrespective of the industry, career stage, or job function. CPD serves as an impactful mechanism for skill enhancement, maintaining the relevance of academic credentials, and strategically advancing one’s career.
This CPDQE Certified Course will ensure that you have obtained the required CPD trainings for your professional development.
What Students say about us
The courses on the website are well designed, very clear and you can learn a lot of useful skills from them. A very
Enjoying the course at my pace, repeating what I did not understand and learning
Frequently Asked Questions
Everything you need to now about he product billing.
To purchase a course, simply select the course you want, choose your plan from the top right side, and click on the ‘Take this course’ button to initiate the checkout process. You will receive access as soon as the payment is processed.
We accept various payment methods, including credit/debit cards, PayPal, and bank transfer. If you don’t have a card or paypal, contact us for alternative payment methods.
If you’re not satisfied with our course, you can request a refund within 14 days of purchase. We follow a no-questions-asked refund policy, and you will receive a full refund.
Yes, upon successful completion of the course and exam (if applicable), you will receive a free digital certificate that can be downloaded and printed.
Yes, our courses are CPDQE accredited. CPDQE is an independent body that accredits courses and events for continuous professional development, ensuring they meet high-quality standards.
You can verify your certificate by visiting the Learndrive certificate verification page and entering your certification code. This will confirm the authenticity of your certificate.
To redeem your voucher, first visit the voucher redemption page. Enter your personal details and paste the voucher code into the designated field (do not type the code manually). After that, click the “Send” button. You will receive your login details via the email address you provided. Once you have received them, log in to our website and access your course from your dashboard.
Course Curriculum
| Course Promo | |||
| Microsoft Excel Promo Video | 00:03:00 | ||
| Section 1: Introduction | |||
| Excel from A-Z Course Intro | 00:04:00 | ||
| What is Microsoft Excel | 00:05:00 | ||
| Who is this course for | 00:03:00 | ||
| Microsoft Excel Marketplace | 00:05:00 | ||
| Excel Job Opportunities | 00:03:00 | ||
| Excel Job Types | 00:04:00 | ||
| Section 2: Getting Started with Excel | |||
| Finding and Opening Excel | 00:01:00 | ||
| Excel_s Start Screen | 00:04:00 | ||
| Explaining the Excel Interface | 00:03:00 | ||
| Excel Interface Cont | 00:02:00 | ||
| Excel Workbook vs. Excel Worksheet | 00:03:00 | ||
| Saving an Excel Doc | 00:04:00 | ||
| Customizing the Quick Access Toolbar | 00:03:00 | ||
| Customizing the Excel Ribbon | 00:03:00 | ||
| Excel Shortcut Keys | 00:02:00 | ||
| Section 3: Values, Referencing and Formulas | |||
| Creating Excel Labels | 00:03:00 | ||
| Entering Numeric Data in Excel | 00:04:00 | ||
| Formatting Date Values in Excel | 00:06:00 | ||
| Building Basic Formulas in Excel | 00:05:00 | ||
| Order of Operation | 00:07:00 | ||
| Relative vs Absolute Cell References | 00:08:00 | ||
| Care for a Feedback | 00:01:00 | ||
| Section 4: Intro to Excel Functions | |||
| Excel Functions Explained | 00:03:00 | ||
| The SUM Function | 00:08:00 | ||
| The MIN and MAX Function | 00:04:00 | ||
| The Average Function | 00:02:00 | ||
| Count Functions | 00:05:00 | ||
| Section 5: Adjusting Excel Worksheets | |||
| Moving and Copying Data | 00:07:00 | ||
| Insert and Delete Rows and Columns | 00:05:00 | ||
| Adjusting the Width and Height of Cells | 00:05:00 | ||
| Hiding and Unhiding Excel Rows and Columns | 00:05:00 | ||
| Renaming Moving and Deleting Excel Worksheets | 00:06:00 | ||
| Adding Protection to Specific Cells | 00:05:00 | ||
| Protecting the Structure of a Workbook | 00:03:00 | ||
| Adding a Workbook Password to Open File | 00:03:00 | ||
| Section 6: Visually Pleasing Cell Formatting | |||
| Formatting Fonts and Cell Background Color | 00:05:00 | ||
| Adding Cell Borders | 00:05:00 | ||
| Formatting Data Appropriately | 00:06:00 | ||
| The Magic Behind Excel_s Format Painter | 00:04:00 | ||
| Creating Styles for Formatting Efficiency | 00:06:00 | ||
| Merging Cells | 00:04:00 | ||
| The Power of Conditional Formatting | 00:07:00 | ||
| Section 7: How to insert Images and Shapes! | |||
| Grab Users Attention using Illustrations | 00:09:00 | ||
| Customizing Icons | 00:05:00 | ||
| Create Compelling Graphics with SmartArt | 00:06:00 | ||
| Section 8: Visualize Data with Charts | |||
| The Commonly Used Column Chart | 00:03:00 | ||
| Changing the Chart Design | 00:02:00 | ||
| Formatting Elements of a Chart | 00:07:00 | ||
| Modifying the Data Type and Location of a Chart | 00:07:00 | ||
| Little Slice of Pie Charts | 00:06:00 | ||
| Section 9: Excel's Printing Options | |||
| Print Preview Options | 00:05:00 | ||
| Excels Page Layout View | 00:07:00 | ||
| Printing a Specific Range of Cells | 00:03:00 | ||
| Converting Spreadsheets to PDF Files | 00:03:00 | ||
| Section 10: Benefits of Using Excel Templates | |||
| Why Create an Excel Template | 00:02:00 | ||
| How to Create an Excel Template | 00:06:00 | ||
| Section 11: Working with Excel Datasets | |||
| How to Prepare Data for Analysis | 00:04:00 | ||
| How to Sort Data in Excel | 00:03:00 | ||
| Multi Level Sorting | 00:03:00 | ||
| Custom Sorting Datasets in Excel | 00:03:00 | ||
| Applying Filters to Datasets | 00:05:00 | ||
| Creating Subtotals within a Dataset | 00:06:00 | ||
| Converting Datasets into Tables | 00:06:00 | ||
| Finding and Removing Duplicate Values | 00:08:00 | ||
| Section 12: Excel Database Functions | |||
| The SUMIF Function | 00:09:00 | ||
| The DSUM Function | 00:08:00 | ||
| The DSUM Function Cont | 00:08:00 | ||
| The SUBTOTAL Function | 00:07:00 | ||
| Section 13: Excel Data Validation | |||
| What is Excel Data Validation | 00:02:00 | ||
| Creating a Drop Down List with Data Validation | 00:08:00 | ||
| Different Types of Data Validation | 00:06:00 | ||
| Adding Custom Alerts to Data Validation | 00:07:00 | ||
| Creating a Dynamic Drop Down List | 00:04:00 | ||
| Dependent Drop Down List | 00:09:00 | ||
| Section 14: Excel PivotTables | |||
| Creating an Excel Pivot Table | 00:06:00 | ||
| Modifying Excel Pivot Tables | 00:06:00 | ||
| Grouping Filtering PivotTable Data | 00:07:00 | ||
| Drilling Down into PivotTable Data | 00:02:00 | ||
| Creating Pivot Charts and Slicers | 00:08:00 | ||
| Section 15: Excel's PowerPivot Add-In | |||
| What is PowerPivot | 00:04:00 | ||
| Activating the Excel PowerPivot AddIn | 00:02:00 | ||
| Creating Relationships between Data Tables | 00:07:00 | ||
| Using Data Models to Create PivotTables | 00:05:00 | ||
| How to Create PowerPivot KPIs | 00:09:00 | ||
| Section 16: Excel's Conditional Functions | |||
| Excels IF Function | 00:06:00 | ||
| IF AND Function | 00:06:00 | ||
| IF OR Function | 00:06:00 | ||
| Nesting Multiple IF Functions | 00:08:00 | ||
| The COUNTIF Function | 00:05:00 | ||
| Key Benefits of Using Named Ranges | 00:05:00 | ||
| Section 17: Excel's Lookup Functions | |||
| The VLOOKUP Function | 00:09:00 | ||
| The Beauty of Excels IFERROR Function | 00:04:00 | ||
| The HLOOKUP Function | 00:07:00 | ||
| The INDEX Function | 00:05:00 | ||
| The MATCH Function | 00:05:00 | ||
| INDEX and MATCH Combined | 00:06:00 | ||
| Two Way Lookup with INDEX and MATCH | 00:05:00 | ||
| Section 18: Text Based Functions in Excel | |||
| LEFT RIGHT MID Function | 00:08:00 | ||
| Extracting Specific Text using LEN and SEARCH | 00:13:00 | ||
| Combining Text with CONCATENATE | 00:07:00 | ||
| Quick Tips and Other Text Based Functions | 00:06:00 | ||
| Section 19: Auditing Formulas & Custom Views in Excel | |||
| Tracing Precedents and Dependents in Formulas | 00:05:00 | ||
| Showing Formulas | 00:02:00 | ||
| Grouping Data | 00:03:00 | ||
| 3D Referencing in Formulas | 00:05:00 | ||
| Utilizing the Watch Window in Excel | 00:03:00 | ||
| How to Freeze Panes in Excel | 00:03:00 | ||
| Section 20: Excel’s “What If?” Tools | |||
| Excels Scenario Manager Tool | 00:06:00 | ||
| Goal Seek in Excel | 00:07:00 | ||
| Compare Results with Excel Data Tables | 00:05:00 | ||
| Solver Tool | 00:11:00 | ||
| Section 21: Welcome to Excel VBA! | |||
| The Power Behind Excel VBA | 00:03:00 | ||
| A Look Inside the Visual Basic Editor | 00:04:00 | ||
| Recording a Macro | 00:10:00 | ||
| Saving and Opening a Macro Enabled Workbook | 00:03:00 | ||
| Section 22: The VBA Language | |||
| Modules and Procedures | 00:07:00 | ||
| Object Methods and Properties | 00:06:00 | ||
| Excel VBA Variables | 00:05:00 | ||
| Section 23: Writing VBA Code | |||
| Referencing a Range | 00:14:00 | ||
| InputBox and MsgBox | 00:06:00 | ||
| Using Variables in VBA Code | 00:05:00 | ||
| If Then Else Statement | 00:11:00 | ||
| Worksheet Functions inside VBA | 00:08:00 | ||
| Creating User Defined Functions | 00:10:00 | ||
| User Defined Functions within VBA Scripts | 00:07:00 | ||
| Section 24: Important VBA Tools and Logic | |||
| Find Last Row of Data | 00:06:00 | ||
| Find Last Column of Data | 00:04:00 | ||
| With Statement | 00:05:00 | ||
| Debugging and Error Handling | 00:07:00 | ||
| Debugging and Error Handling Cont | 00:07:00 | ||
| Section 25: Excel VBA Loops | |||
| For Next Loop | 00:10:00 | ||
| Do Until Loop | 00:06:00 | ||
| For Each Loop | 00:04:00 | ||
| Section 26: Triggering Macros | |||
| Assigning Macros to Shapes | 00:04:00 | ||
| Form Controls vs Active X Controls | 00:08:00 | ||
| Worksheet Events | 00:04:00 | ||
| Workbook Events | 00:03:00 | ||
| Fun with VBA Events | 00:07:00 | ||
| Section 27: Excel UserForms | |||
| Creating an Excel UserForm | 00:04:00 | ||
| Adding Controls to UserForms | 00:10:00 | ||
| How to Show an UserForm | 00:03:00 | ||
| Passing TextBox Values to Desired Cells | 00:07:00 | ||
| Passing Option Buttons Values to Desired Cells | 00:07:00 | ||
| UserForm Combo Boxes | 00:09:00 | ||
| Clearing Values from UserForm Controls | 00:04:00 | ||
| How to Close an UserForm | 00:02:00 | ||
| UserForms and Protected Sheets | 00:05:00 | ||
| Section 28: Starting a Career in Excel | |||
| Creating an Excel Resume | 00:05:00 | ||
| Getting Started with Freelancing | 00:07:00 | ||
| Top Freelance Sites | 00:06:00 | ||
| Personal Branding | 00:07:00 | ||
| Networking Do’s and Don’ts – Learn Microsoft Excel From A-Z | 00:05:00 | ||
| Importance of Website | 00:05:00 | ||
| How to Become an Excel Freelancer | 00:06:00 | ||
| Getting Your First Client | 00:08:00 | ||
| Resources | |||
| Excel Practice.xlsx [Download] | 00:15:00 | ||
| PowerPivot+Data+Tables Document.xlsx [Download] | 00:15:00 | ||
| PowerPivot+Data+Tables.xlsx [Download] | 00:15:00 | ||
| VBA Practice.xlsx [Download] | 00:15:00 | ||
| Final Quiz: Microsoft Excel | |||
| Final Quiz: Microsoft Excel | 00:10:00 | ||
| Order Your Transcript | |||
| Order Your Transcript | 00:01:00 | ||
Course Reviews
No Reviews found for this course.
