Обратите внимание, что наш сайт не размещает какие-либо файлы из списка. Вы не можете скачать
эти файлы или скачать torrent-файл.
|
01_01-Welcome.mp4 |
4.90Мб |
01_02-Using the exercise files.mp4 |
945.96Кб |
02_01-Enter data or formulas in nonadjacent cells simultaneously.mp4 |
8.34Мб |
02_02-Copy data or formulas down a column instantly.mp4 |
8.41Мб |
02_03-Instantly enter todays date or time.mp4 |
8.42Мб |
02_04-Convert formulas to values with a simple drag.mp4 |
15.04Мб |
02_05-Adjust all or selected column widths or row heights in a flash.mp4 |
18.46Мб |
02_06-Display all worksheet formulas instantly.mp4 |
10.98Мб |
02_07-Create charts instantly with either of these keystroke shortcuts.mp4 |
7.68Мб |
02_08-Display Print Preview instantly.mp4 |
10.39Мб |
02_09-Undo, redo, and repeat with keystrokes.mp4 |
10.58Мб |
02_10-Zoom in and out quickly.mp4 |
19.15Мб |
03_01-Expandcollapse ribbon and fullscreen views.mp4 |
10.81Мб |
03_02-Access ribbon commands with Alt key sequences.mp4 |
10.80Мб |
03_03-Adjust the Quick Access Toolbar.mp4 |
21.56Мб |
04_01-Create split screens and frozen titles in a flash.mp4 |
41.99Мб |
04_02-Restore missing labels and hide repeating labels.mp4 |
30.40Мб |
04_03-Customize the display of status bar totals.mp4 |
18.67Мб |
05_01-Navigate between workbooks efficiently.mp4 |
10.52Мб |
05_02-Navigate between worksheets efficiently.mp4 |
16.58Мб |
05_03-Navigate within worksheets.mp4 |
32.80Мб |
05_04-Open, close, save, and create new workbooks with keystrokes.mp4 |
17.76Мб |
06_01-Select entire row, column, region, or worksheet.mp4 |
29.14Мб |
06_02-Select noncontiguous ranges and visible cells only.mp4 |
31.78Мб |
07_01-Accelerate data entry.mp4 |
23.38Мб |
07_02-Enter dates and date series efficiently.mp4 |
23.78Мб |
07_03-Enter times and time series efficiently.mp4 |
8.78Мб |
07_04-Use custom lists for rapid data entry and listbased sorting.mp4 |
36.40Мб |
07_05-Enhance editing tools.mp4 |
12.42Мб |
08_01-Accelerate copy and move tasks.mp4 |
16.58Мб |
08_02-Accelerate worksheet copying and moving.mp4 |
11.84Мб |
08_03-Drag and insert cells with the Shift key.mp4 |
9.68Мб |
08_04-Display Paste Special options instantly.mp4 |
20.29Мб |
08_05-Accelerate CopyMovePaste actions with the right mouse button.mp4 |
23.00Мб |
09_01-Create formulas rapidly.mp4 |
19.66Мб |
09_02-Select all cells that depend on the active cell.mp4 |
19.14Мб |
09_03-Select all cells that can affect the active cell.mp4 |
15.22Мб |
09_04-Use AutoSum shortcuts.mp4 |
9.95Мб |
09_05-Use rounding shortcuts.mp4 |
13.96Мб |
09_06-Generate random numbers.mp4 |
17.13Мб |
09_07-Count the number of unique entries.mp4 |
18.27Мб |
09_08-Perform calculations without formulas.mp4 |
8.77Мб |
10_01-Insert, delete, hide, and unhide columns and rows rapidly.mp4 |
23.59Мб |
10_02-Realign imported text.mp4 |
15.99Мб |
10_03-Select and manipulate blank cells.mp4 |
23.30Мб |
10_04-Collapse and expand detail quickly with outlining shortcuts.mp4 |
40.67Мб |
10_05-Create doublespaced or triplespaced printouts quickly.mp4 |
10.14Мб |
11_01-Use keystroke shortcuts for frequently needed numeric formats.mp4 |
16.10Мб |
11_02-Accentuate data with alignment tools.mp4 |
20.23Мб |
11_03-Add a color background to every 5th row in a range.mp4 |
25.04Мб |
11_04-Use conditional formatting based on comparison criteria.mp4 |
19.83Мб |
11_05-Use conditional formatting to highlight formula cells only.mp4 |
8.54Мб |
11_06-Create custom formats Dot leaders and more.mp4 |
20.58Мб |
11_07-Use special formats for times over 24 hours.mp4 |
16.09Мб |
11_08-Addremove strikethrough and borders with keystroke shortcuts.mp4 |
12.53Мб |
11_09-Quickly format phone and SS numbers.mp4 |
11.85Мб |
12_01-Sort data with single buttons.mp4 |
18.36Мб |
12_02-Clean up spaces quickly with the TRIM function.mp4 |
17.53Мб |
12_03-Identify and eliminate duplicates.mp4 |
25.87Мб |
12_04-Split column data using Text to Columns and Flash Fill.mp4 |
16.11Мб |
12_05-Join data with the TEXTJOIN function and Flash Fill.mp4 |
13.70Мб |
12_06-Ensure unique entries with data validation rules.mp4 |
12.26Мб |
12_07-Force typed dates to be weekdays only with data validation rules.mp4 |
11.41Мб |
12_08-Display unique items from large lists.mp4 |
24.37Мб |
13_01-Manipulate chart placement with dragging techniques.mp4 |
10.22Мб |
13_02-Create chart titles from cell content.mp4 |
7.64Мб |
13_03-Create and manipulate shapes with the Shift, Ctrl, and Alt keys.mp4 |
18.01Мб |
13_04-Create linked dynamic and linked static images.mp4 |
27.97Мб |
14_01-Become a more proficient Excel user with these short tips.mp4 |
22.90Мб |
15_01-Goodbye.mp4 |
2.03Мб |
Ex_Files_Excel_2016_Tips.zip |
2.14Мб |