Microsoft Excel from Beginner to Advanced

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
  • Different types of references
  • Keeping score with the 'IF' and 'Vlookup' Function
  • Splitting names with the 'Find', 'Left', 'Right' and 'Len' Function
  • Using the PMT Function to explore monthly and yearly compounding
  • How to use Google Drive to collect data
  • Using PMT and IPMT Funtions to work out a mortgage
  • Introduction to Charts in Excel
  • Using the 'What if Analysis' function to calculate changes in data
  • Deleting duplicate data, Concatenating and more!
  • Working out true cost. PMT & IPMT for Finance
  • Managing Large Amounts of Data
  • Sub-totalling data
  • Welcome to Pivot Charts and Tables in Excel
DescriptionInstructorImportant DetailsRelated Products

The Complete "How-To" Excel Crash Course

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