Microsoft Excel Beginners & Intermediate Excel Training

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

4.58 (20474 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
Microsoft Excel Beginners & Intermediate Excel Training
69,052
students
3.5 hours
content
Feb 2024
last update
$139.99
regular price

What you will 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

Why take this course?

Do you want to learn how to work with Excel?

Even if you don’t have any prior experience?

You want to become very good at Excel?

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 online, this training includes everything you’ll need. We will start from the very basics and then gradually build a solid foundation that will help you grow as a professional.

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 (1.5 million Udemy students, working experience in Big 4 Consulting and Coca-Cola)

  • 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

  • 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 company on the planet uses this software, 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

  • 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 you learn. One of the exercises we will see in the course consists of building a complete Profit & Loss statement from scratch.

This training is highly recommended 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?

Buy the course today and let's start this journey together!

Content

Welcome! Course Introduction

What Does the Course Cover?
Bonus Gift Number 1
Bonus Gift Number 2
Quiz Number 1

A Quick Introduction to the Basics of Excel

Overview of Excel 2016
The Excel 2016 Ribbon
Working with Rows & Columns
Data Entry in Excel
Introduction to Formatting
Creating Formulas in Excel
Microsoft Excel at Its Best - Functions
Work Efficiently By Using Cut, Copy & Paste
Pasting Values, Formulas and Formats with Paste Special
Quiz Number 2

Excel Best Practices: Useful Tips & Tools

This Is How You Can Start Formatting Your Sheets in a Professional Way
Fast Scrolling That Would Allow You to Be 3x Faster
Fixing Cell References Properly
Using the Alt plus Enter combination
Learn How to Organize Your Excel Data with Text to Columns
Wrapping Text in Excel
Create Easily Printable Documents by Using Set Print Area
Find and Select Special Types of Cells with Select Special (F5)
Learn How to Assign Dynamic Names within a Model
Excel Formulas that Make Sense - Named Ranges
Completing 33% of the course
Assigning Custom Formats to Specific Cells (Ex. Multiples)
Execute 50 Commands with a Single Click - Excel Macros
Create a Drop-Down List by Using Data Validation
Using Custom Sort in Order to Sort Multiple Columns within a Table
Create a Great Index Page at the Beginning of Your Financial Models
Freeze the Title Row of Your Table - Freeze Panes
Excel's "Tell Me" Search Bar
Quiz Number 1

Keyboard Shortcuts in Excel

Keyboard Shortcuts Save LOTS of time in Excel

Excel 2016 Functions

A helpful consideration
Key Functions in Excel: COUNT, COUNTA, COUNTIF, COUNTIFS
Key Functions in Excel: SUM, SUMIF, SUMIFS
Key Excel Functions: AVERAGE & AVERAGEIF
Completing 50% of the course
Working with Text in Excel: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE
Find the Highest and the Lowest Values in a Range: MAX & MIN
Include ROUND in Your Financial Models
Transferring Data Efficiently: VLOOKUP & HLOOKUP
Use INDEX & MATCH as a Substitute of VLOOKUP
IFERROR Allows You to Deal Easily with Error Mesages
Excel's Dynamic & Interactive Tables: Pivot Tables
Create Flexible Financial Models with the CHOOSE Function
Find the Result that You Are Looking For with Goal Seek
Include Sensitivity Analysis In Your Model Through Data Tables
Quiz Number 2

Create Professional Charts in Microsoft Excel 2016

Introduction to Charts in Excel 2016
Inserting Charts in Excel & Learning About the Various Chart Types
Formatting of Excel Charts (1/2)
Formatting of Excel Charts (2/2)
Creating a Bridge Chart in Excel 2016 - As Easy As It Gets
An Easy Way to Create a Treemap
Use Sparklines to Show Data Trends

Build a Complete P&L from Scratch

Introduction to the Case Study
This Is the data that we will use for our Exercise
Let's Reorder our Excel sheet and create a clear structure
Introducing a Code: The best way to work with large amounts of data
Finishing Touches of our Database
Using Vlookup in Order to Transfer Data
Applying Sumif in Order to Populate the Database with Numbers
Mapping the Items Within Our Database - A Key Exercise For Financial Analysts
Creating the Structure of the P&L Statement
Time for Some Formatting! The Secret of Creating Awesome Looking Excel Sheets
Populating the P&L sheet with figures
How do We Find Mistakes in the easiest way possible?
Finishing Touches: Calculating Year-on-Year Growth and Percentage Incidence
Quiz Number 3
Course Challenge - Apply Your Skills in Practice
Completing 100% of the course

Screenshots

Microsoft Excel Beginners & Intermediate Excel Training - Screenshot_01Microsoft Excel Beginners & Intermediate Excel Training - Screenshot_02Microsoft Excel Beginners & Intermediate Excel Training - Screenshot_03Microsoft Excel Beginners & Intermediate Excel Training - Screenshot_04

Reviews

Ashish
October 25, 2023
"Taking the Excel course was a game-changer for me. The course was well-structured, and the instructor made complex concepts easy to understand. I've gained valuable skills that have significantly improved my productivity at work. Thank you for this fantastic opportunity!
Mark
October 10, 2023
I thought I knew quite a bit already about excel! How wrong this course has proven I was. Great format of learning
Kishan
October 10, 2023
There are so many changes on to it. some of the points has doubted on to it . please upload the new slides on to it.
Aaminah
October 4, 2023
This is a good match because once I learn all the short cuts when working on excel, this will save me time when handling my work.
Mande
September 17, 2023
was quick and easy to learn about the excel as it also help where in the shortcuts which are implemented are shown well over all ways to learn the excel in a easy way
Brandon
September 11, 2023
Great overview of general Excel functions. I've learned a couple things I never knew existed. Looking forward to diving deeper into several topics.
Jason
February 28, 2023
I am a seasoned Excel User and I still found the lessons on the new Excel functions of XLOOKUP, and using Index and Match in Tandem very useful, as well as the touch on new charting. I also appreciate the attention paid to design elements of the P&L and Financial Models to present data in an interesting and useful format. Very organic, and helpful, thank you!
Nitin
February 19, 2023
The basics were covered very well, and the exercises were good, but as I have an engineering background, the last part was not that interesting to me.
Patricia
February 15, 2023
This is new to me, it has explained so much so far. Most have been informative, but still being this is new to me, I didn't understand 42 and 43. I will be going back over this again for a refresher. Overall, this is good for a beginer.
Sean
February 13, 2023
This course was a great refresher for entry level excel functions and a simple way to learn intermediate functions.
Shannon
February 11, 2023
Though I use Excel every day for work, this is giving me some more concrete knowledge about the more advanced stuff, like the developer tab. While I use pivot tables and vlookups, it's great to know a bit deeper into the processes and being able to expand a bit more from my every day routine. Great course, highly recommend this for people who are just beginning their Excel journey!
Donna
February 7, 2023
At times the instructor went too fast. I often had to pause and rewind so I could listen a 2nd time.
Shannon
February 3, 2023
The person teaching this course take's me step by step and it is much appropriated for me to learn excel. five stars to the creator of this course.
Veronica
February 3, 2023
I like the vocal pace of the training course, which also compliments and makes it easy for those learning to follow along. As someone that's intermediate within Excel, it's great to still learn or discover little things that I didn't know about. It's been helpful so far within minutes of beginning this course.
Felipe
February 2, 2023
Great Material, it keeps me very engaged in the process and I love the learning experience, it will enrich my knowledge in Excel

Coupons

DateDiscountStatus
3/21/2020100% OFF
expired

Charts

Price

Microsoft Excel Beginners & Intermediate Excel Training - Price chart

Rating

Microsoft Excel Beginners & Intermediate Excel Training - Ratings chart

Enrollment distribution

Microsoft Excel Beginners & Intermediate Excel Training - Distribution chart

Related Topics

659464
udemy ID
11/3/2015
course created date
11/1/2019
course indexed date
Bot
course submited by