Mastering Excel 2016 - Basics

Are you looking for a course that will give you a basic understanding of Excel 2016? This is the course for you! By the end of this course, you should be able to...

• Navigate Excel’s interface to create and save workbooks and enter data
• Sort and filter data
• Apply formatting to text, numbers, and cells
• Create worksheet formulas
• Copy formulas and functions to multiple cells
• Assemble templates for use on future spreadsheets
• Apply styles and themes
• Preview and print a notebook

Certificate of completion

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included

• Mastering Excel 2016 - Basics 4:04:01

  • 1: Introduction Preview 08:52
  • 2: Selecting and Navigating 07:54
  • 3: Keyboard Navigation and Basic Data Entry 09:17
  • 4: The Ribbon 05:22
  • 5: The Quick Access Toolbar 04:27
  • 6: Creating a New Spreadsheet 09:07
  • 7: Compatibility Issues 05:26
  • 8: Cell Data & Data Types 12:40
  • 9: Accessing Help 03:10
  • 10: Creating Worksheet Formulas 11:05
  • 11: Insert Functions 11:18
  • 12: Re-using Formulas and Functions 11:59
  • 13: Insert, Delete, & Adjust Columns & Rows 07:22
  • 14: Find and Replace 09:51
  • 15: Use Proofing and Research Tools 11:21
  • 16: Apply Text Formats 14:06
  • 17: Apply Number Formats 07:00
  • 18: Align Cell Contents 08:44
  • 19: Applying Styles and Themes 11:42
  • 20: Conditional Formatting 11:42
  • 21: Creating and Using Templates 06:12
  • 22: Preview and Print a Notebook 08:32
  • 23: Page Layout 11:53
  • 24: Configure Headers and Footers 12:36
  • 25: Managing Worksheets 06:32
  • 26: View Options 10:54
  • 27: Managing Workbook Properties 04:57

The world is filled with two kinds of people: A handful of people who are masters of Excel, and the millions of others who wish they were

When you master Microsoft Excel 2016, you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet expert can work wonders – from organizing lists, to creating multi-layered, interactive reports. Spreadsheets can help businesses make decisions regarding critical issues involving accounting, budget allocations, expenditures, and inventory. This course is your first step towards getting started with Microsoft Excel and turning it into your most powerful productivity tool.

Excel is our most requested training course! Once you learn Excel, you’ll quickly see how useful it is in your life – from formatting your grocery list to calculating complex ROI values. If you are just getting started with Excel, let our Microsoft Certified Trainer Barbara Evers walk you through the basics of what you need to know about Microsoft Excel 2016.

Topics covered include:

• Navigating Excel’s interface
• Creating and saving a workbook
• Formatting text, numbers, and cells
• Learning the basics of functions and formulas
• Managing workbook properties
• Applying styes and themes
• Creating and using templates
• Previewing and printing a notebook

Quickly search and find the skills you want to master– then just point, click, and learn.

Enjoy over 4 hours of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!

Note: When combined with the Intermediate and Advanced versions of this course, you will cover all the objectives required in the Microsoft Office Specialist exam 77-727

People who want to learn the foundational skills of Excel

Currently there are no Q&As for this course. Be the first to ask a question.