$200.00
Excel Dashboard Basics

 Recorded Webinar
 90 Minutes
 Refer a Friend
Excel Dashboard Basics

In this beneficial presentation, Excel expert David H. Ringstrom, CPA, introduces you to Excel dashboards. Dashboards are quite popular because they empower users to quickly assimilate large amounts of data by way of charts and summary tables. David demonstrates how to: use Excel’s Pivot Table feature to create charts that display data trends, filter data faster using the Slicer feature in Excel 2010 and la..

$200.00
Excel Savvy: Extracting Data from Databases and Text Files

 Recorded Webinar
 90 Minutes
 Refer a Friend
Excel Savvy: Extracting Data from Databases and Text Files

Extracting data from text files or from database management systems, such as Microsoft Access or Microsoft SQL Server, can be intimidating to Excel users. In this outstanding presentation, Excel expert David Ringstrom, CPA, walks you through the process of getting the data you need from databases or from text files into Excel. Once your data is in Excel, you can work with it in a variety of ways, such as us..

$200.00
Excel Savvy: Implementing the Custom Views Feature

 Recorded Webinar
 90 Minutes
 Refer a Friend
Excel Savvy: Implementing the Custom Views Feature

In this presentation, Excel expert David Ringstrom, CPA, shares a variety of ways you can automate your work in Excel by way of the Custom Views feature—one of Excel’s most overlooked features. Step-by-step, David demonstrates how Custom Views allows you to hide and unhide multiple worksheets at once, set a print range for multiple areas of a worksheet, make a single set of data serve multiple purposes, gai..

$200.00
Excel Savvy: Mastering Advanced Lookup Functions

 Recorded Webinar
 90 Minutes
 Refer a Friend
Excel Savvy: Mastering Advanced Lookup Functions

In this insightful webcast, Excel expert David Ringstrom, CPA, focuses on alternatives to the VLOOKUP function. While many Excel users rely on VLOOKUP for basic lookup functionality, it’s often because they’re unaware of other functions that can enable them to work more efficiently in Excel. David sheds light on what can go awry with VLOOKUP; explains how to future-proof VLOOKUP; and discusses alternative f..

$200.00
Excel Savvy: Pivot Tables and Pivot Charts

 Recorded Webinar
 90 Minutes
 Refer a Friend
Excel Savvy: Pivot Tables and Pivot Charts

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..

$200.00
Mail Merge Essentials In Word 2013 To 2016

 Recorded Webinar
 90 Minutes
 Refer a Friend
Mail Merge Essentials In Word 2013 To 2016

Mail merge saves you significant time and effort, producing mass mailings and labels are 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 ..

$200.00
Excel Savvy: Tips and Techniques for Enhancing Charts

 Recorded Webinar
 90 Minutes
 Refer a Friend
Excel Savvy: Tips and Techniques for Enhancing Charts

When you participate in this enlightening session, you’ll learn from Excel expert David Ringstrom, CPA, a variety of tips and techniques to help you create and automate your Excel charts. David discusses several helpful features, including the Recommended Charts feature, the Slicer feature, the Sparkline feature, the PivotChart feature, and more. In addition, he explains how to avoid repetitive formatting, ..

$149.00
Data Analysis in Excel – Working with Multiple Datasets

 December 11 2019
 01 : 00 PM EST    
 90 Minutes
Data Analysis in Excel – Working with Multiple Datasets

In the recent past, it was necessary to have some coding skills, an 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, Micr..

$200.00
Excel Savvy: Creating Interactive Spreadsheets

 Recorded Webinar
 90 Minutes
 Refer a Friend
Excel Savvy: Creating Interactive Spreadsheets

In this valuable session, you’ll learn from Excel expert David Ringstrom, CPA, how to create spreadsheets that are interactive, accurate, and user-friendly. David demonstrates a variety of Excel’s form controls and features to control the data input of other users, simplify data entry, preserve key formulas, minimize spreadsheet maintenance, and more. David demonstrates every technique at least twice, first..

$149.00
Managing Excel Data: Sorting, Filtering, Subtotaling and Creating Tables

 December 16 2019
 01 : 00 PM EST    
 90 Minutes
Managing Excel Data: Sorting, Filtering, Subtotaling and Creating Tables

To be truly proficient in Excel, you must be familiar with these tools to manage data efficiently. Managing data is becoming more important than ever as data collection becomes more automated. What can you do with all that data? You need to know how to rearrange the data (Sort), see just what you want to see (Filter), create quick summaries (Subtotals). Learn to use tables to add even more options for manag..

$200.00
Excel Savvy: Filter and Format Data with Ease

 Recorded Webinar
 90 Minutes
 Refer a Friend
Excel Savvy: Filter and Format Data with Ease

You’ll find it easy to filter and format your data after participating in this presentation by Excel expert David Ringstrom, CPA. David shows you how to analyze data more effectively, gain control of long lists of data, identify duplicates in a list, transform filtering tasks, avoid retyping data and cumbersome formulas, bypass filter drop-down lists, and more.David demonstrates every technique at least twi..

$200.00
Planning, Prioritizing and Execution with the Outlook Calendar and Tasks

 Recorded Webinar
 60 Minutes
 Refer a Friend
Planning, Prioritizing and Execution with the Outlook Calendar and Tasks

Do you face daily dilemmas trying to figure out where to start on your task list? Task lists can be overwhelming with a great range of items to complete. Some can wait but others are urgent and demand immediate attention. When you have 5 or 6 urgent requests at one time, the choice of which one to work on first can be agonizing. The principles taught in this program solve the puzzle for you. You will learn ..

$149.00
Surviving Avalanche Email

 January 14 2020
 11 : 00 AM EST    
 60 Minutes
Surviving Avalanche Email

Is managing your Inbox and digging out from an avalanche of email a full-time job? Then sign up for this webinar and learn how to survive the heavy load of tasks and the constant stream of trivia that arrives via email. You will gain insight into how to work from a clean Inbox and how to reduce what flows into your Inbox while expediting email processing. Outlook provides many Inbox features that can help y..

$149.00
Outlook - Master Your Mailbox - Inbox Hero Inbox Zero

 January 15 2020
 01 : 00 PM EST    
 60 Minutes
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 overload, m..

$200.00
Excel for Bankers: Functions and Formulas for Financial Data Analyzation

 Recorded Webinar
 60 Minutes
 Refer a Friend
Excel for Bankers: Functions and Formulas for Financial Data Analyzation

In the business world, or within your organization, you probably experience large amounts of data. Maybe the data is about your sales, customers, donations, orders, employees, vendors, expenses, or whatever it may be.Excel has many built-in functions that help you deal with that data. It is very important that you know how to use some of these functions to get the most out of your data in a time e..

Showing 1 to 15 of 49 (4 Pages)