Mastering Excel 2016 – Basics

Mastering Excel 2016 – Basics

Part of our online library flat rate.

  • By
  • Triple Tech LLC dba Bigger Brains

Flatrate 12 month

19 USD per month

  • 12 Months
  • Single License
  • 19 USD 228 USD per year
  • 850+ eBooks and video tutorials
  • Tips and tricks from experts
  • Instant access
  • Renews automatically

Share this Product

Get Custom offer

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

Language

English

Level

Beginner

Release

2021

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
  10. Creating Formulas
  11. Inserting Functions
  12. Copying Formulas and Functions
  13. Using 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
  34. Managing Worksheets, Part
  35. Managing Worksheets, Part 2
  36. Creating a Custom View
  37. Managing Worksheet Views
  38. Managing Workbook Views
  39. Managing Workbook Properties
  40. Customizing General Options
  41. Customizing the Ribbon
  42. Customizing the Quick Access Toolbar