Outlook Training
10 Great Time Savers In Outlook 2013 And 2016
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..
10 Microsoft Outlook Features Attorneys Should Use
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..
10 Reasons OneNote is Perfect for Attorneys
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..
17 Microsoft Outlook Quick Tricks Every Legal Professional Should Know
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..
3 Hour Excel Automation Boot Camp
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,..
An Introduction to Excel Macros and VBA
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..
Business Intelligence Resources 2018
Business Intelligence Resources 2018 is the New Economy wave of the Internet. One must learn to use these various online business research tools in a manner that will not only aid but to enhance the various activities and sectors of your business activities. The fast pace of new start ups to maintaining your present position in today’s New Economy…. Business intelligence resources and tools have become a “m..
Create a Dashboard with Excel
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..
Creating Smart Presentations : Integrating Excel, Word and PowerPoint
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..
Data Analysis in Excel – Working with Multiple Datasets
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..
Demystify Excel and Harness the Power Within
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..
Excel - Advanced Reporting - Best Practices, Tools and Techniques
No matter what business you are in, a report is a critical tool in your communication armory. As with any communication tool, presentation is everything. Get it right and it offers the reader (typically a CEO, shareholder, or Project Manager) a valuable insight into the Key Performance Indicators (KPI’s) upon which a business or project is measured. Get it wrong and you'll end up with something that nobody ..
Excel Boot Camp: Conditional Formatting and Data Validation, Smart-Art and Chart, Integrate Excel, PowerPoint and Word
• Conditional Formatting and Data Validation• Exploring SmartArt and Charts• Integrating Excel, PowerPoint, and WordThis training session covers THREE intermediate to advanced features of Excel that provide automation within the application.Using Conditional Formatting and Data ValidationWith Conditional Formatting, we’ll show you how massive amounts of data can be analyzed to visually emphasize relationshi..
Excel Charting Techniques for Infographics and Dashboards I - Unique, Fun and Dynamic Visualizations
"Every Picture Tells a Story" is a popular saying which is true not only in everyday life but in Excel too. Behind your set of numerical data is a story waiting to be told. The telling of this story needs to be to-the-point, easy to understand, and engaging.Data visualization is the representation of numerical data in a visual format so that your audience can quickly and easily understand it and gain insigh..
Excel Pivot Tables For HR Professionals
We’ll begin by understanding what exactly a Pivot Table is and why they’re so popular! You’ll learn how your data should be set up in order to take advantage of this and other Excel tools. You’ll even learn some valuable clean-up steps that turn data that’s not ideal into data that can support key decisions, become the infrastructure for dashboards, and answer questions in a snap. Once we go through the bas..