Excel Online Seminar - Tips, Tricks and Techniques

These three sessions will walk you through productivity-enhancing tactics in Excel, building from foundational tips into more advanced techniques that will allow you to customize Excel to your specific needs, calculations and more. Regardless of your skill level, you’ll learn something valuable. And a recording of each seminar will be provided to the attendees - so you can go back and review what you've learned. If you’ve never taken formal Excel training these are can’t-miss sessions that will provide you with immediately relevant skills. The three chapters will cover: 

Productivity Tips & Tricks; Formatting Essentials: July 16th

  • Tips and tricks such as freezing panes, split windows, selecting cells with special characteristics, adding date and time stamps, the clipboard, and how to use these to increase productivity
  • Formatting techniques; including multiline column headings; custom date and number formats; and conditional formatting

Customizing Excel; Formula Building Essentials: July 17th

  • Customizing Excel for your specific uses, including customizing the ribbon, the quick access toolbar and using templates to increase productivity
  • Use formula building tools, such as the formula tab, splitting and combining text strings, conditional calculations, VLOOKUPS and HLOOKUPS, and using the text to columns wizard

Three-dimensional Workbooks; Printing Essentials: July 18th

  • Linking data from multiple workbooks; handling broken links; combining workbooks; and creating sum-through formulas and rolling reports
  • Expertly print data from Excel, including adjusting settings, using the camera feature to create report forms, and working with custom views

How to Register for this Webinar:

  1. If you do not yet have a CITT account, click here to create an account. If you already have an account, you'll need to be logged in. If you aren't already logged in, please use the "Sign In" fields to the right. If you've forgotten your login information, you can click here to retrieve your username or reset your password here.

  2. Once you're logged in, click on seminar session you would like to attend. Note: you can choose to attend the full three session package option, individual sessions or a combination of two sessions. Please click on the appropriate check box to select your program. 

  3. If choosing individual or a combination of sessions please double check in the Program box that you have selected the correct options. 

  4. Then click the green Register Myself button

  5. Click the green Proceed to Checkout button

If you need any help registering, please contact Marysa at mmackinnon@citt.ca.

When
7/16/2019 12:00 PM - 7/18/2019 1:30 PM
Where
Online Online

Sign In