In this hands-on course, we’ll show you how to use Microsoft Project to schedule and manage projects both large and small. Set up projects, add and link tasks, assign resources, fix scheduling issues, deal with resource conflicts, and track project progress.
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.
No matter where your data comes from – whether it’s a small or very large data set – you can connect, clean, analyze, and share your data faster using Power Query. This course guides you through the essentials of data extraction and transformation, teaching you to seamlessly integrate data from multiple sources and transform the time-consuming chore of data preparation into an efficient, automated process.
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.
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.
For many, learning how to use Photoshop effectively is an essential part of their job. This comprehensive course covers all the basics plus features like masking, colour correction, sharpening (the correct way), and compositing -- things a marketing pro needs day to day. The most amazing things are the new time-saving features (where you click once and save 20 minutes on some common tasks). We’ll give you lots of practice to be sure you remember the lessons learned.
The good, the bad, and the ugly — nearly every photograph can benefit from retouching. In this course, we'll teach you how to turn good photographs into showstoppers! You will learn to make seamless changes, realistically enhancing your images for breath-taking results. The course features both portrait retouching and compositing (adding, altering and removing elements from images).
This course is for existing InDesign users who want to increase their speed and proficiency by learning the most advanced features. The course material is customized to suit the people attending.
Illustrator has a lot of unique drawing features. We’ll focus on the basic ones here -- the ones you will use often. After this workshop you can start using Illustrator, with complete confidence, to create logos, illustrations, floorplans, posters, and banners. Students are encouraged to tell us of special requests. Prerequisite: Basic computer skills.