Live Instructor-Led Training
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.
Oct 28 - 29, 2024$1,500.00Nov 25 - 26, 2024$1,500.00
Working with Styles
The Importance of Styles
Learning What Styles to Use
Planning your Document: Character and Paragraph Styles
Creating Supporting Styles
Assigning Keyboard Shortcuts
Using Styles Consistently
Modifying Styles
Updating the Entire Document
Exercise: Creating a Style Based Document
Working with objects
Introduction to Objects in Microsoft Word
A Note on Object Linking
About Object Pinning
Managing Object Text Wrapping
Working with Clip Art Images
Working with Graphical Elements
Working with External Documents
Working with Excel and-or Access Data
Working with Smart Art
Exercise: Creating a Presentation using External Data
Text References
About Text Citations and References
Making Use of Bookmarks
Adding Footnotes and Endnotes
Working with Captions
Adding Cross-References
Managing Captions and Bookmarks
Exercise: Working with Captions and Cross-references
Document References
The Document Referencing Features of Word
Setting up the Document for Automatic Generation
Creating and Formatting a Table of Contents
Creating and Formatting a Table of Figures/Tables etc.
Creating and Formatting Indexes
Exercise: Creating a Table of Contents and Table of Indexes
Creating Custom Fields
Introduction to Fields
Working with Date and Time Fields
Working with Document Information Fields
Working with Numbering Fields
Custom Field Formats
Creating Custom Fields
Exercise: Using Fields to Polish a Document
Introduction to Macros
Showing the Developer Tab
Understanding the Structure of a Macro
Creating a Custom Function for Word
Iterating through all Paragraphs
Creating a Simple Macro
Exercise: Creating a Simple Macro
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: Multi-project Integration & Management
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.
Training course titled MS Project Training: Multi-project Integration & Management that will allow you to hone your professional skills.
Nov 4 - 5, 2024$1,500.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: 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