Microsoft Excel from Beginner to Advanced

401 Enrolled

6.5 Hours

$19.00$175.00

You save 89%

Microsoft Excel - Excel from Beginner to Advanced

80 Lessons (6.5h)

First Section
Introduction6:14
How to install Microsoft Excel 20165:47
ColumnsRows Formula bar8:43
New Spreadsheets and Autofill4:32
Main Workbook Material
Formulas and Funtions7:57
Formulas Part 14:31
Formulas and Funtions Part 24:39
"Goals" Exercise2:30
Finding the Totals7:40
Formatting into a Table Part 13:02
Formatting into a table Part 27:29
Inserting the First Chart6:58
Inserting the Second Chart5:17
Inserting the Third Chart3:13
Formatting the Title3:55
Printing the First Spreadsheet8:54
Printing the Second Spreadsheet5:42
Printing the Third Spreadsheet6:24
Different types of references
Workbook for exercise
Mixed, Relative and Absolute References7:19
The Mixed Reference6:03
Keeping score with the 'IF' and 'Vlookup' Function
Calculating with the IF Function8:41
Applying Conditional Formatting3:28
Assigning grades with the Vlookup Function8:47
Splitting names with the 'Find', 'Left', 'Right' and 'Len' Function
Workbook for exercise
Splitting names (1)6:30
Splitting names (2)5:21
Using the PMT Function to explore monthly and yearly compounding
Workbook for exercise
Pension/Savings payout with the PMT Function8:18
How to use Google Drive to collect data
Collecting data with Google Drive3:01
Creating a survey form6:25
Completing the form5:26
Filling in a Google Drive survey4:12
Data Analysis4:12
Using PMT and IPMT Funtions to work out a mortgage
Workbook for exercise
PMT for a Mortgage5:07
Mortgages Part 25:15
Mortgages Part 32:01
Mortgages Part 46:34
Mortgages Complete!5:06
Introduction to Charts in Excel
Workbook for exercise (PIE)
Introduction to Charts in Excel6:01
Advanced Pie Chart Formatting (1)4:10
Advanced Pie Chart Formatting (2)5:18
Introduction to Column Charts6:22
Advanced Column Chart Formatting (1)6:49
Advanced Column Chart Formatting (2)7:24
Workbook for exercise (LINE)
Introduction to Line Charts4:28
Advanced Line Chart Formatting (1)5:17
Advanced Line Chart Formatting (2)8:17
Advanced Line Chart Formatting (3)
Workbook for exercise (Scatter/Combo)
Introduction to Scatter and Combo Charts1:19
Advanced Scatter and Combo Chart Formatting (1)4:05
Advanced Scatter and Combo Chart Formatting (2)5:45
How to insert a Combo Chart3:29
Using the 'What if Analysis' function to calculate changes in data
Workbook for exercise
"What if" Analysis5:32
Workbook for exercise
"What if" Analysis with a Data Table4:02
Deleting duplicate data, Concatenating and more!
Workbook for exercise
Locating and Deleting Duplicate Data2:42
Deleting Duplicates2:17
Creating Email Addresses with Formulas4:36
Creating Email Addresses with Concatenate4:33
Deleting Duplicates Inactive/Active4:12
Working out true cost. PMT & IPMT for Finance
Workbook for exercise
Calculating payment with PMT and IPMT4:38
Exploring cost2:26
Calculating total costs5:24
Filling in the table with Autofill5:48
Completing the table6:36
Inserting a chart for quick reference6:17
Managing Large Amounts of Data
Workbook for exercise
Freezing the Panes3:58
Deleting Blank Rows and sorting Data6:02
Filtering and Analysing4:58
Sub-totalling data
Workbook for exercise
Sub-totalling data (1)3:11
Sub-totalling data (2)3:53
Sub-totalling data (3)5:13
Welcome to Pivot Charts and Tables in Excel
Workbook for exercise
Welcome to Pivot Charts and tables. The Pie Chart4:23
Inserting the first pivot table8:02
Inserting the second pivot table4:53
Inserting the third pivot table6:34
Creating the last pivot table5:12
Building a Dashboard3:31
Inserting a Slicer5:37

DescriptionInstructorImportant DetailsRelated Products

The Complete "How-To" Excel Crash Course

Warrick KlimaytysWarrick Klimaytys has spent many years with all kinds of computers in many different situations around the world and is eager to share his knowledge and skills with the StackCommerce community.

Around a decade ago Warrick started his professional life in the military where experienced all kinds of computers and machines. Today, he could be referred to as just a Microsoft "Windows Warrior". As a result of his past experience, he finds it best to deliver lessons in bite sized chunks.

Description

More than 750 million people have Excel installed on their computer but most do not know how to use it. Whatever version of Excel you have, this course will show you how to build and prepare a workbook good enough for a Fortune 500 CEO, to a household budget, and everything in between.

Access 80 lectures & 6.5 hours of content 24/7
Get downloadable Excel workbooks which you can use to follow along
Learn how to install Microsoft Excel & work w/ formulas and functions
Calculate w/ the IF Function & apply conditional formatting
Use the PMT Function to explore monthly & yearly compounding
Use Google Drive to collect data

Specs

Details & Requirements

Length of time users can access this course: lifetime
Access options: web streaming, mobile streaming
Certification of completion not included
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: all levels
Microsoft Excel required

Terms

Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.

Your Cart

Your cart is empty. Continue Shopping!

Processing order...