Course

# Excel basic to advanced by Trump Excel

1

2

3

4

5

### Teacher Trump Excel

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.

## Course content

0h22m

### Getting Started with Excel | Excel For Beginners | FREE Excel Course

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,
-- 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

### [FREE Excel Course] Lesson 2 - Data Entry, Editing, and Number Formatting

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.

0h25m

### [FREE EXCEL COURSE] Lesson 3 - Data Formatting in Excel

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 also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6

Subscribe to

0h33m

### [FREE EXCEL COURSE] Lesson 4 - Working with Cells and Ranges

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
-- 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 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

### [FREE EXCEL COURSE] Lesson 5 - Managing Worksheets in Excel

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
-- 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 also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq

0h21m

### [FREE EXCEL COURSE] Lesson 6 - Excel Tables Overview

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 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

### [FREE EXCEL COURSE] Lesson 7 - Auto-fill, Custom Lists, and Flash Fill

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.

0h26m

### [FREE EXCEL COURSE] Lesson 8 - Number Formatting in Excel

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 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

### [FREE Excel Course] Lesson 9 - Excel Formula Basics

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 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

### [FREE Excel Course] Lesson 10 - Logical Formulas in Excel

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 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

### [FREE Excel Course] Lesson 11 - Math Formulas in Excel

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 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

### [FREE Excel Course] Lesson 12 - Lookup and Reference Formulas in Excel

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 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

### Stats Formulas in Excel - Explained with Examples

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 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

### [FREE Excel Course] Lesson 14 - Text Formulas in Excel

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 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

### [FREE EXCEL COURSE] Lesson 15 - Date & Time Formulas in Excel

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 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

### 10 Advanced Excel Formula Examples | FREE Excel Course

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

### Creating Named Ranges in Excel | Dynamic Named Range in Excel | FREE Excel Course

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

### Data Validation in Excel | Drop-down lists | FREE Excel Course

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

### Data Sorting & Filtering in Excel (Basic + Advanced) | FREE Excel Course

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

### Excel Conditional Formatting (Overview + Advanced Examples)

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.