Excel Tutorial for First Time User
TIMESTAMPS 0:00 Intro 0:45 Rows and Columns 1:30 Insert Worksheets 3:00 Enter data (text, numbers & date formats) 4:00 Adjust column widths 6:00 Format Cells 7:09 Create a Table to sort 10:00 Enter your first formula D5 = D3 + D4 14:58 Enter your first Function B7 = SUM(B1:B6)
How to use the IF and XLOOKKUP functions together in Excel
0:00 intro 0:56 LEN function 1f:52 IF function 3:56 Xlookup function
Create SKU Sales Reports in Excel with Power Query Help
0:00 Intro 1:30 Demo begin 2:45 Power Query - Text Between Delimiters to pull out SKU number 6:12 XLOOKUP to fetch SKU number related product name 9:00 Summarize with PivotTable 11:28 Analyze with PivotTable Charts 11:55 Insert Timeline to filter dashboard sales graph by dates
