Microsoft Excel 2016 covers key Excel skills, from introductory through advanced. Among others, introductory topics include entering, editing, and formatting entries; selecting cells and ranges, and creating and modifying basic formulas. Intermediate topics include themes, cell styles, and number formats, as well as functions for dates, numbers and text. Advanced topics include tables, financial functions, what-if analyses, PivotTables and PivotCharts, workbooks protection, collaboration, and more.

  • Enter data into a worksheet
  • Format a worksheet
  • Rearrange data on a worksheet
  • Use functions to perform calculations
  • Define names for cells and ranges
  • Create charts to compare data
  • Add images to a worksheet
  • Use conditional formatting
  • Import and export data in different formats
  • Control data entry with data validation rules
  • Apply and customize themes
  • Create and use cell styles
  • Create custom number formats
  • Customize the page setup
  • Apply custom date formatting
  • Perform date and time calculations
  • Create customized conditional formatting rules
  • Find and correct errors in formulas
  • Create formulas using lookup functions
  • Manage data using a table
  • Create sparklines
  • Create financial functions
  • Create PivotTables
  • Create a calculated field
  • Create hyperlinks for navigation
  • Insert comments
  • Add alt text to objects
  • Protect your workbook
  • Much, much more!
Go to top