EXCEL 2016: Excel from beginner to professional
Learn Excel 2016 and the most important and popular functions. Learn to use Excel like a pro with this Excel Course
Watch Promo
This course has cut down on the fluff and empty space to keep it shorter, but still cover a wide range of topics. Designed for people starting out with Excel, it also covers some of the more complicated and important areas like Pivot Tables.
This Excel course is recorded completely using Excel 2016, the latest version of Excel offered in the Microsoft Office 2016 suite.
Some of the topics include (but not limited to)
- Creating your first workbook
- Referencing from other sheets within a book
- Quick Charts
- Quick Sorting
- Flash Fill
- Named Ranges
- Excel Sheet Management (moving, colouring, creating)
- Creating 3D maps using address data in a list
- Popular Excel Functions like SumIf, VLookUp, Left, Right, Mid, Len and more
- Power Excel functionality like nested formulas
- Using slicers to quickly sort and make spreadsheets look good
- A complete set of Pivot Table videos
I aim to add 4 new lectures every month to the course, and would love to have your feedback. So once you have signed up and completed the training, let me know what you would like to learn next!
What are the requirements?
- You will need to have a copy of Excel 2010 / 2013 or 2016. 2016 is recommended, but a lot of this is backwards compatible
What am I going to get from this course?
- Use Excel in a professional environment
- Create and manage complicated spreadsheets
- Manage constantly changing data
- Understand what Excel is and how it really works
- Create a 3D heat map to plot sales geographically
- Set up and manage Excel Pivot Tables
What is the target audience?
- Anyone who needs to manage large amounts of information with as much efficiency as possible
- Anyone looking to join an admin related position, or enhance their current employability
- General PC literacy
Your Instructor
Course Curriculum
Getting Started
Available in
days
days
after you enroll
-
StartJumping Straight in to Excel 2016 - Our First small Excel Spreadsheet (5:57)
-
StartCreating an Excel Workbook using a template (2:28)
-
StartFirst look at Excel Formula - Creating a Worksheet in Excel 2016 (9:16)
-
StartQuick Charts - How to quickly add charts to your Excel 2016 Spreadsheet (4:21)
-
StartQuick Sorting - How to quickly sort your Excel 2016 Spreadsheet (3:50)
-
StartFlash Fill - Excel 2016's incredible time saving fill feature (4:25)
-
StartFormatting Data Types in Excel 2016 - Numbers, Text, Percentages and more (7:26)
Increasing Efficiency to save time in Excel
Available in
days
days
after you enroll
-
StartCopy Paste - How to increase your efficiency in Excel 2016 (7:53)
-
StartTransposing with Copy Paste (1:32)
-
StartInserting, Deleting and Hiding Rows in Excel 2016 (7:45)
-
StartAbsolute Reference - Copy and Pasting with Absolute Reference in 2016 (4:37)
-
StartExploring the Clipboard using Multiple Copy and Paste in Excel 2016 (2:26)
-
StartNamed Range Referencing - Simplifying Excel Cross Worksheet Referencing (4:12)
-
StartCopying Moving and Deleting Excel 2016 Sheets (3:37)
-
StartChanging Excel Sheet Tab Colors (3:01)
-
StartUsing Excel's Autocorrect to Speed Up Typing (3:07)
-
StartAdding, Editing and Deleting Comments in your Excel 2016 Sheet (2:22)
-
StartManaging Excel Sheets - Best Practices for Cleaning up Raw Data (5:15)
Using the data in your Excel 2016 spreadsheet
Available in
days
days
after you enroll
-
Start3D Maps - Creating 3D maps and plotting addresses from your Excel spreadsheet (12:08)
-
StartSumIf Function - How to use it in an Excel Spreadsheet (6:46)
-
StartCreating a Drop Down Cell - Using SumIf command with it (3:38)
-
StartCreating an Independent Drop Down - Using SumIf (3:25)
-
StartVLookUp Part 1 - How it works, and how it makes your life easier in Excel (6:02)
-
StartVlookUp Part 2 - More indepth and pulling information from other Excel sheets (10:06)
-
StartLeft, Right and Mid Functions - Editing Text in Excel (5:28)
-
StartFind and Len Functions - And using nested formula (6:39)
-
StartCreating a Table Within your Excel 2016 Spreadsheet (6:19)
-
StartUsing Slicers in your Table for Quick Filtering your Excel 2016 Sheet (4:41)
Frequently Asked Questions
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.