In this course you will learn the basics of Microsoft Excel as quickly as possible. By the end of this course, you will have a solid understanding of how to use basic functions of Microsoft Excel that you can apply to your professional or personal life.
You can use any version of Microsoft Excel to take this course, including Microsoft Excel 2007, 2010, 2013, 2016, 2019, or Excel 365.
Each lesson is around 3-5 minutes, and you can learn at your own pace.
WHAT STUDENTS SAY ABOUT THIS COURSE:
– “This is such a great course for beginners. It taught me so many new tricks to use Excel more easily.” – Nora A.
– “I enjoyed all the lessons. I felt like each one had at least one thing that I could take away from. I really enjoyed learning how to add charts and pivot tables to my spreadsheets for an easy summary of information. The sound quality was good. The instructor was clear and precise. The information was presented in a way that was easy to understand and also covered a vast amount of information. Definitely glad that I took this course. Would take another course provided by him, hands down.” – Brittany A.
– “Sum function, formatting numbers, mean, median, mode, and count, Sumif, VLookup and HLookup were the most helpful lessons for me. They taught me new lessons that will help me in the future. The lessons were very easy to follow. I would have Excel open and ready to input the same criteria when the video started, and could pause where I needed to do the exercises on my own.” – B. Alvarez
YOU WILL LEARN:
Navigating around Microsoft Excel
Entering text and numbers
Adding numbers (SUM function), subtracting, multiplying, and dividing
Correcting cells and moving around cells
Inserting columns and rows
Adding and deleting cell format (bold, font, etc.)
Using Copy, Cut, Paste, and Format Painter to quickly copy cell formatting
Paste Value using Paste Special
Wrap text in a cell
Formatting numbers using dollar sign, percentage, decimals
Conditional formatting to add colors to make sense of cell data
Using charts (pie charts, column charts, etc.)
Sorting numbers
Filtering numbers
Using Freeze Panes to see columns and row headings
Print Preview options to nicely print your Excel sheet
Using Sumif function to add cells based on criteria
Using VLookup function to quickly find data in a table vertically
Using HLookup function to quickly find data in a table horizontally
Using “If” function to test criteria
Using “Left” and “Right” functions to extract data from a cell
Removing duplicates in a range of data
Shortcut keys to quickly select a range of cells
Finding absolute value of positive and negative numbers
Pivot Tables to summarize your data
And much more!
WHY THIS COURSE?
Taught by a CPA, CA, MBA – Calvin K. Lee
Calvin is a top-rated instructor at Schulich School of Business at York University
Over 52,000+ students from 172 countries enrolled in his courses
Lifetime access to this course, and you receive new lessons and updates for FREE.
He has 15 years of experience in bookkeeping & accounting
He has worked in a Big 4 accounting firm (Ernst & Young)
Subtitles (captions) available in English, French, Hindi, Simplified Chinese, and Spanish
Certificate of Completion available
I guarantee you will learn Excel. If you aren’t absolutely satisfied, I’ll refund your money with a 30-day money-back guarantee
REGISTER FOR THIS COURSE NOW!
In this video we discuss how you can make the most out of this course by activating English subtitles or other foreign languages, and speed up videos to get through the course quicker.
In this video I will show you how to navigate around the main interface of Microsoft Excel.
In this video I will show you how to enter text and numbers into Excel.
In this video I will show you how to add numbers using the SUM function in Excel.
In this video I will show you how to subtract, multiply, and divide in Excel.
In this video I will show you how to correct data in cells and move around cells using the tab key.
In this video I will show you how to add columns and rows in Excel.
In this video I will show you how to use conditional formatting to quickly add colors to your data to more easily see trends, top numbers, show negative numbers, etc.
In this video I will show you how to clear formats and clear contents in cells.
Select the best answer.
In this video I will show you how to format cells in Excel using:
Bold & italics
Adding borders
Highlighting a cell
Changing text color
Merge & center
In this video I will show you how to use Copy, Cut, Paste, and Format Painter to copy format of cells.
In this video we will discuss how to use Paste Special to paste values instead of formulas into cells.
In this video I will show you how to use Wrap text to wrap spill over text in a cell.
In this video I will show you how to format numbers using dollar sign ($), percentage (%) and decimal points.
Choose the best answer.
Learn the Excel shortcuts to open/close/save a spreadsheet, bold & italics, copy, paste
Learn the Excel shortcuts to access the Home Tab, delete column, insert row, and zoom.
In this video we discuss Excel shortcuts - Tab, move to last cell, move to next worksheet, move down one screen.
In this video we discuss how to calculate the mean (average), median (middle number in a series), mode (most frequent number), and the counting number of cells.
In this video we discuss how to use split screen to work on different parts of the same Excel sheet simultaneously.
In this video we discuss how to group data to hide and show information, expand and collapse data.
Choose the best answer.
In this video I will show you how to use Charts to present your data in an easy to understand manner.
In this video I will show you how to use sort and filters in Excel.
In this video I will show you how to use Freeze Panes in Excel to always see column and row headings.
In this video we will discuss how to use absolute reference to prevent a cell reference from moving.
In this video we will discuss the Print Preview options:
How to fit data on one page
Fit all columns or rows on one page
How to print an entire workbook or an active Excel sheet
Use portrait and landscape orientation
Choose the best answer.
In this video I will show you how to use the "Sumif" function to add cells based on criteria that you set.
In this video I will show you how to use VLookup to find data quickly.
In this video I will show you how to use HLookup to find data quickly.
In this video I will show you how to use the "If" function to test criteria.
In this video I will show you how to use the "Left" and "Right" functions to extract parts of a cell.
In this video I will show you how to quickly remove duplicates in Excel.
In this video I will show you how to use shortcut keys to quickly select a range of cells.
In this video I will show you how to get the absolute value of numbers in Excel.
How to use the Find & Replace options to quickly find information and replace information in cells.
How to use the sum, count, average, time, and date functions.
How to see all the cell formulas in an Excel sheet with one click.
Use Sparklines to reveal trends in your Excel sheets, shown right inside cells!
Using the Text to Columns feature. Easily split columns with first and last names from one cell into 2 separate cells.
Using the Concatenate function to combine two cells together into one cell (for example, combining a first and last name in two separate cells into one cell).
This is a great time saver! Use the Flash Fill feature to have Excel automatically fill in data for you.
Use the Countif function to count the number of items that match a condition.
Use the Protect Sheet function to prevent unwanted changes. You can also add an optional password that must be corrected inputted before making changes.
Google 
Facebook