Microsoft Excel: From Beginner to Advanced (2022)

350 Enrolled
92 Lessons
$19.99$175.00
You save 88% -

92 Lessons (8h)

  • Your First Program
  • Introduction
    A brief introduction to Excel5:09
    The basic layout of spreadsheet10:00
    Auto-fill, basic functions and more8:13
    Exercise and solution video5:29
    Course notebook preview0:52
    Downloading your notebook templates
    A general overview and brief introduction (MUST WATCH)1:47
  • Starting on the main workbook
    Main workbook download
    The three different types of references. Part 16:38
    The three different types of references. Part 23:41
    References exercise. A quick note
    References exercise4:12
    Quiz question: Test your knowledge on references
    Formulas and functions. What's the difference?2:08
    How to write formulas8:53
    Basic function variations you must know10:41
    Basic function variations you must know. SumIF and AverageIF9:02
    Functions exercise instructions1:29
    Welcome to the Concatenate function3:01
    Quiz question: Test your knowledge on the concatenate function
    The IF Function12:25
    Introduction to charts1:49
    Inserting a chart6:04
    Chart exercise instructions1:11
    Charts (And more) Solution video5:09
    Formatting data into a table7:03
    Formatting data into a table. Part 25:20
    Function error in next tutorial
    The If/And/Or functions. Part 18:26
    Quiz question: Test your knowledge on the IfAndOr function
    The If/And/Or functions. Part 23:52
    Quiz question: Test your knowledge on the IfAndOr function
    Introduction to printing0:51
    Printing your first spreadsheet9:37
    Quiz question: Test your knowledge on printing
    Printer settings1:35
    Printing the second spreadsheet. Solution/exercise4:23
    Building a Navigation pane9:33
    Quiz question: Test your knowledge of building a navigation pane
    Vlookup9:38
    Subtotaling data. Part 19:41
    Subtotaling data. Part 26:51
    "Goals" Exercise instructions2:56
    Goals solution video!11:33
  • Advanced printing
    Advanced printing8:36
    Collation and more...6:20
    Advanced printing. Part 29:22
    Advanced printing. Part 39:20
  • Welcome to macros
    Introduction to macros1:33
    Creating your first macro12:11
    Create a macro with cell referencing6:11
    Creating macro shortcut icons on the ribbon4:27
    How to save a macro enabled Workbook. Best practices
  • Using PMT and IPMT functions for a Mortgage
    Using the PMT function for a mortgage8:20
    Using the IPMT function for a mortgage7:54
  • What if analysis
    What if analysis. Data table7:50
    What if analysis. Goal seek6:49
    What if analysis. Goal seek formulas4:35
  • 3D maps
    Introduction to 3D maps4:18
    3D maps. How to use. Part 111:54
    3D maps. How to use. Part 211:57
    Link to Microsoft web page with data
  • MUST know functions
    Must know functions. Part 18:28
    Must know functions. Part 28:41
    Must know functions. Part 35:53
    Splitting names with the 'Find', 'Left', 'Right' and 'Len' Function. Part 17:18
    Splitting names with the 'Find', 'Left', 'Right' and 'Len' Function. Part 26:01
    Excels drawing tools and more6:14
  • Charts in Excel
    Introduction to Charts in Excel1:18
    Charts in Excel. Part 15:19
    Charts in Excel. Part 25:58
    Charts in Excel. Part 310:18
    Inserting sparklines and more11:54
    Charts solution video8:48
  • Sorting large amounts of data
    Freezing the panes and more!8:19
    Sorting the data (Exercise instructions)2:23
    Sorting the data (Solution video)5:33
    Filtering and analyzing the data. Part 17:19
    Filtering and analyzing the data. Part 26:25
  • Deleting duplicate data, Concatenating and more!
    Locating and deleting duplicate entries4:33
    Concatenate continuation training5:56
    How to use the "DateValue" attribute within the IF function4:55
  • Working out true cost. PMT & IPMT for Finance
    Calculating the payment with the PMT Function5:45
    Exploring true cost4:26
    Calculating total cost6:12
    Using the 'IPMT' function to work out interest7:59
    Inserting a chart for reference (Car Finance)5:19
  • Welcome to Pivot tables and Pivot Charts
    Introduction to pivot tables and charts0:57
    Source data checklist and build your first pivot table7:12
    How the interface works (The field list) and more!10:58
    Inserting our last Pivot table, charts, and beginning on our dashboard5:37
    Building a dashboard and inserting slicers11:07

Go from Zero to Hero with 8 Hours of Content on the Most Basic to Advanced Excel Functions & Tools

WK
Warrick Klimaytys


Warrick Klimaytys | Computer Technician

4.4/5 Instructor Rating: ★ ★ ★ ★

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 he 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

Excel can be the most awkward of all Microsoft programs if not, the most awkward programs of all time! And although 750 million people have Excel installed on their computer, 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. It's designed to help you get up to speed as fast as possible, you can expect to be at a capable level within the first hour of lectures, then you will have the opportunity to explore more great features, functions, and tools as you progress further through the course.

4.6/5 average rating: ★ ★ ★ ★

  • Access 92 lectures & 8 hours of content 24/7
  • Acquire critical Excel knowledge
  • Create workbooks & spreadsheets everyone will be jealous of
  • Learn all about: tables, charts, formatting, formulas & functions, macros, pivot tables/charts, and much more!
  • Calculate with the IF Function & apply conditional formatting
  • Use the PMT Function to explore monthly & yearly compounding
  • Use Google Drive to collect data

NOTE: Software NOT included.

Specs

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any version of Excel. Including Excel in Microsoft Office 365

Terms

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