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 Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence CBT
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 Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing 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
Office Productivity Microsoft Excel

Microsoft Excel 2016 Introductory Course

This Step By Step Easy To Learn Course Has Been Designed To Help You Learn The Basics Of Excel 2016.
Rating: 4.5 out of 54.5 (9 ratings)
1,852 students
Created by Everyday Solutions
Last updated 12/2019
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • You Will Learn The Fundamentals Of Microsoft Excel 2016

Requirements

  • Microsoft Excel 2016
  • Will To Learn

Description

This 3 Hour Step By Step Introductory Course Has Been Designed To Help You Learn The Basics Of Excel 2016.


                                 This Course Is Made Up Of 13 Sections.

  • I will teach you how to open and close excel 2016 at the very beginning.

  • We will look at the different toolbars that are present in excel 2016, the ribbon and the backstage view.

  • You will learn the different ways to select cells, how to manipulate and format worksheets.

  • We will show you different ways to enter data.

  • We will talk about formulas and how to manipulate rows and columns.

  • We will take a look at macros, charts, tables and graphics.

  • I will teach you how to protect, save and print your workbooks.

  • I will show you how to customize the ribbon and the quick access toolbar .

  • We will look at the excel options dialog box and much much more...


You will get access to me. If you don’t understand something, just let me know and I will explain it to you. That is why you’re here.


You will get access to all 33 exercise files that have been used in this course.

This Course has been designed for anyone who wants to learn.

If you are an advanced user , this course can help you learn the basics of excel again and if you are a beginner , it can help you learn the basics of excel so that you can start using the software.

This course also comes with  30-Day Money-Back Guarantee

You will be able to watch the videos on your iOS or Android Devices.

You will get Full Lifetime Access.

Who this course is for:

  • This course is for the beginner who does not know how to use Microsoft Excel 2016
  • This course is also open to the advanced user who wants to learn the basics again and refresh their memory
  • Anyone who wants to learn Excel 2016

Course content

13 sections • 60 lectures • 3h 38m total length

  • Preview00:15
  • Preview02:09
  • Exercise Files
    00:11
  • Preview00:24
  • How To Open And Close Excel 2016
    01:01
  • The Start Screen
    02:00
  • The Backstage View
    06:03
  • The Ribbon
    02:46
  • The Mini Toolbar
    02:48
  • The Formula Bar
    03:08
  • The Quick Access Toolbar And The Status Bar In Excel 2016
    04:41
  • Preview01:35
  • Quiz Number 1
    1 question

  • Preview00:11
  • How To Select Cells In Excel 2016
    09:21
  • Quiz Number 2
    1 question

  • Preview00:10
  • How To Create And Delete A Worksheet
    02:33
  • Moving, Copying And Renaming Worksheets In Excel 2016
    05:32
  • Quiz Number 3
    1 question

  • Preview00:37
  • Preview05:41
  • Text Alignment in Excel 2016
    06:11
  • A Beginner's Guide To Cell Styles
    01:43
  • How To Automatically Insert A Decimal Point In Excel 2016
    01:52
  • How To Rotate Text Within A Cell
    02:58
  • How To Wrap Text In Excel 2016
    01:35
  • A Beginner's Guide To Borders In Excel 2016
    04:38
  • An Introduction To Conditional Formatting
    11:34
  • Formatting And Special Effects
    06:42
  • Quiz Number 4
    1 question

  • Preview00:20
  • Data Entry In Excel 2016 - A Beginner's Guide
    02:58
  • How To Limit Data Entry To A Cell Range
    01:27
  • Autocomplete
    02:27
  • Autofill
    05:26
  • Quiz Number 5
    1 question

  • Preview00:14
  • How To Create And Edit A Formula
    05:04
  • Order Of Operator Precedence
    03:12
  • How To Use Operators To Build Formulas
    07:34
  • How To Copy A Formula
    01:27
  • Quiz Number 6
    1 question

  • Preview00:12
  • Inserting And Deleting Rows And Columns
    06:48
  • Adjusting Width Of Columns And The Height Of Rows
    03:42
  • Quiz Number 7
    1 question

  • Preview00:22
  • How To Create And Delete A Chart In Excel 2016
    06:07
  • How To Insert WordArt And SmartArt Graphics
    04:08
  • Introduction To Tables In Excel 2016
    05:44
  • Quiz Number 8
    1 question

  • Preview00:06
  • How To Record And Run A Macro
    07:27
  • Quiz Number 9
    1 question

  • Preview00:08
  • How To Password Protect A Workbook
    05:21
  • How To Save Workbooks In Excel 2016
    06:10
  • Quiz Number 10
    1 question

Instructor

Everyday Solutions
Life Hacker, Writer, Producer, Trainer, Lover.
Everyday Solutions
  • 4.1 Instructor Rating
  • 101 Reviews
  • 13,081 Students
  • 5 Courses

I love working with people and help them reach their goals.

Whenever I train someone or a group of people, I ask the hard questions and the uncomfortable questions so that I can REALLY help them.

My goal is to help you fulfill your goals.

Let's do it together. Enroll Today :)

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