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

Chartered Professional Accountants of Canada (CPA Canada) annually offers its views on priorities for the federal budget. Review past submissions of pre-budget briefs and consultations, and post-budget release opinions and commentary.

Our Firm Directory allows you to search for Canadian CPA firms using our interactive map as well as other criteria.

Jointly presented by CPA Canada and CPA Ontario, The ONE is the must-attend, multi-track event of the year, designed for all CPAs who want to be at the top of their game.