LUNCH AND LEARN SESSIONS

GETTING THE MOST OF OFFICE 365 & OFFICE ONLINE sessiondet
Office365 and Office Online is one of the most powerful collaboration suites that we have ever seen. What else do we see? People not using it because they don’t understand it. In this lunch and learn we can show you how to embrace the technology and why you’d want to. Walk out after lunch with an understanding of how to get started with Office365 and begin utilizing the power of Office Online.
OFFICE 2016 NEW FEATURES sessiondet
It’s not your first rodeo with Office, or with a new version of Office. I mean you technically use it every day. This lunch and learn is designed for you to get to know the features that you might use until the next version. Walk out after lunch with an understanding of the new features so that you don’t have to figure them out for yourself.
SHAREPOINT ONLINE & OFFICE 2016 sessiondet
Why learn more about SharePoint Online? The best answer we can give you is that most people think it’s just for documents, but the features that are available are way more than just documents. We see people minds blown when they discover how powerful it is. It’s not the first version of SharePoint…It’s grown up big time. Walk out after lunch with an understanding of what SharePoint can do for you and how it integrates with Office.
EXCEL AND POWERPOINT TIPS AND SHORTCUTS 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 that 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.
GETTING STARTED WITH MACROS AND AUTOMATION 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.
MAIL MERGE TO EMAIL IN WORD 2016 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.

 

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.

 

FULL DAY SESSIONS
NOT SO FUNDAMENTAL EXCEL 2016 sessiondet
We have all “looked” at Excel for years, but that doesn’t mean we know all we can know about it. If you are interested in knowing the new level of fundamentals like pivot tables, data tools and the best practices in working with Excel 2016 then join us for this upcoming course on the Not So Fundamental Excel 2016. If you are more than a beginner but not ready for programming, then this course can be an excellent option for you.
EXCEL 2016 FUNCTIONS, DATA, CHARTS AND MACROS sessiondet
Everyone can become so comfortable with the way they do things that they tune out new features. This course is our “kitchen sink” course on Excel. If you are an everyday user but haven’t had training in some time we recommend this fast paced – deep dive into Excel 2016. We promise – you will be worn out by the end of the day, but you’ll leave better at Excel.
ACCESS 2016 & SHAREPOINT ONLINE sessiondet
Access and SharePoint Online make a very, very powerful combination. This session is dedicated to showing you how to turn your Access database into live SharePoint data and all the benefits that come with that type of change. Learn how to quickly create powerful user interfaces and workflows to bring your databases to the next level.
WORD 2016 TECHNICAL FORMATTING sessiondet
This is one of our most favorite courses because people learn so much about Word. It’s one of the most common office products to be used and is one that has not been trained nearly as much as needed. This session will teach how to deal with things that go crazy on a document when you are just trying to “fix” one thing. Learn how to technically control Word.
INTRODUCTION TO VBA FOR EXCEL sessiondet
You probably inherited a workbook or two that have had macros in them and you wondered – what in the world am I going to do with this? Learning just a little can help you navigate the complexity of any VBA that is in your workbook. You won’t be a programmer in 1 day, but you will have a better understanding of how VBA works, how to make modifications and how to get started building your own automation.
INTRODUCTION TO ACCESS 2016 sessiondet
The day of “hating” access should be over. For some users, it is the most powerful database tool they will ever have access to, no pun in intended. Learn about the key elements of database design and how to model your data into Access by build tables or just leveraging data already set in your organization. Learn how to build forms, queries, and reports and expand your toolbox.
INTRODUCTION TO EXCEL 2016 sessiondet
If you are new to Excel or just plain uncomfortable with Excel, this course is a great way to get started. This session will take you through Excel in a way that will help you productively use the tool for your everyday work. This session is introductory but it is also full of wonderful tips and tricks that will love to use every day and share.