Microsoft Excel from Beginner to Advanced

393 Enrolled
6.5 Hours
$19.00$175.00
You save 89% -

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

The Complete "How-To" Excel Crash Course

WK
Warrick Klimaytys

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