Excel formatting tools: Adding eye-catching elements

Learn how to use Excel to create interesting and impactful financial reports.

Event Details

Location and date:
Online On-Demand Event

When you invest time and effort into creating a financial report, you want to make sure it gets read. With Excel Formatting Tools: Adding Eye-Catching Elements, you will learn how to use Excel to develop more vibrant and professional-looking reports.

Discover tips and tricks for making more appealing and easy-to-understand diagrams, workflow charts, equations and more. This course is filled with techniques to help you better engage your readers so that you can do more than just present numbers — you can deliver the message.

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:

  • importing and manipulating images
  • using drawing objects to create flowcharts
  • inserting and manipulating SmartArt diagrams
  • building dynamic conditional formats to:
    • highlight cells based on defined rules
    • add collapsible outline groupings to rows and columns
    • define customized views to control who sees what
  • using outlining commands on your spreadsheet
  • creating and managing custom workbook views

Who should attend?

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

More Details:

Session Descriptions

Introduction
Welcome

Photo images in Excel
• What We Will Cover
• Working With Pictures in Excel
• Generating Marketing Collateral in Excel
• Formatting Photos and Adding Clip Art
• Screen Clippings and Background Insertion
• What Have We Done

SmartArt
• Working With Drawing Tools in Excel
• Creating SmartArt
• Formatting SmartArt
• What Have We Done

Drawing tools
• Working With Drawing Tools in Excel
• Creating a Flowchart in Excel
• Connecting Your Flowchart
• Grouping and Formatting Drawing Objects
• Creating WordArt in Excel
• What Have We Done

Equations and symbols
• Working With Equations and Symbols
• Using Equations and Symbols in a Report
• Inserting the Copyright Symbol
• Building an Equation in Excel
• Using Spell Check, Thesaurus, and Translation
• What Have We Done

Custom number formatting
• Working With Custom Number Formatting
• Using Custom Number Formatting
• Using Custom Formatting for Variances - Part 1
• Using Custom Formatting for Variances - Part 2
• What Have We Done

Conditional Formatting
• Working With Conditional Formatting
• Using Conditional Formatting
• Highlighting Key Values
• Using Formulas With Conditional Formatting
• Understanding Precedence
• Managing and Customizing Formatting Rules
• What Have We Done

Worksheet views
• Working With Outlining and Custom Views
• Building and Modifying Worksheet Views
• Creating Custom Views
• 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

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.

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

You’re in the eye of the storm amid a swirl of slips, forms and receipts. Chart your way through tax-time turbulence with these updates and resources.