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

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.

• 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

• Getting Acquainted With Excel 2016
  • Welcome
  • Introductory Video
  • Exercise Files
  • What You Will Learn In Section 1
  • How To Open And Close Excel 2016
  • The Start Screen
  • The Backstage View
  • The Ribbon
  • The Mini Toolbar
  • The Formula Bar
  • The Quick Access Toolbar And The Status Bar In Excel 2016
  • The Tell Me Feature In Excel 2016
  • Quiz Number 1
• Different Ways To Select Cells
  • What You Will Learn In Section 2
  • How To Select Cells In Excel 2016
  • Quiz Number 2
• How To Manipulate Worksheets
  • What You Will Learn In Section 3
  • How To Create And Delete A Worksheet
  • Moving, Copying And Renaming Worksheets In Excel 2016
  • Quiz Number 3
• Formatting Worksheets In Excel 2016
  • What You Will Learn In Section 4
  • How To Change The Font , Font Color And Font Size In Excel 2016
  • Text Alignment in Excel 2016
  • A Beginner's Guide To Cell Styles
  • How To Automatically Insert A Decimal Point In Excel 2016
  • How To Rotate Text Within A Cell
  • How To Wrap Text In Excel 2016
  • A Beginner's Guide To Borders In Excel 2016
  • An Introduction To Conditional Formatting
  • Formatting And Special Effects
  • Quiz Number 4
• Ways To Enter Data
  • What You Will Learn In Section 5
  • Data Entry In Excel 2016 - A Beginner's Guide
  • How To Limit Data Entry To A Cell Range
  • Autocomplete
  • Autofill
  • Quiz Number 5
• Formulas
  • What You Will Learn In Section 6
  • How To Create And Edit A Formula
  • Order Of Operator Precedence
  • How To Use Operators To Build Formulas
  • How To Copy A Formula
  • Quiz Number 6
• Manipulating Rows And Columns
  • What You Will Learn In Section 7
  • Inserting And Deleting Rows And Columns
  • Adjusting Width Of Columns And The Height Of Rows
  • Quiz Number 7
• Charts , Tables And Graphics
  • What You Will Learn In Section 8
  • How To Create And Delete A Chart In Excel 2016
  • How To Insert WordArt And SmartArt Graphics
  • Introduction To Tables In Excel 2016
  • Quiz Number 8
• Macros
  • What You Will Learn In Section 9
  • How To Record And Run A Macro
  • Quiz Number 9
• Protecting And Saving Your Workbook
  • What You Will Learn In Section 10
  • How To Password Protect A Workbook
  • How To Save Workbooks In Excel 2016
  • Quiz Number 10
• Printing Your Worksheet
  • What You Will Learn In Section 11
  • How To Print A Workbook
  • Quiz Number 11
• Customizing The Quick Access Toolbar And The Ribbon
  • What You Will Learn In Section 12
  • How To Customize The Quick Access Toolbar In Excel 2016
  • How To Customize The Ribbon In Excel 2016
  • Quiz Number 12
• The Excel Options Dialog Box
  • What You Will Learn In Section 13
  • The General Tab In The Excel Options Dialog Box
  • The Formulas Tab In The Excel Options Dialog Box
  • The Proofing Tab In The Excel Options Dialog Box
  • The Save Tab In The Excel Options Dialog Box