Open Mic(rosoft Excel) Night

Come join us on "Open Mic(rosoft Excel) Night" where I, along with your fellow Excelers, can help provide you with answers to your MS Excel questions.

WHO IS THIS MEETUP FOR?

This meetup is for anyone who uses MS Excel… for anyone who asks themselves, “Can Excel do (XYZ)? ”,… for anyone is frustrated with their manual administrative process… for anyone who needs to manage compliance issues… for anyone needing to generate reports or dashboards… for beginners getting comfortable with creating formulas, to more advanced users learning about Pivot Tables and Macro’s, to heavy data crunchers using the (quite awesome) PowerBI Toolkit… and EVERYONE in between.

HOW DOES THIS WORK?

Bring your laptop or notebook, so you can easily follow along with the topic being discussed (there are no laptops provided). You're free to come and stay for the entire duration of our meetup. You're also free to come just to get the answer you need and run off with it.

WHAT TOPICS WILL BE COVERED?

There is NO predetermined itinerary, as this is strictly up to you! Think of this as an Improv/Open mic night, where you get to come and ask any questions you have about MS Excel. Again, there is NO predetermined itinerary. So jot down your questions now and bring them along before you forget them!

Not sure what to ask? Here are some thoughts to get you started...

How do I create a VLOOKUP? Can/how do I nest multiple functions into a formula? How can I modify the default auto-spell settings? How do I create my own personalized Toolbar (Ribbon)?

Are you into Finance?

How can I create complex financial calculations in Excel? How can I analyze my assets/liabilities in Excel? How can I use Scenario Manager to handle my all of finances multiple variables?

Are you into Data Analysis?

How to I automatically import data from various sources into Excel? How can I create queries to manipulate this data? How can I use this imported data to drive pivots and KPI’s on my dashboard? How do I create a dashboard?

Are you into Law?

How can MS Excel help me manage eDiscovery? How can I use Excel to automate all my legal forms? How can I personalize and manipulate the Print Settings?

Are you into Healthcare?

How can I calculate drug dosages in Excel? How can I help manage manually controlled and regulated IVs with Excel? How can I analyze and compare data from my patients to Open Sources of data?