Excel Training
Outlook - Master Your Mailbox - Inbox Hero Inbox Zero
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 ..
Excel - Creating an Interactive Dashboard
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..
Intermediate Functions, Lookups and Linking In Excel
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..
Using Excel's Conditional Formatting And Data Validation Tools
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..
Excel - Automate Repetitive Tasks with Macros
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..
Boot Camp: Sort And Filter, Conditional Formatting And Data Validation, Creating Charts
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..
Outlook Pro Tricks: Inbox, Search Folders, Tasks And Calendar
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..
Excel For Real Estate
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 Techniques In Depth In Excel
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..
Pivot Tables Essentials For Data Analytics In Excel
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 Essentials In Word
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 ..
Mastering Chart And Graph Essentials In Excel
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..
Mastering Styles, Table Of Contents and Indexing In Word
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..
Name Ranges, Goalseek, Linking and Formula Auditing In Excel
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..
10 Features of Microsoft Outlook that Give You Screaming Productivity
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..