Stephen Beak – EXCEL 2016: Excel from beginner to professional

Description

Buy Stephen Beak – EXCEL 2016: Excel from beginner to professional Course at esyGB. You will have immediate access to the digital downloads in your account or your order email.

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 Forimc.com 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 esygb.com.
– 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!

10 reviews for Stephen Beak – EXCEL 2016: Excel from beginner to professional

There are no reviews yet.

Be the first to review “Stephen Beak – EXCEL 2016: Excel from beginner to professional” Cancel reply

Your rating *Rate…PerfectGoodAverageNot that badVery poor

Your review *

Name *

Email *

Δ

Buy the Stephen Beak – EXCEL 2016: Excel from beginner to professional course at the best price at esy[GB]. Upon completing your purchase, you will gain immediate access to the downloads page. Here, you can download all associated files from your order. Additionally, we will send a download notification email to your provided email address.

Unlock your full potential with Stephen Beak – EXCEL 2016: Excel from beginner to professional courses. Our meticulously designed courses are intended to help you excel in your chosen field.

Why wait? Take the first step towards greatness by acquiring our Stephen Beak – EXCEL 2016: Excel from beginner to professional courses today. We offer a seamless and secure purchasing experience, ensuring your peace of mind. Rest assured that your financial information is safeguarded through our trusted payment gateways, Stripe and PayPal.

Stripe, known for its robust security measures, provides a safe and reliable payment process. Your sensitive data remains confidential throughout the transaction thanks to its encrypted technology. Your purchase is fully protected.

PayPal, a globally recognized payment platform, adds an extra layer of security. With its buyer protection program, you can make your purchase with confidence. PayPal ensures that your financial details are safeguarded, allowing you to focus on your learning journey.

Is it secure? to Use of?

• Your identity is kept entirely confidential. We do not share your information with anyone. So, it is absolutely safe to buy the Stephen Beak – EXCEL 2016: Excel from beginner to professional course.
• 100% Safe Checkout Privateness coverage
• Communication and encryption of sensitive data.
• All card numbers are encrypted using AES with a 256-bit key at rest. Transmitting card numbers occurs in a separate hosting environment and does not share or store any data.

How can this course be delivered?

• After your successful payment this “Stephen Beak – EXCEL 2016: Excel from beginner to professional course”, Most of the products will come to you immediately. But for some products were posted for offer. Please wait for our response, it might take a few hours due to the time zone difference.
• If this occurs, please be patient. Our technical department will process the link shortly after, and you will receive notifications directly via email. We appreciate your patience.

What Shipping Methods Are Available?

• You will receive a download link in the invoice or YOUR ACCOUNT.
• The course link is always accessible through your account. Simply log in to download the Stephen Beak – EXCEL 2016: Excel from beginner to professional course whenever you need it.
• You only need to visit a single link, and you can get all the Stephen Beak – EXCEL 2016: Excel from beginner to professional course content at once.
• You can choose to learn online or download for better results, and you can study anywhere on any device. Please ensure that your system does not enter sleep mode during the download.

How Do I Track Order?

• We promptly update the status of your order after your payment is completed. If, after 7 days, there is no download link, the system will automatically process a refund.
• We value your feedback and are eager to hear from you. Please do not hesitate to reach out via email us with any comments, questions and suggestions.