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..
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..
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,..
A macro is an action or a set of actions that you can use to automate routine tasks. Macros are recorded in the Visual Basic for Applications programming language. The easiest way to create a macro is to record the steps. Excel stores information about each step you take as you perform a series of commands. The steps you do are saved in Visual Basic code. You then run the macro to repeat, or "playback," the..
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 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 th..
Microsoft Office is known for its integration capabilities. We typically work with Excel, Word, and PowerPoint individually, and we may insert data from Excel into a Word report or a PowerPoint presentation. Each program has features specific to sharing data automatically among programs. This webinar will give attendees important time-saving techniques in creating truly smart presentations; determine when a..
In the recent past, it was necessary to have some coding skills, and available data analyst or some very strong VLOOKUP skills in order to join related datasets to perform meaningful data analysis. With the new Get & Transform tools and Power Query (which you probably already have, but don’t know it!), you can do this sort of thing yourself with a few clicks. Over the past several versions of Excel, Mic..
Excel spreadsheets have really become essential in the workplace. They are used for many purposes, from budgets to forecasts, from financial spreadsheets, to even more scientific purposes and everything in between. But, all spreadsheets require formulas and functions. Formulas are mathematical equations in Excel, and functions are built-in formulas. Building formulas is a crucial skill in Excel, one that ha..