Mastering Microsoft Excel 2016

If you are looking for a course to give you a complete overview of Microsoft Excel 2016, look no further! This is the course for you! By the end of this course, you will be able to...

• Navigate Excel’s interface to create and save workbooks and enter data
• Sort and filter data
• Perform calculations using formulas and functions
• Apply formatting to text, numbers, and cells
• Explain the importance of named ranges
• Write nested functions
• Create and modify tables
• Create and use PivotTables and Pivot Charts
• Define and develop Macros

Certificate of completion

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included

• Mastering Excel 2016 9:58:24

  • 1: Intro 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
  • 28: Working with Named Ranges 11:39
  • 29: Using Named Ranges in Formulas 03:53
  • 30: Using Specialized Functions 14:12
  • 31: Working with Logical Functions 13:56
  • 32: Displaying Formulas 04:29
  • 33: Nesting Functions 05:28
  • 34: Date and Time Functions 03:38
  • 35: Working with Text Functions 14:34
  • 36: Sorting Data 05:22
  • 37: Filtering Data 09:09
  • 38: Using Database Functions 07:49
  • 39: Using Subtotals 09:41
  • 40: Create and Modify Tables 07:59
  • 41: Manipulating Table Data 03:50
  • 42: Conditional Formatting Rules 03:44
  • 43: Using Logical Functions with Conditional Formatting 05:20
  • 44: Creating Charts 08:36
  • 45: Modifying and Formatting Charts 09:32
  • 46: Creating a Dual Axis Chart 07:17
  • 47: Chart Templates 02:59
  • 48: Formatting Shapes and Objects 07:05
  • 49: Creating a PivotTable 07:14
  • 50: Analyzing PivotTable Data 09:47
  • 51: Pivot Charts 06:25
  • 52: Slicers and Timelines 06:04
  • 53: Using Links and External References 10:03
  • 54: Using 3D References 08:57
  • 55: Consolidating Data 06:07
  • 56: Using Lookup Functions, Part 1 11:26
  • 57: Using Lookup Functions, Part 2 05:59
  • 58: Tracing Precedent and Dependent Cells 06:23
  • 59: Watching and Evaluating Formulas 05:29
  • 60: Comments and Track Changes 07:19
  • 61: Comparing and Merging Workbooks 04:00
  • 62: Accessibility Checker 04:19
  • 63: Protecting Worksheets and Workbooks 09:03
  • 64: Applying Data Validation 09:02
  • 65: Search for Invalid Data 06:26
  • 66: Working with Macros, Part 1 10:53
  • 67: Working with Macros, Part 2 07:20
  • 68: Creating Sparklines 03:56
  • 69: 3D Maps 06:19
  • 70: Data Tables 06:32
  • 71: Using Scenarios 04:45
  • 72: Goal Seek 02:42
  • 73: Forecasting Data Trends 03:00
  • 74: Changing Your Display 04:16
  • 75: Importing Delimited Text Files 03:22
  • 76: Data Forms and Form Controls 12:18
  • 77: Calculated Fields and Cube Functions 04:45

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 decision on critical issues involving budget allocations, expenditures, and investments. This course covers everything you need to know about Excel 2016, from the very basics to the most advanced features and functions.

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 a more experienced Excel user, let Microsoft Certified Trainer Barbara Evers walk you through steps to enhance your Excel proficiency, so you can add impact and relevance to your data.

Topics covered include:

• Navigating Excel’s interface
• Formatting text, numbers, and cells
• Learning the basics of functions and formulas
• Managing workbook properties
• Sorting, filtering, and summarizing data
• Creating Pivot Tables and Pivot Charts
• Using Scenarios and Goal Seek
• Working with Macros
• Using Data Forms and Form Controls

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

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

Note: This course covers all the objectives required in the Microsoft Office Specialist exam 77-727

People who want to learn the foundational skills of Excel and those who want to add to their Excel skillset

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