Last updated 2/2023Course Language EnglishCourse Caption English [Auto]Course Length 05:41:53 to be exact 20513 seconds!Number of Lectures 58
This course includes:
5.5 hours hours of on-demand video
Full lifetime access
Access on mobile and TV
Certificate of completion
114 additional resources
Master Excel's interface and gain a comprehensive understanding of its essential tools and features.
Develop proficiency in cell referencing and spreadsheet navigation, ensuring smooth and efficient data handling.
Learn to create powerful formulas and functions in Excel, including popular functions like VLOOKUP, XLOOKUP, and HLOOKUP.
Acquire the skills to clean, organize, merge, and join data in Excel effectively, making data management a breeze.
Discover how to create insightful charts and pivot tables that represent data in a clear and visually appealing manner.
Use pivot charts to analyze data trends and patterns, enabling data-driven decision-making.
Build compelling dashboards to present data in a clear, concise, and visually appealing way, perfect for business professionals and analysts.
Master printing and formatting techniques to ensure that your work in Excel is polished and professional.
Learn to use the search and find function to locate and edit data quickly and efficiently.
Freeze panes to make data navigation easier, allowing you to work with large datasets effortlessly.
Unlock advanced tips and tricks to enhance your productivity in Excel, enabling you to work faster and more efficiently than ever before.
Welcome to "The Complete Excel Bootcamp: From Beginner to Expert"! Whether you're a complete beginner or an experienced user, this course has everything you need to master Excel and become an expert in data management and analysis.In this course, you'll learn the essential skills you need to take your Excel skills to the next level. We cover everything from the basics of Excel and its interface to advanced techniques like using VLOOKUP, XLOOKUP, and HLOOKUP functions, and building dashboards to present data. Here's what you can expect to learn:Introduction to Excel and its interface: Get comfortable with Excel's interface, tools, and features.Cell referencing and navigation within a spreadsheet: Learn how to navigate Excel's cells, rows, and columns, making it easy to handle even the most massive datasets.Creating formulas and functions in Excel: Discover how to create powerful formulas and functions that help you perform calculations quickly and accurately.Using VLOOKUP, XLOOKUP, and HLOOKUP functions: Learn how to use Excel's essential functions to find specific values and perform lookup operations.Cleaning and organizing data in Excel: Get hands-on experience with techniques to clean, organize, and transform data.Merging and joining data in Excel: Discover how to merge and join datasets from different sources into one cohesive unit.Creating charts and pivot tables to represent data: Learn how to create professional-looking charts and pivot tables that represent data visually and concisely.Using pivot charts to analyze data: Discover how to use pivot charts to analyze data trends and patterns, making it easy to understand complex datasets.Building dashboards in Excel to present data: Get practical experience in building and designing dashboards that showcase data in a clear, visually appealing way.Printing and formatting work in Excel: Learn how to format and print your Excel work for a professional look.Using the search and find function in Excel: Discover how to quickly locate and edit data using the search and find function.Freezing panes in Excel to make data navigation easier: Learn how to freeze panes to make it easier to navigate large datasets.Advanced tips and tricks to enhance productivity in Excel: Unlock advanced techniques that can help you work faster and more efficiently in Excel.Why you should choose this course:My curriculum is carefully designed to teach you only the most essential Excel skills used in a business environment.My course is concise and can be completed in just one day, allowing you to learn Excel quickly and efficiently.I use business-related examples, data analysis, and case studies to show you how to use Advanced Excel to solve real-world problems.You'll learn various data analysis techniques using Excel, which are useful across many different industries and professions.My course provides ample practice exercises for data analysis and Excel, both basic and advanced, so you can master Excel through hands-on practice.With practical examples and projects, you'll develop your skills quickly and efficiently, becoming an Excel pro in no time. Whether you're a business professional, analyst, or student, this course is perfect for anyone who wants to become an expert in Excel.Enroll now to start your journey to becoming an Excel pro!Who this course is for:Beginners who are new to Excel and want to gain a comprehensive understanding of the software and learn essential tools and techniques to manage and analyze data.Professionals who work with data and want to improve their Excel skills to become more efficient and productive in their roles.
Course Content:
Sections are minimized for better readability, click the section title to view the course content
2 Lectures | 04:41
Introduction to the Course
01:52
Dataset: Check Resources
In the first lecture of this Excel course, you will learn the fundamental skills necessary to navigate Excel's interface and become comfortable with the software. You will become proficient in capturing data and editing it in Excel, as well as styling and formatting your spreadsheets for clear and organized data representation. You will learn how to reference cells and use basic formulas to perform calculations, as well as format and add notes or comments to your spreadsheets for easy collaboration.
By the end of this section, you will have a strong foundation in Excel basics that will prepare you for more advanced techniques and features.
What is Excel and why use it?
02:49
Dataset: Check Resources
In this lecture, we will explore the versatility and power of Excel as a tool for storing, analyzing, and reporting on large amounts of data. Although often associated with financial analysis, Excel's computational capabilities make it useful in any field for managing long and unwieldy datasets. Some of the practical applications of Excel include creating budgets, organizing lists, manipulating text, creating charts, accessing external data sources, and automating complex tasks. By the end of this lecture, you will have a clear understanding of Excel's uses and be well-equipped to harness its power to improve your productivity and efficiency in data management.
9 Lectures | 56:49
Understanding Excel's Interface
04:50
Dataset: Check Resources
In this lecture, I cover the general interface of Excel, opening Excel and Understanding workbooks and worksheets. We also cover Navigating a Worksheet.
A Note about the Course
00:30
A quick note about the course.
Introduction to the Excel Ribbon
03:19
Dataset: Check Resources
In this lecture we have a look at the Excel Interface
Introduction to Project 1
03:52
Dataset: Check Resources
In this lecture we look at our first project, Jim's fit. Resources are below.
Styling on Excel
08:15
Dataset: Check Resources
In this lecture we cover basic styling and formatting on Excel.
Cell Referencing and Introduction to Basic Formulas
14:28
Dataset: Check Resources
In this lecture we cover using Cell Referencing and an Introduction to Formulas
Formatting Cells on Excel
10:57
Dataset: Check Resources
In this lecture we cover formatting cells to different data types.
Referencing other Sheets, Hiding and Changing Tab Colours
07:35
Dataset: Check Resources
In this lecture we talk about Referencing Other Sheets, Hiding Tabs and Tab Color.
Adding Notes and Comments on Excel
03:03
Dataset: Check Resources
In this lecture we learn to use Notes and Comments
11 Lectures | 01:12:31
Tables on Excel
08:00
Dataset: Check Resources
In this lecture, we learn about Tables on Excel.
Sorting, Filtering, Slicing and Removing Duplicates
11:09
Dataset: Check Resources
In this lecture, we talk about sorting, filtering, slicing and removing duplicates.
Introduction to Project 2
00:49
Dataset: Check Resources.
In this lecture we get introduced to Project 2.
Introduction to Formulas and Functions (Working with Operations)
06:05
Dataset: Check Resources
In this lecture, we talk about an Introduction to Formulas and Functions.
Using Functions in Excel
06:19
Dataset: Check Resources
In this lecture, we use functions in Excel
Working with Inequalities
11:02
Dataset: Check Resources
In this lecture, we work with inequalities.
Using the Formula Bar and tracing precedents and dependents
06:09
Dataset: Check Resources
Using the Formula Bar and tracing precedents and dependents
Working with Dates (Using WEEKDAY and WEEKNUM)
07:31
Dataset: Check Resources
In this lecture we use formulas to apply operations to dates.
Working with Errors
06:36
Dataset: Check Resources
In this lecture we learn to work with Errors.
Using Name Manager
04:06
Dataset: Check Resources
In this lecture we will learn to use Name Manager
Using Round and an Introduction to Nested Formulas
04:45
Dataset: Check Resources
In this lecture we learn to use Round and an introduction to Nested Formulas.
13 Lectures | 01:27:26
Introduction to Project 3
01:19
Dataset: Check Resources
In this lecture we get introduced to Project 3.
Joining Cells using Ampersand and TEXTJOIN
05:55
Dataset: Check Resources
In this lecture we learn about joining cells.
Separating Text using TEXTSPLIT and Text to Columns
06:13
Dataset: Check Resources
In this lecture we learn to separate text using TEXTSPLIT and TEXT_TO_COLUMN
Using Lookup Functions (VLOOKUP)
06:18
Dataset: Check Resources
In this lecture we use lookup functions such as VLOOKUP
Using XLOOKUP
09:04
Dataset: Check Resources
In this lecture we use lookup functions such as HLOOKUP
Using HLOOKUP
04:50
Dataset: Check Resources
In this lecture we use lookup functions such as HLOOKUP
Changing Case using Formulas on Excel
03:52
Dataset: Check Resources
In this lecture we look at changing cases on Excel
Using the TRIM Function
03:19
Dataset: Check Resources
In this lecture we use TRIM functions
Extracting Text from Excel
08:29
Dataset: Check Resources
In this lecture we learn to extract text from Excel
Using Find and Replace
04:06
Dataset: Check Resources
In this lecture we use FIND and REPLACE
Using IF Statements
20:33
Dataset: Check Resources
In this lecture we use IF Statements.
Conditional Formatting
07:35
Dataset: Check Resources
In this lecture we use conditional formatting.
Data Bars, Icon Sets and Color Scales
05:53
Dataset: Check Resources
In this lecture we use Data Bars, Icon Sets and Color Scales.
11 Lectures | 01:19:11
Introduction to Charts
12:55
Dataset: Check Resources
In this lecture we get an introduction to charts.
Creating Column Charts
14:07
Dataset: Check Resources
In this lecture we use Column and Bar Charts.
Creating Bar Charts on Excel
02:08
Dataset: Check Resources
In this lecture we use Bar Charts on Excel
Creating Line Charts on Excel
05:39
Dataset: Check Resources
In this lecture we use Line Charts on Excel
Creating Histograms on Excel
02:49
Dataset: Check Resources
In this lecture we learn to use Histograms
Creating Spark Lines on Excel
08:21
Dataset: Check Resources
In this lecture we use spark lines.
Introduction to Pivot Tables
16:14
Dataset: Check Resources
In this lecture we use PIVOT tables.
Adding Percents to Pivot Tables
02:07
Dataset: Check Resources
In this lecture we use Pivot tables and look at adding percents
Filters, Slicers and Timelines in Pivot Tables
04:28
Dataset: Check Resources
In this lecture we use filters, slicers, timelines in Pivot Tables
Introduction to Pivot Charts
04:14
Dataset: Check Resources
In this lecture we use Pivot Charts.
Dashboards on Excel
06:09
Dataset: Check Resources
In this lecture we use Dashboards on Excel
12 Lectures | 41:15
Working with Dates on Excel (adding, subtracting dates)
09:32
Dataset: Check Resources
In this lecture we get some useful tips on how to working with dates
Using SUMIF on Excel
06:19
Dataset: Check Resources
In this lecture we use SUMIF on Excel
Hiding Rows and Columns on Excel
01:19
Dataset: Check Resources
In this lecture we learn to Hide Rows and Columns on Excel
Data Validation on Excel
04:18
Dataset: Check Resources
In this lecture we use Data Validation
Remove Duplicates on Table
00:58
Dataset: Check Resources
In this lecture we Remove Duplicates
Using Grouping on Excel
01:20
Dataset: Check Resources
In this lecture we use Grouping on Excel
Fill in Blanks in Excel
02:27
Dataset: Check Resources
In this lecture we learn how to fill in the blanks on Excel
Using Search and Find
04:33
Dataset: Check Resources
In this lecture we use Search and Find
Freezing Rows and Columns
02:11
Dataset: Check Resources
In this lecture we freeze rows and columns
Protecting Sheets, Cells and Workbooks
03:21
Dataset: Check Resources
In this lecture we learn to secure on Excel.
Printing on Excel
04:45
Dataset: Check Resources
In this lecture we use learn some tricks to print on Excel
Conclusion
00:12
Thanks so much for watching my course and the support.
0
(0 course ratings)
1
0/0
2
0/0
3
0/0
4
0/0
5
0/0
JOIN OUR WHATSAPP GROUP TO GET LATEST COUPON AS SOON AS UPDATED
If you like to get inspired by great web projects, you should check out Made with Javascript. If you have a project that you wish to share with the world, feel free to submit your project on Made with Javascript Club website.
Free Online Tools And Converters for your use
URL Encoder
Input a string of text or a URL and encode the entered string
FAQ: Udemy Free course Most frequent questions and answers
Does Udemy offer Free Udemy coupons?
Yes, Udemy is the largest online education platform, with the broadest selection of video-on-demand courses and qualified instructors available to meet your needs. At theprogrammingbuddy.club we curate the latest udemy coupons, their expiry, and the number of uses left of these udemy coupons.
How to get free Udemy courses?
There are two ways to get free Udemy courses:
Go to udemy.com and search for your desired course category. Then select free from the filter options.
You can also get paid courses for free if you have a coupon. You can head to theprogrammingbuddy.club, where you can get a daily udemy paid course for free.
How to get Udemy Certificates for free?
Udemy offers certification on completion of each course. In order to receive a certificate of completion from Udemy, you need to complete your course 100%. There is a simple hack, you can open a video and jump on the timeline to complete a lecture.
To download the certificate from Udemy, you need to head over to your account on a desktop browser. Udemy certificates can't be accessed on the mobile app.
Do Udemy courses expire?
No, once you enroll, you will have lifetime access to the course. You can complete the course on your schedule.
Why are the Udemy instructors giving away free Udemy Coupons?
Every instructor has worked for hours on each of their courses. As new courses get launched, the instructors have no way to get their course in front of an audience to get some feedback. So, instructors share free coupons for their courses to get feedback from the students. We attheprogrammingbuddy.club work with these instructors to get their courses available to our buddies.
Is Udemy safe to use?
Yes, payments on Udemy are safe. It is no different than paying for other services on an application or website and inputting your payment information before receiving your goods. Just be sure to keep your account secure, do not share your udemy accounts.
Can Udemy courses get you a job?
Earning a skill is more valuable than earning a job these days. Skills are your most valuable asset. They can help you qualify for jobs you want and get promoted to more advanced positions within your organization. Unfortunately, it is difficult for many people to balance taking courses with work and family obligations. We have had many students, who have taken just Udemy courses, started a job as well as started freelancing with the skills they have learned.