Lynda Excel 2013 Tips and Tricks

/

Create split screens and frozen titles in a flash-182283.mp4

Create linked dynamic and static images-182343.mp4

Select noncontiguous ranges and visible cells only-182292.mp4

Select the current region of cells and move around region corners-182293.mp4

Use Custom Lists for rapid data entry and list-based sorting-182298.mp4

Navigate within worksheets-182289.mp4

Restore missing labels and hide repeating labels-182284.mp4

Insert, delete, hide, and unhide columns and rows rapidly-182316.mp4

Add a color background to every fifth row in a range-182324.mp4

Select an entire row, column, or worksheet-182291.mp4

Become more proficient with these short tips-182345.mp4

Clean up spaces quickly-182332.mp4

Collapse and expand detail quickly with outlining shortcuts-182319.mp4

Accelerate data entry-182295.mp4

Enter dates and date series efficiently-182296.mp4

Use keystroke shortcuts for frequently needed numeric formats-182322.mp4

Select and manipulate blank cells-182318.mp4

Create custom formats - Dot leaders and more-182327.mp4

Add and remove a strikethrough or a border with keystroke shortcuts-182329.mp4

Count the number of unique entries-182313.mp4

Create formulas rapidly-182307.mp4

Accelerate Copy, Move, and Paste actions with the right mouse button-182305.mp4

Select all cells that can affect the active cell-182309.mp4

Split column data into multiple columns with Flash Fill-182334.mp4

Accentuate date with alignment tools-182323.mp4

Navigate between worksheets efficiently-182288.mp4

Generate random numbers-182312.mp4

Accelerate worksheet copying and moving-182302.mp4

Identify and eliminate duplicates-182333.mp4

Accelerate copy-and-move tasks-182301.mp4

Create and manipulate shapes and use Shift and Ctrl keys-182342.mp4

Display Paste Special options instantly-182304.mp4

Sort data with single buttons-182331.mp4

Select all cells that depend on the active cell-182308.mp4

Undo, Redo, and Repeat with keystrokes-182276.mp4

Use rounding shortcuts-182311.mp4

Display unique items from large lists-182338.mp4

Adjust the Quick Access Toolbar-182281.mp4

Customize the display of Status bar totals-182285.mp4

Use special formats for times over 24 hours-182328.mp4

Access Ribbon commands with Alt key sequences-182280.mp4

Perform calculations without formulas-182314.mp4

Realign imported text-182317.mp4

Enhanced editing tools-182299.mp4

Convert formulas to values with a simple drag-182269.mp4

Navigate between workbooks efficiently-182287.mp4

Adjust all or selected column widths or row heights in a flash-182271.mp4

Manipulate chart placement with dragging techniques-182340.mp4

Expand and collapse the Ribbon and full-screen views-182279.mp4

Use Conditional Formatting to highlight formula cells only-182326.mp4

Create double-spaced or triple-spaced printouts quickly-182320.mp4

Use Conditional Formatting based on comparison criteria-182325.mp4

Use AutoSum shortcuts-182310.mp4

Force typed dates to be only weekdays with data validation rules-182337.mp4

Zoom in and out quickly-182277.mp4

Ensure unique entries with data validation rules-182336.mp4

Welcome-182265.mp4

Enter times and time series efficiently-182297.mp4

Drag and insert with the Shift key-182303.mp4

Join data from multiple columns into one column with Flash Fill-182335.mp4

Instantly display all worksheet formulas-182272.mp4

Enter data or formulas in non-adjacent cells simultaneously-182268.mp4

Copy data or formulas down a column instantly-182270.mp4

Display a print preview instantly-182274.mp4

Create chart titles from cell content-182341.mp4

Create charts instantly with either of these keystroke shortcuts-182273.mp4

Instantly enter today's date or time-182275.mp4

Next steps-182347.mp4

Using the exercise files-182266.mp4

/Exercise Files/

Ch_04.xlsx

Ch_01.xlsx

Ch_11.xlsx

Ch_10.xlsx

Ch_03.xlsx

Ch_05.xlsx

Ch_12.xlsx

Ch_06.xlsx

Ch_07.xlsx

Ch_09.xlsx

Ch_08.xlsx

Ch_02.xlsx

Ch_04A.xlsx

Ch_13.xlsx

Total files 83