Lynda.com - Excel 2010 Power Shortcuts

seeders: 0
leechers: 0
Added on February 17, 2015 by VIP-Naruin Other > Tutorials
Torrent verified.



Lynda.com - Excel 2010 Power Shortcuts (Size: 341.2 MB)
 0001 Welcome.mov18.46 MB
 0002 Using the exercise files.mov339.74 KB
 0110 Zooming in and out quickly.mov6.27 MB
 0105 Instantly displaying all worksheet formulas.mov4.98 MB
 0109 Undo Redo Repeat.mov4.85 MB
 0103 Copying data or formulas down a column instantly.mov3.77 MB
 0102 Converting formulas to values with a simple drag.mov3.46 MB
 0104 Adjusting all or selected column widths or row heights in a3.27 MB
 0101 Entering data or formulas in non-adjacent cells simultaneou2.69 MB
 0107 Print Preview.mov1.67 MB
 0106 Two quick shortcuts for creating charts.mov1.46 MB
 0108 Instant date or time entry.mov1.36 MB
 0203 Quick Access toolbar display tips.mov7.2 MB
 0201 Expanding and collapsing the Ribbon and Full Screen view.mov2.8 MB
 0202 Keyboard command access.mov2.72 MB
 0301 Split screens and frozen titles in a flash.mov12.71 MB
 0302 Repeating title creation and suppression.mov9.78 MB
 0303 Customizing your display of Status Bar totals.mov2.71 MB
 0403 Navigating within worksheets.mov7.82 MB
 0402 Tips for navigating between workbooks.mov6.53 MB
 0401 Navigation shortcuts.mov3.68 MB
 0502 Selecting noncontiguous ranges and visible cells only.mov6.78 MB
 0503 Selecting the current region and moving around region corne6.57 MB
 0501 Selecting an entire row column or worksheet.mov5.33 MB
 0604 Custom lists for rapid entry.mov11.6 MB
 0601 Accelerating data entry.mov7.48 MB
 0602 Auto-Fill techniques for entering dates.mov6.13 MB
 0605 Cell editing tips.mov3.31 MB
 0603 Auto-Fill techniques for entering times.mov2.97 MB
 0703 Dragging and inserting variations.mov4.72 MB
 0704 Instantly displaying Paste Special options.mov4.25 MB
 0701 Copy Move acceleration tips.mov4.2 MB
 0702 Worksheet Copy Move shortcuts.mov3.29 MB
 0802 Selecting all cells that depend on the active cell.mov6.64 MB
 0805 Rounding shortcuts.mov5.53 MB
 0801 Rapid formula creation.mov4.57 MB
 0807 Counting unique entries.mov4.35 MB
 0806 Generating random numbers.mov3.88 MB
 0808 Performing calculations without formulas.mov3.75 MB
 0803 Selecting all cells that can affect the active cell.mov3.41 MB
 0804 AutoSum shortcuts.mov3.2 MB
 0901 Controlling rows and columns.mov11.04 MB
 0903 Handling blank cells.mov7.46 MB
 0904 Collapsing and expanding detail.mov5.75 MB
 0902 Realigning imported text.mov2.72 MB
 1001 Formatting numbers.mov10.27 MB
 1005 Creating custom formats.mov8.97 MB
 1003 Adding background color for readability.mov8.27 MB
 1002 Aligning data.mov5.08 MB
 1007 Applying strikethroughs and borders.mov4.29 MB
 1006 Formatting periods over 24 hours.mov3.71 MB
 1004 Formatting data conditionally.mov2.83 MB
 1102 Cleaning up spaces.mov8.97 MB
 1103 Identifying duplicates.mov6.31 MB
 1104 Splitting columns.mov5.02 MB
 1106 Forcing dates to be weekdays only.mov4.33 MB
 1101 Sorting shortcuts.mov3.59 MB
 1105 Ensuring unique entries.mov2.99 MB
 1107 Displaying unique items from large lists.mov1.95 MB
 1204 Linking and unlinking pictures.mov12.92 MB
 1203 Creating and manipulating shapes.mov6.15 MB
 1201 Placing and adjusting charts.mov3.17 MB
 1202 Creating chart titles from cell content.mov2.67 MB
 1301 Goodbye.mov131.85 KB
 Chapter04.xlsx597.1 KB
 Chapter11.xlsx282.98 KB
 Chapter10.xlsx227.43 KB
 Chapter01.xlsx158.09 KB
 Chapter06.xlsx118.13 KB
 Chapter07.xlsx116.84 KB
 Chapter09.xlsx115.82 KB
 Chapter03.xlsx114.79 KB
 Chapter12.xlsx112.78 KB
 Chapter08.xlsx106.54 KB

Description

In Excel 2010 Power Shortcuts, Excel expert Dennis Taylor shares tips and shortcuts to vastly increase efficiency and get the full power out of Excel 2010. There are tips for working with the Ribbon and Quick Access toolbar, navigating workbooks and selecting cells, rapid data entry and editing, working with formulas, formatting data, working with charts, sorting data, and much more. Exercise files accompany the course.
Topics include:

Creating charts with keyboard shortcuts
Converting formulas to values by dragging
Repeating Undo and Redo actions
Displaying formulas instantly
Navigating quickly through worksheets and across workbooks
Formatting numeric, and date/time data in a flash with keystroke shortcuts
Inserting dates or times instantly
Grouping rows or columns to create collapsible regions
Building data-entry shortcuts with Auto-fill
Displaying unique items from large lists

Software:
Excel
Author:
Dennis Taylor

Source Page


Related Torrents

torrent name size seed leech

Sharing Widget


Download torrent
341.2 MB
seeders:0
leechers:0
Lynda.com - Excel 2010 Power Shortcuts