Microsoft Excel 2016 - Excel From Beginner To Advanced
4.1 (21 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,645 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2016 - Excel From Beginner To Advanced to your Wishlist.

Add to Wishlist

Microsoft Excel 2016 - Excel From Beginner To Advanced

Master Microsoft Excel 2016 with this comprehensive step by step course. Excel 2010, Excel 2013 and Excel 2016.
4.1 (21 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,645 students enrolled
Created by Andrew Morritt
Last updated 5/2017
English
Current price: $10 Original price: $80 Discount: 88% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 30 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • You will learn to use Excel formulas
  • You will learn how to create amazing Pivot Tables
  • You will learn how to create charts to present financial reports
  • You will learn how to use conditionnal formatting
  • You will learn how to apply many productivity hacks
  • You will be able to apply everything you learned into real life situations
View Curriculum
Requirements
  • It is not necessary to have Excel installed
  • Being able to use a PC at beginner level
  • Students do not need to know anything about Excel before starting this course
Description

Includes 30 Excel files so you can practice what you have learned in the course + All Excel's keyboard shortcuts and function keys!

Hey there! Are you ready to learn Excel 2016?

Nowadays, Excel knowledge is a must. You can use this software for so many different reasons; at work, in school, for your budget and even for your diet! Bosses also love seeing an employee having Excel on his resume. This course can land you a new job!

In this tutorial, you will learn everything that you need to know about Microsoft Excel 2016. It's the perfect fit for you if you are a beginner or intermediate and want to be able to use this amazing and useful softare to the fullest!

This course is divided into 6 sections of incredible content :

  • Overview of the Basic Options
  • Editing Cells and the Worksheet
  • Page Setup
  • Learning to Use Formulas
  • Advanced Options
  • Pivot Tables, Charts and Illustrations

After completing this course, you will be able to do everything you want to on Excel.

My ultimate goal is to be there for you and help you become a master at Microsoft Excel 2016.

Sign up and join me in this great course!

Who is the target audience?
  • This course is for beginners and intermediates who want to learn how to master Excel 2016
  • Entrepreneurs, teachers and students who want to improve their Excel skills
Students Who Viewed This Course Also Viewed
Curriculum For This Course
79 Lectures
02:45:33
+
Introduction
1 Lecture 00:47

This lecture is an intro to present what you will learn in this course.

Preview 00:47
+
Overview of the Basic Options
6 Lectures 08:03

This lecture will teach you the basics about cells.

Preview 01:07

You will learn where every option is in the different menus of Excel.

Excel's top menu
01:48

You will learn how to edit the ribbon and the quick access toolbar. You will learn how to add and remove elements from them.

Customizing The Ribbon And Quick Access Toolbar
03:01

You will learn the different ways you can save your files.

Saving Your File
00:57

You will learn the different ways you can share your files.

Sharing
00:40

You will learn how to export your files.

Exporting
00:30
+
Editing Cells and the Worksheet
13 Lectures 28:50

You will learn how to use the option Wrap Text.

Wrap Text
01:02

You will learn how to change the font, the size and the format of numbers and words.

Changing the Number Format
01:39

After this lecture, you will be able to insert, delete rows and columns.

Inserting, Deleting Rows and Columns
02:03

You will learn how to modify the height, the width of rows and columns by different ways.

Modifying the Height and Width of Rows and Columns
03:09

You will learn how to use conditionnal formatting.

Preview 05:35

You will learn how to merge cells.

Merging cells
01:38

After this lecture, you will be able to insert and use different types of borders.

Adding borders
02:36

In this lecture, you will learn how to cut, copy and paste numbers and text.

Copy and Paste
02:09

You will learn how to extend series automatically.

Preview 02:02

You will learn how to use the text to columns option.

Text To Columns
01:40

You will learn how to use the options in the Review Tab.

Review Tab
00:57

You will learn how to use the View options.

View Options
01:42

You will learn how to use the different types of cell styles.

Cell Styles
02:38
+
Page Setup
10 Lectures 20:37

After this lecture, you will be able to add and delete page breaks.

Preview 02:00

You will learn how to scale your pages for printing.

Scaling Pages
01:35

You will learn how to print a title on many pages automatically.

Printing a Title on Many Pages
01:30

You will learn how to add headers and footers that appear on every page automatically.

Using Headers and Footers
02:30

You will learn how to show, hide gridlines and headings on printed pages and in Excel.

Showing, Hiding Gridlines and Headings
01:09

You will learn how to use all the different printing options.

Printing Options
02:01

You will learn how to add sheets, delete, rename and group them.

Sheet Options
03:43

You will learn how to protect a worksheet and a workbook.

Protecting a Worksheet
01:40

You will learn how to add a comment in your Excel worksheet and make your name appear as the user.

Adding a Comment
02:01

You will learn how to use many different types for hyperlinks.

Hyperlinks
02:28
+
Learning to Use Formulas
23 Lectures 40:04

You will learn what is in the formula tab and how to use the options.

Formula Tab
01:13

You will learn how to use the formula Sum.

Sum
03:42

You will learn how to use the formula Average.

Preview 01:39

You will learn how to use the formulas Max and Min.

Max and Min
01:44

You will learn how to use the formulas Count and Counta.

Count and Counta
01:32

In this lecture, you will learn how to use the formula CountIf.

CountIf
02:09

You will learn how to use the formula CountBlank.

CountBlank
00:55

You will learn how to use the formula If

If
03:01

You will learn how to use the formula If Error.

If Error
02:50

You will learn how to use the formulas Today and Now.

Today and Now
01:01

You will learn how to use the formula Weekday.

Weekday
01:13

You will learn how to use the formula Concatenate.

Concatenate
02:04

You will learn how to calculate the payment for a loan with the formula PMT

PMT
02:33

This lecture will teach you how to find the interest payment with the formula IPMT.

IPMT
02:56

This lecture will teach you how to find the payment for an investment with the formula PPMT.

PPMT
02:22

You will learn how to use the formula Upper to transform words in upper case to lower case

Lower
00:45

You will learn how to use the formula Upper to transform words in lower case to upper case.

Upper
00:37

You will learn how to use the formulas Round, RoundUp and RoundDown

Round, RoundUp and RoundDown
01:59

You will learn how to use the formula Large to find the k-th largest number in a range of data.

Large
01:27

You will learn how to use the formula Small to find the k-th smallest value in a range of data.

Small
01:14

You will learn how to convert a number in a certain measurement system to a different one.

Convert
00:56

You will learn how to use the formula IsEven.

IsEven
01:08

You will learn how to use the formula Exact.

Exact
01:04
+
Advanced Options
9 Lectures 18:10

After this lecture, you will be able to use absolute references.

Absolute References
03:22

You will learn how to give a name to a cell and to a group of cells.

Giving a Name to Cells
01:38

You will learn to use the option freezing panes.

Freezing Panes
01:34

You will learn how to create a list with data validation.

Creating a List with Data Validation
02:15

You will learn how to sort a group of values.



Sorting
01:29

You will learn how to filter a group of values.

Filtering
02:53

After this lecture, you will be able to use the option Subtotal.

Subtotal
01:11

You will learn how to use the find and the replace options.

Find And Replace
02:29

You will learn how to import data from many different sources.

Importing Data
01:19
+
Pivot Tables, Charts and Illustrations
16 Lectures 48:32

In this lecture, you will learn everything you need to know about creating and modifying charts.

Creating and Modifying Charts
03:46

You will learn how to insert, delete and modify shapes.

Using Shapes
01:23

You will learn how to insert, delete and modify images from internet and from your computer.

Using Images
01:04

You will learn how to use many different SmartArt Graphics and how to customize them.

Using SmartArt Graphics
01:58

You will learn how to add and modify tables.

Using Tables
03:15

You will learn how to insert screenshots in your Excel workbook.

Using Screenshots
01:21

You will learn how to insert and modify many different types of icons.

Using Icons
01:32

You will learn how to use the options that are in the Draw tab.

Draw Tab
01:29

You are going to learn how to generate a Pivot Table. You are also going to learn how to customize the fields and the levels of your Pivot Table and learn to add different fields to the rows.

Pivot Tables Pt.1
06:48

You are going to learn how to add different fields to the column and to the filter.

Pivot Tables Pt.2
04:13

You are going to learn how to name your Pivot Table, how to name the different fields, how to modify the field settings, how to group and ungroup a selection.

Pivot Tables Pt.3
04:43

You will learn how to insert a slicer, how to move and clear your Pivot Table and how to use the show options.

Pivot Tables Pt.4
05:23

You are going to learn how to customize the design of your Pivot Table.

Pivot Tables Pt.5
02:53

You are going to learn how to create, customize and use a Pivot Chart.

Pivot Charts Pt.1
03:08

You are going to learn how to name your chart, how to use a slicer with a Pivot Chart, how to clear, move your chart and how to use the show/hide options.

Pivot Charts Pt.2
03:01

You are going to learn how to use the filter and the legend area with your different fields for a Pivot Chart.

Pivot Charts Pt.3
02:35
+
Congratulations!
1 Lecture 00:30

This lecture is a congratulations video to congratulate you for completing the course!

Congratulations! You're done!
00:30
About the Instructor
Andrew Morritt
4.1 Average rating
28 Reviews
2,270 Students
3 Courses
Business Manager - Students From 100+ Countries

Hi! I'm Andrew. I have a degree in Business Management and I have 10 years of experience with the Microsoft Office softwares.

My ultimate goal is to help you learn and to transfer my knowledge to you through my courses.

I'm passionate about the business world and all the techniques that you can use to get your company or the company you work in to the next level. I speak English and French.

I'm preaching personal development and I believe that it is so important to learn new things about different subjects every single day. Life is a journey in which you never stop to learn and to grow.

This is the reason why I decided to become a Udemy instructor; to provide knowledge for those who want to learn more and to be there for my students.

You won't believe how my courses will help you!

Sign up to my courses and join me in this amazing adventure today.