1. Introduction FREE CHAPTER

• Acquiring Excel 2016 and Information on Installation and Upgrade
• Exercise Files

2. What's New

• New and Improved Features in Excel 2016

3. Using Touch

• Overview of Principles of Using Touchscreen

4. Getting Started

• Creating and Saving a Workbook
• Opening a Workbook

5. Using Help

• Online Help and Contextual Help

6. Excel Options

• Personalizing your use of Excel

7. The Ribbon and Toolbars

• Basics of using the Ribbon
• Quick Access Toolbar
• Tell Me Feature
• Mini Toolbars and Contextual Menus
• Status Bar

8. Entering and Editing Data

• Basics of Entering and Editing Data in a Workbook
• Exercise 01
• Formatting Dates
• Formatting Numbers
• Exercise 02

9. Backup and Recovery

• AutoSave, Recover Unsaved Workbook, and Create a Backup Copy

10. Fill and Series

• Working with Fill and Series
• Flash Fill

11. Viewing and Printing

• Workbook Views, Zoom, and Freeze
• Printing
• Exercise 03

12. Cut, Copy, and Paste

• Methods of Cutting, Copying, and Pasting

13. Formatting a Worksheet

• Delete and Clear
• Insert, Hide, Column Width and Row Height, and Merge
• Alignment
• Themes and Styles
• Exercise 04

14. Formulas and Functions

• Basics of Formulas and Functions
• Complex Examples of Formulas
• Exercise 05

15. Managing Worksheets

• Worksheet

16. Working with Multiple Workbooks

• Working with Multiple Workbooks

17. Saving Workbooks

• Saving in Different File Types

18. Proofing

• The Spell Checker

19. Inserting Comments

• Inserting Comments
• Exercise 06

20. Basic Functions in Excel

• The VLOOKUP Function
• Text Functions
• Date and Time Functions
• Logical Functions

21. Graphs and Charts

• Creating Graphs and Charts
• Customizing a Cluster Column Chart
• Customizing a Pie Chart
• New Chart Types in Excel 2016
• Exercise 7

22. Sorting and Filtering Data

• Managing Data by Sorting
• Managing Date by Filtering
• Customizing Tables

23. Shapes and Pictures

• Inserting Shapes and Pictures
• Exercise 08

24. Formatting Cells Based on Content

• Conditional Formatting

25. Protection and Security

• Protecting Worksheets
• Protecting Workbooks

26. Naming Items

• Giving Items Names
• Exercise 09

27. Finding and Replacing Words

• Find and Replace

28. Borders

• Adding Borders

29. Workbook Inspection

• Inspecting a Workbook

30. Privacy Options

• Trust Center Privacy Options

31. Sharing Options

• Sharing a Workbook

32. Conclusion

• Conclusion and Close