Microsoft Excel 2016 Beginners Intermediate Excel Training

Tags: Excel

Excel for the office: Excel Formatting, Excel functions, Excel charts, Excel pivot tables made easy for you

Last updated 2022-01-10 | 4.6

- 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

What you'll learn

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

* Requirements

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

Description

Do you want to learn how to work with Excel?

Even if you don’t have any prior experience?

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

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

Microsoft Excel is the greatest productivity software the world has seen so far.

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

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 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

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

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 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.

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?

Enrol today and let's start this journey together!

Who this course is for:

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

Course content

8 sections • 79 lectures

What Does the Course Cover? Preview 05:30

Bonus Gift Number 1 Preview 1 page

Bonus Gift Number 2 Preview 1 page

Quiz Number 1

Overview of Excel Preview 03:34

The Excel Ribbon Preview 02:43

Working with Rows & Columns Preview 01:49

Data Entry in Excel Preview 03:00

Introduction to Formatting Preview 05:52

Creating Formulas in Excel Preview 03:01

Microsoft Excel at Its Best - Functions Preview 03:50

Work Efficiently By Using Cut, Copy & Paste Preview 02:15

Format Cells Preview 05:24

Pasting Values, Formulas and Formats with Paste Special Preview 01:16

Quiz Number 2

This Is How You Can Start Formatting Your Sheets in a Professional Way Preview 02:05

Fast Scrolling That Would Allow You to Be 3x Faster Preview 01:40

Fixing Cell References Properly Preview 02:20

Using the Alt plus Enter combination Preview 00:54

Learn How to Organize Your Excel Data with Text to Columns Preview 02:05

Wrapping Text in Excel Preview 00:47

Create Easily Printable Documents by Using Set Print Area Preview 01:17

Find and Select Special Types of Cells with Select Special (F5) Preview 01:45

Learn How to Assign Dynamic Names within a Model Preview 01:27

Excel Formulas that Make Sense - Named Ranges Preview 01:39

Completing 33% of the course Preview 00:32

Introduction to Custom Formatting Preview 06:14

Assigning Custom Formats to Specific Cells (Ex. Multiples) Preview 01:42

Execute 50 Commands with a Single Click - Excel Macros Preview 03:04

Create a Drop-Down List by Using Data Validation Preview 01:58

Using Custom Sort in Order to Sort Multiple Columns within a Table Preview 01:28

Create a Great Index Page at the Beginning of Your Financial Models Preview 02:05

Freeze the Title Row of Your Table - Freeze Panes Preview 01:16

Excel's "Tell Me" Search Bar Preview 00:46

Quiz Number 1

Keyboard Shortcuts Save LOTS of time in Excel Preview 04:38

A helpful consideration Preview 00:37

Key Functions in Excel: COUNT, COUNTA, COUNTIF, COUNTIFS Preview 04:06

Key Functions in Excel: SUM, SUMIF, SUMIFS Preview 04:24

Key Excel Functions: AVERAGE & AVERAGEIF Preview 01:59

Completing 50% of the course Preview 00:38

Working with Text in Excel: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE Preview 04:29

Find the Highest and the Lowest Values in a Range: MAX & MIN Preview 00:52

Include ROUND in Your Financial Models Preview 01:01

Transferring Data Efficiently: VLOOKUP & HLOOKUP Preview 07:47

Use INDEX & MATCH as a Substitute of VLOOKUP Preview 07:27

The Perfect VLOOKUP Substitute: XLOOKUP (Office 365 Only) Preview 06:40

IFERROR Allows You to Deal Easily with Error Mesages Preview 01:43

Excel's Dynamic & Interactive Tables: Pivot Tables Preview 02:17

Create Flexible Financial Models with the CHOOSE Function Preview 02:24

Find the Result that You Are Looking For with Goal Seek Preview 02:17

Include Sensitivity Analysis In Your Model Through Data Tables Preview 04:10

Quiz Number 2

Introduction to Charts in Excel 2016 Preview 01:11

Inserting Charts in Excel & Learning About the Various Chart Types Preview 02:10

Formatting of Excel Charts (1/2) Preview 02:29

Formatting of Excel Charts (2/2) Preview 03:09

Creating a Bridge Chart in Excel 2016 - As Easy As It Gets Preview 01:42

An Easy Way to Create a Treemap Preview 01:31

Use Sparklines to Show Data Trends Preview 03:52

Introduction to the Case Study Preview 00:51

This Is the data that we will use for our Exercise Preview 02:42

Let's Reorder our Excel sheet and create a clear structure Preview 02:16

Introducing a Code: The best way to work with large amounts of data Preview 01:59

Finishing Touches of our Database Preview 01:58

Using Vlookup in Order to Transfer Data Preview 05:29

Applying Sumif in Order to Populate the Database with Numbers Preview 04:06

Demonstrating How Index & Match Can Successfully Replace Vlookup Preview 03:51

Substituting VLOOKUP with XLOOKUP (Office 365 Only) Preview 02:53

Mapping the Items Within Our Database - A Key Exercise For Financial Analysts Preview 02:16

Creating the Structure of the P&L Statement Preview 02:21

Time for Some Formatting! The Secret of Creating Awesome Looking Excel Sheets Preview 03:17

Populating the P&L sheet with figures Preview 02:47

How do We Find Mistakes in the easiest way possible? Preview 02:14

Finishing Touches: Calculating Year-on-Year Growth and Percentage Incidence Preview 03:08

Quiz Number 3

Course Challenge - Apply Your Skills in Practice Preview 01:09

Practical Exercise - SUMIFS Preview 08:05

Completing 100% of the course Preview 00:29