QED specializes in teaching Microsoft Office for the Petro-Technical. Our courses are customized to reflect the technical work performed in the Petroleum Industry, and allow you to leverage software currently on your computer to add value immediately to your team. Click on Microsoft Office course title to view description and upcoming class dates.
301 Basic Excel // $650
This 1-day class teaches you how to utilize basic and advanced functions to manipulate typical oil and gas industry data. Unlike other Excel courses, we use real oil and gas data and standard formats. This course allows for a new view of Excel and the power in its functions. Click here for availability.
302 Excel Wizardry // $650
This 1-day course provides an overview of pivot tables, macros, subtotals, V-lookups, etc. leveraging typical oil and gas industry data to perform analysis and draw conclusions. From simple tasks like finding top operators or reservoirs in an area, to complex tasks like converting lease operating statements from text, this class uses real oil and gas industry data and introduces you to the world of large scale data manipulation. Click here for availability.
303 Access For the Petro-Technica l// $1,200
This 2-day course is a comprehensive overview of relational databases within Microsoft Access. DBMS are discussed along with database structure and design. Topics covered include tables, linking tables, queries, forms, and reports. Industry specific examples are utilized to understand large scale data manipulation in commonly used proprietary software. Click here for availability.
402 VBA for The Petro-Technical // $1,200
This 2-day course requires Excel Wizardry and Access for the Petro-Technical as a pre-requisite. This class will cover analytical and statistical formulas, conditional formatting, and automating routine processes within the petro-technical role. Discussion regarding servers and database systems will be discussed with reference made to common industry tools. A tool kit of basic macros will be provided for individual use at the successful completion of the course. Click here for availability.
108 PowerPoint 2010 Basic// $350
This is an introduction to Power Point 2010 covering the basics in slide preparation. Click here for availability.
208 PowerPoint 2010 Intermediate // $350
This builds upon the Basic PowerPoint class and includes topics such as: Using a Template, Inserting an Excel Table, Adding Effects, Legends and Labels, Inserting a SmartArt Graphic from a Slide, Changing Diagram Types and Design Schemes, Adding a Text Box, Inserting ClipArt, Updating a Photo Album, Insert Movie from the Clip Organizer or File, Sound Tools, and Add and Draw Motion Paths. Click here for availability.
308 PowerPoint 2010 Advanced // $350
This course teaches students the advanced features of PowerPoint. Students will learn how to add multimedia to their presentations, and how to edit their video and audio files from within PowerPoint; how to set up and use slide masters; how to review presentations using comment and comparison tools; and finally, students will learn how to set up monitors, rehearse timing, create custom shows, as well as record, broadcast, and create video from their slide shows. Leaving practically no feature unexplored, users will be able to create and present dynamic presentations. Click here for availability.
109 Outlook 2010 Basic // $350
Microsoft Office Outlet 2010 training material courseware will expand on existing functionality and introduce new features including: Ribbon Interface, Calendar Overview, Conversation Features, Quick Steps, Multiple Exchange Server E-mail Accounts, Integration with Microsoft Officer Communicator, and social networking, Support for Text Messaging and Improved Search Functionality. Click here for availability.
209 Outlook 2010 Intermediate // $350
Staying connected with colleagues, customers, clients, and employees through email is essential to remaining up to date with business and organizational activities. Office Outlook 2010 enables users to access a personal calendar, create, send, and manage e-mail, manage an address book, keep track of their to-do list and schedule appointments. Making sure that your personnel are taking advantage of these features is the best way to ensure positive communication results. Our training materials for Office Outlook 2010 provide students with a comprehensive learning resource to maximize their capabilities using the program. Click here for availability.
309 Outlook 2010 Advanced // $350
Advanced Outlook 2010 training teaches students how to use advanced e-mail, calendar, task, contact management, and view features; custom forms; set up and use the new Social Network Connector; manage personal folders and profiles; the Trust Center; and the Outlook Address Book. Click here for availability.
111 Publisher 2010 Basic // $350
Discover, and learn how to create amazing pieces of work from start-to-finish. This course guides you through how to create, modify, save and print. Click here for availability.
211 Publisher 2010 Intermediate // $350
Intermediate Publisher 2010 training teaches students how to work with publisher files; incorporate their business information into their publication; package and send their publication; work with templates; use the formatting and language tools available to them; and how to spice up their publications by working with shapes, illustrations, and adding images. Students will be able to create a new publication from scratch, add and format tables and images, and transfer their publication once it’s all done. Click here for availability.
311 Publisher 2010 Advanced // $350
Section one focuses on how to create and use master pages in order to create consistent publications. It also discusses how to create, edit, and use styles, and introduces typography tools that can add that extra touch of class to publication fonts. Section Two is all about Building Blocks. These pre-designed elements allow you to create or enhance publications in no time by providing themed, customizable page elements. Section Three discusses the often-misunderstood world of mail and catalog merges. Participants will learn how to correctly and effectively use these tools to create personalized mail-outs and catalogs. Section Four will cover tools like the Graphics Manager and Design Checker in order to help participants ensure their publications are correct and consistent. This section also discusses commercial printing topics and common customization settings for Publisher. Click here for availability.