For most business users (and many home users too), Microsoft Outlook has become the standard application for managing emails, calendar appointments, and to-dos. With an abundance of features and versions for desktop and mobile, there’s really no excuse not to be organized. Or so the theory goes. With the average office worker receiving over 100 emails per day, the reality for most people is email ..
No matter what business you are in, a dashboard is a critical tool in your communication armory and as with any communication tool, presentation is everything. Although there are many tools that can be used to create a dashboard, Excel is commonly used due to its power, its flexibility, and the fact that most people have it installed on their computers. This training focuses on what you need to know to crea..
To work efficiently with formulas and functions you must start with a clear understanding, good habits, and application of correct structure and syntax. Understand and work effectively with fundamental and versatile calculation and analysis techniques in Excel beyond the introductory level. This course effectively demonstrates and teaches examples of formulas and specific functions, providing the perspectiv..
With Conditional Formatting, we’ll show you how massive amounts of data can be analyzed to visually emphasize relationships, find exceptions, and spot trends. Conditional formatting can change the format of cells based on their values in multiple ways including font style, underline style, font color, fill color, and more. Adding your own formula to a conditional formatting rule gives it a power boost to he..
Do you find yourself repeatedly performing the same actions or tasks in your spreadsheets? Do you have a time-consuming Excel-based process that you want to automate? If the answer to either of those questions is "Yes", it’s time to learn how to create a macro. In short, a macro allows you to automate Excel, allowing you to spend more time on other things!Learning ObjectivesIn this session, you will learn h..
Learning Excel’s Sort and Filter ToolsExcel is a powerful program for managing and analyzing lengthy lists of data. What tips, tricks, and techniques do you need to know to quickly and easily sort and filter a range or table of data? Join this training course to explore the shortcuts and solutions for effectively working with large worksheets of data.Using Conditional Formatting and Data ValidationWith Cond..
If you are a pro at using email and using the calendar for appointments and meetings and you want to expand your use of the tool, this webinar is for you. Microsoft Outlook will become your partner in productivity when you discover the hidden features taught. This webinar covers productivity, not just from a technology viewpoint, but from a time management perspective. If you want to be productive, you need..
This course will demonstrate how to use Excel to perform custom calculations based on the topic of housing data analysis. The attendees will learn the formula language and become comfortable with how to create any calculation.The attendees will also observe a Pivot Table process using the same housing data and then a final presentation of that data in a publish-worthy report layout.Areas CoveredCalculate av..
Linking between spreadsheets, workbooks and applications offers huge efficiencies but needs a clear understanding to work accurately and avoid risks that linking can pose. Understand and apply the power of linking techniques within Excel and other key MS Office applications to boost productivity and efficiency for you and your organization. Object Linking and Embedding (OLE) makes content that is created in..
PivotTables are the most powerful data analysis feature in Excel, combining the ability to sort, filter, subtotal, calculate and chart data in minutes. A PivotTable displays a summary of a selected data set in a condensed format of rows, columns, data fields, and pages. These components can be “pivoted” with your mouse allowing you to expand, isolate, calculate, and group the particular data in real-time. T..
Mail merge saves you significant time and effort, producing mass mailings and labels is much simplified, especially compared to the process of preparing individual letters or envelopes for many people. One standard letter can be created and sent to a huge range of recipients without having to manually add each name and address.MS Word "mail merge" creates personalized letters, emails, envelopes, or mailing ..
With 16 chart types in MS Excel including the new funnel chart, there are many choices to present information in a clear, engaging, and professional manner. Each chart type has up to 7 sub-chart variations plus a massive range of formatting options and variations. Maximize your use of this powerful Excel feature and take data analysis and interpretation to an effective and appealing level, helping your audi..
Styles can save you significant time and effort by applying consistent formatting throughout your document and instantly creating a Table of Contents which is automatically updated. A Table of Contents can include titles or descriptions and page numbers for sections or chapters and outline your content giving readers a high-level view of the structure and segments in your documents.Indexing allows you to ma..
Understanding of Name Ranges, Goalseek, Linking and Formula Auditing provides a huge advantage in progressing to higher levels of mastering Excel. Understand and work effectively with fundamental and versatile calculation and analysis techniques in Excel at introductory to intermediate level. To work efficiently with formulas and functions you must start with a clear understanding, good habits, and applicat..
Margaret Thatcher said: “Think of a day when you are supremely satisfied. It is not a day when you lounged around and did nothing, but a day when you had everything to do and you did it.” If this speaks to your daily purpose and emotional makeup, sign up for this webinar. Projects, deadlines, bosses, and your internal psychic all scream for ways to check off more items on your task list in a short amo..