Skip to product information
1 of 1

ThinkData

Microsoft Excel Data Worker - 11/8/22

Microsoft Excel Data Worker - 11/8/22

Regular price $495.00 USD
Regular price Sale price $495.00 USD
Sale Sold out

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 your chart template
  • Charting with the secondary axis

 

Conditional Formats and Data Commands

  • Work with conditional formats
  • Data commands
  • Sort and filter data
  • Remove duplicates

 

PivotTables

  • Understand PivotTables
  • Create a PivotTable
  • Connect data to a PivotTable
  • Build a pivot
  • Filter pivot data
  • Drilldown on a pivot for filtered data
  • Format pivots
  • Create a PivotChart
  • Visualize pivot data with PivotCharts
  • Update the data
  • Linking data from PivotTables to worksheet

 

Power Query

  • Get data into Power Query
  • Navigating Power Query Editor
  • Basic data cleaning commands and Applied Steps
  • Reviewing your steps and the Advanced Editor

 

Our Favorite Shortcuts

  • Timesaving shortcuts for adding information to the spreadsheet
  • Shortcuts for navigation
  • Shortcuts for selecting
  • Shortcuts for making copies

Shipping & Returns

View full details