Introduction to Excel: Journey to spreadsheet mastery

This is the agenda for Table of Contents
Table of Contents
 
Introduction

Welcome

 
Excel user interface

• What We Will Cover
• The Excel User Interface
• The Work Surfaces
• Ribbons and Menus
• Customizing the Ribbon and Quick Access Toolbar — Part 1
• Customizing the Ribbon and Quick Access Toolbar — Part 2
• Keyboard Navigation
• Keyboard Shortcuts
• Other Visual Elements
• What Have We Done

 
Basic navigation in excel

• Navigational Keyboard Shortcuts
• Selecting Ranges
• Entering and Clearing Data — Part 1
• Entering and Clearing Data — Part 2
• What Have We Done

 
Worksheet manipulation

• Data Relocation
• Manipulating Worksheet Structure
• Hiding Data
• What Have We Done

 
Formatting

• Formatting Elements
• Number Formatting
• Text Alignment Options
• Changing Fonts
• Borders
• Cell Fills
• Copying Formats
• What Have We Done

 
Page layout and printing

• Basic Printing Setup
• Fitting Print Jobs to Specific Pages
• Advanced Print Job Setup
• Creating Custom Headers and Footers
• Other Sharing Methods and Creating PDF’s
• What Have We Done

 
Excel options

• General Excel Options
• Locating Excel Options and Add-Ins
• What Have We Done

 
Conclusion

• In Review
• Conclusion
• Final Quiz

Highlights

Gain practical organizational insights and learn from industry experts at this annual event for not-for-profit financial leaders.