Lynda com Excel 2010 Power Shortcuts | 112CAC84DBF1E51A12FEF0D275F534A07BAFA32E

Lynda com Excel 2010 Power Shortcuts

Name	Lynda.com - Excel 2010 Power Shortcuts	DOWNLOAD Copy Link
Total Size	357.8 MB
Total Files	77
Hash	112CAC84DBF1E51A12FEF0D275F534A07BAFA32E

/00 Introduction/
0001 Welcome.mov	19.4 MB
0002 Using the exercise files.mov	347.9 KB
/12 Charting and Visual Object Tips/
1204 Linking and unlinking pictures.mov	13.5 MB
1203 Creating and manipulating shapes.mov	6.4 MB
1201 Placing and adjusting charts.mov	3.3 MB
1202 Creating chart titles from cell content.mov	2.8 MB
/03 Display Shortcuts/
0301 Split screens and frozen titles in a flash.mov	13.3 MB
0302 Repeating title creation and suppression.mov	10.3 MB
0303 Customizing your display of Status Bar totals.mov	2.8 MB
/06 Data Entry and Editing Shortcuts/
0604 Custom lists for rapid entry.mov	12.2 MB
0601 Accelerating data entry.mov	7.8 MB
0602 Auto-Fill techniques for entering dates.mov	6.4 MB
0605 Cell editing tips.mov	3.5 MB
0603 Auto-Fill techniques for entering times.mov	3.1 MB
/09 Operational Shortcuts/
0901 Controlling rows and columns.mov	11.6 MB
0903 Handling blank cells.mov	7.8 MB
0904 Collapsing and expanding detail.mov	6.0 MB
0902 Realigning imported text.mov	2.9 MB
/10 Formatting Shortcuts/
1001 Formatting numbers.mov	10.8 MB
1005 Creating custom formats.mov	9.4 MB
1003 Adding background color for readability.mov	8.7 MB
1002 Aligning data.mov	5.3 MB
1007 Applying strikethroughs and borders.mov	4.5 MB
1006 Formatting periods over 24 hours.mov	3.9 MB
1004 Formatting data conditionally.mov	3.0 MB
/11 Database Techniques/
1102 Cleaning up spaces.mov	9.4 MB
1103 Identifying duplicates.mov	6.6 MB
1104 Splitting columns.mov	5.3 MB
1106 Forcing dates to be weekdays only.mov	4.5 MB
1101 Sorting shortcuts.mov	3.8 MB
1105 Ensuring unique entries.mov	3.1 MB
1107 Displaying unique items from large lists.mov	2.0 MB
/04 Navigation Shortcuts/
0403 Navigating within worksheets.mov	8.2 MB
0402 Tips for navigating between workbooks.mov	6.9 MB
0401 Navigation shortcuts.mov	3.9 MB
/02 Ribbon and Quick Access Toolbar Tips/
0203 Quick Access toolbar display tips.mov	7.6 MB
0201 Expanding and collapsing the Ribbon and Full Screen view.mov	2.9 MB
0202 Keyboard command access.mov	2.9 MB
/05 Selection Shortcuts/
0502 Selecting noncontiguous ranges and visible cells only.mov	7.1 MB
0503 Selecting the current region and moving around region corne	6.9 MB
0501 Selecting an entire row column or worksheet.mov	5.6 MB
/08 Formula Shortcuts/
0802 Selecting all cells that depend on the active cell.mov	7.0 MB
0805 Rounding shortcuts.mov	5.8 MB
0801 Rapid formula creation.mov	4.8 MB
0807 Counting unique entries.mov	4.6 MB
0806 Generating random numbers.mov	4.1 MB
0808 Performing calculations without formulas.mov	3.9 MB
0803 Selecting all cells that can affect the active cell.mov	3.6 MB
0804 AutoSum shortcuts.mov	3.4 MB
/01 Top Ten Shortcuts/
0110 Zooming in and out quickly.mov	6.6 MB
0105 Instantly displaying all worksheet formulas.mov	5.2 MB
0109 Undo Redo Repeat.mov	5.1 MB
0103 Copying data or formulas down a column instantly.mov	4.0 MB
0102 Converting formulas to values with a simple drag.mov	3.6 MB
0104 Adjusting all or selected column widths or row heights in a	3.4 MB
0101 Entering data or formulas in non-adjacent cells simultaneou	2.8 MB
0107 Print Preview.mov	1.8 MB
0106 Two quick shortcuts for creating charts.mov	1.5 MB
0108 Instant date or time entry.mov	1.4 MB
/07 Drag-and-Drop Techniques/
0703 Dragging and inserting variations.mov	5.0 MB
0704 Instantly displaying Paste Special options.mov	4.5 MB
0701 Copy Move acceleration tips.mov	4.4 MB
0702 Worksheet Copy Move shortcuts.mov	3.4 MB
/Exercise Files/
Chapter04.xlsx	611.4 KB
Chapter11.xlsx	289.8 KB
Chapter10.xlsx	232.9 KB
Chapter01.xlsx	161.9 KB
Chapter06.xlsx	121.0 KB
Chapter07.xlsx	119.6 KB
Chapter09.xlsx	118.6 KB
Chapter03.xlsx	117.5 KB
Chapter12.xlsx	115.5 KB
Chapter08.xlsx	109.1 KB
Chapter02.xlsx	108.5 KB
Chapter05.xlsx	107.8 KB
Chapter04A.xlsx	27.4 KB
/13 Conclusion/
1301 Goodbye.mov	135.0 KB
Total files 77