Forgot your password?
No account yet? Start here
Shopping is always safe and secure
In this hands-on, in-person, instructor-led class, you will learn to write macros to create pivot tables and charts, utilize advanced nested text, lookup, date and array formulas and advanced comparison of multiple lists.
Learn how to reduce hours of repetitious tasks, send mass emails, letters and labels from your Outlook contacts, Excel databases and other databases, eliminate page numbering bulleting problems and easily track changes from multiple people and documents.
A hands-on course providing an in-depth view of the features and functionality of Microsoft Access. Students will be introduced to relational database funda- mentals and concepts of database design. Participants will learn how to create, view, and modify queries as well as viewing queries in SQL and running it in VBA.
In this hands-on, in-person, instructor-led class, students will create a relational database in Access, define and populate a data table, modify table structure and fields, view and maintain data using queries and forms and create summary fields in queries, forms and reports.
This hands-on PMP Certification program will prepare you for the PMP exam. Concentrating on PMI's actual PMP exam content from the Guide to the Project Management Body of Knowledge-Fourth Edition (PMBoK Guide) and other sources, this program features a wide variety of proven learning tools and study aids.
Along with configuring and using Project Server 2013 for portfolio management and project governance, you learn best practices for managing enterprise projects using Project Server 2013 from creating projects, gathering tracking information, updating progress, and analyzing variance to working with issues, risks, deliverables and business intelligence tools for projec
Taking a class for work? Access exclusive perks and savings for free.
Learn More »
Students learn to work with SharePoint, customize project sites, manage Project Server tracking settings, add and manage metadata in both SharePoint and Project Server, configure portfolio management elements, build a workflow, and the basics of improved decision support using portfolio management tools.
This course is designed to instruct students how to proficiently use MS Word 2010 for word processing. The course follows skills measured on the Microsoft Office Expert Exam 77-887.
We will introduce students to the use of SQL queries for data analysis, keeping the focus on analysis by using a graphic SQL program (MySQL workbench). We will learn enough query syntax to perform basic analysis and get students started on problems too unwieldy for spreadsheets.
After introducing or reinforcing the necessary Project Management concepts needed to properly manage projects in real-world environments, the workshop focuses on raising the participants’ skill and speed in the use of Microsoft® Project.
Learn how to create a reusable PowerPoint Template, make an easily updatable, engaging, consistent presentation, deliver a presentation without difficulty and feel comfortable with importing any type of file.
This course is designed to instruct students how to use Excel 2010 more proficiently. The course follows skills measured on the Microsoft Office Specialist Exam 77-882. Each topic covered will be followed by a review and hands-on exercises for retention. Quick Reference guides are given out in class and practice files are copied to each student’s computer. Topics to
This course is for students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web.
This seminar is intended for more experienced Project Managers, already well-versed in the concepts and techniques needed to properly manage projects in real-world environments.
The advanced Excel training is for those who need to learn beyond the basics. Keyboard shortcuts, functions like If, SumIfs, IfError, Vlookup, Index, Match, Subtotal, Trim, Concatenate, data analysis features like pivot tables and charts, data validation, and macros are introduced.
GET IT FIRST. SIGN UP FOR UP-TO-THE-MINUTE-OFFERS, SALES AND NEWS