|
|
001 A brief introduction to the course.en.srt
|
SRT
|
10.5 KB
|
|
|
001 A brief introduction to the course.mp4
|
MP4
|
85.5 MB
|
|
|
001 Create blank and populated workbooks.en.srt
|
SRT
|
11 KB
|
|
|
001 Create blank and populated workbooks.mp4
|
MP4
|
164 MB
|
|
|
001 Create charts and objects.en.srt
|
SRT
|
8.4 KB
|
|
|
001 Create charts and objects.mp4
|
MP4
|
79.2 MB
|
|
|
001 Create data; reuse data; replace data.en.srt
|
SRT
|
40.7 KB
|
|
|
001 Create data; reuse data; replace data.mp4
|
MP4
|
372.2 MB
|
|
|
001 Hide and unhide worksheet contents.en.srt
|
SRT
|
5.3 KB
|
|
|
001 Hide and unhide worksheet contents.mp4
|
MP4
|
64.9 MB
|
|
|
001 Manage worksheet attributes.en.srt
|
SRT
|
9 KB
|
|
|
001 Manage worksheet attributes.mp4
|
MP4
|
61.6 MB
|
|
|
001 One_ Create and manage tables; manage table styles and options; filter and sort.en.srt
|
SRT
|
22.8 KB
|
|
|
001 One_ Create and manage tables; manage table styles and options; filter and sort.mp4
|
MP4
|
229.7 MB
|
|
|
001 Print all or part of a workbook.en.srt
|
SRT
|
10.5 KB
|
|
|
001 Print all or part of a workbook.mp4
|
MP4
|
101.8 MB
|
|
|
001 Search for data within a workbook.en.srt
|
SRT
|
11.7 KB
|
|
|
001 Search for data within a workbook.mp4
|
MP4
|
82 MB
|
|
|
001 Summarize data by using functions.en.srt
|
SRT
|
14.7 KB
|
|
|
001 Summarize data by using functions.mp4
|
MP4
|
122.1 MB
|
|
|
002 2017_Fruits.xlsx
|
XLSX
|
11.9 KB
|
|
|
002 Add worksheets to workbooks; move or copy worksheets; import data from text file.en.srt
|
SRT
|
13.3 KB
|
|
|
002 Add worksheets to workbooks; move or copy worksheets; import data from text file.mp4
|
MP4
|
110.3 MB
|
|
|
002 Change the appearance of workbook content; modify page setup; insert headers and.en.srt
|
SRT
|
12 KB
|
|
|
002 Change the appearance of workbook content; modify page setup; insert headers and.mp4
|
MP4
|
133.9 MB
|
|
|
002 Customize the Quick Access Toolbar (QAT).en.srt
|
SRT
|
10.9 KB
|
|
|
002 Customize the Quick Access Toolbar (QAT).mp4
|
MP4
|
72.7 MB
|
|
|
002 Exercise1.xlsm
|
XLSM
|
3.5 MB
|
|
|
002 Exercise2.xlsm
|
XLSM
|
635.9 KB
|
|
|
002 Format cells and ranges.en.srt
|
SRT
|
13.2 KB
|
|
|
002 Format cells and ranges.mp4
|
MP4
|
114.5 MB
|
|
|
002 Format charts.en.srt
|
SRT
|
12.4 KB
|
|
|
002 Format charts.mp4
|
MP4
|
108.1 MB
|
|
|
002 ManageWbEx1.xlsx
|
XLSX
|
45.2 KB
|
|
|
002 ManageWbEx1_Results.xlsx
|
XLSX
|
44.9 KB
|
|
|
002 ManageWbExercises.docx
|
DOCX
|
17.5 KB
|
|
|
002 MyBus_results.xlsx
|
XLSX
|
308.7 KB
|
|
|
002 Navigate to a named cell, range, or workbook element.en.srt
|
SRT
|
7.5 KB
|
|
|
002 Navigate to a named cell, range, or workbook element.mp4
|
MP4
|
47 MB
|
|
|
002 Perform conditional operations by using functions.en.srt
|
SRT
|
17.6 KB
|
|
|
002 Perform conditional operations by using functions.mp4
|
MP4
|
225.4 MB
|
|
|
002 Set print scaling; print sheet elements.en.srt
|
SRT
|
8.5 KB
|
|
|
002 Set print scaling; print sheet elements.mp4
|
MP4
|
109.3 MB
|
|
|
003 Apply cell formats and styles; apply number formats.en.srt
|
SRT
|
11 KB
|
|
|
003 Apply cell formats and styles; apply number formats.mp4
|
MP4
|
67.8 MB
|
|
|
003 Format and modify text by using functions.en.srt
|
SRT
|
7.3 KB
|
|
|
003 Format and modify text by using functions.mp4
|
MP4
|
89.2 MB
|
|
|
003 Insert and format objects.en.srt
|
SRT
|
14.1 KB
|
|
|
003 Insert and format objects.mp4
|
MP4
|
142.7 MB
|
|
|
003 Link to internal and external locations and files.en.srt
|
SRT
|
16.7 KB
|
|
|
003 Link to internal and external locations and files.mp4
|
MP4
|
115 MB
|
|
|
003 ManageWbEx1.xlsx
|
XLSX
|
45.2 KB
|
|
|
003 ManageWbEx1_Results.xlsx
|
XLSX
|
44.9 KB
|
|
|
003 ManageWbExercises.docx
|
DOCX
|
17.5 KB
|
|
|
003 Modify the display of worksheets.en.srt
|
SRT
|
13.4 KB
|
|
|
003 Modify the display of worksheets.mp4
|
MP4
|
172.3 MB
|
|
|
003 MyBus_results.xlsx
|
XLSX
|
308.7 KB
|
|
|
004 ManageWbExercise.xlsx
|
XLSX
|
27.3 KB
|
|
|
004 ManageWbExercise_Results.xlsx
|
XLSX
|
27.4 KB
|
|
|
004 NavigateWbExercise.docx
|
DOCX
|
19.7 KB
|
|
|
004 Summarize and organize data.en.srt
|
SRT
|
12.7 KB
|
|
|
004 Summarize and organize data.mp4
|
MP4
|
118.4 MB
|
|
|
005 Insert Sparklines; outline data and insert subtotals.en.srt
|
SRT
|
9.8 KB
|
|
|
005 Insert Sparklines; outline data and insert subtotals.mp4
|
MP4
|
106.5 MB
|
|
|
005 ManageWbExercise.xlsx
|
XLSX
|
27.3 KB
|
|
|
005 ManageWbExercise_Results.xlsx
|
XLSX
|
27.4 KB
|
|
|
005 NavigateWbExercise.docx
|
DOCX
|
19.7 KB
|
|
|
006 ManageWbExercise_Results.xlsx
|
XLSX
|
27.4 KB
|
|
|
006 NavigateWbExercise.docx
|
DOCX
|
19.7 KB
|
|
|
007 FormatWbExercises.docx
|
DOCX
|
19.9 KB
|
|
|
007 FormatWsWb.xlsx
|
XLSX
|
69.4 KB
|
|
|
007 FormatWsWb_Results.xlsx
|
XLSX
|
69.5 KB
|
|
|
008 Exercise122.xlsm
|
XLSM
|
1.8 MB
|
|
|
008 Exercise150.xlsm
|
XLSM
|
1.9 MB
|
|
|
008 Exercise48.xlsm
|
XLSM
|
1.6 MB
|
|
|
008 Exercise49.xlsm
|
XLSM
|
1.8 MB
|
|
|
008 Exercise74.xlsm
|
XLSM
|
891.8 KB
|
|
|
008 Exercise75.xlsm
|
XLSM
|
872.7 KB
|
|
|
008 Exercise76.xlsm
|
XLSM
|
1 MB
|
|
|
008 Exercise78.xlsm
|
XLSM
|
1 MB
|
|
|
008 Exercise80.xlsm
|
XLSM
|
1.8 MB
|
|
|
008 Exercise87.xlsm
|
XLSM
|
2.1 MB
|
|
|
008 FormatWbExercises.docx
|
DOCX
|
19.9 KB
|
|
|
008 FormatWsWb.xlsx
|
XLSX
|
69.4 KB
|
|
|
008 FormatWsWb_Results.xlsx
|
XLSX
|
69.5 KB
|
|
|
009 CustomizeOptionsExercise.xlsx
|
XLSX
|
54.7 KB
|
|
|
009 CustomizeOptionsExercise_Result.xlsx
|
XLSX
|
56.1 KB
|
|
|
009 CustomizeOptionsandViews.docx
|
DOCX
|
19.7 KB
|
|
|
009 Hide_Unhide_Conlents_L1.mp4
|
MP4
|
31.1 MB
|
|
|
010 CustomizeOptionsExercise.xlsx
|
XLSX
|
54.7 KB
|
|
|
010 CustomizeOptionsExercise_Result.xlsx
|
XLSX
|
56.1 KB
|
|
|
010 CustomizeOptionsandViews.docx
|
DOCX
|
19.7 KB
|
|
|
011 CustomizeOptionsExercise.xlsx
|
XLSX
|
54.7 KB
|
|
|
011 CustomizeOptionsExercise_Result.xlsx
|
XLSX
|
56.1 KB
|
|
|
011 CustomizeOptionsandViews.docx
|
DOCX
|
19.7 KB
|
|
|
012 Acotex-Compatible.xls
|
XLS
|
41.5 KB
|
|
|
012 Acotex-Template.xltm
|
XLTM
|
23.7 KB
|
|
|
012 ConfigureForDistribution.xlsm
|
XLSM
|
21.8 KB
|
|
|
012 ConfigureForDistribution.xlsx
|
XLSX
|
18.7 KB
|
|
|
012 ConfigureForDistributionExercise.docx
|
DOCX
|
19.7 KB
|
|
|
012 ConfigureForDistribution_Results.xlsx
|
XLSX
|
20.9 KB
|
|
|
012 PrintAllOrPartOfWB_L1.mp4
|
MP4
|
51.8 MB
|
|
|
013 CustomizeOptionsExercise.xlsx
|
XLSX
|
54.7 KB
|
|
|
013 CustomizeOptionsExercise_Result.xlsx
|
XLSX
|
56.1 KB
|
|
|
013 CustomizeOptionsandViews.docx
|
DOCX
|
19.7 KB
|
|
|
014 InsertDataCellsAndRanges.docx
|
DOCX
|
20.1 KB
|
|
|
014 InsertDataCellsAndRanges.xlsx
|
XLSX
|
26.3 KB
|
|
|
014 InsertDataCellsAndRanges_results.xlsx
|
XLSX
|
20.8 KB
|
|
|
016 ApplyNumberFormats.docx
|
DOCX
|
19.5 KB
|
|
|
016 FormatCellsAndRanges.xlsx
|
XLSX
|
23.8 KB
|
|
|
016 FormatCellsAndRanges_results.xlsx
|
XLSX
|
16.5 KB
|
|
|
017 Exercise101.xlsm
|
XLSM
|
2 MB
|
|
|
017 Exercise102.xlsm
|
XLSM
|
2 MB
|
|
|
017 Exercise12.xlsm
|
XLSM
|
1.3 MB
|
|
|
017 Exercise23.xlsm
|
XLSM
|
1.7 MB
|
|
|
017 Exercise23_CSV.csv
|
CSV
|
420.1 KB
|
|
|
017 Exercise24.xlsm
|
XLSM
|
2.8 MB
|
|
|
017 Exercise24a.xlsx
|
XLSX
|
18 KB
|
|
|
017 Exercise24b.xlsx
|
XLSX
|
18.6 KB
|
|
|
017 Exercise24c.xlsx
|
XLSX
|
18.6 KB
|
|
|
017 Exercise24d.xlsx
|
XLSX
|
17.9 KB
|
|
|
017 Exercise24e.xlsx
|
XLSX
|
18.4 KB
|
|
|
017 Exercise24f.xlsx
|
XLSX
|
18.8 KB
|
|
|
017 Exercise35.xlsm
|
XLSM
|
997 KB
|
|
|
017 Exercise38.xlsm
|
XLSM
|
986.4 KB
|
|
|
017 Exercise4.xlsm
|
XLSM
|
643 KB
|
|
|
017 Exercise46.xlsm
|
XLSM
|
1.6 MB
|
|
|
017 Exercise5.xlsm
|
XLSM
|
523 KB
|
|
|
017 Exercise51.xlsm
|
XLSM
|
1.5 MB
|
|
|
017 Exercise68.xlsm
|
XLSM
|
978.5 KB
|
|
|
017 Exercise73.xlsm
|
XLSM
|
850.2 KB
|
|
|
017 Exercise8.xlsm
|
XLSM
|
855.9 KB
|
|
|
017 Exercise98.xlsm
|
XLSM
|
2.9 MB
|
|
|
017 SummarizeAndOrganize.docx
|
DOCX
|
20.1 KB
|
|
|
017 SummarizeAndOrganize.xlsx
|
XLSX
|
48.5 KB
|
|
|
017 SummarizeAndOrganizeresults.xlsx
|
XLSX
|
48.9 KB
|
|
|
018 SummarizeAndOrganize.docx
|
DOCX
|
20.1 KB
|
|
|
018 SummarizeAndOrganize.xlsx
|
XLSX
|
48.5 KB
|
|
|
018 SummarizeAndOrganizeresults.xlsx
|
XLSX
|
48.9 KB
|
|
|
019 TablesEx1.xlsx
|
XLSX
|
18.1 KB
|
|
|
019 TablesEx1_results.xlsx
|
XLSX
|
19.1 KB
|
|
|
019 TablesEx2.xlsx
|
XLSX
|
24.2 KB
|
|
|
019 TablesEx2_results.xlsx
|
XLSX
|
23.2 KB
|
|
|
019 TablesEx3.xlsx
|
XLSX
|
29.9 KB
|
|
|
019 TablesEx3_results.xlsx
|
XLSX
|
28.5 KB
|
|
|
020 FormulaAndFunctionsEx1.xlsx
|
XLSX
|
16.8 KB
|
|
|
020 FormulaAndFunctionsEx1_results.xlsx
|
XLSX
|
17.8 KB
|
|
|
020 FormulaAndFunctionsEx2.xlsx
|
XLSX
|
21.9 KB
|
|
|
020 FormulaAndFunctionsEx2_results.xlsx
|
XLSX
|
20.2 KB
|
|
|
020 FormulaAndFunctionsEx3.xlsx
|
XLSX
|
21.4 KB
|
|
|
020 FormulaAndFunctionsEx3_results.xlsx
|
XLSX
|
21.7 KB
|
|
|
020 FormulaAndFunctionsEx4.xlsx
|
XLSX
|
13.2 KB
|
|
|
020 FormulaAndFunctionsEx4_results.xlsx
|
XLSX
|
13.4 KB
|
|
|
020 FormulaAndFunctionsEx5.xlsx
|
XLSX
|
17.4 KB
|
|
|
020 FormulaAndFunctionsEx5_results.xlsx
|
XLSX
|
16.3 KB
|
|
|
020 FunctionsAndFormulas.docx
|
DOCX
|
20.9 KB
|
|
|
025 ChartsExercise1.xlsx
|
XLSX
|
29.1 KB
|
|
|
025 ChartsExercise1_results.xlsx
|
XLSX
|
28.9 KB
|
|
|
025 ChartsExercise2.xlsx
|
XLSX
|
16.1 KB
|
|
|
025 ChartsExercise2_results.xlsx
|
XLSX
|
18.3 KB
|
|
|
025 ChartsExercises.docx
|
DOCX
|
19.9 KB
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
![[ FreeCourseWeb ] Udemy - Microsoft Excel - Basic to intermediate](/static/img/no-torrent-image.png "[ FreeCourseWeb ] Udemy - Microsoft Excel - Basic to intermediate")
