Excel Training
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 - Creating High Impact Business Reports
The training will focus on 4 areas - Pivot tables, charts/graphs, the Power View report adding, and how to present geographic information.No matter what business you are in, a report is a critical tool in your communication armory. As with any communication tool, a presentation is everything. Get it right and it offers the reader (typically a CEO, shareholder, or Project Manager) a valuable insight into the..
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 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..
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..
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..
Excel PivotTables 2016: The Ace Analytical Tool of 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..
Excel Savvy: Building Practical Budget Spreadsheets
In this comprehensive webcast, you’ll learn from Excel expert David H. Ringstrom, CPA, how to create dynamic and resilient budget spreadsheets. David shares helpful techniques, including how to separate inputs from calculations, streamline formula writing, preserve key formulas, and create both operating and cash flow budgets. In addition, he discusses the benefits of using a variety of Excel functions and ..
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..
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..
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..
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..
Excel Savvy: Linked Workbooks
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..
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..