-73%

Stephen Beak – EXCEL 2016: Excel from beginner to professional

Name: Stephen Beak - EXCEL 2016: Excel from beginner to professional
Availability: InStock
Rating: 3.82 (10 reviews)

Rated 3.82 out of 5 based on 23 customer ratings

Original price was: $200.00.Current price is: $54.00.

Digital Download: You will receive a download link via your order email
Should you have any question, please contact us: [email protected]

Category: SEO & Design Website Tags: EXCEL 2016: Excel from beginner to professional, Stephen Beak, Stephen Beak - EXCEL 2016: Excel from beginner to professional

Description
Reviews (10)

Learn Excel 2016 and the most important and popular functions. Learn to use Excel like a pro with this Excel Course

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

Stephen Beak

Course Curriculum

EXCEL 2016: Excel from beginner to professional
Getting Started

Jumping Straight in to Excel 2016 – Our First small Excel Spreadsheet (5:57)

Creating an Excel Workbook using a template (2:28)

First look at Excel Formula – Creating a Worksheet in Excel 2016 (9:16)

Quick Charts – How to quickly add charts to your Excel 2016 Spreadsheet (4:21)

Quick Sorting – How to quickly sort your Excel 2016 Spreadsheet (3:50)

Flash Fill – Excel 2016’s incredible time saving fill feature (4:25)

Formatting Data Types in Excel 2016 – Numbers, Text, Percentages and more (7:26)

Increasing Efficiency to save time in Excel

Copy Paste – How to increase your efficiency in Excel 2016 (7:53)

Transposing with Copy Paste (1:32)

Inserting, Deleting and Hiding Rows in Excel 2016 (7:45)

Absolute Reference – Copy and Pasting with Absolute Reference in 2016 (4:37)

Exploring the Clipboard using Multiple Copy and Paste in Excel 2016 (2:26)

Named Range Referencing – Simplifying Excel Cross Worksheet Referencing (4:12)

Copying Moving and Deleting Excel 2016 Sheets (3:37)

Changing Excel Sheet Tab Colors (3:01)

Using Excel’s Autocorrect to Speed Up Typing (3:07)

Adding, Editing and Deleting Comments in your Excel 2016 Sheet (2:22)

Managing Excel Sheets – Best Practices for Cleaning up Raw Data (5:15)

Using the data in your Excel 2016 spreadsheet

3D Maps – Creating 3D maps and plotting addresses from your Excel spreadsheet (12:08)

SumIf Function – How to use it in an Excel Spreadsheet (6:46)

Creating a Drop Down Cell – Using SumIf command with it (3:38)

Creating an Independent Drop Down – Using SumIf (3:25)

VLookUp Part 1 – How it works, and how it makes your life easier in Excel (6:02)

VlookUp Part 2 – More indepth and pulling information from other Excel sheets (10:06)

Left, Right and Mid Functions – Editing Text in Excel (5:28)

Find and Len Functions – And using nested formula (6:39)

Creating a Table Within your Excel 2016 Spreadsheet (6:19)

Using Slicers in your Table for Quick Filtering your Excel 2016 Sheet (4:41)

Pivot Tables – How to use them in Excel 2016 and why you should

Pivot Tables Part 1 – Setting up for first Excel Pivot Table, and how it works (8:46)

Pivot Tables Part 2 – Adding Automatically Updating Charts (4:04)

Pivot Tables Part 3 – Using Slicers in your Pivot Table for Quick Filtering (3:29)

Pivot Tables Part 4 – Using Timeline for even easier filtering in Excel sheets (3:36)

More functions – General Excel 2016 Functions

Concatenate – How to join text together in Excel 2016 (2:39)

Lower, Proper, and Upper functions – Formatting text in Excel 2016 (2:12)

Repeat Function – Using REPT in your Excel 2016 sheet for quick duplication (1:19)

Substitute – Easily replace pieces of text with other pieces of text in Excel (2:30)

Trim – An Excel function to quickly format out extra spaces (1:38)

Access download Stephen Beak – EXCEL 2016: Excel from beginner to professional at IMC.sale right now!

Salepage: https://indie-learn.teachable.com/p/excel-2016-excel-from-beginner-to-professional

Archive: https://archive.ph/Iloho

Delivery Method

– After your purchase, you’ll see a View your orders link which goes to the Downloads page. Here, you can download all the files associated with your order.
– Downloads are available once your payment is confirmed, we’ll also send you a download notification email separate from any transaction notification emails you receive from IMC.sale.
– Since it is a digital copy, our suggestion is to download and save it to your hard drive. In case the link is broken for any reason, please contact us and we will resend the new download link.
– If you cannot find the download link, please don’t worry about that. We will update and notify you as soon as possible at 8:00 AM – 8:00 PM (UTC+8).

Thank You For Shopping With Us!