6-Hour Virtual Seminar on Microsoft Excel - From Beginner to Expert
Hour 1: Productivity Tips and Tricks: Excel comes with “Some Assembly Required". You will setup and learn numerous features, buttons and tools.
Hour 2: Tools of the Trade and Every Day Excel Hacks: These are the old-school tips and tricks that have been forgotten by so many Excel users.
Hour 3: Useful Formulas: learn a handful of the most useful and often used formulas in Excel. These will include: VLookup, HLookup, IF Error, Text to Columns, Concatenate, and the power of the Name Box when creating formulas.
Hour 4: Power Query Intro: When the redundant task of 'cleaning up this week's data' comes across your desk, Power Query is the answer. It handles the repetitious steps specifically tied to data prep.
Hour 5: Pivot Tables Crash Course: This is all about data summaries and data analysis. You will meet the Pivot Table window, learn the design process, the advanced level features (dashboard slicers), and have access to a downloadable PDF guide with step-by-step instructions on each feature covered.
More Event Ideas
What can we do for you?
Thank you for your input. Please fill out the form below and provide as much information as possible about updates to this event or venue.