This course teaches the basics of creating, editing, and sharing presentations with Microsoft PowerPoint. You will learn how to build a slideshow from scratch, or leverage PowerPoint templates and themes for quick construction. We’ll show you how to add and edit text, images, graphs, video, and animation; format slides for consistency; and add speaker notes to ensure a smooth delivery.
In this class, you will learn to send and receive e-mail, to work with contacts, calendars, task lists, notes, and the journal. You will connect to your social media, cloud, and other mail accounts and we’ll give you tips on how to quickly and efficiently read, organize and send your mail.
This one-day course teaches you the basics of work books and work sheets. You will learn how to enter and format data, text, and formulas; how to use pre-defined functions for basic calculations; and how to avoid errors. You will also learn how to organize and manage lists and tables (including sorting, filtering, and analyzing).
With this intermediate Excel course you’ll really ramp up your productivity. Using robust formulas and surprisingly simple techniques, you will be slicing and dicing to discover the power of data analysis. You’ll create Pivot Tables, build fully functional financial dashboards, and complete relevant exercises. At this level, Excel is an eye-opener.
Are you an advanced Excel user? Do you need to consolidate data from several worksheets, work with external data, or perform What-IFs? Would you like to learn how to use macros or create rolling charts? This two-day course will teach you all that and a whole lot more with sought-after techniques and formulas. Where the entire class is using Excel 365 or later, you will be introduced to the exciting new Dynamic Array formulas.
Dynamic Arrays are the most significant enhancement to Excel in years. Traditional array formulas (one formula, multiple results) have always been possible but they’re complicated and cumbersome to use, and usually require careful replication. New functions you will learn include: XLOOKUP, UNIQUE, FILTER, and SORT. Now, with Dynamic Arrays, formulas are simpler and easier to manage, and they usually require no replication at all. Dynamic Arrays are available to users of Excel 365 or later.
Pivot Tables – one of the most powerful features of Excel – allow large amounts of data to be summarized and analyzed with just a few mouse clicks, and without any formulas. You'll be able to drag and drop fields directly into a Pivot Table to change your report layout to whatever you want, whenever you want. This one-day workshop culminates in building a sophisticated, yet uncomplicated dashboard that communicates financial information with power and ease you never thought possible.
Picture a dazzling presentation. Then make it happen with Keynote. Easy‑to‑use visual tools and the intuitive interface put everything you need front and centre. This class is completely hands on. You’ll work along with the instructor and then create a presentation on your own..
| Number of students |
|
1 person $449.00 CAD
2 people $898.00 CAD
3 people $1,347.00 CAD
|
| Preferred date |
In this one-day course you will learn how to create accessible PDF files using Adobe InDesign and Adobe Acrobat. The course is hands-on throughout, offering useful tips, current standards for compliance, and lots of practice.
In this workshop, you will learn everything you need to know about cutting with Premiere Pro, interacting dynamically with other Adobe applications, and outputting to multiple formats. We’ll practice core editing skills, workflows, and technologies professional editors use every day to produce media for broadcast television, DVD, and the web.
