Course Title: 3 Hour Live Virtual Training on Microsoft PowerPoint from Beginner to Advanced
Type: LIVE : $149
Communicating effectively in the workplace requires specific skills and the self-confidence to apply them effectively. This course is designed to improve communication skills by providing practical processes and easily applied strategies for achieving success.
Learning objectives
A repeatable writing process and strategic planning guides for specific applications will be introduced through learning activities. Peer support and feedback will be emphasized.
Upon completion of this course, you will be able to:
- introduce and apply a repeatable writing process that can be applied to all business communication challenges including all business-related use of social media,
- identify and apply business writing characteristics that support clear, concise messaging and eliminate interference,
- develop and apply planning, organizational, and editing strategies for specific types of written business messages, and
- review and apply the principles and elements of specific business writing formats such as presentations, letters, e-mails, proposals, resumes, and recommendation letters
Core Objectives
- To develop a strategic framework for negotiations (the 3D framework)
- To understand the various elements of the three dimensions of the framework
– Designing the Settlement
– Setting the Context
– Engaging in Effective Tactics
- To understand how the concepts of anchors, framing and the principles of persuasion are critical to effective negotiation tactics
- To understand what “win-win” negotiation means and how to create such a situation when designing a settlement
- To understand the underlying contextual reasons for unequal power in negotiations and ways for the weaker party to manage the lack of power, and
- To understand the Challenges of, and solutions to, Multiparty-Multi items negotiations.
Learn the three critical skills that will allow you to leverage your PM experience and prepare you for a move into senior leadership within your industry or elsewhere:
1) Strategic thinking and planning,
2) Business acumen for thinking beyond projects and
3) Communication skills that inspire confidence
Excel - Level 1 • BSCM 511V (12 hours)
Whether you manage your own finances, run a business or a large organization, this course will give you the skills you need to have Excel do your calculations. Each topic is designed to save you time and ensure the integrity of your data. Use AutoFill, number styles, relative and absolute cell referencing, and many more commands to reduce typing and increase accuracy. Know how and when to apply functions (e.g. average, sum, count, min, max) to calculate your data; simplify your formatting, and create charts to visually represent your numbers. An electronic course manual (pdf) is included.
Course Learning Outcomes
Upon completion of this course, learners will be better able to:
- Understand and navigate the Excel interface (workbooks vs. worksheets, ribbon, tabs, groups, help)
- Create, save, close, open, rename and delete workbooks and worksheets
- Select and modify cells (adjacent and non-adjacent) and define cell and range references
- Enter and edit text, values, dates, times, symbols, special characters and functions
- Use AutoFill and other fill commands
- Understand and apply the order of mathematical operations (BEDMAS)
- Manage worksheets:
- Insert, hide, delete and adjust rows and columns
- Switch between open workbooks
- Group worksheets
- Apply character, number and cell formatting, and understand how themes work
- Define number styles (accounting, comma, percent, date)
- Use Format Painter to copy formatting
- Apply page set up and printing layout options:
- Preview and print worksheets/workbooks
- Customize printing and add headers/footers
- Understand and use relative, absolute and mixed cell references in formulas:
- Describe when and how to use relative vs. absolute references
- Use introductory Excel functions (sum, average, count, max, min, round)
- Create and modify introductory charts (column, pie, line and other chart types)
- Document a workbook
Excel - Level 2 • BSCM 512V (18 hours)
Realistic examples will be used to demonstrate ways to build on your basic knowledge of Excel to increase your productivity. Use powerful logic functions such as "IF" to identify conditions met or not met for specific criteria. Determine if you can afford a loan with financial payment functions. Use conditional formatting tools to easily identify key indicators for your business such as top 10, or highest average, based on your unique criteria. Link and group worksheets, use named ranges to quickly locate data, and use powerful database techniques that include data validation, sorting and filtering and many more Excel topics. You must be familiar with AutoSum, AutoFill, how to create a basic chart and understand the difference between relative and absolute referencing. An electronic course manual (pdf) is included.
Course Learning Outcomes
Upon completion of this course, learners will be better able to:
- Create and modify charts (includes format titles, axis, scale, areas and data labels)
- Use functions including conditional formatting with:
- Financial functions for future value, payment, interest and principle payments (FV, PMT, IPMT, PPMT)
- Review of Statistical functions (AVG, COUNT, MIN, MAX, SUM) (taught in-depth in Excel 1)
- Median and Logical functions (IF, COUNTIF, SUMIF, AND, NOT, OR)
- Date and time functions (NOW, TODAY)
- Text functions (TRIM, UPPER, LOWER, CONCATENATE) and vertical lookup (VLookup)
- Create and edit hyperlinks to text and graphics within a workbook and to other files
- Link and group worksheets and workbooks
- Use Excel tables as a database:
- Create tables and data forms
- Sort with single and multiple fields
- Filter and subtotal within databases
- Create pivot tables and pivot charts (overview only)
- Apply data validation:
- Restrict cell entries to the data from a list
- Use a formula to validate data
- Find cells with data restrictions
- Work effectively with large worksheets (includes freeze panes, adjust page order, print titles, display row and column headings, insert page breaks and define print areas)
- Create and edit templates
- Protect and hide worksheets and workbooks
- Use advanced options (includes custom lists)
- Name ranges and use paste special
- Work with themes
- Understand when, why and how to create and run a macro
- Apply and create web queries
Prerequisites: BSCM 511V
Microsoft Project 2013 - Level 1
Learn the features and functionality of Microsoft Project 2013.
This course provides you with the knowledge and skills to become familiar with introductory and intermediate features and functionality of Microsoft Project 2013.
This course includes access to our exclusive Microsoft Office Online Support Program, enabling you to build your skills and expertise after class. The program provides 60-day access to online mentoring via chat from Microsoft Office experts.
What You'll Learn
- Basics of the software
- Create a new project and create, edit, and outline a task list, as well as establish dependencies by linking tasks
- Add and assign resources to a project, work with project calendars, and enter project costs (such as standard, variable, and fixed costs)
- Apply page setup options, create headers and footers, insert page breaks, and preview and print project information
- Apply task type settings, modify fixed tasks, set task constraints, and define and format the critical path
- Apply preset and custom contours, edit resource assignments, identify and resolve resource overallocations, and set and modify a baseline
- Track the progress of a project, update tasks and the schedule, and compare baseline and actual data
- Sort, filter, and group views
- Format views and format the Gantt Chart
Who Needs to Attend
New Microsoft Project 2013 users
Prerequisites
Experience working in a Windows computing environment
Follow-On Courses
Course Outline
1. Getting Started with Project 2013
- Understanding Project Management Concepts
- Getting Started
- Application and Project Windows
- Ribbon and Tabs
- Creating and Saving Projects
- Opening and Closing Projects
- Changing the View
- Moving Within a View
2. Project Creation
- Project Information
- Creating Task Lists
- Editing Task Lists
- Outlining Task Lists
- Task Dependencies
- Modifying Task Dependencies
- Task Information
3. Project Resources and Costs
- Project Resources
- Resource Assignment Concepts
- Assigning Resources
- Working with Project Calendars
- Working with Resource Calendars
- Working with Task Calendars
- Entering Project Costs
4. Printing Schedule Information
- Page Setup Options
- Previewing Views and Reports
- Printing Project Information
5. Changing Scheduling Methods
- Resource Assignment Concepts
- Task Type Settings
- Changing Task Types
- Task Constraints
- Identifying Factors Affecting Tasks
- Defining the Critical Path
- Formatting the Critical Path
6. Resolving Resource Conflicts
- Preset Contours
- Applying Preset Contours
- Editing Resource Assignments
- Resource Overallocations
- Locating Resource Overallocations
- Resolving Resource Overallocations
- Saving the Baseline
7. Tracking Project Progress
- Tracking Task Progress
- Updating Tasks
- Updating the Remaining Schedule
- Comparing Baseline and Actual Data
8. Sorting, Filtering and Grouping
- Sorting Views
- Filtering Views
- Grouping Tasks and Resources
9. Formatting the Project Environment
- Formatting Views
- Formatting the Gantt Chart