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
()
Ex_Files_UaR_Excel2016.zip
(410 KB)
Glossary_Learning_Excel_2016.zip
(102 KB)