Please note that this page does not hosts or makes available any of the listed filenames. You
cannot download any of those files from here.
|
01_01-Welcome.mp4 |
4.72MB |
01_02-Using the exercise files.mp4 |
1.52MB |
02_01-What is Excel used for.mp4 |
8.55MB |
02_02-Using the menu system.mp4 |
15.82MB |
02_03-Using the Quick Access Toolbar.mp4 |
18.70MB |
02_04-Understanding workbooks and worksheets.mp4 |
12.01MB |
02_05-Using the Formula bar.mp4 |
3.87MB |
02_06-Using the Status bar.mp4 |
19.37MB |
02_07-Using navigation tools.mp4 |
10.17MB |
02_08-Using shortcut menus and the Mini toolbar.mp4 |
13.92MB |
02_09-Creating new workbooks.mp4 |
8.71MB |
02_10-Using Excel Help.mp4 |
22.50MB |
03_01-Exploring data entry and editing techniques.mp4 |
8.18MB |
03_02-Entering data with AutoFill.mp4 |
9.71MB |
03_03-Working with dates and times.mp4 |
9.91MB |
03_04-Using Undo and Redo.mp4 |
9.75MB |
03_05-Adding comments.mp4 |
5.64MB |
03_06-Using Save or Save As.mp4 |
10.11MB |
04_01-Creating simple formulas.mp4 |
16.97MB |
04_02-Copying a formula into adjacent cells.mp4 |
9.16MB |
04_03-Calculating yeartodate totals.mp4 |
9.23MB |
04_04-Creating a percentagechange formula.mp4 |
18.29MB |
04_05-Working with relative, absolute, and mixed references.mp4 |
15.28MB |
04_06-Using SUM and AVERAGE.mp4 |
13.23MB |
04_07-Using other common functions.mp4 |
23.16MB |
05_01-Exploring font styles and effects.mp4 |
10.04MB |
05_02-Adjusting row heights and column widths.mp4 |
16.36MB |
05_03-Working with alignment and Wrap Text.mp4 |
18.62MB |
05_04-Designing borders.mp4 |
8.47MB |
05_05-Exploring numeric and special formatting.mp4 |
24.90MB |
05_06-Formatting numbers and dates.mp4 |
21.29MB |
05_07-Using conditional formatting.mp4 |
28.15MB |
05_08-Creating and using tables.mp4 |
40.29MB |
05_09-Inserting shapes, arrows, and other visual features.mp4 |
29.72MB |
06_01-Inserting and deleting rows and columns.mp4 |
25.22MB |
06_02-Hiding and unhiding rows and columns.mp4 |
18.57MB |
06_03-Moving, copying, and inserting data.mp4 |
18.22MB |
06_04-Finding and replacing data.mp4 |
19.07MB |
07_01-Exploring the Page Layout tab and Page Layout view.mp4 |
28.79MB |
07_02-Previewing page breaks.mp4 |
24.58MB |
07_03-Working with Page Setup and printing controls.mp4 |
28.27MB |
08_01-Creating charts.mp4 |
18.42MB |
08_02-Exploring chart types.mp4 |
25.82MB |
08_03-Formatting charts.mp4 |
20.64MB |
08_04-Working with axes, titles, and other chart elements.mp4 |
17.52MB |
08_05-Creating incell charts with sparklines.mp4 |
19.63MB |
09_01-Freezing and unfreezing panes.mp4 |
26.23MB |
09_02-Splitting screens horizontally and vertically.mp4 |
25.41MB |
09_03-Collapsing and expanding data views with outlining.mp4 |
21.72MB |
10_01-Displaying multiple worksheets and workbooks.mp4 |
31.70MB |
10_02-Renaming, inserting, and deleting sheets.mp4 |
11.27MB |
10_03-Moving, copying, and grouping sheets.mp4 |
15.61MB |
10_04-Using formulas to link worksheets and workbooks.mp4 |
20.55MB |
10_05-Locating and maintaining links.mp4 |
18.62MB |
11_01-Using IF functions and relational operators.mp4 |
13.43MB |
11_02-Getting approximate table data with the VLOOKUP function.mp4 |
17.82MB |
11_03-Getting exact table data with the VLOOKUP function.mp4 |
25.07MB |
11_04-Using the COUNTIF family of functions.mp4 |
15.47MB |
12_01-Unlocking cells and protecting worksheets.mp4 |
24.21MB |
12_02-Protecting workbooks.mp4 |
16.82MB |
12_03-Assigning passwords to workbooks.mp4 |
7.73MB |
12_04-Sharing workbooks.mp4 |
12.37MB |
12_05-Tracking changes.mp4 |
15.75MB |
13_01-Sorting data.mp4 |
38.79MB |
13_02-Inserting subtotals in a sorted list.mp4 |
42.80MB |
13_03-Using filters.mp4 |
23.89MB |
13_04-Splitting data into multiple columns.mp4 |
25.80MB |
13_05-Splitting and combining columnar data with Flash Fill.mp4 |
21.32MB |
13_06-Removing duplicate records.mp4 |
9.18MB |
13_07-Using validation tools.mp4 |
26.74MB |
14_01-Using Goal Seek.mp4 |
18.94MB |
14_02-Using Solver.mp4 |
18.87MB |
14_03-Using Scenario Manager.mp4 |
22.30MB |
14_04-Using data tables.mp4 |
16.98MB |
15_01-Creating PivotTables.mp4 |
36.63MB |
15_02-Manipulating PivotTable data.mp4 |
29.29MB |
15_03-Grouping by date and time.mp4 |
36.40MB |
15_04-Grouping by other factors.mp4 |
12.46MB |
15_05-Using slicers to clarify and manipulate fields.mp4 |
19.37MB |
15_06-Using PivotCharts.mp4 |
13.10MB |
16_01-Exploring the need for macros.mp4 |
19.37MB |
16_02-Creating a simple macro.mp4 |
32.69MB |
16_03-Running a macro.mp4 |
34.42MB |
17_01-Goodbye.mp4 |
2.00MB |