Lynda com Excel 2010 Power Shortcuts | B78169622CB5CF7DD30E011F0A13CD37352E090E

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	B78169622CB5CF7DD30E011F0A13CD37352E090E

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