Microsoft Project Certifications

(1)

www.iil.com • +1-800-325-1533 or +1-212-758-0177 • Visit our website for the latest course schedules.

63

www.iil.com

Microsoft® Project Certifications

IIL and Microsoft: a Rich History

Beginning in 1998, IIL has been offering “Belt” certification for Microsoft Project. Since that time, we have certified almost 7,000

practitioners. Beginning with the 2007 version of Project and Project Server, IIL helped Microsoft develop its own certification

program, which consists of three credential exams. In addition, Microsoft selected IIL to develop the Microsoft Official

Curriculum (MOC) for this new certification.

IIL’s Project Belt Courses

IIL’s Project Belt courses prepare project managers for Microsoft Official Certification(s). Our series of Belt courses is progressive,

with successful completion of one Belt course (or the equivalent) being a prerequisite to enrollment in the next level.

Project White Belt® earns you IIL’s White Belt Certification and complements Project Orange Belt® in preparing you

for the Microsoft Certified Technology Specialist (MCTS) credential. This course is targeted to individuals relatively new

to scheduling.

Project Orange Belt is a bit more advanced, equipping you with the knowledge and skills to build, maintain and control

well-formed project plans. The Orange Belt course fully prepares you for the MCTS exam.

Project Blue Belt® teaches you how to initiate, plan, execute, monitor and control enterprise projects using the Project

Server Enterprise tool.

Project Black Belt® addresses the management of complex projects using Project Server and Project Professional.

Microsoft Project and Project Server 2010

IIL’s Project 2010 courseware will focus on best practices gathered from thousands of customers and trainers around the

world. We will offer our full Belt curriculum, including White, Orange, Blue and Black Belt courses, as well as courses on Utilizing

SharePoint® for Project Management.

Project White Belt 2010 will be available in May 2010, and we will subsequently roll out the rest of our Belt courses as follows:

Project Orange Belt 2010 in October 2010; Project Blue Belt 2010 in March 2011; and Project Black Belt 2010 in June 2011.

Microsoft Excel

Two new Excel® courses - Microsoft Excel in Depth and Microsoft Excel Visual Basic® for Applications - will help you

deepen your understanding of the intricacies and capabilities of Excel.

•

• IIL is a Gold Certifi ed Partner for Microsoft, and we are dedicated to

providing individuals, teams and companies with the training they need

to successfully manage projects and programs using the Microsoft

Project and Project Server solutions.

We keep our courseware aligned with the needs of the advancing

project manager, as well as those of progressive organizations looking

to be competitive in the global marketplace by increasing their project

management maturity level and capabilities.

Leverage the power of our wholly-owned network of IIL companies, strategically located all over the world. We have deep experience working in different languages, cultures, countries and industries and are proud to be the training solution partner of choice for many top global companies. Find out what we can do together! Contact your local IIL company (listed on the back cover of the catalogue) or email us at [email protected].

Microsoft®, Excel® and Visual Basic® are registered trademarks of Microsoft Corporation in the United States and other countries. Project White Belt®, Project Orange Belt®, Project Blue Belt® and Project Black Belt® are registered trademarks of International Institute for Learning, Inc.

(2)

ON-DEMAND LEARNING: Set your own pace

with a recorded online version of this course and log on when and where you learn best.

TRADITIONAL CLASSROOM: Engage with our

instructors and a diverse group of peers in a Traditional Classroom version of this course.

VIRTUAL CLASSROOM: Dynamic and fully

interactive, a live, online version of this course is led by an instructor and conducted in real time.

Take advantage of the fl exibility, customization, focus and control that onsite training off ers and let us tailor a course or program to align with your company’s mission, values and unique business needs. We can deliver any course to your team or organization in a private format - at your location, at one of our training sites or in a virtual setting. Email us at [email protected] for a free consultation today or visit www.iil.com/onsite for more information.

M

ic

ro

so

ft

®

P

ro

je

ct

C

er

tif

ic

at

io

ns

Project White Belt® 2010

Getting Started with Microsoft® Project 2010

#8955 / Four 3-hour sessions CEU Credits: 1.2 / PDU Credits: 12 Price: USD 850

IIL/University Price: USD 1050

#8288 / 2 Days

CEU Credits: 1.4 / PDU Credits: 14 Price: USD 1295

This workshop serves as an introduction to scheduling using Microsoft Project. It is suitable for anyone with a need to use scheduling software such as team members, planners, project leaders, project managers or other scheduling practitioners.

This workshop is kept up to date with the framework of knowledge outlined by the Project Management Institute’s (PMI®’s) Practice Standard for Scheduling and A Guide to the Project Management Body of Knowledge (PMBOK® Guide).

This course will be led by an IIL certified instructor who will outline the benefits of the software, provide tips on using various features and common shortcuts, recommend guide-lines and discuss the application of scheduling concepts to manage project work. Participant materials include a comprehensive workbook with screen captures of various software fea-tures for ease of reference after class. Prerequisites

There are no prerequisites for this course Course Level

Basic

Who Should Attend

Anyone new to Microsoft Project Individuals who would like to learn more about the scheduling process using Microsoft Project

Individuals on a project management career path who need to sharpen their skills in scheduling

Excel® and SharePoint® users

What You Will Learn

You’ll learn to:

Define key scheduling concepts and terms Effectively navigate the user interface and interpret common views

Configure essential elements of a new schedule

Enter and modify a task list

Record unplanned or partially planned activities

Set dependencies between tasks Create a resource list and generate assignments • • • • • • • • • • •

Apply individual and global formats to views and charts

Create a summary or executive timeline Prepare the schedule for printing, reporting and sharing through other file formats

Course Overview

Getting Started Introductions Course structure

Course goals and objectives

Scheduling Concepts

Project management concepts Scheduling concepts The Critical Path method

Navigating the User Interface and Views Working with the ribbon

Working with the quick access toolbar Setting general and display options Gantt chart view

Calendar view Network diagram view Getting help

Hands-on exercise Setting up a New Schedule

Creating new schedules - From existing files - From a template - From a SharePoint task list - From an Excel workbook Providing the schedule start date Working with the standard calendar Hands-on exercise

Entering, Modifying and Outlining Task Data Entering and correcting task activities Entering an unscheduled task Techniques for entering estimates Organizing tasks

Outlining tasks

Adding supplemental text Hands-on exercise

Creating Dependencies by Setting Links Dynamic schedules and dependencies Methods for linking tasks

Switching the scheduling mode Hands-on exercise • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • •

Entering and Assigning Resources Resource planning

Creating a list of available resources Techniques for assigning resources Displaying task costs

Hands-on exercise Formatting Gantt Chart View

Single and global text formatting Single and global Gantt bar formatting Working with Gantt chart styles

Adding drawings/objects to the chart area Hands-on exercise

Communicating Information Creating a basic timeline view Rich data exchange

Printing views Creating basic reports

Creating Excel, PDF and XPS Files Hands-on exercise

Course Summary and Next Steps White Belt certification - Exam structure - Registering for the exam - Taking the exam - Certification award Recap of learning objectives

This course is also available for Microsoft Office Project 2007 and 2003.

Note: Courses in Microsoft Project also qualify as required education hours for the PMI-SP® (Scheduling Professional) certification (course information on page 45). Contact your education consultant or local IIL company for more information.

• • • • • • • • • • • • • • • • • •

#PA8955 / Four 3-hour sessions CEU Credits: 1.2/ PDU Credits: 12 Price: USD 850

Microsoft®, Excel® and SharePoint® are registered trademarks of Microsoft Corporation in the United States and other countries. Project White Belt® is a registered trademark of International Institute for Learning, Inc. PMBOK® is a registered mark of the Project Management Institute, Inc.

(3)

www.iil.com • +1-800-325-1533 or +1-212-758-0177 • Visit our website for the latest course schedules. www.iil.com • +1-800-325-1533 or +1-212-758-0177 • Visit our website for the latest course schedules.

icr

os

oft

_®

Pr

oje

ct C

ert

ific

atio

ns

#PA8955 / Four 3-hour sessions CEU Credits: 1.2/ PDU Credits: 12 Price: USD 850

This course provides participants with the knowledge and skills to build, maintain and control well-formed project plans as well as preparing them for the Microsoft Certified Technology Specialist (MCTS) exam. Prerequisites

A familiarity with key project management concepts and terminology is recommended, as well as basic Windows navigation skills and prior experience managing projects using Microsoft Project.

Course Level Intermediate

This course is intended for both novice and experienced project managers and schedulers, or any user of Project 2007 stand-alone desktop features (this course excludes Project Server features). Participants may be involved in or responsible for scheduling, estimating, coordi-nating, controlling, budgeting and staffing of projects and supporting other users of Project 2007.

You’ll learn how to:

Create a well-formed project schedule Assign resources to tasks

Understand task types and the schedule formula

Analyze resource utilization Track progress

Customize and format Project 2007 views Create project reports and analyze project, resource and task data

Manage multiple projects

Course Overview

Course goals and objectives How to Enter Data into Project 2007

Understanding the nature of projects Understanding Project 2007 file types Navigating the Project 2007 interface Getting help and guidance

Configuring options • • • • • • • • • • • • • • • •

How to Create and Set Up Projects Creating and saving projects Defining properties and options Creating and organizing the task list Importing data

Modifying and applying calendars Setting scheduling options Entering task estimates

Using a Program Evaluation and Review Technique (PERT) Analysis to estimate task durations

Linking and unlinking tasks Adding lag or lead time

Creating and modifying deadlines, constraints and task calendars Identifying critical tasks Working with task drivers

How to Work With Resources and Project Budgets

Introducing resources, assignments and budgeting

Adding resources to the resource sheet Creating and modifying resource assignments

Entering project budgets

Understanding Task Types and the Schedule Formula

Introducing task types and the schedule formula

Changing variables and predicting behavior Applying task types to produce predictable behavior

How to Analyze Resource Utilization and Track Project Progress

Introducing resource utilization concepts Viewing resource assignments, allocation and utilization

Managing resource availability Optimizing and leveling resource assignments

Working with baselines

Entering duration, work and cost updates Discovering variances

Troubleshooting and getting back on track How to Create, Customize and Format Reports

Selecting, editing and creating basic reports Configuring print and page setup options Setting options to correct printing issues Exporting reporting data

Creating and modifying visual reports • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • •

Formatting screen elements Creating and modifying templates, calendars, fields, tables, formulas, filters, groups and custom views

How to Manage Multiple Projects Introducing management of multiple projects

Creating consolidated views and master projects

Creating links between projects

Calculating single or multiple critical paths Saving and opening multiple projects Sharing resources and analyzing resource utilization across multiple projects • • • • • • • •

Project Orange Belt® 2007

Managing Projects with Microsoft® Office Project 2007

To attend this course, you will need to bring a laptop with Microsoft Office Project 2007 Standard or Professional edition with the latest service packs. You may obtain a trial version of this soft-ware from Microsoft. You will also need a CD-ROM drive and the power supply for your laptop.

#8960 / Six 3-hour sessions CEU Credits: 1.8 / PDU Credits: 18 Price: USD 1250

#4960 / 3 Days

#PA8960 / Six 3-hour sessions CEU Credits: 1.8 / PDU Credits: 18 Price: USD 1250

Managing Projects with Microsoft Office Project 2007

Prepares you for the Microsoft Office Project 2007 MCTS certification exam

Project Orange Belt® 2007

Project Orange Belt 2010 will be available in October 2010.

(4)

M

ic

ro

so

ft

®

P

ro

je

ct

C

er

tif

ic

at

io

ns

Project Blue Belt® 2007

Managing Projects with Microsoft® Office Project Server 2007

#8970 / Six 3-hour sessions CEU Credits: 1.8 / PDU Credits: 18 Price: USD 1250

#4970 / 3 Days

This course provides participants with the knowledge and skills to initiate, plan, execute, monitor and control enterprise projects by using the Microsoft Office Project Server 2007 enterprise tool. This is the second course in the Microsoft Office Project 2007 Official Curriculum series and covers the Microsoft Enterprise Project Management (EPM) Solution. It also prepares participants for Microsoft’s Server 2007 MCTS exam.

Prerequisites

Project Orange Belt® course is required before taking Project Blue Belt; however, participants may skip this if they can demonstrate successful completion of the equivalent Microsoft certification exam. Experience using Project 2007 to create project schedules

Experience with the Microsoft Windows XP® or Windows Vista™ operating system Experience with Excel®

Familiarity with key PM concepts and terminology in A Guide to the Project

Management Body of Knowledge (PMBOK® Guide)

Course Level

Intermediate/Advanced

This course is intended for experienced project managers and schedulers. These individuals are capable of managing projects in the Project 2007 EPM environment, including project and non-project efforts, risks, issues, documents, task progress and timesheets. These individuals should be familiar with key project manage-ment concepts and terminology found in the PMBOK Guide and should have advanced knowledge and capabilities with Project 2007.

You’ll learn how to: Initiate projects

Understand the project planning processes Plan projects through scope, schedule and staffing management plans

Plan resource assignments

Plan projects through cost, risk and other planning documents

Execute projects through processes, resources and deliverables

Execute projects by managing timesheets and personal settings

• • • • • • • • • • • •

Monitor and control projects through processes and baselines

Monitor and control projects by tracking task and project progress

Monitor and control projects through measuring project performance and reporting progress

Close projects

Course Overview

Getting Started With Project 2007 and Project Server 2007

Describing the Enterprise Project Management context

Discovering Project Server 2007 Differentiating the users of Project Server 2007

Working with Project Professional 2007 and Project Server 2007

How to Initiate Projects

Understanding initiating processes Differentiating the initiating processes in Project Professional 2007 and Project Web Access

Managing initiating processes by using Project Web Access

Managing documents in Project Web Access How to Plan Projects

Understanding the project management plan

Differentiating the Project Server 2007 client software

Developing components of the scope management and schedule management plans

Working with deliverables

Understanding the Staffing Management Plan

Building a project team

Analyzing and managing resource availability

Understanding resource assignments Resolving resource overallocation with enterprise resources

How to Develop Cost, Risk and Other Planning Documents

Developing components of the cost management plan

Developing components of the risk management plan • • • • • • • • • • • • • • • • • • • • • •

Linking planning documents and using the team discussion feature

How to Execute Projects and Manage Processes, Resources and Deliverables Understanding executing processes Managing resources and deliverables Working with timesheets

Reporting administrative time Configuring personal settings

Understanding Monitoring and Controlling Working with the baselines

Working with task progress and updates in Project Web Access

Working with task progress using Project 2007

Tracking and viewing task information using Outlook® 2007

Measuring Performance and Reporting Progress

Understanding status reports Reviewing performance metrics and progress reports

Working with the baselines

How to Close Projects in the Enterprise Understanding the closing process Summary

What did we learn, and how can we implement this in our work environments? • • • • • • • • • • • • • • •

Managing Projects with Microsoft Office Project Server 2007

Prepares you for the Microsoft Office Project Server 2007 MCTS certification exam

Project Blue Belt® 2007

Project Blue Belt 2010 will be available by March 2011.

Microsoft®, Windows XP®, Excel®, Outlook® and VistaTM_{are registered trademarks or trademarks of Microsoft Corporation in the United States and other countries. Project Blue Belt® and Project Orange Belt® are registered trademarks of International Institute for}

(5)

icr

os

oft

_®

Pr

oje

ct C

ert

ific

atio

ns

This course will address managing complex projects and programs using Project Server 2007 and Project Professional 2007. It requires practitioners to apply project management methodology and experience to the management of projects and program schedules in a Microsoft Office Enterprise Project Management (EPM) 2007 environment. Prerequisites

A solid understanding of key project management concepts and terminology as found in PMI®’s A Guide to the Project

Management Body of Knowledge (PMBOK® Guide) is recommended. Extensive hands-on

experience is also recommended in both Project Professional 2007 and Project Web Access 2007.

Project Orange Belt® and Project Blue Belt® courses are required before taking Black Belt. However, participants may skip these prerequi-site courses if they can demonstrate successful completion of the equivalent Microsoft certification exam(s).

Course Level

Intermediate/Advanced

This course is intended for project managers, program managers, members of the Project Management Office as well as those participating in the deployment of an EPM solution who are responsible for managing, analyzing and reporting on projects and programs in the Microsoft Office EPM environment. Course participants should be able to recommend Office EPM environment configurations to create solutions for business problems.

Manage enterprise projects, programs and portfolios

Work with the Microsoft EPM Solution Define a standardized methodology for program management

Define and create the enterprise environment

Set up the program Plan the program

Manage the program resources Track timesheets and task progress • • • • • • • •

Perform Earned Value Management (EVM) Report and analyze the program data Manage project workspaces for programs and the queue

Close the program and refine the environment

Course Overview

How to Manage Enterprise Projects, Programs and Portfolios

Managing projects, programs and portfolios in an enterprise

Understanding program management standards and terminology

Understanding the EPM solution Navigating the EPM solution interfaces Understanding Program Management

Program management in the organization Defining the policies and procedures of program management

Program life cycle process and phases Defining and Creating the Enterprise Environment

Reviewing the default settings of Project Server 2007

Implementing changes in an enterprise environment

Working with and setting up a program Customizing permissions and enterprise custom fields

How to Plan the Program

Developing a detailed plan of the program Establishing project interdependencies in a program

Finalizing the program plan

Adding and deleting a project and resetting the baseline

Proposing and implementing updates to improve the planning process

How to Manage Enterprise Resources Updating the enterprise resource pool and replacing resources

Refining the program plan by identifying critical resources

Managing and configuring timesheets and task progress

Proposing improvements to timesheet and task progress configurations

Reporting time and managing timesheets and task progress

• • • • • • • • • • • • • • • • • • • • • • • • •

How to Perform Earned Value Management Applying EVM

Using EVM in Microsoft Project 2007 Creating and modifying views and reports for EVM analysis

Understanding, Reporting and Analyzing Program Data

Customizing the enterprise fields and views to track a program

Proposing changes to the look and feel of a program

Working with an Online Analytical Processing (OLAP) Cube and a data analysis view

Generating and modifying data analysis views

Configuring a workspace for a project in a program

Managing the queue

How to Close the Program and Refine the Environment

Closing and archiving a program Refining an enterprise environment Making changes to an EPM environment

Summary

What did we learn, and how can we implement this in our work environments? • • • • • • • • • • • • •

Project Black Belt® 2007

Managing Projects and Programs with Microsoft® Office Project Server 2007

#8980 / Eight 3-hour sessions CEU Credits: 2.4 / PDU Credits: 24 Price: USD 1450

#4980 / 4 Days

#PA8980 / Eight 3-hour sessions CEU Credits: 2.4 / PDU Credits: 24 Price: USD 1450

Managing Projects and Programs with Microsoft Office Project Server 2007

Prepares you for the Microsoft Office Project Server 2007 MCITP certification exam

Project Black Belt® 2007

Project Black Belt 2010 will be available by June 2011.

Microsoft® is a registered trademark of Microsoft Corporation in the United States and other countries. Project Black Belt®, Project Blue Belt® and Project Orange Belt® are registered trademarks of International Institute for Learning, Inc. PMBOK® is a registered mark of the Project Management Institute, Inc.

(6)

M

ic

ro

so

ft

®

P

ro

je

ct

C

er

tif

ic

at

io

ns

Microsoft® EPM Role-based Courses

Organization-Specific Support for the Deployment of Microsoft® Office Project Server 2007

Microsoft EPM 2007 for Team Members

Prerequisites

There are no prerequisites for this course. Course Level

Basic

Project team members who need to report hours spent on project and non-project work to a resource manager and progress made towards completing assigned tasks to project managers by using Project Web Access.

Performance Focus

This half-day course is designed to intro-duce the Enterprise Project Management (EPM) solution to project team members and demonstrate how to directly interact with Project Web Access. Attendees will configure personal settings and use Project Web Access to report hours worked by using timesheets and report task progress by using task updates.

You will learn how to:

Understand the architecture and benefits of Microsoft’s EPM Solution and how the team member role fits in the organizational workflow

Navigate through the Project Web Access user interface

Quickly respond to changes from the resource manager or project manager through personal alerts and reminders Incorporate non-project work efforts with project tasks such that all commitments are visible in Project Web Access or Outlook®

Provide the project manager with an accurate update on the status of assignments using task updates and textual status reports

Provide the resource manager with an accurate update on the hours worked on project tasks and administrative tasks through timesheets or Outlook Adjust the timesheet view in Microsoft Project Web Access

• • • • • • •

Microsoft EPM 2007 for Project Managers

Prerequisites

Some experience managing projects using Microsoft Project is recommended. Course Level

Intermediate Who Should Attend

Project managers who are planning to use Project Professional and Project Web Access in a Microsoft Enterprise Project Management (EPM) environment.

This two-day course offers PMs the informa-tion they need to effectively manage projects in Microsoft Project Server. Participants will become familiar with Project Web Access and its collaborative features for managing project documents, risks and issues and for receiving task updates from resources.

Discuss how the key roles within Project Server 2007 fit in the EPM workflow Create a schedule connected to Project Server 2007 and assign resources from the Enterprise Resource Pool

Create master project schedules and set cross-project links to manage programs Collaborate with and manage project team members on the list of tasks and assignments for each project

Utilize Project Web Access to configure desired project views and to manage alerts, reminders and published jobs Collaborate with resource managers to maximize resource effectiveness Enter project ideas using proposals and create activity and resource plans for potential future projects

Simplify the team-building process by using the Resource Substitution Wizard Receive task updates and publish progress updates to the schedule

Manage the project workspace and collaborate with others using documents, risks and issues

Understand the dashboard views, portfolio views and data analysis views Conduct real-time manipulation of data analysis views including configuration in Excel® • • • • • • • • • • • •

Microsoft EPM 2007 for Resource Managers

Prerequisites

A good understanding of project and resource management is recommended, as well as prior experience managing projects using Microsoft Project.

Course Level Intermediate

Resource managers who are planning to use Microsoft Project and Project Web Access in a Microsoft EPM environment.

This half-day course covers the necessary ele-ments for effective resource management in both Project Web Access and Microsoft Project. Participants learn how to create and maintain resources and assign them to projects, receive timesheets submitted by team members and approve project and administrative time. This course explores the resource capacity model and uses data analysis views to analyze resource allocation and recommend changes to enter-prise resources.

Describe the different types of resources and their main attributes: work, material, local, cost, enterprise generic and enterprise actual resources

Set up and maintain resources using the Enterprise Resource Pool*

View and modify resources using the Resource Center in Project Web Access Understand the resource capacity model and how to optimize resource ROI

Collaborate with project managers to build teams on projects using Team Builder and Project Web Access

Understand matching resources with skills and the request/demand attribute

Analyze resource assignments and availability using the Resource Center

Utilize generic resource assignments in future time periods to predict resource needs Receive and approve timesheets and respond to administrative time requests Use data analysis views to report on resource allocation and resource trends

*This feature may be limited to the Project Server administrator. • • • • • • • • • •

Microsoft®, Excel® and Outlook® are registered trademarks of Microsoft Corporation in the United States and other countries.

Contact your local IIL company for details Contact your local IIL company for details Contact your local IIL company for details

(7)

icr

os

oft

_®

Pr

oje

ct C

ert

ific

atio

ns

Microsoft® Excel in Depth

Becoming Proficient in the Details of Excel®

This practical course gives participants a solid

background in the features of Excel, as well as a deeper understanding of the best ways to use Excel.

This is not a beginner’s course in Excel. Participants will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering, Functions and more.

The goal of this course is to give participants a deeper understanding of the intricacies of Excel and a new ability to use it efficiently to produce the solutions they’re seeking. Prerequisites

A solid working knowledge of Excel and a desire to become more knowledgeable about its features and benefits

Course Level

Intermediate/ Advanced

This course is for anyone with a basic working knowledge of Excel who wishes to enhance their understanding of the myriad features of Excel and when to use them.

Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE and many more Create meaningful charts Use Pivot Tables

Use Conditional Formatting and Data Validation

Take advantage of using Named ranges, do sorting, filtering, tables

Course Overview

Course goals and objectives • • • • • • • • Excel Overview

Excel Functions – VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, Filtering

Learn the Name manager

Learn the difference between local and global names

Ensure correct access to linked workbooks Ensure data accuracy

Learn how to use cascading data validation (for example, once a user chooses “cars”, another cell allows only Ford, Toyota, etc.) Sorting by more than 3 fields

Filtering by font, pattern or value

See your data based on things like dates in the third quarter, or fields where quantity x price is greater than some fixed value Conditional Formatting and Data Formatting

Make relevant data stand out Isolate highs and lows Make error cells invisible

Learn about Data bars and Icon sets Color Scales

Highlight differences between worksheets Learn all the codes in the Format/Number list, like (#,##0.00_);(#,##0.00)

Using cell styles

Learn all about alignment, protection, borders, colors and more

Pivot Tables

How to summarize large amounts of data with a few clicks

Learn various ways of presenting the data Pivot table tools

How to customize and format a pivot table to suit your needs

How to group data

Using the various options to present your data

Charts

Learn how to create a chart with one keystroke!

The 11 types of built-in charts

How to customize the charts to make the information tell the right story

Using the design, layout and formatting available to charts in Excel

Embedded charts versus chart sheets How to modify all the pieces of a chart • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • Array formulas

Learn how to use the most powerful formulas in Excel

How to combine many formulas into one compact array-formula

Learn the real power of these formulas and why regular formulas can’t do the job Using built-in array formulas, like TREND or TRANSPOSE

Summary

What did we learn, and how can we implement this in our work environments?

• • • •

#8858 / Four 3-hour sessions CEU Credits: 1.2 / PDU Credits: 12 Price: USD 850

#PA8858 / Four 3-hour sessions CEU Credits: 1.2 / PDU Credits: 12 Price: USD 850

Microsoft® and Excel® are registered trademarks of Microsoft Corporation in the United States and other countries.

(8)

M

ic

ro

so

ft

®

P

ro

je

ct

C

er

tif

ic

at

io

ns

Microsoft® Excel Visual Basic for Applications (VBA)

Mastering Automation - Making Things Happen Fast!

This practical course provides a solid

back-ground in the capabilities and usage of Visual Basic® for Applications (VBA) programming. It explores macro recording, editing, writing macros from scratch, making User Forms and creating user-defined functions.

The goal of this course is to provide access to the programming environment of Excel® and enable participants to make macros that are always available to make their usage of Excel easier.

Prerequisites

A solid working knowledge of Excel, and a desire to get more deeply into the programming language built in to Excel - Visual Basic for Applications.

Course Level

Intermediate/ Advanced

This course is for anyone with a solid working knowledge of Excel.

You’ll learn how to: Record macros Edit macros Debug macros

Create and use User Forms Create user-defined functions

Explore Event-driven macros (macros which run when some event occurs, like printing or saving or using a right-mouse click)

Course Overview

Course goals and objectives Macros and User Forms

Record, edit and maintain your macros Learn what can and cannot be recorded A quick look at syntax

A discussion of functions and User Forms Course Outline

Record macros

Examine and learn about the VBE (Visual Basic Environment) - the place where macros are stored

• • • • • • • • • • • • • • •

Get information to/from a workbook - How to design a User Form - When to use it, when not - How to get information to/from a User Form

- Learn the various controls on a User Form (button, checkbox, textbox, etc.) - Using Input boxes and getting messages to a user

Make repetitive tasks happen without errors and quickly: for example, updating a monthly report using new data

Create your own set of personal utilities which are available to you in every workbook

Create your own functions in addition to Excel’s wide set, like a weighted average function

Debugging

Prevent a workbook from being saved or printed unless all required fields are filled in

Summary

What did we learn, and how can we implement this in our work environments? • • • • • • •

#8857 / Two 3-hour sessions CEU Credits: 0.6 / PDU Credits: 6 Price: USD 495

#PA8857 / Two 3-hour sessions CEU Credits: 0.6 / PDU Credits: 6 Price: USD 495

Microsoft®, Excel® and Visual Basic® are registered trademarks of Microsoft Corporation in the United States and other countries.