Excel is a vital tool for data organization and visualization in modern workplaces. The following resources should be able to help provide tips and tricks for any level of excel user.
This nine minute video outlines some basic formatting to help with data visualization. It goes over the Conditional Formatting tab in excel and shows the different ways to sort and visualize a table of data as well as some basic formatting formulas.
This seven minute video goes over how to create and utilize a pivot table in excel. It shows different uses for pivot tables as well as how to customize your table in order to allow you to sort data.
This video is just shy of nine minutes and covers different excel tools and strategies you can implement to help limit data mistakes. These parameters and formulas help validate proper data and keep it accurate.
This is a 14 minute video that goes over basic math functions and statistical functions. These are both very helpful for data organization and overall flow of an excel sheet.
This Microsoft website explains how to create a drop-down list in a simple and easy way. It includes a short video as well as a step-by-step list of instructions.
This Microsoft website goes over the “Ideas” feature in excel and how it can benefit you. It also includes a short video that overviews the rest of the page.
This is a six hour workshop provided by Udemy that goes through the fundamentals of Excel and is taught by a certified excel instructor with over 15 years of experience. The course costs $25 and has a moneyback satisfaction guarantee.
This Lynda.com training is just shy of 30 minutes and is an intermediate level course of tips to help efficiency of excel users. Each section is roughly a minute long and covers various helpful topics.
This is a two hour training from Lynda.com that covers the essentials of managing and analyzing data within excel. It covers the basics of Excel including basic charts, shortcuts, and data sorting.
Specialized/Specific Excel Trainings:
These excel tutorials are categorized by specific features within excel. If you’re looking for a specific part of excel that you want to learn, check out the categories below!
This youtube video is roughly 20 minutes and goes over “everything you need to know” with VLOOKUP. It’s broken up into six sections in order to help easily digest the information.
This video is only 11 minutes and helps break down the VLOOKUP function