NEW! EXCEL 2016: Excel from beginner to professional

NEW! EXCEL 2016: Excel from beginner to professional, available at $44.99, has an average rating of 4.2, with 37 lectures, based on 50 reviews, and has 1418 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone who needs to manage large amounts of information with as much efficiency as possible or Anyone looking to join an admin related position, or enhance their current employability or General PC literacy It is particularly useful for Anyone who needs to manage large amounts of information with as much efficiency as possible or Anyone looking to join an admin related position, or enhance their current employability or General PC literacy.

Enroll now: NEW! EXCEL 2016: Excel from beginner to professional

Summary

Title: NEW! EXCEL 2016: Excel from beginner to professional

Price: $44.99

Average Rating: 4.2

Number of Lectures: 37

Number of Published Lectures: 37

Number of Curriculum Items: 37

Number of Published Curriculum Objects: 37

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

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

Who Should Attend

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

Target Audiences

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

By Completing this course, you will receive a verifiable Certificate of Completion.

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!

Course Curriculum

Chapter 1: Jumping Straight In

Lecture 1: Jumping Straight in to Excel 2016 – Our First small Excel Spreadsheet

Lecture 2: Creating an Excel Workbook using a template

Lecture 3: First look at Excel Formula – Creating a Worksheet in Excel 2016

Lecture 4: Quick Charts – How to quickly add charts to your Excel 2016 Spreadsheet

Lecture 5: Quick Sorting – How to quickly sort your Excel 2016 Spreadsheet

Lecture 6: Flash Fill – Excel 2016's incredible time saving fill feature

Lecture 7: Formatting Data Types in Excel 2016 – Numbers, Text, Percentages and more

Chapter 2: Increasing Efficiency to save time in Excel

Lecture 1: Copy Paste – How to increase your efficiency in Excel 2016

Lecture 2: Transposing with Copy Paste

Lecture 3: Inserting, Deleting and Hiding Rows in Excel 2016

Lecture 4: Absolute Reference – Copy and Pasting with Absolute Reference in 2016

Lecture 5: Exploring the Clipboard using Multiple Copy and Paste in Excel 2016

Lecture 6: Named Range Referencing – Simplifying Excel Cross Worksheet Referencing

Lecture 7: Copying Moving and Deleting Excel 2016 Sheets

Lecture 8: Changing Excel Sheet Tab Colors

Lecture 9: Using Excel's Autocorrect to Speed Up Typing

Lecture 10: Adding, Editing and Deleting Comments in your Excel 2016 Sheet

Lecture 11: Managing Excel Sheets – Best Practices for Cleaning up Raw Data

Chapter 3: Using the data in your Excel 2016 spreadsheet

Lecture 1: 3D Maps – Creating 3D maps and plotting addresses from your Excel spreadsheet

Lecture 2: SumIf Function – How to use it in an Excel Spreadsheet

Lecture 3: Creating a Drop Down Cell – Using SumIf command with it

Lecture 4: Creating an Independent Drop Down – Using SumIf

Lecture 5: VLookUp Part 1 – How it works, and how it makes your life easier in Excel

Lecture 6: VlookUp Part 2 – More indepth and pulling information from other Excel sheets

Lecture 7: Left, Right and Mid Functions – Editing Text in Excel

Lecture 8: Find and Len Functions – And using nested formula

Lecture 9: Creating a Table Within your Excel 2016 Spreadsheet

Lecture 10: Using Slicers in your Table for Quick Filtering your Excel 2016 Sheet

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

Lecture 1: Pivot Tables Part 1 – Setting up for first Excel Pivot Table, and how it works

Lecture 2: Pivot Tables Part 2 – Adding Automatically Updating Charts

Lecture 3: Pivot Tables Part 3 – Using Slicers in your Pivot Table for Quick Filtering

Lecture 4: Pivot Tables Part 4 – Using Timeline for even easier filtering in Excel sheets

Chapter 5: More functions – General Excel 2016 Functions

Lecture 1: Concatenate – How to join text together in Excel 2016

Lecture 2: Lower, Proper, and Upper functions – Formatting text in Excel 2016

Lecture 3: Repeat Function – Using REPT in your Excel 2016 sheet for quick duplication

Lecture 4: Substitute – Easily replace pieces of text with other pieces of text in Excel

Lecture 5: Trim – An Excel function to quickly format out extra spaces

Instructors

Stephen Beak
Home Entrepreneur, and loving it

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 4 votes
4 stars: 15 votes
5 stars: 30 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu