Office Manager Journey

There is a science behind communication, including how we react neuro-physiologically to others - through verbal communication such as their words and tone, as well as the non-verbal communication of their actions and body language. There's also an art to communication, allowing your authentic self to shine through and allowing the exchange with another person to unfold naturally. In this course, you'll learn about the art and science of communication. You'll explore techniques for connecting with your audience and building trust with them so that your communication intention is clear and understood. You'll also learn the basic principles of assertive communication that is positive and not aggressive.

Building relationships with the people you want to communicate with is key to making communication effective. And building trust is essential to forging meaningful working relationships. In this course, you'll explore the necessity of clearly presenting your information and intentions as the basis of effective communication. You'll see how understanding your audience ensures that your message is delivered in such a way so to maximize its impact and how managing your emotions allows you to adapt to the emotional needs of others to build trust. Finally, you'll learn how verbal communication combines with body language and vocal tone to better convey your message effectively.

Do you ever feel that a lack of email productivity is frustrating the effectiveness of your written communication? Are poor verbal communication skills holding you back? Choosing the right communication method for the situation has a huge impact on how your message is received. This course explores the importance of choosing the right communication method to best convey your message. You'll learn how to select the proper methods for building trust, conveying your ideas, and targeting your method to your intended audience. The right communication method improves the odds of getting your point across and communicating effectively, leaving your audience informed, enlightened, and engaged.

Communication is a two-way process - while one person provides information, another must not only understand what is meant, but also show that they're being receptive to that information. This requires strong listening skills - a vital asset in any business environment. In this course, you'll work on sharpening your listening skills and getting yourself in the right receptive mindset for communicating. You'll learn how to recognize the behaviors that indicate receptivity, as well as to identify the different types of listener. You'll also learn how to ask the right questions to ensure that you understand what is being communicated.

Communicating effectively can be challenging when having difficult conversations. Because these challenges typically involve emotions such as hurt, anger, or confusion, it's not uncommon for people to avoid one another or shut down, preventing what could be a productive exchange at many levels. In this course, you'll examine some common communication challenges and how you can successfully navigate them. By showing patience, perseverance, and accountability, you can effectively deal with tough conversations, communicate your message, and reach mutual understanding and agreement.

Communicating with confidence is critical to your message being successfully received. Feeling confident in a high stakes situation is not always easy but with effort, confidence can be cultivated and improved. In this course, you'll learn about being an effective speaker. You'll discover ways to prepare, techniques to avoid being nervous and how to use your voice and body language to communicate with self-confidence.

Get started with Excel 2019, the spreadsheet application included with the Microsoft Office 2019 Suite. During this course, you will familiarise yourself with the interface and some of its features, including the ribbon, status bar, zoom, and various view modes. Begin the course by learning how to find the application on the desktop and open it. To get the most out of Excel, you need to understand how the interface is laid out, so the course next explores the application. This leads into the zoom function, which can be used to adjust how to visualize the spreadsheet in Excel by making data entries larger or smaller. Discover how to examine mode views, which in Excel features three different preset view modes: Normal, Page Layout, and Page Break. Conclude the course by observing how to move between documents, allowing work on multiple documents simultaneously while using a number of tools to organize a workspace. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Getting Started Exercise as well as the associated materials in the Resources section.

Create a new spreadsheet and workbook, with Excel 2019. During this course, you will begin by learning how to create and open a document, and then learn how to use document templates. This leads into how to manage worksheets, which are used in Excel to manage different sets of data within a workbook. Next, observe how to save your worksheet or workbook as an Excel version or pdf; and recover unsaved documents. Learn how to insert headers and footers, useful if you have additional information to insert into a spreadsheet. Examine how to set your print area; adjust your print page layout, and then print your document. Discover how to check for compatibility issues; edit your document properties; and check for personal information in your document. The course concludes by showing how to create an accessible document, and how to protect your document or restrict all access with a password. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Creating & Saving Workbooks Exercise as well as the associated materials in the Resources section.

Delve into data manipulation techniques with Excel 2019 for Windows. In this course, learners can explore various ways to insert, edit, and manipulate data. Begin by learning how to select cells in order to apply changes to individual or multiple cells. Then learners will discover different ways of inserting, editing, and replacing data in a spreadsheet, and observe how to insert special characters. The course continues by demonstrating how to edit multiple worksheets simultaneously; delete items in a spreadsheet; and how to use the undo and redo actions. Explore how to create automatic data series; use the Flash Fill feature, and insert dropdown menus. Delve into configuring the spell check and autoCorrect options; transferring, and copying and pasting data. Complete this course by observing how to move data from one worksheet to another, and transpose a data range. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Inserting & Manipulating Data Exercise as well as the associated materials in the Resources section.

Refine your data's appearance with Excel 2019 for Windows. In this course, you will discover how you can align data, use colors and themes, resize rows and columns, and insert tables and borders in Excel 2019 to change data presentation. Learners will begin by observing how to set a data type, and then format and align their data. Next, observe how to use colors, which can help data stand out for the reader and make the table easier to read. Discover how to change the cell style; use document themes, and use formulas to modify the text case. Explore how to create clean, professional looking titles, and format titles to make them presentable. Create tables to ease organization; resize columns and rows; insert borders, and columns and rows. Conclude the course by observing how to transfer format styles. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Formatting Data Exercise as well as the associated materials in the Resources section.

Put formulas to work with Excel 2019 for Windows. In this 12-video course, learners will observe how to work with formulas, including built-in formulas such as SUM and COUNT. You will begin by discovering how to insert a formula by using the function library, and then perform simple calculations within an individual cell. Explore how to use automated formulas in a table; create automated cumulative tools; and insert subtotals. Following on from this, you will learn how to count cells in a range by using different formulas, and then rank values, which is extremely useful if you want to find out where a particular value places on a list of data entries. The course also explores how to examine rounding a number, to round up or down your data values; use replacement formulas when you need to make changes; convert number types, and factorize the results of a division. Conclude the course by observing how to create random values. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Using Basic Formulas Exercise as well as the associated materials in the Resources section.

The first step in analyzing the data in a worksheet is often taken with Excel's sorting and filtering tools. These tools help you to control what is displayed in your data range, and how the values are organized. Key concepts covered in this 10-video course include how to sort data in a worksheet according to a specific data type; how to customize sort options when sorting data in a worksheet and sort data by using multiple criteria and sort levels; and how to create and use custom sort lists to sort data. Next, learn how to use column filters to filter data in a worksheet; to use column filters to apply multiple filters to data in a worksheet; and to create filter arguments by using text and number data types. Finally, you will learn to sort and filter data by using colors applied to data; learn to use the advanced filter tools to filter and extract data; and learn to use filter tools to hide duplicate values in a data range. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Sorting & Filtering Data Exercise as well as the associated materials in the Resources section.

In the modern business environment, it's easy to feel overwhelmed by the volume of written communication that you need to process every day. To keep up, you need strong communication skills to sort, file, respond to, or delete all emails that you receive during your business day. In this course, you'll learn some vital communication techniques for managing and writing emails effectively. The course covers email etiquette tips on how to use folders and filters to organize emails for increased efficiency, as well as guidelines on what emails to delete. You'll also explore how to recover important information should you lose an email.

If you want to manage your schedule and make your time count, you have to be organized. But to stay organized, you need to check your progress. This mean developing schedule management skills. The stress and potential for mistakes grows when you don't spend time organizing your time. In this course, you'll discover how schedule management can help you regain control of your time. You'll learn how to leverage your personality to boost your productivity and explore techniques for dealing with time stealers. And you'll learn how to create practical to-do lists and keep them relevant and realistic.

Organizing your physical and digital workspaces is a great way to be more productive. When you declutter your workspace, you can improve many aspects of your work day, including your ability to concentrate, achieve targets, and become more efficient. This course will help you increase your productivity by showing you how to organize and maintain both your physical and digital workspaces. You'll learn the rewards of organizing your workspace and find out what a productive workspace looks like. You'll learn how to use your organization skills to manage your digital workspace. And finally, you'll find out how to make your new clutter-free life last by making organization a habit.

Procrastination reduces your productivity while causing you stress at the same time. Procrastinating is a habit that causes urgent and difficult tasks to pile up as you studiously avoid them. Developing and applying organization skills, you can declutter your schedule and avoid putting off work that demands your attention. In this course, you'll learn about the reasons people procrastinate, and the benefits of organizing your time. You'll learn how to build self-discipline and combat time wasters, as well as how to bring more organization to your day. And finally, you'll explore how to set priorities and how to say no when you need to.

Spelling errors are all too common, and are one of the main culprits behind poor business writing. A wrong letter here, an extra letter there, and your reader may lose confidence in your communication skills and overall competence as a professional. That's why writing well doesn't just mean writing persuasively - it also means knowing the rules, as well as the exceptions, of spelling. In this course, you'll learn how to spell words with prefixes and suffixes, and how to form the plural and possessive forms of words. You'll also learn general rules on how to spell correctly, as well as some handy tips for better writing in general.

Solving problems requires strategic thinking. You need to ask the right people the right questions to get to the source of the issue and find the solution. In this course, you'll learn about identifying stakeholders, gaining their input and trust, and using analysis techniques to get to the root cause of a problem.

Before you start looking for solutions to a problem, it's helpful to know what people want in an ideal world. This will give you some direction and aid in the strategic thinking needed to create alternative solutions. In this course, you'll learn how to define ideal states and generate and evaluate problem solutions. You'll also learn how to recognize and avoid common pitfalls when solving problems.

When the time comes to make a final, critical decision, you need to be able to understand the reasons for making that decision, as well as its possible consequences. You must also assess the effectiveness of your decisive action in solving a particular organizational problem. In this course, you'll learn techniques for making decisions based on key criteria, such as costs, time constraints, and organizational goals. You'll explore different decision-making styles, and how each can help in problem solving. You'll also learn how to plan, manage, evaluate, and celebrate solution implementation.

Systems thinking allows you to understand how systems work, as well as your role in them. Systems thinking affords you the ability to see the interrelationships among all events, putting you in a better position to address problems.

Computational thinking is a structured way to understand and solve the kind of complex problems facing most organizations today. First developed in conjunction with developing computer systems, it can be applied to many situations, both computerized and not. And it can help determine the right types of computer and human actions to apply in order to solve a problem. In this course, you'll learn the characteristics of computational thinking, including problem expression, as well as of its core techniques, such as decompositions and pattern recognition. You'll also learn how abstraction is used in logical problem solving to build algorithms that create and evaluate business solutions.

Managing teams successfully involves ensuring that team members can communicate with you and with one another and that they will collaborate effectively as a team. To achieve this, clear channels of communication are required for both on-site and virtual teams. In this course, you'll learn how to demonstrate team leadership by encouraging effective communication and overcoming communication problems. You'll explore strategies for encouraging team collaboration. Finally, you'll learn about tools and technologies that are commonly used for virtual teamwork and key considerations for establishing virtual communication guidelines.

Making a real, positive difference on a team is not necessarily about showing team leadership. Even if your role doesn't involve managing teams, you can still make an important contribution by being a strong team member. This course covers strategies and techniques to help you become a more effective and valued team member. You'll explore ways to adopt a positive mindset toward teamwork, so that you can make a significant contribution. Because your success when working on a team depends on pulling together with other people, you'll also learn constructive ways to acknowledge differences and show respect for teams, and specific strategies for team collaboration.

Team cohesion, or the strength of the links between team members, determines how effective teams will be, especially in responding to outside pressures. A team has to be cohesive if its members are to function as a unit, working closely and efficiently to achieve common goals. In this course, you'll learn methods for effectively building and managing teams that focus on improvements in three areas: communication, cooperation, and trust. You'll learn specific strategies for improving communication and promoting collaboration among staff members working on a team. You'll also learn what signs suggest a lack of trust on a team, and how you can show team leadership by using the right techniques to build trust and improve teamwork.

It's vital to maintain open, effective communication when working on a team. However, it's all too easy for teams to adopt bad habits. Without realizing how badly it affects your team, you or another team member may communicate in ways that lead to misunderstandings in teamwork, cause unnecessary conflict, keep others from having their say, and prevent collaboration. In this course, you'll learn about different verbal barriers to effective team communication and strategies for overcoming them. But speaking is only one part of communication; effective team leadership is about listening too. So you'll also learn about some active listening techniques that can help you be a better listener when managing teams.

Everyone working on a team has particular strengths. To get teams to perform at their best, these strengths have to be recognized, reflected in the roles and responsibilities assigned to team members, and directed toward achieving suitable goals. In this course, you'll learn techniques for building and managing teams, including how to set effective team goals, identify roles, assess team members' competencies, and assign roles based on these competencies. You'll also learn how to give and receive feedback effectively to improve teamwork, so that it strengthens your team leadership and the collaboration between your team members.

Innovation, disruption, and revolutionary ideas are the stuff of business success. But unless you can get those ideas across to the people in your organization how matter, they're destined to remain pipedreams. Bland business presentations aren't doing your ideas justice and boring PowerPoint presentations are blunting your message. But effective verbal communication, public speaking and presentation skills can be cultivated and improved. This course looks at methods for presenting your ideas in a convincing, succinct, and confident manner that will get them heard and given the attention they deserve.