About this course
We get it, you're busy! You don't have time or patience to sit through hours of long winded, boring Excel lectures. This course is for you! You get through comprehensive material quickly that's to-the-point and presented by an expert in an approachable, lighthearted manner.
You will learn how
to write formulas and use functions. It isn't complicated or scary, and with
this course’s friendly, understandable and approachable style, you can quickly
become an Excel expert. You will learn functions useful in different fields, industries,
careers and tasks, and will learn efficient, time-saving techniques. You get
videos with new and completed class files and a PDF reference guide.
The material in this course covers older versions of Excel through the latest edition of 365. Most functions and features work on the Mac as well as Windows. A few feature works only in Windows and we make sure you know which those are.
We start with writing simple formulas and functions, then progress to Excel's commonly used functions, like adding, taking averages and finding the highest and lowest numbers in a range. You'll learn how to use functions that make decisions, where the result can be two or more possibilities. Some of these functions are mashups of other functions you already know.
Do you need to work with statistics? You'll find several functions in that chapter are just for you. Math or finance? We have those, too. And who knew Excel worked great for manipulating text? We cover functions and features that will make your life easier.
We also cover Excel's data handling features like sorting and filtering tables, lookups, we have a chapter on data analysis that includes Pivot Tables, and how to manipulate data. You even get a chapter on how to create macros an even how to embed Python programs on a worksheet.
FAQ
Frequently Asked Questions
Who is this course designed for?
This course is designed for beginners and intermediate users who want to improve their Excel skills quickly. Whether you’re a student, professional, or entrepreneur, this crash course will help you grasp essential Excel functions and techniques quickly.
What will I learn in this course?
By enrolling in this course, you’ll learn fundamental Excel functions and techniques, including:
- Navigating the Excel interface efficiently
- Creating and formatting spreadsheets
- Performing basic mathematical operations
- Using essential functions like SUM, AVERAGE, and IF
- Sorting and filtering data
- Creating and modifying charts
- Working with Excel's database features
- Performing detailed data analysis
- Using brand new features and functions
- Automating Excel
- Using new AI tools
How long is the course, and how is it structured?
The full course runs a little over 9 hours and it's broken up into standalone bite-size parts, so you can learn Excel quickly. It’s divided into concise modules, each focusing on specific topics, so you can learn at your own pace and come and go as you need.
Is the course hands-on?
Yes, the course includes practical demonstrations and exercises to reinforce your learning. You’ll have the opportunity to follow along with the instructor and practice the techniques taught in each module using Excel on your own computer.
Can I access the course on mobile devices?
Yes, the course is accessible on both desktop and mobile devices.
Is there a certificate of completion?
Yes, upon completing the course, you’ll receive a certificate of completion, which you can showcase on your resume or LinkedIn profile to demonstrate your newfound Excel skills.
What if I have questions or need further assistance?
If you have any questions or need further assistance while taking the course, you can utilize the Q&A area.
Can I preview the course content before enrolling?
You can preview select lectures from the course before purchasing.
Comments (0)
Welcome to the Course!
2 Parts
- 0:01 Hr
Introduction
Thank you for taking this Excel course! We will start with writing simple formulas, learn how to use functions, and what absolute references are all about. We will move on to common functions like averages and other basic statistics, working with dates, and formulas that span worksheets.
As the course progresses, we will see more involved features like managing lists and database features like many ways of sorting and filtering. Of course we will learn how to create Pivot Tables and use lookup functions and a lot more. But don't worry -- everything is direct and to the point, so you won't be wasting time. If there are topics you don't need, you can skip over them and come back to them later if you want.
As the course progresses, we will see more involved features like managing lists and database features like many ways of sorting and filtering. Of course we will learn how to create Pivot Tables and use lookup functions and a lot more. But don't worry -- everything is direct and to the point, so you won't be wasting time. If there are topics you don't need, you can skip over them and come back to them later if you want.
54.23 MB
Getting the data files for this course
Download and unzip.
1 Min
Attachments:
Writing Simple Formulas
6 Parts
Introduction
What this section is about.
8.97 MB
How do you write a formula?
If it’s been a while since you’ve used Excel or if you just learned the fundamentals, this lesson gives you a short review of the basics.
7.05 MB
How to do basic adding and subtracting
Add and subtract numbers on a simple worksheet. Learn how to save time with the AutoFill feature.
99.31 MB
Learn how functions work
Excel has over 400 built-in functions. This lesson shows you the starting point for how they all work.
65.31 MB
Why you sometimes need absolute references
Usually, you want Excel to rewrite your formulas when you copy and paste and move data around. Learn how to prevent that from happening when the need arises.
124.57 MB
Chapter quiz: Writing simple formulas
3 Questions
Min
Passed grade: 2/3
Attempts: 0/
Commonly used functions
8 Parts
Introduction to common Excel functions
These are Excel's basic, core functions. You should know these.
17.89 MB
Define range names
It's often a good idea to assign friendly names to ranges of data. This makes it easier to write and modify formulas and to select large ranges of cells.
133.37 MB
How to calculate averages
Calculating averages manually can lead to incorrect results. Learn how to use a function that gets it right.
59.18 MB
How to find the highest, lowest and quantity of values
In a range of cells, find the highest and lowest numbers, and count how many there are.
96.83 MB
Computer dating: functions to insert and calculate dates
Learn the functions and formulas to calculate and manipulate dates and time.
121.66 MB
Finding date differences with the Datedif function
Undocumented unofficial function that finds the difference between two dates.
63.39 MB
Write formulas that span multiple worksheets and workbooks
We'll show you how to write formulas that can span multiple worksheets and even multiple workbooks.
114.37 MB
Chapter quiz: Commonly-Used Functions
3 Questions
Min
Passed grade: 2/3
Attempts: 0/
Functions that make decisions
6 Parts
Introduction to decision-making functions
These functions are not linear. The values they return depend on conditions elsewhere.
11.18 MB
IF function: value that depends on a condition
Use the IF function when you want the value of one cell to depend on the value of another cell.
110.46 MB
SUMIF and AVERAGEIF: sums and averages that depend on a condition
Combine the SUM and AVERAGE functions with the decision making ability of the IF function.
76.1 MB
IFS and SWITCH to cure nested IF statements
Evaluate several criteria at once without complicated formula nesting.
113.67 MB
MAXIFS and MINIFS find highest and lowest with multiple criteria
Find the highest or lowest number in a range based on a value that you specify.
70.46 MB
Chapter quiz: Functions that Make Decisions
3 Questions
Min
Passed grade: 2/3
Attempts: 0/
Using Math, Statistical, Financial and Text Functions
8 Parts
Introduction to math, statistical, financial and text functions
You will learn how to use some common functions that are helpful in different fields or professions.
7.52 MB
Adding and multiplying with Sumproduct
Like the name sounds, Sumproduct will add and multiply in one step. This can reduce the number of columns in a large worksheet.
42.46 MB
Find square roots, exponents and logarithms
Use functions that calculate exponents, square roots, common, natural and any-base logarithms.
83.77 MB
Functions for correlation, standard deviation, median and nth-largest
Learn how to calculate four common statistical functions.
153.47 MB
Calculate the monthly payment on a loan
Plug in the amount you're borrowing, the interest rate and payback period to find out how much the payments will be.
138.94 MB
Use Net Present Value to measure the quality of an investment
Is an investment worth the money? Use a net present value calculation to help you decide.
31.2 MB
Use a function to customize the display of error messages on a sheet
Use a function to make the worksheet display helpful messages instead of errors.
91.93 MB
Chapter quiz: Using math, statistical and financial functions
3 Questions
Min
Passed grade: 2/3
Attempts: 0/
Using Excel's database features
8 Parts
Introduction to Excel database features
Excel has a lot of powerful features that let you use it like a database.
11.09 MB
Using tables to sort and filter data
Not all worksheets are tables. Tables are objects you create that have data handling features.
297.88 MB
Running a multiple level sort
You can sort one category inside another, as many levels as you want.
95.11 MB
Setting up an advanced filter
Have filtered data extracted to another location.
205.96 MB
Filtering with the Filter function
Use the Filter function to filter data dynamically.
111.69 MB
Custom sorting using the Sort and Sortby functions
Sort data by any field using the Sort function. Sort by a non-displaying field using the Sortby function.
82.25 MB
Using the Xlookup function to query a data sheet
Xlookup lets you query a data set like it's a database. This function replaces the Vlookup and Hlookup functions in older versions of Excel.
113.01 MB
Chapter quiz: Using Excel's Database Features
3 Questions
Min
Passed grade: 2/3
Attempts: 0/
Conducting data analyses
8 Parts
Introduction to Excel data analysis
You will learn methods of gaining insight into data, comparing data, and examining how data might be different.
-
What-if analysis
Look at multiple possibilities of formula results.
-
Creating automatic subtotals
Let Excel create subtotals based on categories you choose.
-
Finding unique values with the Unique function
Create a list of unique values in a dataset.
-
Auditing worksheets
See where the results are that data feed into and which data contribute to results.
-
Creating and modifying Pivot Tables
Analyze and summarize large amounts of transactional data.
-
Creating Pivot Tables from multiple tables
Create a Pivot Table that uses several tables as the source data.
-
Chapter quiz: Conducting Data Analysis
3 Questions
Min
Passed grade: 2/3
Attempts: 0/
Manipulating Data
13 Parts
Introduction to data manipulation
Excel has many ways of identifying, adding, removing and modifying content. In this chapter, we look at several powerful techniques.
-
Importing & exporting data
Learn techniques of moving data in and out of Excel.
-
Connecting to live data on the web
Connect to data tables on websites that can update worksheets automatically.
125.65 MB
Removing duplicate data
How to remove duplicate data from a worksheet.
78.64 MB
Changing data with the Substitute and Replace functions
Make changes to data based on content or character position.
130.21 MB
Swap rows with columns using the Transposing features
Rotate columns into rows and rows into columns.
109.12 MB
Combining (concatenating) text from different cells
You can use formulas to manipulate text, as well as numbers. In this lesson, you'll combine a column of first names and a column of last names into one column of full names.
147.25 MB
Creating comma separated values with the Textjoin function
Create comma separated values (CSV) inside Excel, rather than having to export to a file.
123.19 MB
Use the Left, Mid and Find functions to extract text
Use some of Excel's powerful functions for manipulating text… and learn how to cheat!
221.24 MB
Splitting text apart with the Textsplit, Textbefore and Textafter functions
These functions make it easier to separate text. They replace long, complicated formulas.
143.16 MB
Keeping and dropping data with the Take and Drop functions
When you have a lot of data and want to keep most of it but just eliminate some, or keep just some and eliminate the rest, these functions do it simply. They replace old, complicated formulas.
114.14 MB
Keeping and dropping first or last rows with the Take and Filter functions
This is a method of extracting several rows at the top or at the bottom of a list.
194.92 MB
Chapter quiz: Manipulating Data
3 Questions
Min
Passed grade: 2/3
Attempts: 0/
Enhancing worksheets
5 Parts
Introduction to enhancing worksheets
Learn how to add special objects to worksheets to make them shine.
12.95 MB
Insert links with the Hyperlink function
Use a function to insert links. It's a dynamic alternative to using the Insert Hyperlink command on the ribbon bar and especially useful if you have a lot of them to insert.
142.89 MB
Inserting images with the Image function
Insert images from web links dynamically. Useful if you have a lot of images to place.
63.57 MB
Inserting checkboxes on a worksheet
At last! You don't need complicated Visual Basic programming to insert simple checkboxes on a sheet. And you can format them.
74.97 MB
Chapter quiz: Enhancing worksheets
3 Questions
Min
Passed grade: 2/3
Attempts: 0/
Creating and editing charts in Excel
8 Parts
Introduction to Excel charting
Excel has great charting features, and much of the controls and formatting work the same in each one, making them faster to learn.
28.96 MB
Creating column charts
Column charts are useful for comparing multiple component data over time or with each other.
219.13 MB
Producing pie charts
Pie charts are the most common way of displaying parts of a whole. They have pretty nice featues in Excel.
77.71 MB
Building bubble charts
A bubble chart lets you sneak a third dimension into a two-dimentional chart. You get X and Y axes plus bubble size.
63.82 MB
Constructing combination charts
Combination charts let you create two charts, one overlaying the other. This lets you show a comparison between data that wouldn't be easy to compare otherwise.
46.84 MB
Making map charts
Use map charts when you have data with geographic information, like sales by state or country.
74.1 MB
Setting up Sparklines
Sparklines are tiny, little charts that go inside cells. They're great for showing individual trends for rows of data.
98.1 MB
Chapter quiz: Charting
3 Questions
Min
Passed grade: 2/3
Attempts: 0/
Misc. advanced features
7 Parts
Introduction to advanced features
These features are relatively new in Excel. Some of them may still be in beta, so you may have to wait until they are available on your computer.
9.3 MB
Define variables and values with the Let function
Inside a formula, you can define variables and their values and calculations that use them. This can make long repetitive formulas easier to manage.
122.09 MB
Create your own functions with the Lambda function
Create custom Excel functions on a worksheet without having to write Visual Basic macros.
197.54 MB
Finding running totals with the Scan function
Running totals can be difficult to create. The Scan function makes the process a little easier.
69.33 MB
Create numbered sequences with the Sequence function
This is a dynamic way of creating a sequence of numbers based on a pattern you define.
106.88 MB
Let Excel write formulas for you!
Show Excel what you want to accomplish and its artificial intelligence might create the formula you need.
78.76 MB
Chapter quiz: Misc. advanced features
3 Questions
Min
Passed grade: 2/3
Attempts: 0/
Automating Excel with macros, VBA and Python
5 Parts
Intro to automation
You can create macros in Excel either by recording keystrokes and mouse clicks or by writing code in Visual Basic. This lesson is an overview of how it works.
7.89 MB
Recording a simple macro
Learn the ins and outs of recording actions in Excel so you can play them back.
265.48 MB
Editing macros using VBA
To customize or modify a macro or to collect user interaction, you need to edit the program code. This is an overview of how to do it.
198.96 MB
Embedding Python code in Excel
One of the biggest upgrades in Excel ever, you can write and run Python code in a worksheet.
190.46 MB
Chapter quiz: Automating Excel with macros, VBA and Python
4 Questions
Min
Passed grade: 3/4
Attempts: 0/
Goodbye
1 Parts
Thank you and additional resources
Keep up the good work!
20.63 MB
0
0 Reviews
