Live Instructor-Led Training
The course Multi-project Integration & Management (MS Project Training) teaches you how to manage multiple projects with Microsoft Project Pro. The training includes project team management, resource planning & tracking, shared resource configuration, cost & time management and more. The course covers basic & advanced MS Project configuration. The use of MS Project to coordinate resources for multiple projects is discussed in detail.
Nov 4 - 5, 2024$1,500.00
Review of Essential Skills: Getting Started
Creating the Project
Creating a Schedule
Setting up Resources and Task Assignments
Tuning the Schedule
Tuning Tasks
Modifying the Project
Exercise: Creating the Project
Project Schedule Optimization
Making Time and Data Adjustments
Working with the Critical Path
Task Start Delay
Working with Assignment Contours
Compressing the Schedule
Working with the Calendar View
Working with Task IDs and WBS Codes
Working with Network Diagrams
Exercise: Optimizing and Presenting the Project Schedule
Managing Multiple Projects
About Consolidated Projects
Creating Task Relationships between Projects
Managing Time
Managing Costs
Best Practices
Exercise: Managing Multiple Projects
Resource Pools
Developing a Resource Pool
Viewing Assignment Details
Working with a Sharer File
Updating Resource Information
Updating Working Time for Multiple Projects
Adding New Project Schedules
Exercise: Creating a Resource Pool
Microsoft Project Application Integration
Using Graphical Indicators
Working with the Timeline View
Publishing Data the Project Server
Exporting Data to Relational Databases
Exporting Data to Microsoft Excel and Word
Importing External Data into Microsoft Project
Exercise: Exporting Data to Excel
Excel Training: Data Analysis for Business Users
The course Data Analysis for Business Users (Excel Training) teaches you to organize, analyze, validate and present data using Microsoft Excel. Starting with data layout, the course explores basic and advanced functions. The training includes a detailed discussion of conditional, math & logic functions, PivotTables, Charts and a comprehensive introduction to Macro development.
Training course titled Excel Training: Data Analysis for Business Users that will allow you to hone your professional skills.
Oct 21 - 22, 2024$1,500.00Nov 18 - 19, 2024$1,500.00
Business Writing Training: Creating Documents that Work
A document that excites and motivates the reader can make the difference between project success and project failure. In today’s information rich workplace, a well written document that moves the reader to action is key. But well written technical documents don’t just happen. They are created by well-organized, informed and knowledgeable writers. equips the business professional with the necessary tools and strategies to plan and create technical documents that inspire, inform, motivate and facilitate decision making. The course Creating Documents that Work (Business Writing Training) teaches you to write documents that communicate & deliver. Technical documents do not need to be long, complicated and obtuse.
Training course titled Business Writing Training: Creating Documents that Work that will allow you to hone your professional skills.
Nov 4 - 5, 2024$1,500.00
Excel Training: Analysis & Reporting for Finance
The course Analysis & Reporting for Finance (Excel Training) teaches you how to use MS Excel to present, analyze and format financial data. The training includes data layout, basic math & financial functions and advanced financial analysis with MS Excel. You learn about present value and future value, WACC, IRR, cash flow calculations & interest considerations. Become a financial wizard with MS Excel.
Training course titled Excel Training: Analysis & Reporting for Finance that will allow you to hone your professional skills.
Nov 5 - 8, 2024$3,750.00
Excel Training: Cells, Workbooks and Graphs
The course Cells, Workbooks and Graphs (Excel Training) teaches you how to work efficiently with cells, worksheets & workbooks. The training includes working with multiple worksheets, useful keyboard shortcuts & functions, absolute & relative references and custom functions. You learn to set your data so that it can be easily sorted and filtered. The course also covers how to create, edit & format graphs in MS Excel. Maximum productivity is within your grasp with Microsoft Excel.
Training course titled Excel Training: Cells, Workbooks and Graphs that will allow you to hone your professional skills.
Nov 11 - 12, 2024$1,500.00
Excel Training: Data Analysis & Reporting
The course Data Analysis & Reporting (Excel Training) teaches you to analyze & report on data using Microsoft Excel. The course covers data layout using multiple Excel worksheets and custom & advanced functions. The training includes Excel graphs, PivotTables and the use of custom functions, sorting & filtering to analyze & report on data.
Training course titled Excel Training: Data Analysis & Reporting that will allow you to hone your professional skills.
Nov 4 - 5, 2024$1,500.00
Excel Training: Mastering Task Automation
The course Mastering Task Automation (Excel Training) provides business participants with the skills they need to automate almost any business task. Starting with a review of essential concepts in data analysis using Microsoft Excel, the course quickly proceeds to a complete and in depth study of macros and VBA development. The course covers every aspect of VBA development including the Excel object model, looping, functions, conditional logic and database access amongst others. If you need to use Microsoft Excel to automate your business tasks, this SETC certified course will teach you the skills you need. SETC Training - Formation SETC provides advanced Microsoft Excel training in Ottawa, Montreal, Toronto, Quebec and Calgary.
Training course titled Excel Training: Mastering Task Automation that will allow you to hone your professional skills.
Nov 6 - 8, 2024$2,250.00
Microsoft Access Training: Macros, Code & Automation
The course Macros, Code & Automation (Microsoft Access Training) builds upon the course Tables, Queries & More by showing you how to data access forms and associates data access code with MS Access. Participants learn how to build forms, develop macros and write supporting code. You will learn how to build data drive applications using MS Access. The 50:50 theory to practice ratio help you learn how to build real applications using MS Access
Training course titled Microsoft Access Training: Macros, Code & Automation that will allow you to hone your professional skills.
Nov 12 - 15, 2024$3,750.00
Microsoft Access Training: Tables, Queries & More
The course Tables, Queries & More (Microsoft Access Training) provides a solid introduction to creating tables and writing SQL queries. Participants learn to define table columns using Access standard data types and validation rules. Normalized data tables are creates and targeted using all available MS Access query types. The 50:50 theory to practice ratio help you understand how to design and implement data models using MS Access.
Training course titled Microsoft Access Training: Tables, Queries & More that will allow you to hone your professional skills.
Nov 6 - 8, 2024$2,250.00
Microsoft Word Training: Planning & Creating Documents
The course Planning & Creating Documents (Microsoft Word Training) show you how to plan and create business documents that inspire, inform and motivate. You will learn how to use advacned MS Word features such as styles, macros and templates to spend mpre time writing and less time formatting. The 50:50 theory to practice ratio help you learn how to build real documents in less time using MS Word.
Training course titled Microsoft Word Training: Planning & Creating Documents that will allow you to hone your professional skills.
Oct 23 - 25, 2024$2,250.00Nov 20 - 22, 2024$2,250.00
MS Outlook Training: Managing Email Messaging
The course Managing Email Messaging (MS Outlook Training) provides you with best practices and useful tips and tricks when working with Microsoft Outlook. Given the daily use of MS Outlook, the skills & knowledge that you gain in this course in organizing and working with emails, tasks and calendars will serve you well in maximizing your productivity at work.
Training course titled MS Outlook Training: Managing Email Messaging that will allow you to hone your professional skills.
Oct 21 - 21, 2024$850.00Nov 18 - 18, 2024$850.00
MS Project Training: Scheduling & Tasks
The course Scheduling & Tasks (MS Project Training) teaches you how to identify, structure & plan project tasks using MS Project Pro. Preliminary topics such as MS Project initial configuration & project structure are discussed. The training includes working with tasks & task links as well as creating a WBS & a critical path. You learn how to create a project team & how to define resource costs (work, cost & material resources). The course teaches you how to manage corporate projects using MS Project Pro.
Training course titled MS Project Training: Scheduling & Tasks that will allow you to hone your professional skills.
Nov 11 - 12, 2024$1,500.00
MS Project Training: Tuning, Tracking & Reporting
The course Tuning, Tracking & Reporting (MS Project Training) teaches you how track, tune & report on a project using MS Project Pro. Concepts such as resource crashing, time lags, scheduled delays & resource portfolio modification are included in the training. The course teaches you how to fine-tune a project schedule while you monitor and report on current project tasks using Microsoft Project. Manage projects like a pro with Microsoft Project Pro with this SETC Training Ottawa course.
Training course titled MS Project Training: Tuning, Tracking & Reporting that will allow you to hone your professional skills.
Oct 21 - 22, 2024$1,500.00Nov 18 - 19, 2024$1,500.00
MS Word Training: Styles, Refrences & Macros
The course Styles, References & Macros (MS Word Training) teaches you to produce professional documents using Microsoft Word. You learn how to work with styles & formatting to easily modify documents and how to use Macros & custom code to automate any task. The training includes how to add key elements such as table of contents, index & cross-references in MS Word.
Training course titled MS Word Training: Styles, Refrences & Macros that will allow you to hone your professional skills.
Oct 28 - 29, 2024$1,500.00Nov 25 - 26, 2024$1,500.00
MS Word Training: Text, Tables, Styles & Formatting
The course Text, Tables, Styles & Formatting (MS Word Training) teaches you to produce professional documents using Microsoft Word. You learn how to work with styles & formatting to easily modify documents. The training includes tips & tricks that will help you format MS Word documents quickly & easily. The course covers everything that you need to know in order to work with text & tables in MS Word.
Training course titled MS Word Training: Text, Tables, Styles & Formatting that will allow you to hone your professional skills.
Oct 21 - 22, 2024$1,500.00Nov 18 - 19, 2024$1,500.00
PowerPoint Training: Creating Professional Presentations
The course Creating Professional Presentations (PowerPoint Training) teaches you how to create PowerPoint presentations that pop. You learn how to make appropriate use of images, graphs, animation, transitions & sounds. The training includes advanced techniques such as working with multiple slides & designing the slide master.
Training course titled PowerPoint Training: Creating Professional Presentations that will allow you to hone your professional skills.
Nov 4 - 5, 2024$1,500.00
Professional Training: The Foundations of Graphic Design
The professional course titled Foundations of Graphic Design is a comprehensive study of the art and science of designing professional documents that communicate and inspire. Students will be introduced to the core principles of effective graphic design in creating high quality documents. The use of typography, space, graphical elements and more will be covered. The course also covers commonly made errors and best practices.
Training course titled Professional Training: The Foundations of Graphic Design that will allow you to hone your professional skills.
Nov 11 - 12, 2024$2,250.00
Visio Training: Mastering Graphics Creation
The course Mastering Graphics Creation (Visio Training) teaches you to create professional diagrams with MS Visio. You learn how to configure Visio, draw scaled & unscaled diagrams, group & ungroup objects, transform objects & more. The training includes tips & tricks that make working with MS Visio easier including selecting multiple object, using keyboard shortcuts, using visible grids, creating custom shapes & more.
Training course titled Visio Training: Mastering Graphics Creation that will allow you to hone your professional skills.
Oct 28 - 29, 2024$1,500.00Nov 25 - 26, 2024$1,500.00