Microsoft Excel Data Worker - 11/8/22

We developed this course to teach real world tech skills in Excel to the people who encounter data in spreadsheets in their day-to-day work. This course gives you a foundation for working with data. We will dive into the practical skills needed by a data worker and we will show you how to approach and handle data with Microsoft Excel. This course is not for an Excel beginner. We will provide you with exercise files to be used during training for a hands on, interactive learning experience. After the session we will provide you a guidebook pdf to use as a reference source. Functions & Formulas Basic date & time functions (TODAY,NOW,DAY/MONTH/YEAR) Advanced date functions Text conversion functions Parse and cleaning functions Logical functions IF function Absolute/relative referencing VLOOKUP and other fun functions   Charts Create a basic chart Formatting charts Adding chart elements, labels, and legends Changing the chart title Create a trendline Create a chart template Use