Microsoft Excel 2016 Beginners & Intermediate Excel Training

Excel 2016 Is Here! Master the Number One Software Tool for the Office Even If You Have No Prior Experience
4.5 (198 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.
7,523 students enrolled
$19
$150
87% off
Take This Course
  • Lectures 65
  • Length 3 hours
  • Skill Level All Levels
  • Languages English, captions
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2015 English Closed captions available

Course Description

Do you want to learn how to work with Excel 2016?

Even if you don’t have any prior experience?

Would you like to take your skills to the next level and become an advanced user?

If so, then this is the right course for you!

A Verifiable Certificate of Completion is presented to all students who undertake this course.

Microsoft Excel 2016 is here, and it promises to be one of the greatest versions that we’ve seen so far. It includes a number of great new features, while all of the old ones are still in place and much improved.

However, it’s essential that you learn how to work with it effectively.

If you want to become any of the following…

  • Executive Assistant
  • Office Clerk
  • Auditor
  • Accountant
  • Business Analyst
  • Financial Analyst
  • Credit Counselor
  • Sales Representative
  • Sales Manager
  • Financial Manager
  • Investment Banker
  • Real Estate Agent
  • Market Research Analyst
  • Financial Advisor
  • Business Operations Manager
  • Entrepreneur
  • Someone who is involved with a business and would like to be successful

Then you simply have to learn Microsoft Excel 2016. There is no way around it.

But how can you do that if you have very limited time and no prior training? And how can you be certain that you are not missing an important piece of the puzzle?

Microsoft Excel 2016 Beginners & Intermediate Excel Training is here for you. One of the best Excel courses available on Udemy, it includes everything you’ll need. We will start from the very basics and then gradually build a solid foundation that will serve you well throughout your career.

What makes this course different from the rest of the Excel courses out there?

  • High quality of production – HD video and animated slides (this isn’t a collection of boring lectures!)
  • Knowledgeable instructor (experience in Big 4 Accounting + Commercial Finance)
  • Downloadable materials: The course comes with a complete set of downloadable materials (handouts, Excel files, etc.)
  • Extensive Case Studies that will help you reinforce everything that you’ve learned
  • Excellent support: If you don’t understand a concept or you simply want to drop us a line, you’ll receive an answer within 24 hours
  • Dynamic: We don’t want to waste your time! The instructor maintains a very good pace throughout the whole course
  • Bonus prizes: Upon completion of 50% and 100% of the course you will receive two bonus gifts

How come Microsoft Excel is so important?

Every large company uses it, right? So if you want to learn a new skill that is highly valued by all employers, you should start here.

Here are 5 more reasons why you should take this course and learn Excel:

  • Jobs. A solid understanding of Excel opens the door for a number of career paths
  • Promotions. Top Excel users are promoted very easily inside large corporations
  • Bill Gates knows how to work with Excel
  • Secure Future. Excel skills remain with you and provide extra security. You won’t ever have to fear unemployment
  • Girls dig guys who are proficient in Excel! Guys who can use VLOOKUP are proven to be the most popular with women J

This course is suitable for people without any previous experience in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, goal seek, pivot tables, custom formatting, Excel 2016 charts, and other tools that are often used for the purposes of Financial Modeling.

Additionally, the course includes practical case studies that will reinforce everything that you learn. One of the exercises that we will see in the course consists of building a complete Profit & Loss statement from scratch.

This course is perfect for University students, Entry-level Finance, Business and Marketing professionals who would like to grow faster than their peers.

++++++++++++++++++++++++++++++++++++++++

Students of this course who complete 50% of the lessons get full, lifetime access to our five-star rated course “Beginner to Pro in PowerPoint: Complete PowerPoint Training”. It has a full price of $20.

++++++++++++++++++++++++++++++++++++++++

Students of this course who complete 100% of the lessons get full, lifetime access to our five-star rated course “Finance 101: Financial Skills for the Real World”. It has a full price of $20.

+++++++++++++++++++++++++++++++++++++++++

Please don’t forget that the course comes with Udemy’s 30-day unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced that it will provide a ton of value for you?

What are the requirements?

  • Install Microsoft 2016, 2013 or 2010
  • No previous knowledge is required!
  • Great for students who want to learn at their own pace

What am I going to get from this course?

  • Work comfortably with Microsoft Excel 2016 and many of its advanced features
  • Learn what is new in Excel 2016
  • Be much quicker at carrying out regular tasks
  • Become your team's go-to-guy when it comes to Excel
  • Use sophisticated functions that will improve the quality of your work

What is the target audience?

  • Beginner, Intermediate and Advanced users who want to be proficient in Excel

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Welcome! Course Introduction
What Does the Course Cover?
Preview
05:30
Bonus Gift Number 1
1 page
Bonus Gift Number 2
1 page
Quiz Number 1
1 question
Section 2: A Quick Introduction to the Basics of Excel
Overview of Excel 2016
Preview
03:34
The Excel 2016 Ribbon
02:43
Working with Rows & Columns
01:49
Data Entry in Excel
03:00
Introduction to Formatting
05:52
Creating Formulas in Excel
03:01
Microsoft Excel at Its Best - Functions
03:50
Work Efficiently By Using Cut, Copy & Paste
02:15
Pasting Values, Formulas and Formats with Paste Special
01:33
Quiz Number 2
5 questions
Section 3: Excel Best Practices: Useful Tips & Tools
This Is How You Can Start Formatting Your Sheets in a Professional Way
02:05
Fast Scrolling That Would Allow You to Be 3x Faster
01:40
Fixing Cell References Properly
02:20
Using the Alt plus Enter combination
00:54
Learn How to Organize Your Excel Data with Text to Columns
Preview
02:05
Wrapping Text in Excel
00:47
Create Easily Printable Documents by Using Set Print Area
01:17
Find and Select Special Types of Cells with Select Special (F5)
01:45
Learn How to Assign Dynamic Names within a Model
01:27
Excel Formulas that Make Sense - Named Ranges
01:39
Assigning Custom Formats to Specific Cells (Ex. Multiples)
01:42
Execute 50 Commands with a Single Click - Excel Macros
03:04
Create a Drop-Down List by Using Data Validation
01:58
Using Custom Sort in Order to Sort Multiple Columns within a Table
01:28
Create a Great Index Page at the Beginning of Your Financial Models
02:05
Freeze the Title Row of Your Table - Freeze Panes
01:16
Excel's "Tell Me" Search Bar
00:46
Quiz Number 1
5 questions
Section 4: Keyboard Shortcuts in Excel
Keyboard Shortcuts Save LOTS of time in Excel
04:38
Section 5: Excel 2016 Functions
Key Functions in Excel: Count, Counta, Countif, Countifs
04:06
Key Functions in Excel: Sum, Sumif, Sumifs
04:24
Key Excel Functions: Average & Averageif
01:59
Working with Text in Excel: Left, Right, Mid, Upper, Lower, Proper, Co
04:29
Find the Highest and the Lowest Values in a Range: Max & Min
00:52
Include Round in Your Financial Models
01:01
Transferring Data Efficiently: Vlookup & Hlookup
07:47
Use Index & Match as a Substitute of Vlookup
07:27
Iferror Allows You to Deal Easily with Error Mesages
01:43
Excel's Dynamic & Interactive Tables: Pivot Tables
02:17
Create Flexible Financial Models with the Choose Function
02:24
Find the Result that You Are Looking For with Goal Seek
02:17
Include Sensitivity Analysis In Your Model Through Data Tables
04:10
Quiz Number 2
5 questions
Section 6: Create Professional Charts in Microsoft Excel 2016
Introduction to Charts in Excel 2016
01:11
Inserting Charts in Excel & Learning About the Various Chart Types
02:10
Formatting of Excel Charts (1/2)
02:29
Formatting of Excel Charts (2/2)
03:09
Creating a Bridge Chart in Excel 2016 - As Easy As It Gets
01:42
An Easy Way to Create a Treemap
01:31
Use Sparklines to Show Data Trends
03:52
Section 7: Build a Complete P&L from Scratch
Introduction to the Case Study
00:44
This Is the data that we will use for our Exercise
02:31
Let's Reorder our Excel sheet and create a clear structure!
02:03
Introducing a Code: The best way to work with large amounts of data
01:54
Finishing Touches of our Database
02:00
Using Vlookup in Order to Transfer Data
05:26
Applying Sumif in Order to Populate the Database with Numbers
04:10
Demonstrating How Index & Match Can Successfully Replace Vlookup
04:04
Mapping the Items Within Our Database - A Key Exercise For Financial Analysts
02:12
Creating the Structure of the P&L Statement
02:13
Time for Some Formatting! The Secret of Creating Awesome Looking Excel Sheets
03:23
Populating the P&L sheet with figures
05:32
How do We Find Mistakes in the easiest way possible?
02:24
Finishing Touches: Calculating Year-on-Year Growth and Percentage Incidence
03:10
Quiz Number 3
3 questions
Course Challenge - Apply Your Skills in Practice
01:09

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

365 Careers, Creating opportunities for Business & Finance students

365 Careers is a firm specializing in high-end financial training programs. Our growing list of courses includes Excel (Microsoft Excel for Beginner and Advanced users), PowerPoint, Financial Modeling, Company Valuation, Accounting, Investment Banking, Financial Planning & Analysis, and Job Hunting trainings. Our goal is to provide to our students the practical instruments they will need in order to perform successfully at their future workplace.

Ready to start learning?
Take This Course