Search
To account for the video time in the certificate, wait for the video to shut down automatically. The next video of the course will be triggered next.
Quality content and selected for your learning.
Download your digital certificate of course completion after watching all course videos.
Many of the courses available have exercises to help with learning.
This course is free today and always will be, from start to finish you will pay nothing.
Teacher
Here you'll find hundreds of free Excel tips & tutorials and is a great place to learn Excel. These Excel tips videos will help you skyrocket your productivity and make you a rockstar at work.
0h22m
0h21m
0h25m
0h33m
0h16m
0h21m
0h13m
0h26m
0h26m
0h23m
0h33m
0h46m
0h41m
0h32m
0h40m
0h45m
0h22m
0h31m
0h16m
0h25m
Watch the 1st video of the course
0h22m
This video covers the basics of Excel and is meant for people who beginners in Excel and are just starting with Excel.
This is the first video of this FREE Online Excel training and covers all the basics of Excel and how to get started with it.
Its starts with the different parts of Excel and how to navigate through it. It also forms the foundation of all the other videos in this Free Excel course.
The following topics are covered in this video on getting started with Excel for beginners:
-- Structure of the Excel working area,
-- How to navigate in Excel,
-- Ribbons and tabs,
-- Quick Access Toolbar (QAT)
-- Dialog Box & Task Panes,
-- Customizing ribbons and QAT,
-- What is an active cell
-- How to use ALT shortcuts
This video is a part of my Free Excel course where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can also get this training and more resources here: https://trumpexcel.com/learn-excel/
Subscribe to this YouTube chann
0h21m
This video covers the basics of Data Entry, editing as well as number formatting.
Once you know are comfortable with the layout of Excel, the next step is to learn how to enter and edit data in Excel.
You can enter three types of data in Excel - numeric, text, and formulas.
To enter data in any cell, just select the cell and start typing. Once done, press the enter key to move to the cell below. In case you are entering dates, enter it in a format that Excel recognizes as a date (such as 01-01-2020 or 01 Jan 2020 or 01/01/2020).
This video will show you how to enter data in Excel and edit already added data (such as deleting data, modifying existing data and replacing data).
Apart from this, it also covers the auto-fill in Excel as well as number formatting.
This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files
0h25m
This video covers the basics of data formatting in Excel.
You can format data in Excel to make it look better and to highlight some data points.
For example, if you have data-set and you want to highlight the negative numbers, you can simply highlight it in red color to it.
Here are some of the common formatting I use to make my data look better and more readable
-- Applying borders to all cells
-- Making headers bold
-- Giving a background cell color to headers.
-- Center align the headers
You can find these options in the 'Home' tab in the Font category.
This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: https://trumpexcel.com/learn-excel/
You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6
Subscribe to
0h33m
In this video, you'll learn how to work with cells and ranges in Excel.
Since a worksheet in Excel is made up for cells, if you want to become proficient in Excel, you need to know how to best work with cells and ranges.
And this video will teach you exactly that.
It covers the following topics:
-- Cell address nomenclature
-- Selecting cell/ranges in Excel
-- Copying and moving cells/ranges in Excel
-- Using paste special
-- Selecting special cells
-- Using find and replace to select cells
-- Adding comments and
-- Using quick analysis
This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: https://trumpexcel.com/learn-excel/
You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6
Subscribe to this YouTube channel t
0h16m
In this video, you'll learn how to manage worksheets in Excel.
This video will teach you a lot about working with worksheets.
For example, if you're working with large datasets, you can use the functionalities such as splitting the worksheet or freeze panes to be more efficient.
It covers the following topics:
-- Navigating through worksheets in Excel
-- Changing worksheet name and color
-- Adding/deleting worksheets
-- Hiding/Un-hiding worksheets
-- Moving/copying worksheets
-- Comparing worksheets side by side
-- Splitting worksheet into panes
-- Freeze panes
-- Saving and opening workbooks
This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: https://trumpexcel.com/learn-excel/
You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq
0h21m
In this video, you'll learn how to use Excel tables.
Excel tables are amazing, especially if you plan to work with a lot of data/dashboards/models.
And now that new tools (such as Power Query and Power Pivot) are available, it has made Excel tables even more powerful.
In this video, I cover the following topics:
-- Creating an Excel Table
-- Excel Table features
-- Structured references
-- Table slicers
-- Note that table slicers became available only from Excel 2013 -version onward.
This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: https://trumpexcel.com/learn-excel/
You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials video
0h13m
In this video of this free Excel course, you will learn about tools that can help you when working with data in Excel.
In this lesson, I cover the following topics:
-- AUTOFILL: This allows you to quickly fill data in contiguous cells. For example, you can have 'Jan' and 'Feb' in two adjacent cells and then you can use Autofill to get the other month names
-- CUSTOM LISTS: Custom lists allows you to create your own lists that you can use in Autofill. For example, if you have 20 names, you can create a custom list and then use Autofill to get all the names by just dragging the mouse
-- FLASH FILL: Flash fill is a new feature in Excel 2013 and allows you to identify a pattern in data and perform data slice and dice based on the pattern.
This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: https://trumpexcel.
0h26m
In this video of this Excel course, you will learn all about number formatting in Excel.
This video covers the following topics:
-- How to access number formatting options
-- Using number formatting options using a dialog box
-- Using custom number formatting
Remember that formatting a number in Excel only changes how it's displayed, but the underlying value remains the same.
This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: https://trumpexcel.com/learn-excel/
You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos - https://www.youtube.com/c/trumpexcel
This YouTube channel is managed by Sumit Bansal (who also runs the Trum
0h26m
In this video of this Free Excel Training, you will learn how to get started with Excel formulas.
This video covers the following topics:
-- Constituents of Excel formula
-- Operators in formulas
-- Entering a formula in Excel
-- Editing a formula
-- Absolute/relative cell references
-- Copying/pasting formulas in Excel, and
-- Formula auditing and debugging.
This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: https://trumpexcel.com/learn-excel/
You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos - https://www.youtube.com/c/trumpexcel
This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website).
0h23m
In this video of this Free Online Excel Training, you will learn about the following logical formulas:
-- AND function
-- OR function
-- NOT function
-- TRUE function
-- FALSE function
-- IF function
-- IFERROR function
-- IS function
This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: https://trumpexcel.com/learn-excel/
You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos - https://www.youtube.com/c/trumpexcel
This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Exce
0h33m
In this video of this Free Excel Training, you will learn about the MATH formulas
-- INT function
-- MOD function
-- RAND function
-- RANDBETWEEN function
- ROUND function
-- SUM function
-- SUMIF function
-- SUMIFS function
-- SUMPRODUCT function
This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: https://trumpexcel.com/learn-excel/
You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos - https://www.youtube.com/c/trumpexcel
This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics
0h46m
If you want to get good with Excel, Lookup and Reference formulas are something you must learn about. You don't need to know each and every formula, but a basic understanding of these will help you a lot.
In this video, you will learn about the following LOOKUP and REFERENCE formulas:
-- VLOOKUP function
-- HLOOKUP function
-- INDEX function
-- MATCH function
-- OFFSET function
-- INDIRECT function
-- ROW function
-- ROWS function
-- COLUMN function
-- COLUMNS function
This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: https://trumpexcel.com/learn-excel/
You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos - https://www.yo
0h41m
In this video of this Free Excel Training, you will learn about the following STAT formulas:
-- AVERAGE function
-- AVERAGEIF function
-- AVERAGEIFS function
-- COUNT function
-- COUNTA function
-- COUNTBLANK function
-- COUNTIF function
-- COUNTIFS function
-- LARGE function
-- SMALL function
-- RANK function
-- MAX function
-- MIN function
This video is a part of my Free Excel course where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: https://trumpexcel.com/learn-excel/
You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos - https://www.youtube.com/c/trumpexcel
This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for pe
0h32m
In this video of this Free Excel Training, you will learn about the following TEXT formulas:
-- LEFT function
-- RIGHT function
-- MID function
-- LEN function
-- LOWER function
-- PROPER function
-- UPPER function
-- FIND function
-- -REPLACE function
-- SUBSTITUTE function
-- TEXT function
This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: https://trumpexcel.com/learn-excel/
You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos - https://www.youtube.com/c/trumpexcel
This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a
0h40m
In this video of this online Excel Training, you will learn about the following DATE and TIME formulas:
-- DAY function
-- HOUR function
-- MINUTE function
-- DATE function
-- DATEVALUE function
-- TODAY function
-- NOW function
-- WEEKDAY function
-- NETWROKDAYS function
-- NETWORKDAYS.INTL function
-- WORKDAY function
-- WORKDAY.INTL function
This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: https://trumpexcel.com/learn-excel/
You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos - https://www.youtube.com/c/trumpexcel
This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is
0h45m
In this video, I will show you some advanced Excel formula examples that involve using one or more than functions.
There a lot of awesome stuff you can do with a combination of these advanced formulas in Excel.
While a lot of things can be managed with in-built Excel functions, sometimes you need to use a combination of these formulas to get the work done.
This video covers 10 such examples where you can use advanced excel formulas (including a combination of in-built Excel functions) to achieve the desired result.
I cover the following advanced formula examples this video:
-- Compare Lists, Get Unique List
-- Get the Closest Match
-- Get Last Value in the List
-- Find the Last Occurrence of an Item in a List
-- 2 Way and 3 Way Lookup using Index/Match
-- Count the Number of Words
-- Extract Username from Email Id
-- Find the First Monday of the Month
-- Extract Data using Drop Down List
Again, the combination of formulas you need to use will depend on what you want to achieve,
0h22m
In this video of this Free online Excel Training, I will cover all that you need to know about Named Ranges in Excel.
Named Range - as the name suggests - is a range that has been named.
This can be extremely useful as it allows you to use this defined name instead of the range. For example, instead of using A1:C10, you could instead use the name SaleData in the formula.
This video will cover a brief introduction of the named range and then show you how to create one in Excel. It also covers some advanced concepts such as creating a dynamic named range - something that automatically updates in case your data changes.
A very popular use of the dynamic named range is to create dependent drop-down lists (which is covered in detail in this video). You can use functions such as INDEX or OFFSET to create dynamic named ranges.
This video also covers some important named range keyboard shortcuts that can help you save time.
It covers the following topics:
-- Creating Named Ranges
-- Ma
0h31m
In this video, I will cover all you need to know about data validation and drop-down lists.
Data validation allows you to make sure any data that is entered in a cell meets specified criteria (i.e, it's first validated and then allowed).
For example, if you only want to make a cell accept date values, you can set that in data validation. Or if you only want to accept numbers up to 10 digits, you can specify that in Data Validation.
Drop Down Lists are a part of data validation, as it gives the user an option to select from a pre-populated list. This can be really useful when you have a workbook where you want people to do data entry or when you're creating an Excel dashboard.
The video covers all the basic data validation topics and then also covers some advanced data validation topic - such as dependent drop-down lists, input messages, dynamic drop-down lists. etc.
It covers the following topics:
-- Data Validation Criteria
-- Input Message
-- Customizing Error Messages
-- Circle
0h16m
This video covers all the basic and advanced concepts about data sorting and data filtering in Excel.
It starts with the absolute basics and covers advanced examples.
It covers the following topics:
-- Data Sorting (by name, text, color, icon and custom list)
-- Multi-Levels of Sorting
-- Data Filter (by text, number, date, and color)
-- Advanced Filter in Excel
-- Filtering and Sorting in Excel Data Tables
Excel has a lot of sorting options such as sorting from left to right, sorting based on color and icon and doing multi-level sorting. All these sorting options can be accessed from the single sorting dialog box.
Similarly, you have a lot of filtering options - such as filter based on numbers, text, dates and even colors.
Excel has many data analysis functionalities and a good knowledge of filtering and sorting data in Excel will help you analyze a huge amount of data easily.
This video is a part of my Free Online Excel Training where I show you how to use Excel from the bas
0h25m
In this video, you will learn all about conditional formatting in Excel.
The video covers the following topics:
-- Introduction to Conditional Formatting
-- Using Formula in Conditional Formatting
-- Advanced Examples (Highlight Every Nth Row, Creating Dynamic Search)
Conditional formatting is a great feature in Excel that allows you to highlight data points based on the specified conditions. It's loaded with features and you can use it to apply a background color to a cell based on the value in it.
You can also change a lot of formatting (such as font type, font size, border, etc.) with conditional formatting.
Apart from it, conditional formatting has a rich set of icons that you can use to make your data more visual. For example, you can use it to apply tick mark and cross mark or traffic lights icons based on the cell value.
One of the most powerful aspects of conditional formatting is that you can use a custom formula to check cell value and apply formatting to it accordingly.
This site and the application have been developed with the goal of helping people find
free courses more easily, because there are many good and free content on youtube,
but many people are not aware of this.
[email protected]
MEDEIROS TECNOLOGIA LTDA - CNPJ 24.471.978/0001-08
Access in other languages:
Night mode
Course comments