In this session, you’ll learn the core skills of communicating in business, including correspondence, reports, presentations, both virtual and live. You’ll take away key technical skills such as 3 different types of proofreading and important document formatting tips that ensure your content is communicated effectively. You’ll discover valuable techniques you can use to be more confident that if your writing is translated to another language, that it will be well understood?
A significant amount of business is done via email. A simple mistake in the subject line or salutation may mean your beautifully crafted message might not ever be read! We’ll discuss your “digital dress code” to make sure your email, text messages are opened, read and understood.
In the section on live communication, you’ll learn 5 important ways you communicate who you are while you are telling the listener what you want them to know. Most people aren’t confidence about communicating in front of a room, yet it is a requirement of many professions. Is it possible to communicate clearly and with impact even if you’re nervous? It is! In this session, you’ll learn how to avoid common live presentation mishaps
In this session, you’ll go beyond sums and averages and learn how to use advanced formulas to take the data you get and turn it into what you need. There are nearly 500 native functions in Excel. And while we won’t have the time to cover all 500, we will cover essential ones like IF, VLookUp, XLookUp, SumIF, SumIFs and more. You’ll learn the all important text functions that can help you tackle problems like poorly formatted date and time data, leading and trailing spaces, and miscapitalization.
We’ll look at alternatives to formulas to summarize information as well as effective was to create charts, graphs and other visuals such as conditional formatting to help you convey what you need to about your data. There are easier and faster ways to create charts in Excel than ever before and new tools to create charts and graphs on maps for data you need to present geographically.
Finally, well cover how formulas work in and with Pivot Tables and how to apply formulas in PowerQuery. Not only will you know how to get the most out of Excel, but know all the different ways to do it and when to use what.
In this session, we’ll take you on the entire journey to creating an instruction manual, one type of technical writing. From gathering information and resources to producing the final document, we’ll cover each step along the way showing you tools and techniques for making short work of daunting tasks. We will be working from the Microsoft Office Suite, but the information will be applicable across other applications suites.
We’ll also look at common missteps in creating technical documentation that can create unnecessary work for others and non-compliance. Understanding how the end user will consume and apply the information you assemble can help you save time and produce precisely what is needed. In this section we’ll cover writing styles, integrating multiple information resources and how to use styles for precise formatting and organization.
Finally, we’ll cover how to produce and end product of a technical writing assignment. Whether the end product is printed, presented in electronic format or presented online as an interactive tool, you’ll have a solid foundation on how to produce a valuable final product.
In this seminar you will learn the tools and techniques available in Excel to help you manage large amounts of data accurately and efficiently in Pivot Tables. If you are new to Pivot Tables or haven’t ever heard of them, this seminar is for you. We’ll begin by explaining what a Pivot Table is and the basic building blocks associated with this particular data management tool.
Next, we’ll explore the features that enable you to customize and tailor your reports to suit various needs. From charts and graphs to simple dashboards, you’ll discover how to use this popular tool to accomplish your data analysis goals.
We’ll cover the 3 main ways to perform calculations with Pivot Table data, as well as the tips, tricks and pitfalls of each one. Knowing how to calculate within a Pivot Table and use the data generated by a Pivot Table in other formulas can really take your skills to the next level.
Once you have your completed Pivot Table, you’ll want to protect it from being altered, including protecting the underlying datasets. We’ll share the ways you can do this without making the end user experience cumbersome or awkward.
Finally, we’ll introduce you to the Get & Transform tools and Power Query. With these tools, you can move from the limitations of the number of rows and columns provided in the standard Excel worksheet to millions of rows of data. You’ll learn how to access different types of data sources with Power Query and perform complex connections that used to take lines and lines of SQL code.
There is a strategy to writing email that matters. From the subject line to the signature line, every piece of an email can mean the difference between instructions followed or instructions ignored, a sale made or a sales opportunity lost. Learn the 3 reasons why someone would not open or postpone opening your email message.