Toms Data World

InstallSQLServer

GROUP BY! and HAVING!!!! SQL Server

Where the ---- is it??? Yes, lets use Find And Replace in Excel!!

M4L5 Aggregation functions

Excel Tables

M3L1 FormatFonts

Lookups

M4L3 Absolute Referencing

M4L2 Function Builder

Learn how to look up things ANYWHERE by using Index/Match

Text To Columns

M2L5 PasteSpecial

M3L6 Conditional Formatting

M4L1 Formula Basics

M4L4 Named Ranges

M3L2 FormatAlignment

TIME to build a clock in Excel!

M2L2 Freeze Panes

M2L4 Filtering

Excel's wonderful IF statment

Remove Duplicates: Remove duplicate rows from Excel worksheet

M3L4 Formatting Dates

M5L1 Text Functions

M3L5 Formating Borders

Learn how to make drop down list (and much more ) with Data Validation in Excel!!