Lynda.com - Excel 2010 Power Shortcuts [2010, ENG]

seeders: 2 leechers: 0
Added 15 years ago by Arthur777 in Other
Downloaded 0 time.
RuTracker.org
Lynda.com - Excel 2010 Power Shortcuts [2010, ENG]

Torrent Contents Size: 341.2 MB

Lynda.com - Excel 2010 Power Shortcuts [2010, ENG]
00 Introduction
0001 Welcome.mov
MOV
18.46 MB
0002 Using the exercise files.mov
MOV
339.74 KB
01 Top Ten Shortcuts
0101 Entering data or formulas in non-adjacent cells simultaneou.mov
MOV
2.69 MB
0102 Converting formulas to values with a simple drag.mov
MOV
3.46 MB
0103 Copying data or formulas down a column instantly.mov
MOV
3.77 MB
0104 Adjusting all or selected column widths or row heights in a.mov
MOV
3.27 MB
0105 Instantly displaying all worksheet formulas.mov
MOV
4.98 MB
0106 Two quick shortcuts for creating charts.mov
MOV
1.46 MB
0107 Print Preview.mov
MOV
1.67 MB
0108 Instant date or time entry.mov
MOV
1.36 MB
0109 Undo Redo Repeat.mov
MOV
4.85 MB
0110 Zooming in and out quickly.mov
MOV
6.27 MB
02 Ribbon and Quick Access Toolbar Tips
0201 Expanding and collapsing the Ribbon and Full Screen view.mov
MOV
2.8 MB
0202 Keyboard command access.mov
MOV
2.72 MB
0203 Quick Access toolbar display tips.mov
MOV
7.2 MB
03 Display Shortcuts
0301 Split screens and frozen titles in a flash.mov
MOV
12.71 MB
0302 Repeating title creation and suppression.mov
MOV
9.78 MB
0303 Customizing your display of Status Bar totals.mov
MOV
2.71 MB
04 Navigation Shortcuts
0401 Navigation shortcuts.mov
MOV
3.68 MB
0402 Tips for navigating between workbooks.mov
MOV
6.53 MB
0403 Navigating within worksheets.mov
MOV
7.82 MB
05 Selection Shortcuts
0501 Selecting an entire row column or worksheet.mov
MOV
5.33 MB
0502 Selecting noncontiguous ranges and visible cells only.mov
MOV
6.78 MB
0503 Selecting the current region and moving around region corne.mov
MOV
6.57 MB
06 Data Entry and Editing Shortcuts
0601 Accelerating data entry.mov
MOV
7.48 MB
0602 Auto-Fill techniques for entering dates.mov
MOV
6.13 MB
0603 Auto-Fill techniques for entering times.mov
MOV
2.97 MB
0604 Custom lists for rapid entry.mov
MOV
11.6 MB
0605 Cell editing tips.mov
MOV
3.31 MB
07 Drag-and-Drop Techniques
0701 Copy Move acceleration tips.mov
MOV
4.2 MB
0702 Worksheet Copy Move shortcuts.mov
MOV
3.29 MB
0703 Dragging and inserting variations.mov
MOV
4.72 MB
0704 Instantly displaying Paste Special options.mov
MOV
4.25 MB
08 Formula Shortcuts
0801 Rapid formula creation.mov
MOV
4.57 MB
0802 Selecting all cells that depend on the active cell.mov
MOV
6.64 MB
0803 Selecting all cells that can affect the active cell.mov
MOV
3.41 MB
0804 AutoSum shortcuts.mov
MOV
3.2 MB
0805 Rounding shortcuts.mov
MOV
5.53 MB
0806 Generating random numbers.mov
MOV
3.88 MB
0807 Counting unique entries.mov
MOV
4.35 MB
0808 Performing calculations without formulas.mov
MOV
3.75 MB
09 Operational Shortcuts
0901 Controlling rows and columns.mov
MOV
11.04 MB
0902 Realigning imported text.mov
MOV
2.72 MB
0903 Handling blank cells.mov
MOV
7.46 MB
0904 Collapsing and expanding detail.mov
MOV
5.75 MB
10 Formatting Shortcuts
1001 Formatting numbers.mov
MOV
10.27 MB
1002 Aligning data.mov
MOV
5.08 MB
1003 Adding background color for readability.mov
MOV
8.27 MB
1004 Formatting data conditionally.mov
MOV
2.83 MB
1005 Creating custom formats.mov
MOV
8.97 MB
1006 Formatting periods over 24 hours.mov
MOV
3.71 MB
1007 Applying strikethroughs and borders.mov
MOV
4.29 MB
11 Database Techniques
1101 Sorting shortcuts.mov
MOV
3.59 MB
1102 Cleaning up spaces.mov
MOV
8.97 MB
1103 Identifying duplicates.mov
MOV
6.31 MB
1104 Splitting columns.mov
MOV
5.02 MB
1105 Ensuring unique entries.mov
MOV
2.99 MB
1106 Forcing dates to be weekdays only.mov
MOV
4.33 MB
1107 Displaying unique items from large lists.mov
MOV
1.95 MB
12 Charting and Visual Object Tips
1201 Placing and adjusting charts.mov
MOV
3.17 MB
1202 Creating chart titles from cell content.mov
MOV
2.67 MB
1203 Creating and manipulating shapes.mov
MOV
6.15 MB
1204 Linking and unlinking pictures.mov
MOV
12.92 MB
13 Conclusion
1301 Goodbye.mov
MOV
131.85 KB
Exercise Files
Chapter01.xlsx
XLSX
158.09 KB
Chapter02.xlsx
XLSX
105.98 KB
Chapter03.xlsx
XLSX
114.79 KB
Chapter04.xlsx
XLSX
597.1 KB
Chapter04A.xlsx
XLSX
26.73 KB
Chapter05.xlsx
XLSX
105.29 KB
Chapter06.xlsx
XLSX
118.13 KB
Chapter07.xlsx
XLSX
116.84 KB
Chapter08.xlsx
XLSX
106.54 KB
Chapter09.xlsx
XLSX
115.82 KB
Chapter10.xlsx
XLSX
227.43 KB
Chapter11.xlsx
XLSX
282.98 KB
Chapter12.xlsx
XLSX
112.78 KB

Description

Related Torrents

Location

Trackers

Tracker name
http://bt4.t-ru.org/ann?magnet
http://bt2.t-ru.org/ann
http://bt3.t-ru.org/ann
http://bt4.t-ru.org/ann
udp://tracker.opentrackr.org:1337
udp://open.stealth.si:80/announce
udp://tracker.torrent.eu.org:451/announce
udp://exodus.desync.com:6969
udp://open.demonii.com:1337/announce
udp://tracker.coppersurfer.tk:6969
udp://p4p.arenabg.com:1337
udp://tracker.internetwarriors.net:1337
Torrent hash: