Here you will find a 26 Lesson Free Excel Course meant for beginners as well as intermediate users. The course covers all the important concepts in using Microsoft Excel and then also goes into some advanced concepts. You can also download all the example files and follow along.
This course is created by Sumit Bansal, who has more than 15 years of experience in teaching Excel.
Aulas do Curso
(26 vídeos)
0 de 26 aulas concluídas
0%
Progresso salvo somente neste navegador.
0
Getting Started with Excel | Excel For Beginners | FREE Excel Course
This video covers the basics of Excel and is meant for people who are beginners in Excel and are just starting with Exce…
1
[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 th…
2
[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 hi…
3
[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 of cells,…
4
[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 works…
5
[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 lo…
6
[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.
…
7
[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.
? Download File - https://trum…
8
[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.
? Download File - htt…
9
[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
…
10
[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
-- RA…
11
[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 …
12
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
-- AVE…
13
[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 …
14
[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…
15
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.
Ther…
16
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.
N…
17
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.
? Download File - https://t…
18
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.
? Download File …
19
Excel Conditional Formatting (Overview + Advanced Examples)
In this video, you will learn all about conditional formatting in Excel.
? Download File - https://trumpexcel.com/cours…
20
Introduction to Excel Charting | Excel Charts for Beginners
In this video of this Free Excel course, you will learn about Excel charting and how to make useful charts quickly.
? …
21
10 Advanced Excel Charts and Graphs (Creating from Scratch) | FREE Excel Course
In this video of this Free Online Excel training, I will show you how to use some tricks to create advanced charts and g…
22
Creating Dynamic Charts in Excel (Using Drop-down List and Scroll Bar) | FREE Excel Course
In this video of this Free Excel training, I will show you how to create dynamic charts in Excel.
? Download File - htt…
23
Excel Pivot Table (Intro, Formatting, Grouping, Slicers, Calculated Fields) | FREE Excel Course
In this video of this Free Excel training, I will show you how to create and use Pivot Tables in Excel.
? Download File…
24
Protecting Worksheets / Workbooks in Excel | Lock Worksheets in Excel | FREE Excel Course
In this video of this Free training, I will show you how you can lock cells or protect worksheets and workbooks in Excel…
25
Introduction to Excel Macros (For Excel VBA Beginners) | FREE Excel Course
In this video, I will give you a quick introduction to Excel macros and the Excel VB Editor.
? Download File - https://…
