Ending In:

access

Lifetime

content

8.0 Hours

enrolled

395

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

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

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.

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

- Your First Program
- Introduction
- A brief introduction to Excel - 5:09
- The basic layout of spreadsheet - 10:00
- Auto-fill, basic functions and more - 8:13
- Exercise and solution video - 5:29
- Course notebook preview - 0: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 1 - 6:38
- The three different types of references. Part 2 - 3:41
- References exercise. A quick note
- References exercise - 4:12
- Quiz question: Test your knowledge on references
- Formulas and functions. What's the difference? - 2:08
- How to write formulas - 8:53
- Basic function variations you must know - 10:41
- Basic function variations you must know. SumIF and AverageIF - 9:02
- Functions exercise instructions - 1:29
- Welcome to the Concatenate function - 3:01
- Quiz question: Test your knowledge on the concatenate function
- The IF Function - 12:25
- Introduction to charts - 1:49
- Inserting a chart - 6:04
- Chart exercise instructions - 1:11
- Charts (And more) Solution video - 5:09
- Formatting data into a table - 7:03
- Formatting data into a table. Part 2 - 5:20
- Function error in next tutorial
- The If/And/Or functions. Part 1 - 8:26
- Quiz question: Test your knowledge on the IfAndOr function
- The If/And/Or functions. Part 2 - 3:52
- Quiz question: Test your knowledge on the IfAndOr function
- Introduction to printing - 0:51
- Printing your first spreadsheet - 9:37
- Quiz question: Test your knowledge on printing
- Printer settings - 1:35
- Printing the second spreadsheet. Solution/exercise - 4:23
- Building a Navigation pane - 9:33
- Quiz question: Test your knowledge of building a navigation pane
- Vlookup - 9:38
- Subtotaling data. Part 1 - 9:41
- Subtotaling data. Part 2 - 6:51
- "Goals" Exercise instructions - 2:56
- Goals solution video! - 11:33

- Advanced printing
- Advanced printing - 8:36
- Collation and more... - 6:20
- Advanced printing. Part 2 - 9:22
- Advanced printing. Part 3 - 9:20

- Welcome to macros
- Introduction to macros - 1:33
- Creating your first macro - 12:11
- Create a macro with cell referencing - 6:11
- Creating macro shortcut icons on the ribbon - 4:27
- How to save a macro enabled Workbook. Best practices

- Using PMT and IPMT functions for a Mortgage
- Using the PMT function for a mortgage - 8:20
- Using the IPMT function for a mortgage - 7:54

- What if analysis
- What if analysis. Data table - 7:50
- What if analysis. Goal seek - 6:49
- What if analysis. Goal seek formulas - 4:35

- 3D maps
- Introduction to 3D maps - 4:18
- 3D maps. How to use. Part 1 - 11:54
- 3D maps. How to use. Part 2 - 11:57
- Link to Microsoft web page with data

- MUST know functions
- Must know functions. Part 1 - 8:28
- Must know functions. Part 2 - 8:41
- Must know functions. Part 3 - 5:53
- Splitting names with the 'Find', 'Left', 'Right' and 'Len' Function. Part 1 - 7:18
- Splitting names with the 'Find', 'Left', 'Right' and 'Len' Function. Part 2 - 6:01
- Excels drawing tools and more - 6:14

- Charts in Excel
- Introduction to Charts in Excel - 1:18
- Charts in Excel. Part 1 - 5:19
- Charts in Excel. Part 2 - 5:58
- Charts in Excel. Part 3 - 10:18
- Inserting sparklines and more - 11:54
- Charts solution video - 8: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 1 - 7:19
- Filtering and analyzing the data. Part 2 - 6:25

- Deleting duplicate data, Concatenating and more!
- Locating and deleting duplicate entries - 4:33
- Concatenate continuation training - 5:56
- How to use the "DateValue" attribute within the IF function - 4:55

- Working out true cost. PMT & IPMT for Finance
- Calculating the payment with the PMT Function - 5:45
- Exploring true cost - 4:26
- Calculating total cost - 6:12
- Using the 'IPMT' function to work out interest - 7:59
- Inserting a chart for reference (Car Finance) - 5:19

- Welcome to Pivot tables and Pivot Charts
- Introduction to pivot tables and charts - 0:57
- Source data checklist and build your first pivot table - 7:12
- How the interface works (The field list) and more! - 10:58
- Inserting our last Pivot table, charts, and beginning on our dashboard - 5:37
- Building a dashboard and inserting slicers - 11:07

access

Lifetime

content

8.0 Hours

enrolled

395