Excel Dashboard Basics
: David H Ringstrom
Recorded Webinar
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.....
Excel Savvy: Extracting Data from Databases and Text Files
: David H Ringstrom
Recorded Webinar
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.....
Excel Savvy: Implementing the Custom Views Feature
: David H Ringstrom
Recorded Webinar
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.....
Excel Savvy: Mastering Advanced Lookup Functions
: David H Ringstrom
Recorded Webinar
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.....
Excel Savvy: Pivot Tables Part 1
: David H Ringstrom
Recorded Webinar
After participating in this empowering webcast presented by Excel expert David Ringstrom, CPA, you’ll know how to transform data into a pivot table-ready format and instantly create reports by simply dragging and dropping fields with your mouse. David demonstrates how to initiate a pivot table from a list of data, expand and collapse pivot table elements, dig deeper into the numbers, and more. In addition, .....
Excel Savvy: Tips and Techniques for Enhancing Charts
: David H Ringstrom
Recorded Webinar
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, .....
Excel Savvy: Creating Interactive Spreadsheets
: David H Ringstrom
Recorded Webinar
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.....
Excel Savvy: Filter and Format Data with Ease
: David H Ringstrom
Recorded Webinar
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.....
Excel Savvy: Intermediate Pivot Tables
: David H Ringstrom
Recorded Webinar
Excel expert David Ringstrom, CPA, takes you step-by-step beyond the basics of pivot tables in this comprehensive presentation. He explains the PivotTable feature, the PowerPivot feature, the Recommended PivotTables feature, and others. After participating in David’s presentation, you’ll know how to create self-updating titles for charts and pivot charts, expand and collapse pivot table elements, drill down.....
Laying Out a Financial Model
: Liam Bastick
Recorded Webinar
The problem with modeling in Excel is no two spreadsheets look the same. This makes it difficult for end users to understand and modelers to take over others work. This course considers the four key principles required for laying out a good financial model and provides practical tips and tricks to get your spreadsheets on the right track from the very start. The session revolves around building the rudiment.....
Excel Savvy: What-If Analysis
: David H Ringstrom
Recorded Webinar
In this presentation, Excel expert David H. Ringstrom, CPA, draws your attention to the What-If Analysis tools available within Microsoft Excel’s Data menu. You’ll learn how and when to make use of Excel’s Scenario Manager as well as how to use the Data Table feature to compare calculation results based on two or three inputs. David explains how Excel’s Goal Seek feature empowers you to perform basic what-i.....
Excel Charts
: Dennis Taylor
Recorded Webinar
Creating charts in Excel has long been one of its most popular features. Numerical information can be boring and some of us just don’t read and absorb the meaning of such data until we see the information depicted in a chart. You can create an Excel chart with just a few keystrokes or mouse clicks and can easily alter a chart’s appearance by changing its type into a line, bar, pie, or column chart as well a.....
Microsoft Excel: Data Management Features (Sorting, Filtering, Tables, Subtotals…)
: Dennis Taylor
Recorded Webinar
Microsoft says that up to 70% of users surveyed use Excel to maintain a database or large lists. To be truly proficient in Excel, you must be familiar with these tools to manage data efficiently. It’s all the more important as data collection has become more automated and you’re getting swamped with tons of data. But what can you do with all that data? You need to know how to re-arrange the data (sort), see.....
Excel Savvy: Linked Workbooks
: David H Ringstrom
Recorded Webinar
Excel expert David Ringstrom, CPA, discusses the pros and cons of workbook links and walks you through the nuances of creating and working with them. Workbook links allow you to connect one Excel spreadsheet to other spreadsheets, Word documents, databases, and even web pages. In his presentation, David also covers how to dramatically improve the integrity of linked workbooks using Microsoft Query instead o.....
Make Outlook a Partner in Productivity
: Karla Brandau
Recorded Webinar
Are you one of those people who regularly sign up for time management seminars but you still can’t get a handle on all your projects and tasks? Then sign up for this webinar and get real help, not theory.Effective time management demands that you understand time management principles AND have a tool to implement those principles, this webinar combines both. You are given fundamental time management principl.....