Load Data From SQL Server

Load Data From Text Files

Load Data via Copy and Paste

Cleaning Data

Creating Relationships

Create a Time Table for future labs

Use DATE Function

Use DATEVALUE Function

Use the DAY, MONTH, YEAR, HOUR, MINUTE, SECOND Functions

Use EDATE Function

Use EOMONTH Function

Use NOW and TODAY Functions

Use TIME and TIMEVALUE Functions

Use WEEKDAY and WEEKNUM Functions

Use FIRST* and LAST* Functions

Use DATE* Functions

Use STARTOF* and ENDOF* Functions

Use CLOSING* and OPENING* Functions

Use LASTOF* and FIRST* Functions

Use PREVIOUS* and NEXT* Functions

Use AVERAGE* Functions

Use COUNT* Functions

Use MAX* and MIN* Functions

Use ALL, ALLEXCEPT and ALLNOBLANKROW

Use CALCULATE, CALCULATETABLE

Use DISTINCT

Use EARLIER and EARLIEST

Use FILTER

Use REALTED, RELATEDTABLE

Use VALUES

Use Logical Functions (AND, FALSE, IF, IFERROR, NOT, OR, TRUE)

Use Information Functions (ISBLANK, ISERROR, ISLOGICAL, ISNONTEXT, ISNUMBER, ISTEXT)

Use TEXT Functions

Use PivotCharts

Use Slicers

Use Sparklines