Introduction to Excel: Beginning the journey to spreadsheet mastery

Discover the essential tools needed to further develop your learning in Excel and become proficient at creating spreadsheets.

Event Details

Location and date:
Online On-Demand Event

Creating effective spreadsheets comes down to having a solid handle on Excel. You can strengthen your expertise in this essential accounting software with Introduction to Excel: Beginning the journey to spreadsheet mastery.

This online course provides an overview of the Excel 2010 user interface, and explains areas you should understand long before you start working with formulas and power techniques. The resulting knowledge will enhance your accounting practice and allow you to better serve your clients or organization.

View Table of Contents

Additional options and pricing may be available. See pricing and registration for more details.



$209.00

3 CPD hour(s)
Pricing & registration

You will learn about:

  • the Excel user interface
  • entering, copying, pasting and clearing data
  • formatting data and copying formats to other cells
  • key windows and Excel keyboard shortcuts
  • formatting any document to print as desired

Who should attend?

  • advanced Excel users
  • IT professionals
  • business intelligence educators
  • consultants
  • financial analysts

More Details:

Session Descriptions

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

Speakers/Presenters

You may also be interested in:

Contacts

Please contact:

CPA Canada Professional Learning and Development Customer Service
Tel: 1-888-337-3242
Email: pld@cpacanada.ca

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.