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..
This webinar is for individuals working in Outlook 2013, 2016 or 2019: If you are human, you have had days when you were busy all day with little to show for it. Leave that frustration behind with this webinar that literally “sharpens your axe.” Abe Lincoln said that if he had six hours to cut down a tree, he would spend four hours sharpening his axe.This webinar sharpens your thought process as it shows yo..
Pivot Tables are one of the most powerful tools in Excel’s data analysis and Business Intelligence (BI) report-building set of tools. With just a few clicks of the mouse (and no complicated formulas!) you can quickly and easily build the reports, dashboards and charts that help you to summarize, analyze, interpret and understand your data which in turn helps you to spot trends and get answers to the importa..
ADA is the Americans with Disabilities Act. As of 2010, this U.S. Federal Law was applied to all electronic documents. Any public business or governmental institution is required to have ADA-compliant public documents. This course will teach you how to format MS Word documents for ADA Accessible compliance requirements. This training course focuses on applying the technical formats to your MS Word documents..
Microsoft Excel contains almost 500 built-in worksheet functions. Strip away the ones nobody uses. Discount the ones that have a specialized use-case and you’re left with a small set of functions that all Excel users should know, regardless of their job function, industry, or business sector. This webinar covers ten of Excel’s most popular productivity-boosting functions.Areas CoveredIF: Automate data entry..
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..
Power Pivot removes many of the limitations and frustrations that users find with creating Pivot Tables in Excel. For example, using Power Pivot you can.Create Pivot Tables from multiple lists/tables without the need to combine them into a single list first (goodbye LOOKUP and all the issues that it brings)Create Pivot Tables from large datasets without worrying about file size, performance or needing more ..
How data is presented can affect decision making, and “Yes” it is your responsibility to present data in the best manner possible. Q: Are you serious about your data… or are you decorating? A: Find out in this webinar. This course will introduce the theory of looking at data with a new eye and mindset. It challenges the old-fashioned styles and rules. Data presentation will no longer look drab or regular, b..
Do you spend time each month importing data into Excel from other sources such as CSV files, text files, web pages, databases and SharePoint? Do you spend more time than is necessary getting your data into the right format for your reports, performing repetitive "data cleaning and transforming" tasks such as removing unnecessary rows and columns, filtering out data that you don’t need, converting text to nu..
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,..