Data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
Tips for mouse and touch screen users.
Graphs and charts using templates or custom designs.
SkyDrive and other tools for sharing work.
Pivot tables and slicing.
Working with flash fill.
Bonus exercise files.
Working with dates and times
Averages, percentiles, and LINEST functions
Inserting and formatting tables
Sparklines and data bars
Inserting images and videos directly from the internet
Opening and editing PDFs
Read mode, resume reading, object zoom, and collapsible headings
Protecting data with back-up and AutoRecover
Sharing work through email, blogs, and SkyDrive
Document security and editing restrictions
Setting up email accounts, POP and Gmail
Using touch devices
Calendar appointments and attachments
Tasks and reminders
‘Sneak a Peek’ and workspace customization
Archiving and the Trust Center
Spam and junk mail removal