Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 3 hours on-demand video
  • 4 articles
  • 180 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Excel

Microsoft Excel 2016 Beginners & Intermediate Excel Training

Excel 2016 for the office: Excel Formatting, Excel functions, Excel charts, Excel pivot tables made easy for you
Rating: 4.5 out of 54.5 (5,802 ratings)
25,776 students
Created by 365 Careers
Last updated 11/2020
English
English [Auto]
30-Day Money-Back Guarantee

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
Curated for the Udemy for Business collection

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

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 2016 is here, and it promises to be one of the greatest versions that we’ve seen so far.

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

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.

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

Featured review

Kiran Sankar
Kiran Sankar
20 courses
2 reviews
Rating: 5.0 out of 55 months ago
It is a clear viewed course which helps me to learn EXCEL as earlier as possible. I loved the way of explanation. Only one suggestion I wanted to share is the certificate is not so great, Kindly change the certificate content if possible.

Course content

8 sections • 72 lectures • 3h 11m total length

  • Preview05:30
  • Bonus Gift Number 1
    1 page
  • Bonus Gift Number 2
    1 page
  • Quiz Number 1
    1 question

  • Preview03: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
  • Preview03:50
  • Work Efficiently By Using Cut, Copy & Paste
    02:15
  • Format Cells
    05:24
  • Pasting Values, Formulas and Formats with Paste Special
    01:16
  • Quiz Number 2
    5 questions

  • 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
    Preview02: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
  • Completing 33% of the course
    00:32
  • Introduction to Custom Formatting
    06:14
  • 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

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

  • A helpful consideration
    00:37
  • 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
  • Completing 50% of the course
    00:38
  • Working with Text in Excel: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE
    04:29
  • Find the Highest and the Lowest Values in a Range: MAX & MIN
    00:52
  • Include ROUND in Your Financial Models
    01:01
  • Preview07: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

  • 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

  • Introduction to the Case Study
    00:51
  • This Is the data that we will use for our Exercise
    02:42
  • Let's Reorder our Excel sheet and create a clear structure
    02:16
  • Introducing a Code: The best way to work with large amounts of data
    01:59
  • Finishing Touches of our Database
    01:58
  • Using Vlookup in Order to Transfer Data
    Preview05:29
  • Applying Sumif in Order to Populate the Database with Numbers
    04:06
  • Demonstrating How Index & Match Can Successfully Replace Vlookup
    03:51
  • Mapping the Items Within Our Database - A Key Exercise For Financial Analysts
    02:16
  • Creating the Structure of the P&L Statement
    02:21
  • Preview03:17
  • Populating the P&L sheet with figures
    02:47
  • How do We Find Mistakes in the easiest way possible?
    02:14
  • Finishing Touches: Calculating Year-on-Year Growth and Percentage Incidence
    03:08
  • Quiz Number 3
    3 questions
  • Course Challenge - Apply Your Skills in Practice
    01:09
  • Completing 100% of the course
    00:28

  • Practical Exercise - SUMIFS
    08:05

Instructor

365 Careers
Creating opportunities for Business & Finance students
365 Careers
  • 4.5 Instructor Rating
  • 375,951 Reviews
  • 1,283,166 Students
  • 68 Courses

365 Careers is the #1 best-selling provider of finance courses on Udemy. The company’s courses have been taken by more than 1,000,000 students in 210 countries. People working at world-class firms like Apple, PayPal, and Citibank have completed 365 Careers trainings.  

Currently, the firm focuses on the following topics on Udemy:  

1) Finance – Finance fundamentals, Financial modeling in Excel, Valuation, Accounting, Capital budgeting, Financial statement analysis (FSA), Investment banking (IB), Leveraged buyout (LBO), Financial planning and analysis (FP&A), Corporate budgeting, applying Python for Finance, Tesla valuation case study, CFA, ACCA, and CPA

2) Data science – Statistics, Mathematics, Probability, SQL, Python programming, Python for Finance, Business Intelligence, R, Machine Learning, TensorFlow, Tableau, the integration of SQL and Tableau, the integration of SQL, Python, Tableau, Power BI, Credit Risk Modeling, and Credit Analytics

3) Entrepreneurship – Business Strategy, Management and HR Management, Marketing, Decision Making, Negotiation, and Persuasion, Tesla's Strategy and Marketing

4) Office productivity – Microsoft Excel, PowerPoint, Microsoft Word, and Microsoft Outlook

5) Blockchain for Business

All of the company’s courses are:  

Pre-scripted  

Hands-on  

Laser-focused  

Engaging  

Real-life tested  

By choosing 365 Careers, you make sure you will learn from proven experts, who have a passion for teaching, and can take you from beginner to pro in the shortest possible amount of time.  

If you want to become a financial analyst, a finance manager, an FP&A analyst, an investment banker, a business executive, an entrepreneur, a business intelligence analyst, a data analyst, or a data scientist, 365 Careers’ courses are the perfect place to start. 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.