Mastering Excel 2016 – Basics

Mastering Excel 2016 – Basics

  • By
  • Triple Tech LLC dba Bigger Brains

Subscription

$16.58

per month

  • Single License
  • 12 Months
  • 400+ eBooks and video tutorials
  • Instant access

Share this Product

Get Custom offer

  • 10+ Users
  • For departments or complete companies
  • Premium analytics

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 

 

If you’ve mastered Microsoft Excel 2016, then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders – from organizing lists, to creating multi-layered, interactive reports, to revealing answers to businesses’ critical questions like ROI, budget allocations, tracking expenditures, and more. This course is your first step towards getting started with Microsoft Excel.  

 

This is our most requested training course!  If you learn to use Excel 2016, you will start to 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 Trainers, Barbara Evers and Christina Tankersley, walk you through the basics of what you need to know about Microsoft Excel 2016.  

 

 

Topics covered include: 

  • Navigating around Excel 
  • Creating and saving a workbook 
  • Using basic Office features including Undo, Redo, and Office clipboard 
  • The basics of functions and formulas 
  • Applying formatting 
  • Managing workbook properties 

 

Lesson

  • 1 Introduction
  • 2 Navigating the Interface
  • 3 Selecting Data
  • 4 Using Commands
  • 5 Creating a New Workbook
  • 6 Entering Cell Data
  • 7 Using AutoFill
  • 8 Using Flash Fill
  • 9 Using Excel Help
  • 1 0Creating Formulas
  • 11 Inserting Functions
  • 12 Copying Formulas and Functions
  • 13Using Absolute References
  • 14 Inserting and Deleting Cells
  • 15 Searching and Replacing
  • 16 Using Proofing and Researching Tools
  • 17 Applying Text Formats
  • 18 Applying Number Formats
  • 19 Customizing Number Formats
  • 20 Aligning Cell Contents
  • 21 Applying Cell Styles
  • 22 Applying Themes
  • 23 Iserting Hyperlinks
  • 24 Applying Conditional Formatting to Numbers
  • 25 Applying Conditional Formatting to Text and Dates
  • 26 Applying Comparative Analysis Formatting
  • 27 Using Templates
  • 28 Printing Workbooks
  • 29 Setting the Page Layout
  • 30 Inserting Page Breaks
  • 31 Configuring Headers and Footers, Part 1
  • 32 Configuring Headers and Footers, Part 2
  • 33 Managing Worksheets, Part 1
  • 33 Managing Worksheets, Part
  • 34 Managing Worksheets, Part 2
  • 35 Creating a Custom View
  • 36 Managing Worksheet Views
  • 37Managing Workbook Views
  • 38 Managing Workbook Properties
  • 39 Customizing General Options
  • 40 Customizing the Ribbon
  • 41 Customizing the Quick Access Toolbar