|
|
001 Average, Median & Mode Functions.en.srt
|
SRT
|
4.9 KB
|
|
|
001 Average, Median & Mode Functions.mp4
|
MP4
|
22.5 MB
|
|
|
001 Basic Formula.en.srt
|
SRT
|
8.8 KB
|
|
|
001 Basic Formula.mp4
|
MP4
|
33.7 MB
|
|
|
001 Change Font Style, Size & Color.en.srt
|
SRT
|
6.4 KB
|
|
|
001 Change Font Style, Size & Color.mp4
|
MP4
|
50 MB
|
|
|
001 Column Chart.en.srt
|
SRT
|
7.4 KB
|
|
|
001 Column Chart.mp4
|
MP4
|
32.8 MB
|
|
|
001 Create Drop Down List.en.srt
|
SRT
|
6.2 KB
|
|
|
001 Create Drop Down List.mp4
|
MP4
|
26.4 MB
|
|
|
001 Create Pivot Table.en.srt
|
SRT
|
19.5 KB
|
|
|
001 Create Pivot Table.mp4
|
MP4
|
209.3 MB
|
|
|
001 Create Tables.en.srt
|
SRT
|
4.9 KB
|
|
|
001 Create Tables.mp4
|
MP4
|
31.8 MB
|
|
|
001 Dashboard I.en.srt
|
SRT
|
19.3 KB
|
|
|
001 Dashboard I.mp4
|
MP4
|
127.7 MB
|
|
|
001 Hide & Unhide Sheets.en.srt
|
SRT
|
2.2 KB
|
|
|
001 Hide & Unhide Sheets.mp4
|
MP4
|
10.3 MB
|
|
|
001 Hyperlinks.en.srt
|
SRT
|
6.7 KB
|
|
|
001 Hyperlinks.mp4
|
MP4
|
39.1 MB
|
|
|
001 IF Function.en.srt
|
SRT
|
6.6 KB
|
|
|
001 IF Function.mp4
|
MP4
|
23.1 MB
|
|
|
001 Introduction.en.srt
|
SRT
|
1.9 KB
|
|
|
001 Introduction.mp4
|
MP4
|
7 MB
|
|
|
001 Introduction.mp4.jpg
|
JPG
|
159.3 KB
|
|
|
001 Next Steps.en.srt
|
SRT
|
6.7 KB
|
|
|
001 Next Steps.mp4
|
MP4
|
13.7 MB
|
|
|
001 QAT - Quick Access Toolbar.en.srt
|
SRT
|
7.4 KB
|
|
|
001 QAT - Quick Access Toolbar.mp4
|
MP4
|
53.5 MB
|
|
|
001 Remove Duplicate Records.en.srt
|
SRT
|
7.5 KB
|
|
|
001 Remove Duplicate Records.mp4
|
MP4
|
39.9 MB
|
|
|
001 SUM Function.en.srt
|
SRT
|
1.4 KB
|
|
|
001 SUM Function.mp4
|
MP4
|
7 MB
|
|
|
001 Today, Year, Month & Day Functions.en.srt
|
SRT
|
1.8 KB
|
|
|
001 Today, Year, Month & Day Functions.mp4
|
MP4
|
9 MB
|
|
|
001 Upper Function.en.srt
|
SRT
|
1.5 KB
|
|
|
001 Upper Function.mp4
|
MP4
|
15.9 MB
|
|
|
001 VLOOKUP.en.srt
|
SRT
|
9.1 KB
|
|
|
001 VLOOKUP.mp4
|
MP4
|
94 MB
|
|
|
002 AVERAGE Function.en.srt
|
SRT
|
1.9 KB
|
|
|
002 AVERAGE Function.mp4
|
MP4
|
10.5 MB
|
|
|
002 Bar Chart.en.srt
|
SRT
|
7 KB
|
|
|
002 Bar Chart.mp4
|
MP4
|
27.1 MB
|
|
|
002 Change Text Alignment.en.srt
|
SRT
|
5.7 KB
|
|
|
002 Change Text Alignment.mp4
|
MP4
|
46.5 MB
|
|
|
002 Compare Worksheets Side by Side.en.srt
|
SRT
|
3.3 KB
|
|
|
002 Compare Worksheets Side by Side.mp4
|
MP4
|
19.6 MB
|
|
|
002 Dashboard II.en.srt
|
SRT
|
7 KB
|
|
|
002 Dashboard II.mp4
|
MP4
|
52.4 MB
|
|
|
002 Data Validation.en.srt
|
SRT
|
5.9 KB
|
|
|
002 Data Validation.mp4
|
MP4
|
20.2 MB
|
|
|
002 Date Function.en.srt
|
SRT
|
6.6 KB
|
|
|
002 Date Function.mp4
|
MP4
|
28 MB
|
|
|
002 Excel Shortcut Keys.docx
|
DOCX
|
14.2 KB
|
|
|
002 Insert or Delete Rows and Columns.en.srt
|
SRT
|
2.2 KB
|
|
|
002 Insert or Delete Rows and Columns.mp4
|
MP4
|
12.9 MB
|
|
|
002 Lower Function.en.srt
|
SRT
|
1.4 KB
|
|
|
002 Lower Function.mp4
|
MP4
|
17.8 MB
|
|
|
002 Multi Level Subtotal.en.srt
|
SRT
|
3.2 KB
|
|
|
002 Multi Level Subtotal.mp4
|
MP4
|
30.8 MB
|
|
|
002 Multiple IF Statements.en.srt
|
SRT
|
5.4 KB
|
|
|
002 Multiple IF Statements.mp4
|
MP4
|
21.5 MB
|
|
|
002 Navigating Pivot Table Fields Window.en.srt
|
SRT
|
2.6 KB
|
|
|
002 Navigating Pivot Table Fields Window.mp4
|
MP4
|
20.7 MB
|
|
|
002 Protecting Excel Workbook.en.srt
|
SRT
|
4.4 KB
|
|
|
002 Protecting Excel Workbook.mp4
|
MP4
|
21.1 MB
|
|
|
002 Relative Cell Reference.en.srt
|
SRT
|
3.8 KB
|
|
|
002 Relative Cell Reference.mp4
|
MP4
|
14.4 MB
|
|
|
002 Sort Data in a Table.en.srt
|
SRT
|
7.2 KB
|
|
|
002 Sort Data in a Table.mp4
|
MP4
|
62.5 MB
|
|
|
002 Unique & Sort Functions.en.srt
|
SRT
|
3.2 KB
|
|
|
002 Unique & Sort Functions.mp4
|
MP4
|
16 MB
|
|
|
002 VLOOKUP Using Multiple Workbooks.en.srt
|
SRT
|
8.7 KB
|
|
|
002 VLOOKUP Using Multiple Workbooks.mp4
|
MP4
|
104.1 MB
|
|
|
002 What is Excel.en.srt
|
SRT
|
614.4 B
|
|
|
002 What is Excel.mp4
|
MP4
|
2.4 MB
|
|
|
003 Absolute Cell Reference.en.srt
|
SRT
|
9.1 KB
|
|
|
003 Absolute Cell Reference.mp4
|
MP4
|
34.2 MB
|
|
|
003 Compare Workbooks Side by SIde.en.srt
|
SRT
|
1.3 KB
|
|
|
003 Compare Workbooks Side by SIde.mp4
|
MP4
|
13.5 MB
|
|
|
003 Dashboard III.en.srt
|
SRT
|
7.5 KB
|
|
|
003 Dashboard III.mp4
|
MP4
|
56.2 MB
|
|
|
003 Date Format.en.srt
|
SRT
|
6.9 KB
|
|
|
003 Date Format.mp4
|
MP4
|
61.4 MB
|
|
|
003 Filter & Slicer.en.srt
|
SRT
|
9.8 KB
|
|
|
003 Filter & Slicer.mp4
|
MP4
|
68.4 MB
|
|
|
003 Format Painter.en.srt
|
SRT
|
3.7 KB
|
|
|
003 Format Painter.mp4
|
MP4
|
25.3 MB
|
|
|
003 HLOOKUP.en.srt
|
SRT
|
5.5 KB
|
|
|
003 HLOOKUP.mp4
|
MP4
|
33.5 MB
|
|
|
003 Handling Errors.en.srt
|
SRT
|
11.7 KB
|
|
|
003 Handling Errors.mp4
|
MP4
|
48.4 MB
|
|
|
003 IFS Function.en.srt
|
SRT
|
2.8 KB
|
|
|
003 IFS Function.mp4
|
MP4
|
14.8 MB
|
|
|
003 Importance of Excel.en.srt
|
SRT
|
1.6 KB
|
|
|
003 Importance of Excel.mp4
|
MP4
|
2.9 MB
|
|
|
003 MIN & MAX Function.en.srt
|
SRT
|
716.8 B
|
|
|
003 MIN & MAX Function.mp4
|
MP4
|
4.6 MB
|
|
|
003 Manage Drop Down List.en.srt
|
SRT
|
3.3 KB
|
|
|
003 Manage Drop Down List.mp4
|
MP4
|
15.5 MB
|
|
|
003 Match Function.en.srt
|
SRT
|
2.8 KB
|
|
|
003 Match Function.mp4
|
MP4
|
15.8 MB
|
|
|
003 Merge & Unmerge Cells.en.srt
|
SRT
|
1.5 KB
|
|
|
003 Merge & Unmerge Cells.mp4
|
MP4
|
11.1 MB
|
|
|
003 Pivot Chart - Bar.en.srt
|
SRT
|
6.5 KB
|
|
|
003 Pivot Chart - Bar.mp4
|
MP4
|
56.1 MB
|
|
|
003 Proper Function.en.srt
|
SRT
|
1 KB
|
|
|
003 Proper Function.mp4
|
MP4
|
6.6 MB
|
|
|
003 Stacked Column Chart.en.srt
|
SRT
|
9.2 KB
|
|
|
003 Stacked Column Chart.mp4
|
MP4
|
41 MB
|
|
|
004 COUNT & COUNTA Functions.en.srt
|
SRT
|
3.6 KB
|
|
|
004 COUNT & COUNTA Functions.mp4
|
MP4
|
18.2 MB
|
|
|
004 COUNTIF Function.en.srt
|
SRT
|
3.9 KB
|
|
|
004 COUNTIF Function.mp4
|
MP4
|
21.6 MB
|
|
|
004 Clear Formatting.en.srt
|
SRT
|
5.2 KB
|
|
|
004 Clear Formatting.mp4
|
MP4
|
21 MB
|
|
|
004 Clustered Column Chart.en.srt
|
SRT
|
3.8 KB
|
|
|
004 Clustered Column Chart.mp4
|
MP4
|
15.8 MB
|
|
|
004 Concatenate Function.en.srt
|
SRT
|
2.3 KB
|
|
|
004 Concatenate Function.mp4
|
MP4
|
19.1 MB
|
|
|
004 Dashboard IV.en.srt
|
SRT
|
6.6 KB
|
|
|
004 Dashboard IV.mp4
|
MP4
|
71.7 MB
|
|
|
004 Data Types in Excel.en.srt
|
SRT
|
1.4 KB
|
|
|
004 Data Types in Excel.mp4
|
MP4
|
4.5 MB
|
|
|
004 Datediff Function.en.srt
|
SRT
|
4.3 KB
|
|
|
004 Datediff Function.mp4
|
MP4
|
28 MB
|
|
|
004 Large & Small Functions.en.srt
|
SRT
|
3.3 KB
|
|
|
004 Large & Small Functions.mp4
|
MP4
|
16.1 MB
|
|
|
004 Macro.en.srt
|
SRT
|
6.7 KB
|
|
|
004 Macro.mp4
|
MP4
|
99.9 MB
|
|
|
004 Pivot Chart - Pie.en.srt
|
SRT
|
4.1 KB
|
|
|
004 Pivot Chart - Pie.mp4
|
MP4
|
41.9 MB
|
|
|
004 Split Text into Multiple Columns.en.srt
|
SRT
|
2 KB
|
|
|
004 Split Text into Multiple Columns.mp4
|
MP4
|
15.7 MB
|
|
|
004 XLOOKUP.en.srt
|
SRT
|
4.3 KB
|
|
|
004 XLOOKUP.mp4
|
MP4
|
33.6 MB
|
|
|
005 COUNTIFS Function.en.srt
|
SRT
|
2.5 KB
|
|
|
005 COUNTIFS Function.mp4
|
MP4
|
14.7 MB
|
|
|
005 Dashboard Review.en.srt
|
SRT
|
9.7 KB
|
|
|
005 Dashboard Review.mp4
|
MP4
|
63.1 MB
|
|
|
005 Freeze Panes to Lock Rows & Columns.en.srt
|
SRT
|
6 KB
|
|
|
005 Freeze Panes to Lock Rows & Columns.mp4
|
MP4
|
60.3 MB
|
|
|
005 Insert Current Date & Time.en.srt
|
SRT
|
2.9 KB
|
|
|
005 Insert Current Date & Time.mp4
|
MP4
|
13.3 MB
|
|
|
005 Left, Right & Mid Functions.en.srt
|
SRT
|
5.1 KB
|
|
|
005 Left, Right & Mid Functions.mp4
|
MP4
|
35.8 MB
|
|
|
005 Line Chart.en.srt
|
SRT
|
12.3 KB
|
|
|
005 Line Chart.mp4
|
MP4
|
59 MB
|
|
|
005 Pivot Chart - Line.en.srt
|
SRT
|
6.9 KB
|
|
|
005 Pivot Chart - Line.mp4
|
MP4
|
73.6 MB
|
|
|
005 Rank Function.en.srt
|
SRT
|
13.2 KB
|
|
|
005 Rank Function.mp4
|
MP4
|
59.8 MB
|
|
|
005 Transpose Data - Rotate Data from Vertical to Horizontal.en.srt
|
SRT
|
5.4 KB
|
|
|
005 Transpose Data - Rotate Data from Vertical to Horizontal.mp4
|
MP4
|
37.7 MB
|
|
|
005 Workbook Layout.en.srt
|
SRT
|
6.1 KB
|
|
|
005 Workbook Layout.mp4
|
MP4
|
29 MB
|
|
|
005 Wrap Text in Cells.en.srt
|
SRT
|
4.6 KB
|
|
|
005 Wrap Text in Cells.mp4
|
MP4
|
23.8 MB
|
|
|
006 Aggregate Function.en.srt
|
SRT
|
7.3 KB
|
|
|
006 Aggregate Function.mp4
|
MP4
|
31.6 MB
|
|
|
006 Enter Values into Worksheet.en.srt
|
SRT
|
6 KB
|
|
|
006 Enter Values into Worksheet.mp4
|
MP4
|
22.7 MB
|
|
|
006 Format Time Values.en.srt
|
SRT
|
2.6 KB
|
|
|
006 Format Time Values.mp4
|
MP4
|
20.4 MB
|
|
|
006 Histogram.en.srt
|
SRT
|
7.1 KB
|
|
|
006 Histogram.mp4
|
MP4
|
46.5 MB
|
|
|
006 LEN Function.en.srt
|
SRT
|
3.6 KB
|
|
|
006 LEN Function.mp4
|
MP4
|
22.1 MB
|
|
|
006 Rotate or Align Text in Cells.en.srt
|
SRT
|
1.5 KB
|
|
|
006 Rotate or Align Text in Cells.mp4
|
MP4
|
8.2 MB
|
|
|
006 SUMIF Function.en.srt
|
SRT
|
4.3 KB
|
|
|
006 SUMIF Function.mp4
|
MP4
|
25.2 MB
|
|
|
006 Split Worksheet.en.srt
|
SRT
|
2.8 KB
|
|
|
006 Split Worksheet.mp4
|
MP4
|
22.5 MB
|
|
|
007 Format Numbers.en.srt
|
SRT
|
7.7 KB
|
|
|
007 Format Numbers.mp4
|
MP4
|
33.5 MB
|
|
|
007 MOD Function.en.srt
|
SRT
|
6.2 KB
|
|
|
007 MOD Function.mp4
|
MP4
|
23.9 MB
|
|
|
007 Pie Chart.en.srt
|
SRT
|
7.4 KB
|
|
|
007 Pie Chart.mp4
|
MP4
|
28 MB
|
|
|
007 SUMIFS Function.en.srt
|
SRT
|
2.3 KB
|
|
|
007 SUMIFS Function.mp4
|
MP4
|
17.2 MB
|
|
|
007 TRIM Function.en.srt
|
SRT
|
3.4 KB
|
|
|
007 TRIM Function.mp4
|
MP4
|
19.9 MB
|
|
|
007 Update Values in a Cell.en.srt
|
SRT
|
4.8 KB
|
|
|
007 Update Values in a Cell.mp4
|
MP4
|
18.6 MB
|
|
|
008 AVERAGEIF Function.en.srt
|
SRT
|
1.1 KB
|
|
|
008 AVERAGEIF Function.mp4
|
MP4
|
6.3 MB
|
|
|
008 Doughnut Chart.en.srt
|
SRT
|
4.9 KB
|
|
|
008 Doughnut Chart.mp4
|
MP4
|
24.8 MB
|
|
|
008 Fill Data Automatically.en.srt
|
SRT
|
10 KB
|
|
|
008 Fill Data Automatically.mp4
|
MP4
|
38.2 MB
|
|
|
008 RANDBETWEEN Function.en.srt
|
SRT
|
2.8 KB
|
|
|
008 RANDBETWEEN Function.mp4
|
MP4
|
13.7 MB
|
|
|
008 Substitute Function.en.srt
|
SRT
|
4.8 KB
|
|
|
008 Substitute Function.mp4
|
MP4
|
17 MB
|
|
|
009 AVERAGEIFS Function.en.srt
|
SRT
|
819.2 B
|
|
|
009 AVERAGEIFS Function.mp4
|
MP4
|
4.9 MB
|
|
|
009 Exact & Equal Function.en.srt
|
SRT
|
4.4 KB
|
|
|
009 Exact & Equal Function.mp4
|
MP4
|
18.4 MB
|
|
|
009 Map Chart.en.srt
|
SRT
|
9.8 KB
|
|
|
009 Map Chart.mp4
|
MP4
|
39.9 MB
|
|
|
009 Select Cells, Range, Rows, Columns in a Worksheet.en.srt
|
SRT
|
4.4 KB
|
|
|
009 Select Cells, Range, Rows, Columns in a Worksheet.mp4
|
MP4
|
18.2 MB
|
|
|
010 AND Function.en.srt
|
SRT
|
6.5 KB
|
|
|
010 AND Function.mp4
|
MP4
|
29.1 MB
|
|
|
010 Copy & Duplicate Cell Values.en.srt
|
SRT
|
7.9 KB
|
|
|
010 Copy & Duplicate Cell Values.mp4
|
MP4
|
37.2 MB
|
|
|
011 Hide & Unhide Columns and Rows.en.srt
|
SRT
|
5.1 KB
|
|
|
011 Hide & Unhide Columns and Rows.mp4
|
MP4
|
24 MB
|
|
|
011 OR Function.en.srt
|
SRT
|
4.2 KB
|
|
|
011 OR Function.mp4
|
MP4
|
17.7 MB
|
|
|
012 Book List.csv
|
CSV
|
1.5 KB
|
|
|
012 Find and Replace Text or Numbers.en.srt
|
SRT
|
5.3 KB
|
|
|
012 Find and Replace Text or Numbers.mp4
|
MP4
|
41.4 MB
|
|
|
013 Keyboard Shortcuts.en.srt
|
SRT
|
18.5 KB
|
|
|
013 Keyboard Shortcuts.mp4
|
MP4
|
113.6 MB
|
|
|
024 Formatted Book List.xlsx
|
XLSX
|
12.1 KB
|
|
|
024 Student Names.xlsx
|
XLSX
|
5.2 KB
|
|
|
036 Common Functions.xlsx
|
XLSX
|
9.7 KB
|
|
|
040 Logical Function.xlsx
|
XLSX
|
38.6 KB
|
|
|
051 Student.xlsx
|
XLSX
|
41.6 MB
|
|
|
060 Customer Records.xlsx
|
XLSX
|
88 KB
|
|
|
060 Transpose Function.xlsx
|
XLSX
|
10.9 KB
|
|
|
060 XLOOKUP.xlsx
|
XLSX
|
64.6 KB
|
|
|
060 compromised accounts.xlsx
|
XLSX
|
57.4 KB
|
|
|
065 Date Formats.xlsx
|
XLSX
|
21.1 KB
|
|
|
067 3.Date Format.mp4
|
MP4
|
20.5 MB
|
|
|
071 statistical function.xlsx
|
XLSX
|
27 KB
|
|
|
079 Macros Data.xlsx
|
XLSX
|
101.9 KB
|
|
|
079 sales data.xlsx
|
XLSX
|
22.6 KB
|
|
|
083 Sort Records.xlsx
|
XLSX
|
18.7 KB
|
|
|
086 chart.xlsx
|
XLSX
|
42 KB
|
|
|
095 Pivot Table.xlsx
|
XLSX
|
26.9 KB
|
|
|
100 Dashboard Sales Data.xlsx
|
XLSX
|
32.6 KB
|
|
|
107 Course Discount Links.docx
|
DOCX
|
13.2 KB
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|