Search 

Azcourts.gov

Arizona Judicial Branch

Skillsoft Courses Available - 2012

Product/Course Title Category Description Approximate Seat Time
Advanced Features of Adobe Acrobat 8 Desktop You can use the professional features of Adobe Acrobat 8 to perform such tasks as batch processing, and indexing.  Adobe Acrobat 8 also allows you to prepare a PDF for commercial printing using its Preflight feature and this course explores the advanced features of Adobe Acrobat 8, including working with multimedia, creating batch sequences, and preparing PDFs for indexing. 2
Creating and Working with PDFs in Adobe Acrobat 8 Desktop Adobe Acrobat 8 enables you to create Adobe Portable Document Format (PDF) files  €“ files that retain a standard appearance across various operating system platforms and browsers. This course explores the creation of PDFs, including creating them from multiple files and web pages. In addition, the course discusses methods of saving, printing, formatting, and organizing PDFs. Accessibility and help features of Adobe Acrobat 8 are also covered. 2.5
Editing and Reviewing in Adobe Acrobat 8 Desktop Using Adobe Acrobat 8, you can perform comprehensive reviews of PDF documents. This application allows you to review and add your comments to a document using a wide variety of commenting and markup features, including notes, stamps, and text insertion tools. This course highlights the main concepts of participating in a review using Adobe Acrobat 8. 1
Forms and Document Security in Adobe Acrobat 8 Desktop You can create and review many types of PDFs using Adobe Acrobat 8, but this application also enables you to safeguard your documents using any number of Acrobat's security features. This course explores the advantages of PDF security, and highlights several security measures you can employ, such as using digital IDs, security policies, password and encryption protection, and security envelopes. The course also introduces PDF forms, and sending form data.  1.5
Administrative Professionals: Common Administrative Support Tasks Business Skills When it comes to a typical day at the office for an administrative professional, each day's planned agenda can change on a whim. Whether it be unexpected meeting requests to juggle, a last-minute announcement the boss needs to communicate, or a sudden request from the boss that shifts priorities, the tasks performed in a typical day are varied and ever-changing. But regardless of how much the agenda changes from day to day, there are standard tasks that every administrative professional will perform regularly.  This course describes common administrative support tasks. Specifically, it covers the stages of the records management life cycle and details the different types of classification systems used for sorting records. The course also discusses the key tasks involved in arranging business travel, including considerations for international travel. Finally, the course describes the steps for planning and scheduling meetings, as well as the key techniques for recording meetings.
1
Administrative Professionals: Interacting with Others Business Skills Regardless of the industry you work in, the organization you work for, or the boss you have, as an administrative support professional, almost all of the tasks you perform on a daily basis require, in some way, interaction with others. Effectively interacting with others results in trust, improved morale, and respect between you and your colleagues, which in turn results in your ability to get the feedback, information, and help you need to effectively perform in your role.  This course addresses the skills administrative support professionals require to be able to interact effectively with others. Specifically, you will be introduced to the benefits of being a supportive colleague, including some best practices for doing so. You will also be introduced to techniques to use to ask for help from colleagues in a respectful and proactive way in order to accomplish your goals. Finally, the course covers some techniques to help you deal with criticism, including how to react to and act on it constructively.  1
Administrative Professionals: Maximizing Your Relationship with Your Boss Business Skills As a good administrative professional, you provide invaluable support to your boss and the business. This support is optimized when the working relationship between you and your boss is a true partnership. Within this partnership, your relationship must be managed and maintained according to the particular management style of your boss to ensure compatibility, dependability, and efficiency as you work toward common goals. Through partnership, you can maximize your relationship with your boss and realize benefits for yourself and your career.  This course explores ways to build a partnership with your boss. Specifically, it covers ways of establishing and maintaining the elements of a true partnership, and shows how you can benefit personally from it. The course also covers approaches for dealing effectively with different management styles and techniques for successfully handling confrontations that may occur over the course of your partnership with your boss.
1
Administrative Professionals: Putting Your Best Foot Forward Business Skills As an administrative professional, there are many skills and competencies you must master, ranging from organizational skills to technical aptitude. In order to be truly successful, though, you must also master other essential skills like the ability to gain the trust, respect, and admiration of your boss and colleagues. You must also remain true to yourself and maintain your dignity, all while expressing yourself to others, making decisions at work, or navigating through office politics.  This course introduces some best practices for making a good impression as an administrative professional. Specifically, you'll learn how to project a positive professional image by building credibility and maintaining authenticity. You'll also explore the importance of communicating honestly, respecting others, and having a positive Outlook in order to create a positive work environment. Finally, you'll learn how to practice positive office politics to enable you to put your best foot forward as you make your mark in the organization.
1
Administrative Professionals: Representing Your   Boss Business Skills As an administrative support professional, every interaction you have with others leaves an impression of not only yourself but of your boss. The ability to represent your boss in a positive and professional light is essential to both your own and your boss's success.  This course covers the skills you need to be successful as an administrative professional, including communication skills, organizing and managing skills, problem-solving skills, and basic office skills. It also describes strategies for anticipating your boss's needs, for making your boss look good, and for keeping your boss informed. Finally, you are presented with techniques for effectively communicating a boss's messages and decisions. 1
Essential Skills for Administrative Support Professionals Simulation Business Skills  The role of the administrative support professional today reaches far beyond the dated cliche of the secretary answering phones and filing documents. Effective administrative support professionals require an extensive array of skills, including communication, organizational, managerial, problem-solving, and conflict-resolution skills. Without such skills, the administrative support professional risks both his or her success and the success of his or her boss.  The simulation Essential Skills for Administrative Support Professionals is designed to provide participants with the opportunity to practice administrative support skills in a secure, virtual environment before facing the challenge of an actual, real-world scenario. Over the course of the simulation, participants will be tested on the objectives of working effectively to meet your boss's needs, executing common administrative support tasks, maintaining an effective relationship with your boss, and putting your best foot forward.  The simulation Essential Skills for Administrative Support Professionals comprises three scenarios and is based on the SkillSoft Series "Administrative Professionals. 0.5
Communicating Clearly (Includes Simulation) Business Skills Ensuring that your written or verbal message is understood as you intended is often a challenging experience. This course introduces several techniques for enhancing your communication skills and style by focusing on audience identification and message clarity. 2
Emotional Intelligence (Includes Simulation) Business Skills In this course, you will assess your current emotional intelligence abilities, and apply strategies to improve your emotional intelligence. Increased awareness of your current emotional intelligence strengths and weaknesses can assist you in identifying and developing strategies for improvement. As a manager, by improving your emotional intelligence, you can influence those around you and impact your behaviors, and the behaviors in others, in ways that can allow you to work towards achieving your business objectives. 3
Selecting Your Negotiation Strategy (Includes Simulation) Business Skills In this course, you will explore negotiation strategies, such as the avoiding game, the accommodating game, the competing game, the collaborating game, and you will explore ethical and unethical negotiation behaviors. 6
Change Management for Employees (Includes Simulation) Business Skills In this course, you will identify ways to solve problems related to change on the job, including recognizing, anticipating, and effectively managing change. You will also define change management, identify change-management strategies, define the psychological process of moving through change, identify ways of preparing for change, and explore ways to embrace change on an ongoing basis. 3.5
Managing Change: Building Positive Support for Change  Business Skills It's often said that people don't like change. But when it comes to organizational change, employees are genuinely interested in making things better an improvement in processes, systems, functions, or services most likely translates into direct improvements for the employee too. But employees cannot support change and recognize its benefits without first understanding how it impacts their tasks, processes, or roles. Employees and people in general empowered with knowledge, understanding, and a clear vision of the future state will not only welcome change, but embrace it. In this course, you'll learn about the importance of building a motivating atmosphere that supports organizational change, and the importance of creating short-term wins and vision. The course highlights techniques for listening to your employees during change initiatives such as encouraging open communication, listening to employees' feelings, checking for understanding, and taking employee input into consideration. The course also covers actions you can take to support individuals through change initiatives, including coaching for change, making sure employees are empowered with the critical knowledge and skills necessary, considering individual characteristics of your employees, and being flexible. 1
Managing Change: Dealing with Resistance to Change Business Skills Change is inevitable in an organization, but the process of adapting can be painful. Organizational change can cause anxiety and upheaval, and when it does, it's no surprise that employees show resistance. Resistance behaviors can vary from individual to individual and they are often unproductive. While managers may be tempted to deal with behaviors directly, rather than tackling symptoms of resistance to change, managers must deal with the source of those symptoms. They must first understand the mixture of emotions and thoughts that come with change, identify the underlying causes of employee resistance, and then use techniques to address those root causes. When the root causes are addressed, behaviors that show resistance to change will fade.   This course outlines these aspects of overcoming resistance to change. It surveys the active and passive symptoms of resistance to change, goes deeper to explore the emotional and thought-based causes of these symptoms, and provides strategies for dealing with root causes through direct conversations with employees. 1
Business Coaching: Building the Coaching Relationship Business Skills Establishing a positive and respectful coaching relationship is integral to the success of your coaching efforts. It lays the groundwork for accomplishing the goals you and your coachee set.   This course highlights the importance of a strong coaching relationship. It describes how to establish rapport with your coachee by showing interest, finding common ground, and matching your coachee's demeanor and language. In addition, the course covers ways to develop a positive coaching relationship, including letting coachees act autonomously and take responsibility, and helping them to learn and develop.
1
Business Coaching: Conducting Coaching Sessions Business Skills An important part of any coaching session is asking the right questions. When you do this, your coachees will be more focused, attentive, and proactive in finding their own solutions. But you need to know what questions to ask, and in what order. It helps to follow a structured approach that guides you from a broad understanding of what your coachee is trying to achieve to a clear action plan with detailed steps.  This course describes how to carry out effective coaching sessions, including clarifying the coachee's situation and recognizing and determining the best options for your coachee to work with. Finally, the course provides actions for wrapping up a coaching session, including getting commitment, identifying obstacles, creating a plan with deadlines, and agreeing on support going forward.
1
Business Coaching: Getting Ready to Coach Business Skills Coaching offers organizations a win-win method for developing their employees. It not only helps individuals reach their potential but also helps the organization improve its productivity and competitiveness. In a rapidly changing business world, coaching can also help employees adjust and adapt their skill sets. Coaching is about encouraging, confronting, challenging, questioning, as well as consistently respecting and supporting coachees in developing and achieving their goals.  This course introduces the skills you need to be an effective coach, including listening and observing, providing feedback, questioning, and setting goals. It also covers how to identify which coaching role is most appropriate for a given individual or situation. The course also details the importance of selling the idea of coaching to those you feel need it.
1
Business Coaching: Using Different Coaching Styles Business Skills Every coachee has different needs, and an effective coach can identify those needs and tailor a coaching style to maximize results. Coaches typically use two general coaching styles directive and nondirective depending on their coachee's skill and motivation, as well as how far along they are in the coaching relationship. This course highlights the importance of using an appropriate coaching style with your coachee. Specifically, you will learn how to use different techniques for directive and nondirective coaching.  1
Coaching Essentials (Includes Simulation) Business Skills Coaching is a leadership tool that is effective in improving performance and contributing to the goals of the organization. In this course you will explore the benefits of coaching, coaching approaches, how to develop an action plan, and methods for ensuring the coaching process is successful.

This course is intended for managers, supervisors, team members, team leaders, project managers, mentors and anyone who needs to coach and give feedback as part of his/her job and who wants to learn how to apply the coaching process in order to successfully improve the performance of others.
3.5
Leadership Essentials: Motivating Employees Business Skills Imagine what your organization would be like if you and your colleagues were not motivated. Motivation is what drives people to accomplish things, whether it be small tasks or large undertakings. Without motivation, things simply would not get done. The ability to create an environment that encourages motivation takes both practice and skill as it's not a quality inherent in most people. As a leader, your capacity for motivating plays a key element in the success of your organization.
This course provides you with an understanding of why motivating strategies are important as a leader. It also provides you with practical techniques for encouraging motivation among employees in your organization.
1
Leadership Skills: Build a Winning Team (Includes Simulation) Business Skills Effective leaders have the skills necessary to conduct useful interviews and make great hiring choices, coach people towards better performances on the job, and delegate work to others who can get it done. You want to be able to excel in all of these critical areas of leadership so that your team functions smoothly with or without you, and you can focus your attention on the bigger picture-planning, strategizing, and crisis prevention.

You can achieve excellence in your role as a leader by learning from the experts: Peter Barron Stark and Jane Flaherty, authors of the renowned business book, The Manager''s Pocket Guide to Leadership Skills from HRD Press. In this course, you will identify how management has changed over time and learn the critical skills that will help you become more successful, including effective communication, time-management, and organizational leadership skills.
1.5
Leadership Skills: Lead with Confidence (Includes Simulation) Business Skills Success does not depend on titles, but on the values leaders uphold and the choices they make on a daily basis. True leadership is not achieved through technical expertise, but rather is based on an emotional connection or relationship with others. You want to be the kind of leader who can motivate your team, manage conflict when it inevitably arises, and facilitate your employees'' goals and action plans. In this course, you will learn from the management experts at HRD Press their proven strategies for leading a team with confidence. 1.5
Leading Teams: Launching a Successful Team Business Skills Leading successful teams is an art, and team leaders can face many challenges when trying to optimize team performance. Whether you're a current team leader or simply someone who would like to develop the skills that would make you a strong candidate, you need to know certain things about how teams function and what it takes to develop a high-performance team. Among the most important things to know: good team development begins on day one. Forming an effective and cohesive team is fundamental to the success of the team later on, and pulling the right team together from the start has benefits far beyond just completing tasks on time.  In this course, you'll learn techniques for setting up successful teams that can be applied to a variety of team environments. This course outlines the benefits of business teams and the importance of taking proactive measures to ensure a smooth transition during the initial phase of team formation. It reviews the five stages of team development and offers strategies for dealing with issues that may arise during the first stage, Forming. You'll learn strategies for selecting high-performing team members most suited for your project or team, as well as recommendations for performing proper introductions, clarifying team purpose and context, and making sure team members understand their responsibilities. 1
Collaboration Skills (Includes Simulation) Business Skills In a business environment, there is literally no task that does not involve interaction and negotiation. Therefore, in order to confidently and effectively negotiate with others, you need to possess what is called collaboration skills. The information presented in this course will enable you to efficiently collaborate with others to maintain important relationships and achieve satisfying goals. 2.25
Employee Relations: Communicating for Effective Employee Relations (Includes Simulation) Business Skills A manager may have sound knowledge of the work processes carried out by his team and may also be an expert in his profession. However, being a leader and maintaining an effective relationship with employees takes much more than that. There are several factors that play key roles in establishing a good work relationship between employers and employees, and communication is one of the important factors. This course will show you how the way you communicate affects employee relations and what you can do to overcome the challenges in communication.This course is intended for all managers or supervisors at various levels in any organization. 1.25
Conflict Intervention (Second Edition) (Includes Simulation) Business Skills Conflict is inevitable. It can destroy and it can create. Both danger and opportunity are present in a conflict situation, but the result obtained depends on the management and resolution of the conflict. The outcome of the conflict depends on how each party responds to the negative and emotional charges of the situation, and the third-party role could be critical. With skilled intervention, conflict has the potential of developing better communication, more effective solutions, and greater empathy. In this course, you will gain a practical working knowledge of how to access, analyze, and resolve conflict situations. 2.25
Having Tough Talks Business Skills You're a leader who has to provide constructive criticism, manage conflict and confrontation, and deal with difficult people. When  you're able to successfully manage challenging communications and resolve problems, your leadership credibility is strengthened. You'll be able to maintain productivity and solid relationships in your group or team, and associates will know that you're a person they can depend on to handle sensitive issues requiring first-rate communication skills.

The target audience for this course is anyone who needs to use their leadership skills to influence the outcome of particularly challenging performance and behavior issues.
1
Managing Conflict with Direct Reports Business Skills Conflict in the workplace cannot be avoided. The differences among all the people and personalities within a company creates an environment tailor-made for disagreements and conflict. This is a difficult challenge for managers, and it's especially difficult when conflict occurs between managers and their direct reports. Such difficulties arise partly because of the power relationship between managers and direct reports. Extensive research conducted by the Center for Creative Leadership (CCL), with both U.S. and European managers, shows that the inability to manage conflict and interpersonal relationships with direct reports is one of the major reasons for managerial career derailment. To be a successful leader, you must understand that managing conflict is one of your key priorities and develop a comprehensive strategy to address these conflicts. 1
Working With Difficult People (Includes Simulation) Business Skills In this course, you will explore how to work with difficult people, respond to changes, and cope with continued conflict. Different people have different work styles, and for some people, it becomes difficult to cope with such differences. During continued conflicts, problems should be handled through careful communication to arrive at a solution. 3
Decision Making Skills (Includes Simulation) Business Skills In today''s business climate, you must employ sound decision-making skills and engage in active collaboration. Given the complexity of many business decisions that require input from multiple sources, you must establish your credibility as a decision maker and learn to foster critical thinking when interacting with business teams. 1
Delegating (Second Edition) (Includes Simulation) Business Skills This course is part of the Delegating assignment. Delegating is a win-win situation when done effectively. In this course, you will receive an overview on how to correctly delegate a task. 2
Diversity Awareness (Second Edition) Business Skills In this course, you will learn about the changing labor market and how it affects you, terminology and historical influences on diversity issues, and strategies for how to be more aware of diversity in the workplace. 2
Diversity for Managers (Second Edition) Business Skills In this course, you will learn about the changing labor market and how it affects you, terminology and historical influences on diversity issues, and how to understand the organizational benefits of managing and maintaining a diverse work environment. 3.5
Be An Effective Facilitator (Includes Simulation) Business Skills As a facilitator, you want to be able to take charge of work sessions and lead groups toward successfully completing their work objectives. In this course, you will develop the skills you need to strategically plan work sessions and create formal agendas, lead groups to generate new ideas through brainstorming events, and help people work through difficult facilitated sessions. You will also further develop your facilitation skills by leading remote work groups and even moderating international sessions. 3.5
Creating and Maintaining Life Balance (Includes Simulation) Business Skills In this course, you will explore how to measure stress, solutions for stress, stress relieving habits, and how to devise a stress control plan. 4
Effective Time Management for You (Includes Simulation) Business Skills In this course, you will identify strategies for improving your use of time. You will identify elements of your personal work style that contribute to your effective use of time, assemble a collection of time-management tools and strategies that you can use to take control of your time, and create an action plan to guide your time-management process. 5
Time Management (Second Edition) Business Skills This course is intended primarily for entry-level managers who need to learn time-management techniques so that they can use their time appropriately to accomplish professional goals. Some managers fall into the trap of feeling that they have little or no time to devote to activities that would contribute most to their success. If you're like that, this course will help you avoid the time-management traps that can impede your career goals. In this course, you'll learn about the payoffs of solid time management by examining your goals as well as your uses of time. You'll learn to plan your use of time by setting a daily schedule and choosing activities that use time effectively. Finally, you'll learn to control the time wasters in your day by managing and organizing communications, materials, and your surroundings. By setting goals and maximizing your time, you can accomplish what you want to do both personally and professionally in your life. 1
Effective Listening Skills (Includes Simulation) Business Skills Communication is not one event it is a complex series of processes with one goals: to achieve a shared understanding. This can be achieved by employing effective listening skills and striving to confirm a full understanding of the message another person is trying to communicate. This course will help you identify specific strategies for listening effectively. 1
Managing Effective Business Meetings Business Skills Ineffective meetings can waste time, veer off course, and fail to meet objectives. But with the right techniques, you can lead productive meetings that achieve their goals and leave participants with a sense of satisfaction and accomplishment. Whether regular, recurring, or set up to achieve a special task, all meetings follow a core process: from opening on a positive note, through accomplishing the agenda items, to closing the meeting and following up.  This course will lead you through that process, presenting best practices that will help you realize success as you fulfill your responsibilities as a meeting leader. It will show you how to open the meeting with a positive tone and facilitate the work of the group using the right approach to decision making. Itwill explore how to encourage full participation while keeping your agenda moving and discussions on track with effective time-management techniques. Finally, this course will present tips for closing the meeting and ensuring continued progress by circulating minutes and following up on action items. 1
Defining the Issue of a Problem (Includes Simulation) Business Skills In this course, you will learn how to analyze problems creatively and how to determine the real problem. You will be able to identify both analytical and creative ways to solve problems. You will identify four barriers to creative thinking as well as learn the rules and steps involved in brainstorming. In addition, you will learn about Occam's Razor and how this technique can help you identify a broad problem area, clarify a problem statement, and determine if a problem is worth solving. 2
Effective Management: Creating Successful Solutions (Includes Simulation) Business Skills In this course, you will explore the skills, techniques, and methods needed to successfully create solutions. Even the most challenging problem at work, if closely scrutinized, boil down to minor setbacks in resources and their utilization, improper planning, and the like. The secret to developing effective solutions greatly depends on discerning the real cause of the problem, and deploying every possible approach, because applying lateral thinking produces simple solutions that conventional approaches can''t deliver. This can tremendously increase your effectiveness as a manager.
3
Investigating the Problem (Includes Simulation) Business Skills In this course, you will learn how to use investigative tools, gather evidence, and interpret data. You will get an overview of problem analysis and examine helpful tools such as Fishbone and Six Word diagrams. In addition, you will compare facts with opinions and learn about the types of check sheets and how to use them. You will also identify how much data you need when gathering evidence. Finally, you will learn how to interpret data using Pareto charts and histograms.
3
Solving Problems Logically (Includes Simulation) Business Skills In this course, you will identify when to use group versus individual problem solving and you will learn how to use a methodical problem-solving process. You will identify scenarios where it is better for an individual to solve a problem and also identify scenarios where it is better for a group to solve a problem. You will also learn about three business trends that encourage group problem solving. In addition, you will learn how training helps in the problem-solving process, list the main steps in the problem-solving process, and identify four key problem-solving states of mind.
2
Project Management Skills for Non-Project Managers (Includes Simulation) Business Skills Professionals in every field are often expected to take on leadership roles and manage projects on an informal basis, even if they are not trained project managers. In this course, you will develop the skills you need to be able to step forward and assume leadership responsibilities for projects as needed. Regardless of your job title, you can make a meaningful contribution by leading others through the stages of planning, executing, and completing a project.

This course is intended for a wide range of managers and staff members who need to successfully manage small- to medium-sized projects.

2.5
Developing a Strategic Plan (Second Edition) Business Skills This course is intended for entry-level managers who need to develop and implement strategic plans. Organizations of every type need to engage in strategic planning to ensure that they achieve their long-term goals. The strategic planning process directs the resources of the organization towards a successful future. This course shows you the major states in the process of developing a strategic plan, including forming a mission statement, crafting and implementing the plan, and evaluating plan performance. It also provides you with the skills and techniques you'll require as you move through each stage of the planning process. You'll be able to identify and develop appropriate activities in the plan, communicate the plan effectively, and evaluate and reward team performance as you put the plan into action. These planning skills can make you a valuable leader in the planning process in any business enterprise.
1.5
Advanced Business Writing (Includes Simulation) Business Skills You have either been hired as a manager at a new company or have been promoted to a management position within your company. With your new position comes additional responsibilities. In order to quickly gain respect at a new company or maintain credibility at your current company, one of the first areas your team, colleagues, and managers will assess is your ability to communicate in writing.

The target student for this course is first-time managers who want to build their skills to write well-organized and convincing business documents.

1.75
Effective Business Writing (Includes Simulation) Business Skills In contemporary business environments, information overload makes it necessary for you to communicate clearly and concisely. In this course, you will analyze your audience and organize your writing to make it as effective as possible. 1.5
Grammar Essentials: Editing Effectively and Avoiding Hypercorrections Business Skills Editing is an important process, and one that all professional writers rely on to achieve the best results. Many writers are overly zealous in their approach to grammar, and as a result, they actually create grammatical errors in their sentences. 0.5
Grammar Essentials: Identifying Correct Punctuation, Sentence Fragments, Run-Ons, and Comma Splices Business Skills Correct punctuation provides a clear guide to your readers and helps them to decipher your intended meaning. You can further refine your work by monitoring your writing for problematic sentence fragments, comma splices, and run-ons. Identifying these common errors, and implementing effective solutions, will help you to write consistently clear sentences. 0.5
Grammar Essentials: Identifying Nouns, Pronouns, Verbs, Adjectives, and Adverbs Business Skills Language is an abstract idea. In order for a writer and a reader to interpret a sentence the same way, both parties must have a shared understanding of how language functions. Grammar provides that guiding light. You already know that nouns, pronouns, verbs, adjectives, and adverbs make up the basic building blocks of English. As a professional, you should understand how nouns, pronouns, verbs, adjectives, and adverbs function so that you can use them to clearly articulate your ideas to your readers. 0.5
Grammar Essentials: Identifying Prepositions, Conjunctions, Interjections, and Grammar Rules Business Skills Prepositions, conjunctions, and interjections are significant elements of English. They convey additional meaning to the reader, they connect clauses and phrases, and they help make your writing more interesting. At the same time, prepositions, conjunctions, and interjections are the source of many common grammatical errors. The rules of grammar provide instructions that help the writer and the reader achieve a shared understanding. Identifying the rules of grammar and following them in your writing will help you convey your ideas accurately and clearly to your readers. 0.5
Grammar Essentials: Improving Word Choices and Building Effective Sentences Business Skills Clarity of expression depends on choosing the right word to relay your meaning. You may have a clear idea in your mind, but when you use the wrong word to express it, your meaning will be distorted. You can improve your writing even further by identifying effective word choices. You can structure your writing to meet a stated goal and improve the effectiveness of your writing by considering the audience and context. These are steps that polished writers use to build effective sentences. 0.5
Adding Visuals, Themes, and Styles to Excel 2010 Workbooks Desktop Excel has more than just charts to offer in the way of visual presentation. Nonchart-related graphic tools such as Shapes, SmartArt, WordArt, ClipArt, and Screenshots are all ways to enhance the visual impact of documents that tend to be dominated by dry numbers and text. This course focuses on these and other graphic elements that can be added to Excel 2010 spreadsheets. This course also introduces ways to change the themes and styles offered by Excel 2010.
1
Analyzing Data with What-if Analysis in Excel 2010 Desktop Excel 2010 provides powerful data-analysis tools that enable you to explore large amounts of data and to make educated business decisions based on that data. Using Goal Seek and Solver enables you to retrieve required results from formulas by determining the data the formula requires. And you can use additional what-if analysis components, data tables and scenarios, to forecast worksheet outcome models and to see how changing values in formulas affect the formula results.
1
Applying Basic Data Formatting in Excel 2010 Desktop Excel 2010 provides a number of tools and features that allow you to visually enhance the appearance of worksheets and workbooks. Data and cells can be manipulated and customized using various positioning and formatting features. This course explores the processing of formatting cells and text, using tools such as the format painter and changing the way text is presented in order for it to be more visually appealing. This course also explains the various options for formatting numbers in Excel 2010. 1
Automating Excel 2010 Tasks Using Macros Desktop To automate repetitive tasks, Excel 2010 provides a time saving feature known as a macro. These small programs, created using either a simple macro recorder or by using the more complex VBA language, allow you to record the numerous steps involved in accomplishing a task so that they can be played back automatically when the macro is run. This results in time savings and increased efficiency in day-to-day tasks. This course will introduce you to macros in Excel and show you how to leverage their power to make you work with Excel easier.
1
Customizing Visual Elements in Excel 2010 Desktop Adding visual elements to Excel worksheets can help to enhance what can sometimes be dry facts and figures, making it easier to hold the attention of the intended audience. A balance needs to be struck, however, between enhancing and overwhelming when it comes to adding graphics and colors to your Excel workbooks. Excel 2010 provides you with a number of basic and advanced techniques for customizing common elements such as charts, themes, cell styles, and graphics. This course describes many of these techniques and shows you how to implement them to their best effect.
1
Getting Started with Excel 2010 Desktop Excel 2010 is the newest version of Microsoft's comprehensive spreadsheet tool that offers features that support a wide range of functions. The Ribbon menu is unique to Microsoft Office and stacks the many features of Excel into related tabs, making it easy to quickly access the ones you need. Backstage view is a streamlined gathering of all file-level tools, such as those used for saving, printing, and sharing your files. This course explores these topics and many other basics of Excel 2010, including opening the application, creating new spreadsheets, entering data and, AutoFill features. It also provides an introduction to the many tools that will help you create and use your spreadsheets productively. 1
Inserting Basic Charts in Excel 2010 Desktop Using the charts feature in Excel 2010, you can create attractive and well-organized representations of worksheet and workbook data. Charts can be easily inserted and customized from the Charts group on the Insert tab of the Ribbon. This course demonstrates how to effectively use and customize charts in Excel 2010; it explores available chart types and the best use of each type; and shows how to change the different elements of a chart to provide an effective visualization of your data.
1
Manipulating Formulas and Using Forms in Excel 2010 Desktop Excel 2010 provides a large variety of statistical functions that allow you to perform data analysis on worksheet data, several cube functions that allow you to return information from cubes, and the means of working with arrays. In addition, using the Developer tab, you can further customize an Excel workbook to increase its functionality with form and ActiveX Controls. This courses discusses various statistical functions, include those designed to work with averages, determine the median, pinpoint rank and percentages, and sample populations. In addition, this course explores the available cube functions, such as CUBEMEMBER, CUBESET, and CUBEVALUE. Summarizing data using conditional functions such as SUMIF and COUNTIFS are also covered. This course also examines the methods Excel 2010 provides for working with arrays, including one-dimensional and two-dimensional arrays. Adding form and ActiveX Controls to Excel worksheets is also covered. 1
Microsoft ® Office Excel ® 2007: Level 1 (Second Edition) Desktop As a business professional, you may have worked with the earlier versions of Excel such as Microsoft Excel 2003. This course is designed for experienced Excel users who want to use the upgraded version of Microsoft Excel 2007 or those who want to examine the redesigned user interface and utilize its interactive features. In this course, you will explore the new features and enhancements in Microsoft Excel 2007, insert and format tables, sort and filter data in spreadsheets, create charts and illustrations, and save data in specified formats. The information presented in this course will enable you to work effectively by organizing, analyzing, and presenting data. This will help you gain the confidence needed to perform tasks quickly and efficiently thereby improving your overall efficiency and productivity. 6.25
Microsoft ® Office Excel ® 2007: Level 2 (Second Edition) Desktop In this intermediate-level course, you will use Microsoft ® Office Excel ® 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas, which will allow the data to be analyzed in a variety of formats.

The target students for this course are 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. In addition, this course helps prepare students who desire to take the Microsoft Office Specialist exam in Excel and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.
6
Microsoft® Office Excel® 2007: Level 3 Desktop You have used Microsoft® Office Excel® 2007 to perform tasks such as running calculations on data and sorting and filtering numeric data. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications. This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft® Office Excel® 2007, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data. 8.25
Moving and Getting Around in Excel 2010 Desktop While it can look complicated and daunting, navigating the Excel interface isn't as difficult as it first appears. This course will show you how to move around the Excel interface using the various keys on the keyboard, such as the Home and End keys, and Ribbon commands. The course also covers the ways in which you can view and arrange workbooks and worksheets to be the most useful and shows you how you can access Excel's many Help features. 1
Moving Data and Modifying Worksheets in Excel 2010 Desktop The ability to easily manipulate data is probably the biggest benefit of using productivity applications, such as Excel 2010. For instance, if you have to copy the same data multiple times or move large amounts of data from one place to another within a worksheet or between workbooks, you can see this is much more easily accomplished through software than through the use of pen and paper. For example, Excel 2010 features such as Live Preview let you see how copied data will look before you copy it, even if it's copied between Office applications, and the Paste Special option allows you to further define how your data is copied or moved. This course is designed to show you many of the ways that Excel 2010 allows you to manipulate data and the worksheets that contain them and describes features that let you do this quickly and efficiently.
1
Organizing Data and Objects in Excel 2010 Desktop Excel 2010 provides multiple features for organizing and managing data, including sorting and filtering tools that are integral to data analysis. Using data organization features, you can sort, filter, and group and outline data so that you can focus on its key parts. Properly arranged data using the commands in the Arrange group allows you to present your data in a logical and easy to understand manner. This course explores organizing data in Excel 2010 using the built-in features. It also covers arranging objects for better viewing as well as the use of hyperlinks to organize data.
1
PivotTable Filters, Calculations, and PowerPivot  Desktop PivotTables are a handy tool for summarizing large amounts of data efficiently and making it more manageable. Sometimes, though, it's useful to be able to filter the data in a PivotTable, and Excel 2010 provides filtering functionality for this specific purpose. For those people who require a more visual representation of data, Excel 2010 provides a new feature called a Slicer, which is basically a graphical representation of a PivotTable filter. Excel also provides a number of ways in which you can apply calculations to the data in PivotTables in the form of summary functions and custom calculations. All of these useful features of Excel 2010 are introduced and described in this course.  1
PivotTables and PivotCharts in Excel 2010 Desktop One of the most powerful tools that Excel 2010 provides is a PivotTable that allows you to dynamically reorganize and display your data. PivotTables can summarize huge amounts of data by category without the need to input complex formulas or spend long hours manually reorganizing your spreadsheet. PivotTables also allow you to choose and change what you want to summarize, quickly and easily. This course will introduce you to PivotTables and show you the many benefits they provide. 1
Reviewing and Protecting Content in Excel 2010 Desktop Excel 2010 provides easy to use and access tools that allow you to review, proof, and protect the workbooks you create and share. The tools for performing these tasks are grouped conveniently on the Ribbon and include the Spelling, Research, and Thesaurus tools; a Translate tool; tools to insert, edit, and review Comments in a worksheet; and tools for tracking changes and protecting workbooks. The various tasks you can perform with these features are covered in this course, along with how and when you would use these tools.
1
Saving, Sending, and Printing Excel 2010 Workbooks Desktop Excel 2010 makes it easy for you to save, print, and share workbooks and worksheets. When you create an Excel workbook, you will most likely want to save it, and in many instances, print it to save a hard copy or share with someone else. New features of Excel 2010 also allow you to easily collaborate with others by using the Sharing option in Backstage view. All of these options   saving, printing, and sharing   are grouped together on the File tab for convenience. This course describes these Excel features and explains how to use them to increase your efficiency and productivity.
1
Sharing Excel 2010 Workbooks Online and on a Network Desktop As both business and home users move toward working in more electronically collaborative environments, the need to share Excel workbooks and to have multiple users edit them simultaneously has increased. Excel 2010 allows you to share workbooks over a network, distribute them by e-mail, and share them online. You can make use of Information Rights Management (IRM) to ensure that users cannot copy or forward workbook content, as well as to expire files and enforce corporate information dissemination policies. You can also specify that users can only edit specific ranges in a shared workbook. This course covers sharing Excel 2010 workbooks on a network with advanced sharing options, the limitations of shared workbooks, and the uses and limitations of IRM. It also covers how to limit users' editing to specific cell ranges in a worksheet, and how to apply the AutoRepublish feature when saving workbooks for use on the Web. 1
Using Basic Formulas in Excel 2010 Desktop Excel 2010 provides you with the tools that allow you to perform calculations on your workbook data. Being able to use formulas to do complicated calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. This course introduces the concepts and terminology associated with formulas, and demonstrates how to create and edit them, copy and paste them, and how to check for errors that can arise.
1
Using Basic Functions with Excel 2010 Desktop One of the great features of Excel 2010 is its ability to perform a wide variety of functions to make your use of Excel 2010 easier and more fun. Functions are inbuilt formulas that save you time by allowing you to chose one that suits your needs rather than having to create a complex formula from scratch. This course introduces you to the changes made to functions in Excel 2010, including improved function accuracy and consistency as well as the changes made to some function names that make them more intuitive. It describes the useful feature of Excel's status bar that automatically displays basic calculations as well as the Function Library, which groups useful functions. The most common use of functions, calculating basic financial, logical, date and time data is also covered.
1
Using Conditional Formatting, Tables, and Sparklines in Excel 2010 Desktop Excel 2010 provides tools that enable you to efficiently present your data and that can also make your data easier to understand. Tables can be used to logically present data in an easy to read fashion and table styles provide a way to make your workbooks more attractive and professional looking. Conditional formatting allows you to highlight trends and exceptions in cells or ranges of cells by presenting the identified data in a number of unique ways to make it stand out. Sparklines, a new feature of Excel 2010 are small charts within a cell that provide a visual representation of data and can be used to show trends in an appealing manner. These features   tables, styles, conditional formatting, and sparklines   how to access them and how to use them, are covered in this course.
1
Using Excel 2010 Data Connections: Web Queries, XML, and Databases Desktop There are a number of methods for accessing and using external data with Excel 2010. Creating new or using existing data connections, you can access data from the Internet, Access and SQL Server databases, and Analysis Services. You can also import and export XML data, use Microsoft Query and the Query Wizard to create your own queries, and work from text files. This course explores the concept of data connections, including how to use existing connections to access data and how to create your own. In addition, this course covers how to create a web query to access online data and use it within Excel. Importing XML data is covered, and the course also describes the process of using the Query Wizard to create and edit queries. 1
Using Excel 2010 to Collaborate Online and with Other Office Applications Desktop Being able to collaborate with other users to efficiently disseminate information and complete projects is crucial in today's business environment. Excel 2010 provides numerous tools geared specifically toward collaboration, including Excel Web App and integration with SharePoint that allows for data to be easily exported. Excel 2010 data can also be linked to or embedded in other Office 2010 files, and other Office 2010 data can be linked to or embedded into Excel 2010 to create robust and professional content. This course explores the new Excel Web App, including information on the Web App interface, its limitations, and how to access the full version of Excel 2010 from within it. In addition, this course covers exporting data from a SharePoint list to Excel, and exporting data from Excel into a SharePoint list. Linking Office 2010 content to and embedding Office 2010 content in Excel workbooks is also covered. 1
Using Lookup, Reference, Math, and Text Functions in Excel 2010 Desktop The Excel 2010 function library includes a number of functions in Lookup & Reference, Math & Trig, and Text categories that enable you to quickly complete tasks and analyze data. Lookup and reference functions allow you to perform table lookups to return required information about specific worksheet cells. This course covers lookup and reference functions such as LOOKUP, VLOOKUP, HLOOKUP, INDEX, ROW, and COLUMNS. Math & Trig functions provide multiple methods of working with numbers and triangles. This course explores rounding functions, INT, TRUNC, AGGREGATE, COS, SIN, and TAN. Excel 2010 also provides a number of functions to make working with text easier. Text functions, such as TRIM, CLEAN, PROPER, SEARCH, and MID, as well as string concatenation, are covered. 1
Verifying Excel 2010 Data and Formulas Desktop Formulas are an integral and important feature of Excel 2010. So ensuring they are correct can save you time and a lot of headaches. Excel 2010 provides you with the tools you need to audit formulas and correct errors that may be found. In addition, using Excel's data validation tools you can restrict the types of data that can be input to your workbooks   preventing data entry errors that could otherwise occur. This course describes Excel 2010's auditing and formula correction features and shows you how to use data validation to avoid worksheet errors.
1
Workbook Settings, Conditional Formatting, and Number Formats in Excel 2010 Desktop You can customize the look and feel of workbooks and the program's functionality and efficiency using Excel 2010's numerous features and tools. You can modify existing themes and styles to meet business needs, or you can create custom themes and styles to further enhance data presentation. Custom number formats allow you even more control over the presentation and usefulness of your workbooks and conditional formatting gives you the power to apply individual formatting based on custom rules that meet your specific needs. This course explores some of the more advanced ways that you can enhance your workbooks and data using Excel 2010's powerful customization features.
1
Basic Business Math: Averages and Equations Desktop Basic math skills are practical in any business situation, whether it be calculating average call turnaround times in a call center or using equations to find the stock of inventory and the items that have been sold in a retail store. Because math skills are valuable in so many business situations, refreshing your skills can demonstrate your mathematical competence and business savvy.   This course builds on the basic math that you learned in your school years, showing you how to apply those skills to some common business situations. It helps you to confidently calculate weighted and moving averages, as well as using equations in business through a series of real-life problems and examples. 1
Basic Business Math: Percentages and Ratios Desktop An understanding of basic mathematical principles is important for any business person. They enable you to figure out resource requirements, estimate costs, work out average time spent on different activities, or calculate commission earnings. Percentages and ratios are a means of highlighting many relationships in business, not least of which are financial. The ability to calculate work with percentages and ratios is an essential skill for anyone working today.  This course builds on the basic math skills that you learned in your school years, showing you how to apply those skills to some common business situations. And it helps you to confidently use percentages and ratios in business through a series of real-life problems and examples. 1
Basic Business Math: Using Whole Numbers and Decimals Desktop An understanding of basic mathematical principles is important for any businessperson. Math skills enable you to figure out resource requirements, estimate costs, work out average time spent on different activities, and calculate commission earnings. The ability to analyze and comprehend numbers is a vital skill for personal, as well as corporate, growth and success.  This course builds on the basic math skills that you learned in your school years, showing you how to apply those skills to some common business situations. And it helps you to confidently use whole numbers and decimals in business through a series of real-life problems and examples. 1
Accessing Exchange Remotely and Using Forms in Outlook 2010 Desktop Whether it is to stay in touch with friends and family or to message colleagues from the office, people depend on e-mail communication more than ever before. When away from the office, Outlook 2010 offers two options for people to access their Exchange e-mail accounts   Outlook Web App and Outlook Anywhere. This course discusses how to access and sign on to Outlook Web App using a web browser and how to configure Outlook 2010 with Outlook Anywhere so that users can send and receive messages. This course also covers the role that forms play in Outlook 2010 and how forms can be customized to meet your needs. 1
Customizing Outlook 2010 and Managing Accounts Desktop Outlook 2010 has now adopted a Ribbon, similar to the other products in the Office suite, which provides an intuitive interface with most commands readily available. The Outlook interface is highly customizable as well. This course discusses how to modify the Ribbon to suit your preferences, as well as ways that views and panes can be customized. Configuring Exchange e-mail accounts are also discussed. 1
Data Files, Archiving, and Send/Receive Groups in Outlook 2010 Desktop Items created in Outlook 2010 are stored in data files on your computer. Proper management of these files is important in organizing Outlook items and managing space on your hard drive. This course discusses PST and OST files and how they can help you while working with Outlook 2010. Archiving data also plays an important role in Outlook 2010, and this courses covers how to manage AutoArchive settings and how to manually archive items. Also discussed in this course is the creation and management of Send/Receive groups, which enable you to control how often Outlook folders are updated. 1
Formatting E-mail and Configuring Message Options in Outlook 2010 Desktop The default installation of Outlook 2010 allows you to easily send and receive messages among colleagues and friends. There are, however, many options that help you make creative, more visually appealing messages, as well as options that change how messages are sent. This course discusses sending e-mail in different message formats as well as formatting options that can be applied to the text and background of an e-mail. Also covered are how to check your message's spelling and grammar, how to track outgoing messages, how to add voting buttons, and how to set importance and sensitivity options. 1
Getting Started with Outlook 2010 Desktop Outlook 2010 is the latest release of Microsoft s primary messaging client. Outlook provides all of the tools necessary to manage e-mail, scheduling , tasks, and communication. The Outlook 2010 interface has been updated and now uses the ribbon instead of menus, which makes it easier to locate the commands you need. This course addresses the basic features and functionality of Outlook 2010, including an introduction to the redesigned interface, how to create e-mail messages, and view and reply to incoming e-mails. 1
Implementing Security with Outlook 2010 Desktop Outlook 2010 provides a number of security options that should be enabled to protect you from viruses, unwanted junk mail, and other malicious attacks directed at computer users. This course explains how to protect yourself from spam, junk mail, and phishing attacks as well as how to safely open suspicious messages and attachments. To ensure that no unwanted users can read messages that are not directed towards them, digital signatures can be used. This course discusses how to obtain and apply digital signatures to messages. 1
Managing Attachments, Graphics, Signatures, and Autoreplies in Outlook 2010 Desktop Using Outlook 2010 you can now create e-mail messages that include compelling visuals and graphics that capture the reader s attention. You can also attach and format screenshots from your computer to better convey ideas in your message. This course discusses working with attachments in Outlook 2010 as well as including graphics, tables, symbols, and links in your messages. How to add signatures to e-mail and auto replying to messages that you receive are also covered. 1
Managing Conversations and Organizing E-mail in Outlook 2010 Desktop Microsoft Outlook 2010 provides you with the tools you need to efficiently manage and organize your e-mail messages. Included in Outlook 2010 is a new Conversation view that automatically groups all of your messages by subject, greatly reducing the number of items in your Inbox. This feature along with options that allow you to categorize and flag messages are discussed in the course. Also, covered are the ways you can organize messages in the Inbox. 1
Managing E-mail with Rules, Automatic Replies, and Alerts in Outlook 2010 Desktop Outlook 2010 contains numerous features to help manage the large volume of e-mail that many users receive on a daily basis. Options can be configured to automatically move incoming e-mail into specified folders and Desktop Alerts can be set to notify you of incoming e-mail. This course discusses managing e-mail messages with rules as well as configuring automatic replies and Desktop Alerts for incoming messages. 1
Managing Meetings and Customizing the Calendar in Outlook 2010 Desktop The main functions of the Calendar in Outlook 2010 have remain largely unchanged from previous versions of Outlook. However, many tasks have been streamlined. It is now easier to create and view additional calendars in Outlook 2010 and viewing group calendars has been integrated into the Calendar view. This course demonstrates the available options when replying to meeting requests and managing meeting requests. It covers how to create and view additional calendars, view another person's calendar, and create a calendar group. Also covered are ways to customize the Outlook 2010 calendar. 1
Microsoft ® Office Outlook ® 2007: Level 1 (Second Edition) Desktop This course is intended for the beginner student that has no previous experience using Outlook. In this course, you will, compose and send email, schedule appointments and meetings, manage contact information and tasks, and use notes.

This course is designed for any person with a basic understanding of Microsoft Windows who needs to use Microsoft ® Office Outlook ® 2007 to compose and send email, schedule appointments and meetings, manage contact information and tasks, and use notes. In addition, this course helps prepare students who desire to take the Microsoft Certified Applications Specialist certification for Outlook.
8.5
Microsoft ® Office Outlook ® 2007: Level 2 (Second Edition) Desktop This course is the second in a series of three Microsoft ® Office Outlook ® 2007 courses and is intended for intermediate users. In this course, you will customize your Outlook environment, Calendar, mails, folders and also track, share, assign, and quickly locate various Outlook items.

This course is designed for experienced Outlook users who need to customize their environment, Calendar, and email messages to meet their specific requirements and who wish to track, share, assign, and locate various Outlook items.
8.25
Microsoft ® Office Outlook ® 2007: Level 3 (Second Edition) Desktop This course is intended to instruct intermediate Outlook users how to personalize email, organize Outlook items, manage Outlook data files, share and link contacts, save and archive mails, create forms, and work offline
 and remotely while remaining productive.This course is for persons with an intermediate understanding of Outlook
 and who need to use Outlook to personalize and organize their email, Outlook  items, manage Outlook data files, share and link contacts, create forms, and  work offline and remotely.
6.5
Outlook 2010 Social Connector and Messaging Desktop With Outlook 2010 it is now easier than ever to keep track of your friends and colleagues as well as communicate with them using a variety of methods. With the rise in popularity of social networking sites, Outlook 2010 now includes the ability to track updates of your friends from within Outlook. This course discusses the Outlook Social Connector and how to configure Outlook to connect to social networking sites. How to configure and use both instant and text messaging from within Outlook is also discussed. 1
Using the Calendar for Appointments, Events, and Meetings in Outlook 2010 Desktop The Outlook 2010 Calendar allows you to create appointments and events, as well as schedule meetings. The Calendar is fully integrated with the other components of Microsoft Outlook 2010 allowing you to easily incorporate your contacts and e-mail functionality with the Calendar. This course introduces the major components of the Calendar as well as providing a tour of the interface. Also discussed are how to create appointments and events, and how to schedule meetings with other Outlook users. 1
Using the Tasks, Notes, and Journal Features in Outlook 2010 Desktop To assist you with the various tasks and information that you need to process on a daily basis, Microsoft Outlook 2010 provides the Tasks, Notes, and Journal features to help keep you organized. You can create tasks for yourself or assign tasks to other users. You can create notes for yourself as small reminders, and manage your activities and information using the Journal. This course discusses how the Tasks, Notes, and Journal features can help you to manage your time and stay organized, and it demonstrates how to use them. 1
Working with Contacts in Outlook 2010 Desktop By taking the time to create contacts in Outlook 2010, you can save yourself from having to type out full e-mail addresses every time you send a message, assign a task or send out meeting requests. You can further arrange contacts by creating contact groups that allow you to e-mail multiple contacts at once by only typing the group name. This course covers the multiple ways that contacts can be created, as well as how to modify existing contacts, and import and export contacts between Microsoft Outlook 2010 and Google Gmail. 1
Working with Files and Folders and Using Search and RSS Feeds in Outlook 2010 Desktop Outlook 2010 provides default folders such as the Inbox, Deleted Items, and Sent Items to assist users in managing and organizing their e-mail messages. Sometimes these folders do not meet all of a user s needs and additional folders need to be created. This course discusses the creation and management of additional folders in Outlook, as well as the creation of Search folders, which is a type of virtual folder used to automatically organize messages. The course covers how to use the Instant Search feature, which allows you to instantly find e-mail messages, and how to refine your searches. Importing and exporting files are demonstrated. RSS feeds and how they can be used in Outlook 2010 are also discussed.  1
Adding Images to Presentations in PowerPoint 2010 Desktop Inserting images, such as photographs, clip art, and shapes, into your PowerPoint 2010 presentation can help to capture and keep the attention of your audience. This course will show you how to insert, format, and apply special effects to your images so that they provide the maximum impact for your presentation. You will learn how to create a photo album and create a presentation that effectively displays your favorite photos. In addition, you will be shown how to use the new built-in screen capture tool that enables you to capture and embed screenshots of other programs into your slides.  1
Collaborating and Sharing Presentations in PowerPoint 2010 Desktop Today people can collaborate on the development of PowerPoint presentations in new and exciting ways. With the proper technological infrastructure in place, PowerPoint has the capability of allowing multiple people to work on the single presentation at the same time. An alternative to co-authoring a presentation with other team members is to send the presentation as an e-mail attachment, save it to a web site, burn it on a CD, or broadcast it live over the Internet. To simplify the process of reviewing and accepting or rejecting changes, you can now merge the reviewed version with your original version into one presentation. This course explores these topics and many other collaboration features available in PowerPoint 2010. Also covered are proofing, language, and research tools, along with options for printing and protecting a presentation. 1
Getting Started with PowerPoint 2010 Desktop PowerPoint 2010 is a presentation program that allows you to create professional-looking slide-show presentations. This course provides an introduction to the main components of the PowerPoint 2010 interface. It covers opening and saving a presentation, working with slides, formatting text and text boxes, and using templates and themes to create professional looking presentations. 1
Microsoft ® Office PowerPoint ® 2007: Level 1 (Second Edition) Desktop You may want to upgrade the paper-based overhead presentations to an electronic format. In this course, you will work with the Microsoft ® Office PowerPoint® 2007 to give electronic presentations.

This course is designed for students who are interested in learning the fundamentals needed to create and modify basic presentations using Microsoft® Office PowerPoint ® 2007. This course is also intended for students interested in pursuing Microsoft Office Specialist certification in Microsoft ® Office PowerPoint ® 2007.
1
Microsoft ® Office PowerPoint ® 2007: Level 2 (Second Edition) Desktop By designing your Microsoft ® Office PowerPoint ® 2007 presentations with high-quality sound and visual enhancements, the ideas you communicate can better meet the expectations of today's media savvy audience while effectively getting your point across. You can also make use of PowerPoint's security features when working in a team across diverse locations.

This course is designed for students who want to gain the skills necessary to work with design templates, various types of diagrams, special effects, custom slide shows, collaboration functionality, and advanced presentation delivery. This course also assists in the preparation for the Microsoft Office Specialist exam in Microsoft ® Office PowerPoint ® 2007. It is for students who already have knowledge of the basics of PowerPoint 2007, including slide formatting and working with tables, charts, images, objects, and presentation preparation.
1
PivotTable Filters, Calculations, and PowerPivot Desktop PivotTables are a handy tool for summarizing large amounts of data efficiently and making it more manageable. Sometimes, though, it's useful to be able to filter the data in a PivotTable, and Excel 2010 provides filtering functionality for this specific purpose. For those people who require a more visual representation of data, Excel 2010 provides a new feature called a Slicer, which is basically a graphical representation of a PivotTable filter. Excel also provides a number of ways in which you can apply calculations to the data in PivotTables in the form of summary functions and custom calculations. All of these useful features of Excel 2010 are introduced and described in this course. 1
Using Advanced Slide Show Tools in PowerPoint 2010 Desktop PowerPoint 2010 provides you with all the tools necessary to create and present engaging and effective presentations. As an advanced user, you can take advantage of features that allow you to customize your animations to create just the right effect. PowerPoint has tools for getting your animations to move at the right speed and in the right order. There are also built-in tools, such as the animation painter, that allow you to easily apply an animation scheme to the entire presentation in one easy step. Once you have perfected your presentation, you can set and rehearse timings, create mouse-over actions for elements on a slide, and record your presentation for automatic delivery. There are also many tools that make the presentation of your slide show easy and effective, such as highlighters and laser pointers. These tools and features are all covered in this course. 1
Using Multimedia and Animations in PowerPoint 2010 Desktop PowerPoint 2010 can help you make presentations more dynamic by adding audio and video clips to any slide. You can directly insert, edit, and play video in your presentation, as well as add audio clips to create attention-grabbing sound effects. PowerPoint 2010 also has new animation tools and slide transitions which make slide shows more fluid and interesting. All of these features are discussed in this course.  1
Visually Enhancing PowerPoint 2010 Presentations Desktop PowerPoint 2010 enables you to create visually appealing presentations through the use of graphics. Adding simple enhancements through the use of themes, tables, charts, and SmartArt allows you to create more engaging and interesting presentations. This course introduces the various themes and SmartArt features that allow you to add flair to your presentations by using colors and shapes to emphasize text and data. Also covered are the various ways of incorporating diagrams, tables, and charts to create a professional and effective presentation. 1
Microsoft ® Office Publisher 2007 Desktop In this course, you will look at how to create a publication from scratch or use one of the hundreds of business and personal designs available in Publisher.
 This course was designed for persons with a basic understanding of Microsoft Windows and Microsoft Word who need to learn how to use Microsoft ® Publisher 2007 to create, layout, and edit publications.
7.5
Adding Tables of Contents, Footnotes, Hyperlinks, and Bookmarks in Word 2010 Desktop Word 2010 offers you a variety of tools that allow you to insert navigation and reference materials into a document. With heading styles applied to your document, you can easily construct a table of contents; you can also insert footnotes and endnotes, and you can quickly link to web pages, shared files, or other sections of a document using bookmarks. This course explores all of these topics, and discusses how to use each feature to improve the readability of your documents. 1
Creating and Formatting Tables in Word 2010 Desktop Word 2010 has a robust set of tools that allow you to create, style, and format tables in your documents. This course explores the various methods of inserting tables in Word documents, including selecting a layout from a list of preformatted tables, choosing a table size by selecting a layout from a dynamic grid, and by configuring table settings to match the number of columns and rows that you require. It also discusses using table styles to enhance the appearance of tables and changing the layout of tables. 1
Customizing the Behavior and Appearance of Word 2010 Desktop Word 2010 enables you to efficiently create attractive and organized documents using a variety of automated and pre-built features. You can quickly and easily use any of the Word 2010 styles to give your document a polished appearance, or you can create your own styles so you can use a custom appearance over and over. In addition, Word 2010 enables you to create documents using pre-built templates that are bundled with Word, saving you time and effort in choosing a layout and color scheme for your files. This course introduces Quick Styles and templates, and also explores an editing feature   AutoCorrect   that automatically corrects common errors such as not capitalizing the first letter of a sentence, or accidental usage of the Caps Lock key. The course also demonstrates how you can customize the Ribbon. 1
Drawing and Inserting Graphics in Word 2010 Desktop We all know that to create an effective Word document, your text must be clear and organized, but we sometimes neglect the overall attractiveness of our documents. This course demonstrates powerful drawing and graphic features of Word 2010 - features that can boost the appeal of virtually any document! The course focuses on the processes and tools that allow you to add pictures, Clip Art, screenshots, and SmartArt to your documents. It also explores drawing components such as shapes, WordArt, and text boxes. 1
Embedding Charts and Tables into Word 2010 Desktop Word 2010 offers a wide variety of table and charting tools that let you manipulate and display your data in an attractive, understandable manner. This course shows you that by following a few simple steps you can easily paste Excel data into Word 2010 and either embed the values directly in the Word document or link back to the original Excel workbook. The course also discusses the role of Excel 2010 in Word 2010 table creation and manipulation. And it explores methods of inserting and then designing and altering the layout of many types of charts, including bar charts, pie charts, bubble charts and more. 1
Formatting and Working with Text in Word 2010 Desktop Word 2010 makes it easy to apply formatting to documents by providing a live visual preview of various formatting options. This allows you to view a variety of formatting changes before actually committing to them. This course explains the Font formatting options, as well as the Mini toolbar and Live Preview features. In addition, the creation and formatting of bulleted, numbered, and multilevel lists are demonstrated. 1
Forms, Fields, and Mail Merge in Word 2010 Desktop Word 2010 enables you to create forms quickly and easily, so that they can be used by other users of Word 2010. Forms contain editable form controls that you can link to external data sources, and Word 2010 contains security features to protect forms from tampering by other users. Another method of capturing document information is by using fields. You can use fields to add information about a file into the document. For example, you can insert an Author field to insert the author's name, or use a LastSavedBy field to enter the name of the person who last saved the document.   Word 2010's mail merge feature enables users to merge content such as address blocks into letters, e-mail messages, envelopes, and labels very easily. This course demonstrates how to add, modify, and update forms and fields, and also illustrates the various mail merge capabilities of Word 2010. 1
Getting Started with Word 2010 Desktop Word 2010 is the newest version of Microsoft's dynamic word processing tool and it offers features that allow you to create attractive and engaging documents. The Ribbon menu, which is unique to Microsoft Office, organizes Word s many features into related tabs and makes it easier to quickly access those you need. The new Backstage view provides a single streamlined 'stage' for all file-level tools, such as those used for saving, printing, and sharing your files. This course explores these topics and many other basics of using Word 2010, including opening the application, creating new documents, and an introduction to the many tools that will help you create and edit your documents. 1
Managing, Inspecting, and Recovering Word 2010 Documents Desktop Microsoft Word 2010 offers several options for securing and protecting Word documents as well as providing various features you can use to recover and repair documents. This course demonstrates how to use Word 2010 document security, which includes viewing document properties such as presence information on author contact cards, locking document formatting, password protecting documents, using the Document Inspector, and working with digital signatures. The course also explores recovering unsaved drafts and damaged Word 2010 documents. 1
Manipulating Tables in Word 2010 Desktop You can use Word 2010's features for both designing tables and manipulating your table data. A variety of layout tools allow you to merge and split cells, split tables, autofit cell sizes to match the size of contents, and insert and delete cells. You can also easily insert columns and rows, and then adjust their layouts and distribution. This course explores these methods of altering a table's layout and also walks you through using data tools that allow you to easily sort your data, making critical information easier to locate. The course also covers using formulas in Word 2010 tables, so you can quickly perform calculations or insert other pre-built mathematical functions. 1
Microsoft ® Office Word 2007: Level 1 (Second Edition) Desktop This course is intended for individuals who are new Word users. In this course, students will create, edit, and enhance standard business documents using Microsoft ® Office Word 2007.

This course is intended for individuals who want to gain basic knowledge of working on Word. 
8.5
Microsoft ® Office Word 2007: Level 2 (Second Edition) Desktop This course goes beyond the basics of Microsoft ® Office Word 2007, helping you to increase the complexity of your Word documents. You will create customized efficiency tools, and add customized lists, tables, charts, and graphics to your documents. These skills will allow you to efficiently produce high-quality, effective, sophisticated documents. This course will help you prepare for the Microsoft Certified Application Specialist exam for Microsoft Word 2007.

This course was designed for persons who can create and modify standard business documents in Microsoft Word 2007, and who need to learn how to use Microsoft Word 2007 to create or modify complex business documents as well as customized Word efficiency tools. It will be helpful for persons preparing for the Microsoft Certified Application Specialist exams for Microsoft Word 2007.
9
Microsoft ® Office Word 2007: Level 3 (Second Edition) Desktop You know to use Microsoft ® Office Word 2007 to create and format typical business documents. Now, you may need to work on more complex documents. In this course, you will use Word to create, manage, revise, and distribute long documents and forms.

This course is designed for persons who want to gain skills necessary to manage long documents, collaborate with others, and secure documents. In addition, it will be helpful for persons preparing for the Microsoft Certified Application Specialist exams for Microsoft ® Office Word 2007.
8.5
Moving Around in Word 2010 Desktop Word 2010 offers a variety of intuitive navigation features that help you move around and find your way through documents, whether they're a few pages or hundreds of pages long! This course explores basic navigation features such as scrollbars and keyboard keys, along with built-in tools such as the new Navigation Pane. This pane combines features of the Document Map, thumbnails, and Search features found in earlier versions of Word into one, easy-to-use interface. The course also demonstrates how to use Word's Full Screen Reading view to page through a file as if it were a printed document, and how to use Word's Outline view to organize your document. 1
Organizing and Arranging Text in Word 2010 Desktop To create an attractive, coherent Word 2010 document, it's important to understand the application's basic paragraph-formatting features. This course explores formatting paragraphs in Word 2010, along with a variety of other useful formatting tools such as margins and indents. The course demonstrates how to set margins, paragraph indenting and alignment, tab stops, and how to show or hide formatting marks than can help guide your formatting decisions. 1
Reviewing Documents in Word 2010 Desktop No one wants to be embarrassed by glaring grammatical mistakes and misspellings in a document. To help you catch these errors, Word 2010 includes editing tools that enable you to spot and fix your typos as you work. It also enables you to use other proofing features such as a thesaurus, research options, and word count statistics to help you proof your work. In addition, you can make changes while reviewing your work using a feature that tracks all of your edits, and you can also leave comments during your review. This course explores all of these proofing features, from spelling and grammar correction to tracking changes. The course also demonstrates how to use the Help feature in Word 2010. 1
Saving, Sharing, and Printing in Word 2010 Desktop Once you've created an attractive, well-structured document, how do you save it for future use? Word 2010 enables you to save your documents in many formats, including the standard .docx file extension, along with the well-recognized .doc extension. You can also save your documents as PDF or XPS files to make them uneditable and give them standardized appearances for sharing. In addition, you can choose to save and send your document using e-mail, Microsoft SkyDrive, upload your document as a blog post, or save it on SharePoint. If you want to print your document, you can use Word 2010's new streamlined Print interface which presents print options, such as orientation and duplex printing, on the same page as a preview of your document. This course explores Word 2010's features for saving and printing your documents. 1
Structuring Word 2010 Documents Desktop Word 2010 provides many options for structuring your documents quickly and easily. This course demonstrates how to use headings to restructure the outline of a document using the Navigation Pane. If you're creating large documents with many pages, you might want to add page numbers to make your information easy to locate. The course explores how to add page numbers along with other structural components, such as page and sections breaks, headers, and footers. 1
Using Themes, Backgrounds, Watermarks, and Quick Parts in Word 2010 Desktop Using Themes, Backgrounds, Watermarks, and Quick Parts in Word 2010 1
Basic Presentation Skills: Planning a Presentation Business Skills Even the most seasoned public speakers can experience nerves before a major presentation. The successful ones, however, have learned how to make those nerves work for them. Positive concern about the impact of a presentation can spur presenters to raise their game, enabling them to get the desired results. For example, a presentation can be immeasurably improved if you devote sufficient time and attention to three key steps - analyzing your audience, organizing your ideas, and selecting an appropriate presentation method. This course describes how to plan effectively for a presentation by carrying out these steps.  1
Basic Presentation Skills: Creating a Presentation Business Skills Among the fears that people have about giving a presentation is that they will get mixed up, forget to make a key point, or repeat themselves. One way to avoid this is to have a sound structure. Once you have identified the purpose and audience for the presentation, and come up with some ideas for what to say, you can transform those ideas into a script or notes that will guide you through the presentation. You should start with an introduction, where you grab the attention of the audience and tell what you are going to do. Next, you need to support each of your key points and, at the same time, not lose the attention of the audience. At the end of your presentation, you need to give your audience a clear understanding of what happens next. You also must make your ending compelling. After all, this is how the audience will remember you.
This course describes how to make these key parts of a presentation – the introduction, support content, and conclusion – memorable and effective. It also explains the purposes for which different presentation aids are used, as well as how to use visuals appropriately. Finally, this course describes how to rehearse a presentation – a key step in building confidence for the real thing. 
1
Basic Presentation Skills: Delivering a Presentation Business Skills Excellence in presentation can be achieved when the standard of your delivery matches the quality of your content. You may have carefully planned and structured what you want to say, but if you deliver your message in a monotone while standing stiffly, you're probably not going to captivate the audience. Having diligently prepared for your presentation, you need to make sure that your delivery is engaging. You need to communicate your enthusiasm to the audience if you want them to be enthusiastic about your ideas. At the same time, you must appear composed and confident. This course describes how to make your delivery successful and memorable. It covers techniques for managing stage fright - the biggest problem most speakers have. It also explains how to set the right environment for your presentation by making the right choices about room layout and by preparing the room, including the equipment, lighting, and temperature. You'll also find out how to use your voice and body language to deliver your message clearly and effectively. Finally, the course outlines guidelines for handling audience questions - an area most speakers are also very concerned about. After all, how credible the audience finds you can be swayed by how effectively you answer the difficult questions that come up.  1
Managing Workforce Generations: Introduction to Cross-Generational Employees             Business Skills More than ever, managers appreciate how diversity brings value to an organization. Managed correctly, a diverse workforce, including members from different generations, enhances performance and productivity. The generation in which you grow up is a key influence on your adult behavior, and the different characteristics of each generation can strengthen an organization if properly managed. But stereotypes are pervasive and divert attention from the positive roles that different generations bring to the workforce. Understanding people from different generations prepares managers for the challenges of generational diversity and is a crucial first step in creating a positive work environment. This course describes the common characteristics of the four main generations in the workforce - the Traditionals, Baby Boomers, Generation X, and the Millennial Generation. It also introduces the benefits of cross-generational teams. 1
Workplace Harassment for Supervisors & Managers Business Skills Typically, when people hear the term workplace harassment, they think of sexual harassment. But that is just one of the many forms workplace harassment may take. Unlawful harassment is any form of unwanted or unsolicited behavior directed at an individual or group of individuals, by another employee or superior, on the basis of a protected characteristic as outlined by various antidiscrimination laws (Title VII of the Civil Rights act, the Americans with Disabilities Act, and the Age Discrimination in Employment Act). These protected characteristics include race, color, national origin, religion, gender, disability, and age. Depending on state law and other circumstances, additional characteristics such as sexual orientation and marital status may also be protected. This course will review the characteristics of various forms of harassment and discuss what supervisors and managers can do to discourage harassing behavior of any type in their own work groups by their employees or themselves. This course was developed with subject matter support provided by The Beale Firm, PLLC. Please note, however, that the course materials and content are for informational purposes only and do not constitute legal advice. Nothing herein, or in the course materials, shall be construed as professional advice as to any particular situation or constitute a legal opinion with respect to compliance with any federal, state, or local laws. Transmission of the information is not intended to create, and receipt does not constitute, an attorney-client relationship. Readers should not act upon this information without seeking professional counsel. The information contained herein is provided only as general information that may or may not reflect the most current legal developments. This information is not provided in the course of an attorney-client relationship and is not intended to constitute legal advice or to substitute for obtaining legal advice from an attorney licensed in your state.  1
Workplace Harassment for Employees Business Skills Harassment at work can have a corrosive effect on an organization's culture and can lead to low employee morale, reduced productivity, and even criminal liability. Focusing on the forms of harassment prohibited by federal law, this course will provide an overview of the types of behaviors that can give rise to harassment claims, including those based on gender, race, color, national origin, religion, age, and disability. It will also discuss the benefits of and strategies for promoting a respectful work environment that is free of all forms of harassment, intimidation, and discrimination. If you have questions about harassment either during or after this course, please contact the designated human resources professional at your company who is trained in this area. This course was developed with subject matter support provided by the Labor and Employment Practice Group of the law firm of Burr & Forman LLP. Please note, however, that the course materials and content are for informational purposes only and do not constitute legal advice. Nothing herein, or in the course materials, shall be construed as professional advice as to any particular situation or constitute a legal opinion with respect to compliance with any federal, state, or local laws. Transmission of the information is not intended to create, and receipt does not constitute, an attorney-client relationship. Readers should not act upon this information without seeking professional counsel. The information contained herein is provided only as general information that may or may not reflect the most current legal developments. This information is not provided in the course of an attorney-client relationship and is not intended to constitute legal advice or to substitute for obtaining legal advice from an attorney licensed in your state.  0.5
Addressing and Redistributing Email Business Skills Out of all the e-mails you've received in the past work week, how many have left you scratching your head, wondering why you received it in the first place? How many of those e-mails have you asking what exactly that e-mail has to do with you? With e-mail's prevalence as one of the main forms of communication in business today, it's essential that when sending an e-mail you get the distribution list right. Sending an e-mail to the wrong person, or excluding the right person, is just as ineffective as dialing the wrong number on the phone, leaving a message anyway, and expecting a return call from the right person. This course covers the techniques for addressing and redistributing e-mails appropriately. Specifically, you will be introduced to the best practices for deciding who to send e-mails to, and how to flag e-mails appropriately. The course also covers proper etiquette for forwarding e-mails and using reply and reply all. Finally, the sensitivities of copying an e-mail over someone's head are addressed.  1
Basics of Effective Communication (Second Edition) (Includes Simulation)  Business Skills Communication is not one event; it is a complex series of processes. We can achieve effective communication by carefully managing each of the processes in the series. This course will help you learn the specific management techniques that will help you communicate more effectively.
2.5