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 wi..
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
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 create..
Microsoft Excel has become the de facto spreadsheet application for business. But do you sometimes feel like you have rows and rows of data and it is hard to make heads or tails of it? This instructor-led online class will help you learn how to manage databases in Excel and get the most out of them.For 90-minutes, our Excel expert will lead you through a full array of powerful and easy-to-use database comma..
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-t..
Microsoft Excel has the possibility of processing your data in many ways with built-in formulas. But, you have to know how to use them. It may be hard to figure out these formulas. This webinar will show you exactly how to utilize the logical formulas and functions in Excel to help you get the most out of your data so you can make meaningful decisions.Areas CoveredIFAndOrNested IFConditional FormattingCondi..
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..
Do you use Outlook just for email or do you use it as the headquarters for your daily planning and execution of tasks? Whichever way you use Outlook, you will want to take advantage of the 10 in-depth tips outlined in this webinar that will make you more efficient and effective every day of your life. You’ll learn how to save precious minutes throughout the day, setting you free to use those minutes in prod..
Time management for an attorney in a busy law office is a difficult task. Complicating the issue is managing the productivity of your legal team and the entire firm. If you would like more productivity at your law practice sign up for this webinar and learn the 10 most valuable Outlook features you must be using in your law practice. The outlook is a one-stop-shop for email, calendar, and tasks, and when yo..
Do you wish you could magically simplify your notetaking, sharing of files, and record keeping with a powerful software program? That magic is OneNote. If you have purchased OneNote in either the full-featured desktop version or the “universal” mobile-device-friendly edition and are wondering where the magic is, attend this webinar. You will discover the features that start the magic working, simplifying an..
Superior technical and organizational skills are critical for the success of a busy legal office. This is a difficult task when you consider managing yourself PLUS the productivity of your entire legal team. If you would like increased productivity in your legal office, sign up for this webinar and learn the 17 most valuable Outlook features your entire firm must use.Outlook is a one-stop-shop for email, ca..
Conditional Formatting and Data ValidationIntroduction to Excel PivotTablesExcel Lookup Functions; VLOOKUP, MATCH, INDEXWith Conditional Formatting, you will learn 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,..
In this webinar, you will learn how to make all of your raw data and quickly turn that data into easy to use flexible summary reports using Pivot Tables and Charts. We will start with the basics and built up to more complex pivot tables. Many people struggle with how to create Pivot Tables, or maybe they don’t even know what they can do, or maybe they think they are too difficult. I’m going to show you what..