WEBINAR SESSIONS
VLOOKUP’S AND IF FUNCTIONS sessiondet
VLOOKUP’s and IF seems to be the “function of the day” every day in your department. Every time you get started with that same copy and paste routine, you think “gosh I need a formula for this” and it’s likely a VLOOKUP. Not all data is the same, so not every VLOOKUP is as versatile as you might need. Learn how to combine with IF statements to make a major improvement in your data work.
CHARTING IN EXCEL TIPS, TRICKS AND SHORTCUTS sessiondet
We have come a long way since Microsoft Graphs but you maybe a little intimidated to start building some more comprehensive charts. This session covers the basics of Charts and includes some great tips on making your data work better for you, and when to link and when to embed.
EXCEL AND POWERPOINT CHARTING TECHNIQUES sessiondet
You have been using Excel for years, but now you need to know how to get the most of the data by building charts. You may have also figured out the PowerPoint is heavily used to display the charts and used to talk about complicated data sets. This session has lots of great tips and tricks on using Excel and PowerPoint together.
MAIL MERGE TO EMAIL sessiondet
We have all seen an email where the person sends it TO: themselves; maybe even adds their selves to the CC: but our name and the many, many others are in the BCC line. There are two reasons this happens – they don’t have time to personally email us all, and they don’t know how to Mail Merge to email. The shame of this is that it is so easy and frankly you would likely get a better response. In this session learn how to quickly personalize and get your emails out with a more personal touch.
PIVOTS, CHARTS AND OTHER DATA RELATED TIPS sessiondet
You know the basics of Excel, but you really want to dive deeper and be more comfortable with Pivots tables and pivot charts. In this session learn how to get started with pivots that work all the time, techniques to make them more user friendly to work with. Learn about slicers and timelines.
INTRODUCTION TO MACROS IN EXCEL AND OTHER FUN FUNCTIONS sessiondet
You keep doing the same repetitive tasks over and over again with Excel. You think there must be a better way. You may know you should use Macros, but you aren’t a programmer. This session will give you the ins and outs on how to get started with automating those routine tasks by using macros to achieve more time in your day to day routine. If you need macros, it’s probably because you have a lot of data right? So learn more about some great data functions all analyst should know.
ACCESS DATABASE QUERIES AND REPORTS sessiondet
You aren’t building your database from scratch. You have one that the department or organization has used for years. What you need to know is how to expand some of the reporting capabilities through queries and reports. This session will show you the ins and outs of all types of queries that can make your reporting life easier.
WHAT IF ANALYSIS, GOAL SEEK AND SCENARIOS sessiondet
You ever to try to find a number that fits within a set of “goals.” We know the routine, you type the number, and if it doesn’t fit, you try another one? Have you ever created multiple workbooks of the same structure to show different “scenarios” then this session will really help you understand some amazing built in functionality you likely never use.