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..
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..
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..
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..
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, ..
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, ..
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..
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..
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 ..
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..
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..
Tracking compares what actually happens during your project against what was planned.Protect your well-planned project from becoming a disaster!Thorough project planning is essential, however keeping your project on track is critical and often more challenging.After planning, reality sets in, bringing likely risks, delays, and budget blow-outs. To effectively manage a project, you must regularly monitor act..
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 ..
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 l..
Anything new introduced into your schedule has the potential to slow down your productivity. This is disconcerting to individuals who have the producer’s mindset and makes them shy away from the new, impairing their movement into the future. In the case of the complex Microsoft Outlook software, time spent learning how to use it pays huge dividends in productivity, even when upgrading from one version to a ..