Learning Options:

Live webinar with chat
includes 60 day replay*
12:00 pm – 1:30 pm (Eastern)

Important!
All times are based on Toronto, Ontario.
Please check the corresponding time in your location for the webinar date, as time differences across Canada vary seasonally.

*This program features real-time video of the presenter with synchronized presentation slides, and a chat feature that allows for live Q & A.

Groups Save!

Register 3+ attendees and save up to 25%. See our group discounts here. Contact jennifer@seminarpartners.ca.

Technical Information:

Live webinars allow you to view faculty, see their presentation slides, and ask questions by chat. You will need a current web browser (Chrome (Chrome works best), Safari, Firefox), a wired (better than wireless) connection to the Internet of at least 2 Mbps. You can test your internet speed/bandwidth here. If you miss the live program, you can access the archive, at your convenience, for 60 days.

Who Should Attend

Lawyers and legal professionals who are comfortable with basic Excel skills, including entering and formatting data, creating simple formulas, and sorting and filtering information.

About the Program

You know the basics of Microsoft Excel—but are you making the most of what it can do for your law practice? Excel can do much more than organize information and perform simple calculations. With a few additional skills, you can automate routine tasks, manage financial information, retrieve client details and reduce the time spent entering and updating data. Join Master Microsoft Office Instructor Frank Byl for this practical intermediate course designed to take your Excel skills to the next level.

Using law-related examples, Frank will teach you how to:

• Create spreadsheets that automatically accommodate new information without having to continually adjust formulas
• Use financial functions to calculate payments, interest and other amounts
• Automatically calculate and categorize assets, expenses and other financial information
• Use formulas and checkboxes to automate calculations based on specified conditions
• Automatically organize, sort and extract information from lists
• Create drop-down menus to simplify data entry and reduce errors
• Automatically retrieve client addresses and other information simply by selecting a name from a list

Discover how to make Excel do more of the work for you! Attendees will receive practice exercises as part of the course materials. Access to a second screen may be useful during the program.

Schedule (Eastern)

12:00 pm - 1:30 pm

Welcome and Introduction

Building Smarter Spreadsheets

Automating Financial Calculations

Organizing and Retrieving Information

Wrap-up and Program Evaluation

Praise for Frank Byl

“Presenter was very knowledgeable and comfortable with the subject matter.”

“This was one of the best and most useful seminars that I have attended in a long time.”

“Thanks, great program.”

“Good program and presenter.”

“Very good basic course. Excellent speaker.”

“Great instructor. Hands-on, technical courses like this are so helpful. More please!”

“The instructor was very friendly and put everything in easy terms to understand.”