Excel Online Seminar - Boot Camp

If you are ready for six sessions of intensive Excel training in a “laptop optional, laptop friendly” environment, then this course is for you. By using accounting-centric examples, developed for accountants, by accountants, Excel Boot Camp takes you through Excel from A to Z and shows you how to elevate your use of Excel to the next level. In addition to long-standing features in Excel such as lookup functions, the Camera tool, and formatting options, this program will highlight the number of recent improvements to Excel including additions to the function library, tables, a vastly improved charting engine, and an overhaul of PivotTable functionality. You will also learn various techniques for enhancing, not only your efficiency, but also your effectiveness, when working with Excel by taking advantage of a wide variety of “power features” to assist you in creating accurate spreadsheets in a fraction of the time previously required.

Upon completing this course, you should be able to:

  • Implement various tips, tricks, and techniques in Excel to address issues, such as formatting, AutoCorrect, handling dates and times, and selecting cells with special characteristics
  • Utilize Excel’s formula-building tools
  • Identify how and when Excel’s table feature should be used
  • Create and audit complex formulas, including those containing arrays and SUMIFS, VLOOKUP, HLOOKUP, INDEX, and MATCH functions
  • List and apply various techniques for securing Excel workbooks
  • Create charts in Excel that captivate audiences and communicate messages effectively
  • List the six components of PivotTables and create PivotTables, including PivotTables that perform user-defined calculations
  • Implement Excel’s Camera function to assist in creating custom reports
  • Utilize Excel’s Macro Recorder tool to create simple, yet very useful, macros that you can put to work right away

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 Jennifer at  jtraer@citt.ca.

When
5/19/2020 11:30 AM - 5/28/2020 1:00 PM
Where
Online Online

Sign In