HR Training 2021 - 6-Hour Virtual Seminar on Microsoft Excel - From Beginner to Expert

Overview
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.