Microsoft Excel 2016 Introductory Course

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course 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

Expected Outcomes

  1. 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 Show more Show less Course content 13 sections • 60 lectures • 3h 38m total length Expand all sections Getting Acquainted With Excel 2016 12 lectures • 27min Welcome Preview 00:15 Introductory Video Preview 02:09 Exercise Files 00:11 What You Will Learn In Section 1 Preview 00: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 The Tell Me Feature In Excel 2016 Preview 01:35 Quiz Number 1 1 question Different Ways To Select Cells 2 lectures • 10min What You Will Learn In Section 2 Preview 00:11 How To Select Cells In Excel 2016 09:21 Quiz Number 2 1 question How To Manipulate Worksheets 3 lectures • 8min What You Will Learn In Section 3 Preview 00: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 Formatting Worksheets In Excel 2016 10 lectures • 44min What You Will Learn In Section 4 Preview 00:37 How To Change The Font , Font Color And Font Size In Excel 2016 Preview 05: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 Ways To Enter Data 5 lectures • 13min What You Will Learn In Section 5 Preview 00: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 Formulas 5 lectures • 18min What You Will Learn In Section 6 Preview 00: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 Manipulating Rows And Columns 3 lectures • 11min What You Will Learn In Section 7 Preview 00: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 Charts , Tables And Graphics 4 lectures • 16min What You Will Learn In Section 8 Preview 00: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 Macros 2 lectures • 8min What You Will Learn In Section 9 Preview 00:06 How To Record And Run A Macro 07:27 Quiz Number 9 1 question Protecting And Saving Your Workbook 3 lectures • 12min What You Will Learn In Section 10 Preview 00:08 How To Password Protect A Workbook 05:21 How To Save Workbooks In Excel 2016 06:10 Quiz Number 10 1 question 3 more sections Instructor Everyday Solutions Life Hacker, Writer, Producer, Trainer, Lover. 4.0 Instructor Rating 103 Reviews 13,088 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 :) Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781c8962ae4005b',m:'60241a8e8026139fb9efe062351d12732bdac4c1-1627849400-1800-ARPiwj9/7SQLAr1Z2CzukRck3+ObN7AXEvBk1d6W/dn+xrhvpxSbbBGYKVRyena5DB6FVgIKU0AsdxVtqeEZ1zvNbeVOZoAQOezyTLzMbbGMdwNKrzcjZo+Wue5pjHZL50yAZiw8AnZ8Umrtaz9T9uLFBFJ99Sc8Ztw/BBoiCNCK9Y9YU7VKj5dRyzD7R+m/vA==',s:[0x96ca51bdea,0x184155de2d],}})();