Other Trainings
3 Hour Excel Automation Boot Camp
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,..
An Introduction to Excel Macros and VBA
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..
Business Intelligence Resources 2018
Business Intelligence Resources 2018 is the New Economy wave of the Internet. One must learn to use these various online business research tools in a manner that will not only aid but to enhance the various activities and sectors of your business activities. The fast pace of new start ups to maintaining your present position in today’s New Economy…. Business intelligence resources and tools have become a “m..
Create a Dashboard with 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..
Creating Smart Presentations : Integrating Excel, Word and PowerPoint
Microsoft Office is known for its integration capabilities. We typically work with Excel, Word, and PowerPoint individually, and we may insert data from Excel into a Word report or a PowerPoint presentation. Each program has features specific to sharing data automatically among programs. This webinar will give attendees important time-saving techniques in creating truly smart presentations; determine when a..
Data Analysis in Excel – Working with Multiple Datasets
In the recent past, it was necessary to have some coding skills, and 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, Mic..
Demystify Excel and Harness the Power Within
Excel spreadsheets have really become essential in the workplace. They are used for many purposes, from budgets to forecasts, from financial spreadsheets, to even more scientific purposes and everything in between. But, all spreadsheets require formulas and functions. Formulas are mathematical equations in Excel, and functions are built-in formulas. Building formulas is a crucial skill in Excel, one that ha..
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..