Filename Size 01 - Course information/001 Welcome.mp4 118.7 MB 01 - Course information/001 Welcome_en.srt 12.9 KB 01 - Course information/002 07-relative-references-point-and-click.xlsx 8.6 KB 01 - Course information/002 08-absolute-references.xlsx 12.6 KB 01 - Course information/002 09-gradebook.xlsx 28.1 KB 01 - Course information/002 10-chart-creation.xlsx 198.2 KB 01 - Course information/002 11-functions.xlsx 47.8 KB 01 - Course information/002 12-fcdb.xlsx 58.8 KB 01 - Course information/002 14-hands-on-exercises.xlsx 48 KB 01 - Course information/002 15-16-finding-your-way-around-excel.xlsx 455.1 KB 01 - Course information/002 17-mouse-pointer-awareness.xlsx 36.3 KB 01 - Course information/002 18-right-click-paste-transpose.xlsx 11 KB 01 - Course information/002 19-books-sheets.xlsx 8.6 KB 01 - Course information/002 22-hands-on.xlsx 9.3 KB 01 - Course information/002 23-func-average-max-min.xlsx 17.3 KB 01 - Course information/002 24-func-rand.xlsx 20.7 KB 01 - Course information/002 25-func-concat-textjoin.xlsx 32.3 KB 01 - Course information/002 26-func-concat-textjoin.xlsx 33.1 KB 01 - Course information/002 28-hands-on-exercises.xlsx 18.3 KB 01 - Course information/002 29-introduction.xlsx 174.7 KB 01 - Course information/002 30-top-10.xlsx 174.6 KB 01 - Course information/002 31-xlookup.xlsx 177.2 KB 01 - Course information/002 32-pmt-function.xlsx 177.9 KB 01 - Course information/002 33-pmt-ipmt-functions.xlsx 178.3 KB 01 - Course information/002 34-fv-function.xlsx 178.3 KB 01 - Course information/002 35-fv-retirement-amortization.xlsx 179.2 KB 01 - Course information/002 36-if-iferror-functions.xlsx 179.5 KB 01 - Course information/002 37-conditional-formatting.xlsx 179.7 KB 01 - Course information/002 39-ice-cream-choice.xlsx 14.2 KB 01 - Course information/002 40-fundamentals-of-formatting.xlsx 35.4 KB 01 - Course information/002 41-formatting-tables-quickly.xlsx 20.1 KB 01 - Course information/002 42-font-is-feeling.xlsx 23 KB 01 - Course information/002 43-exploring-home-ribbon.xlsx 243.2 KB 01 - Course information/002 44-zebra-stripe-rows.xlsx 256.5 KB 01 - Course information/002 46-hands-on-exercise.xlsx 22.6 KB 01 - Course information/002 47-visually-representing-data.xlsx 470.3 KB 01 - Course information/002 48-chart-creation-II.xlsx 91.9 KB 01 - Course information/002 49-formatting-charts.xlsx 39.6 KB 01 - Course information/002 50-trendlines.xlsx 32 KB 01 - Course information/002 51-combo-chart.xlsx 212.5 KB 01 - Course information/002 52-sparklines.xlsx 19.1 KB 01 - Course information/002 54-exercises.xlsx 52.6 KB 01 - Course information/002 55-gapminder-road-data.xlsx 22 KB 01 - Course information/002 56-scraping-data.xlsx 18.3 KB 01 - Course information/002 57-outdoor-gear-data.xlsx 1.8 MB 01 - Course information/002 58-name-generator-data.xlsx 6.1 MB 01 - Course information/002 59-sorting-data.xlsx 284.9 KB 01 - Course information/002 60-freeze-panes.xlsx 284.8 KB 01 - Course information/002 61-remove-duplicates.xlsx 23.2 KB 01 - Course information/002 62-filter-data.xlsx 31.9 KB 01 - Course information/002 64-remove-duplicates.xlsx 70.1 KB 01 - Course information/002 65-pivot-tables.xlsx 589.6 KB 01 - Course information/002 66-creating-pivot-tables.xlsx 344.4 KB 01 - Course information/002 67-pivot-table-slicers.xlsx 343.5 KB 01 - Course information/002 68-pivot-charts.xlsx 349.8 KB 01 - Course information/002 70-pivot-exercises.xlsx 396 KB 01 - Course information/002 71-printing-worksheets.xlsx 82.3 KB 01 - Course information/002 72-protect.xlsx 11.2 KB 01 - Course information/002 73-ole.docx 16.4 KB 01 - Course information/002 73-ole.xlsx 31.3 KB 01 - Course information/002 74-macros.xlsm 84.9 KB 01 - Course information/002 74-macros.xlsx 45.2 KB 01 - Course information/002 76-macros.xlsm 12.6 KB 01 - Course information/002 76-macros.xlsx 8.1 KB 01 - Course information/002 Course files.html 778 B 01 - Course information/002 Microsoft-Excel-From-Beginner-to-Expert-in-6-Hours-Course-Outline.pdf 1.5 MB 01 - Course information/003 Getting your certificate.mp4 42.6 MB 01 - Course information/003 Getting your certificate_en.srt 7 KB 01 - Course information/003 Microsoft-Excel-From-Beginner-to-Expert-in-6-Hours-Course-Outline.pdf 1.5 MB 02 - Quick start with MS Excel/001 Introduction.mp4 85.7 MB 02 - Quick start with MS Excel/001 Introduction_en.srt 10.5 KB 02 - Quick start with MS Excel/002 Microsoft Excel.mp4 71.1 MB 02 - Quick start with MS Excel/002 Microsoft Excel_en.srt 9.1 KB 02 - Quick start with MS Excel/002 Microsoft-Excel-From-Beginner-to-Expert-in-6-Hours-Course-Outline.pdf 1.5 MB 02 - Quick start with MS Excel/003 07-relative-references-point-and-click.xlsx 8.6 KB 02 - Quick start with MS Excel/003 Relative references.mp4 70.2 MB 02 - Quick start with MS Excel/003 Relative references_en.srt 10.1 KB 02 - Quick start with MS Excel/004 08-absolute-references.xlsx 12.6 KB 02 - Quick start with MS Excel/004 Absolute references.mp4 63.1 MB 02 - Quick start with MS Excel/004 Absolute references_en.srt 13.9 KB 02 - Quick start with MS Excel/005 09-gradebook.xlsx 28.1 KB 02 - Quick start with MS Excel/005 Calculating a grade.mp4 42.6 MB 02 - Quick start with MS Excel/005 Calculating a grade_en.srt 9.5 KB 02 - Quick start with MS Excel/006 10-chart-creation.xlsx 198.2 KB 02 - Quick start with MS Excel/006 Creating charts.mp4 118.9 MB 02 - Quick start with MS Excel/006 Creating charts_en.srt 15.4 KB 02 - Quick start with MS Excel/007 11-functions.xlsx 47.8 KB 02 - Quick start with MS Excel/007 Functions.mp4 67 MB 02 - Quick start with MS Excel/007 Functions_en.srt 15.6 KB 02 - Quick start with MS Excel/008 12-fcdb.xlsx 58.8 KB 02 - Quick start with MS Excel/008 FCDB.mp4 39.9 MB 02 - Quick start with MS Excel/008 FCDB_en.srt 4.2 KB 02 - Quick start with MS Excel/external-links.txt 103 B 03 - Hands-on exercises #1/001 14-hands-on-exercises.xlsx 48 KB 03 - Hands-on exercises #1/001 Hands-on exercises.mp4 57.9 MB 03 - Hands-on exercises #1/001 Hands-on exercises_en.srt 12.5 KB 04 - MS Excel fundamentals/001 15-16-finding-your-way-around-excel.xlsx 455.1 KB