2015
Lynda
David Rivers
1:10
English
This beginner-level course will introduce new users to Excel 2016. Author David Rivers covers the interface, creating and opening workbooks, entering text and numbers, working with formulas, basic formatting, inserting charts and graphics, and sharing and printing workbooks so that you have a great foundation in the world's most popular spreadsheet program.
Introduction
Welcome
Using the exercise files
1. Getting Started with Excel 2016
What is Excel?
Creating new workbooks and touring the UI
Adding text and numbers
Adding formulas and functions
Understanding cell references when copying and pasting
Using Auto Fill
Saving workbooks
2. Modifying Worksheets
Formatting text
Formatting numbers
Formatting dates and times
Managing rows and columns
Freezing panes
Merging cells
Inserting recommended charts
Inserting pictures
Applying themes
3. Sharing and Printing Workbooks
Sharing workbooks using online options
Sending workbooks as email attachments
Printing workbooks
Conclusion
Next steps
Download File Size:158.07 MB