Excel Resources

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.

Conditional Formatting

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.

Introduction to Pivot Tables

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.

Data Validation in Excel

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.

Math and Statistical Functions

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.

Creating a Drop-Down List

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.

Ideas in Excel

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.

Microsoft Excel – From Beginner to Expert in 6 Hours

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.

Excel Quick Tips

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.

Excel Essential Training

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!

VLOOKUP Tutorial for Excel – Everything you need to know

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.

VLOOKUP Function in Excel for Beginners

This video is only 11 minutes and helps break down the VLOOKUP function