Microsoft Excel: From Beginner to Advanced (2023)

3 Reviews

455 Enrolled

8 Hours

$19.99$80.00

You save 75%

92 Lessons (8h)

Your First Program
Preview

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

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 computers, 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.

Your cart is empty. Continue Shopping!

Processing order...