Lynda Excel Tips Updated Jan 06 2016 | 544E1D1A06A7F042527F2E9A4390521F3DA0024D

Lynda Excel Tips Updated Jan 06 2016

Name	Lynda - Excel Tips (Updated Jan 06, 2016)	DOWNLOAD Copy Link
Total Size	1.2 GB
Total Files	50
Hash	544E1D1A06A7F042527F2E9A4390521F3DA0024D

/
Accelerating Cut, Copy, Paste, and Insert tasks-378860.mp4	19.8 MB
Adding illustrations to your workbook-386195.mp4	27.2 MB
Adding, managing, and printing comments for worksheet documentation-430658.mp4	20.4 MB
Applying conditional formatting across rows of data-408645.mp4	21.5 MB
Becoming more productive with these 10 tiny tips you'll use often-411964.mp4	25.3 MB
Calculating with hours, minutes, and times of day-429254.mp4	31.2 MB
Controlling worksheet security by allowing selected users to edit specific cell ranges-430662.mp4	25.4 MB
Converting charts into pictures-371409.mp4	13.8 MB
Create an Organization Chart-447342.mp4	21.7 MB
Creating colorful 3D buttons for worksheet annotation and macro buttons-427854.mp4	23.2 MB
Creating dynamic charts with in-cell conditional formatting-373128.mp4	9.7 MB
Creating text, numerical, date, and time lists in a flash-447336.mp4	18.8 MB
Creating Variable Conditional Formatting Rules-447337.mp4	30.6 MB
Custom formats using asterisk, semicolon, and brackets-447340.mp4	37.5 MB
Custom grouping in PivotTables-370424.mp4	10.6 MB
Customizing templates to fit your unique needs-374002.mp4	17.2 MB
Discovering time-saving tools in the Go To Special feature-430657.mp4	42.1 MB
Dynamically presenting data via chart slicers-383664.mp4	16.4 MB
Enhancing table filtering with slicers-372453.mp4	17.6 MB
Exploring various layouts for your PivotTable-397767.mp4	11.5 MB
Exploring what-if scenarios using Goal Seek-445784.mp4	26.5 MB
Handling Dates with unusual formats-447338.mp4	21.4 MB
Highlighting PivotTable results with conditional formatting-375504.mp4	16.0 MB
Increasing your productivity with custom lists-377482.mp4	18.0 MB
Meeting unusual filtering needs via Advanced Filter-447341.mp4	50.2 MB
Parsing your data to create unique lists-383074.mp4	13.1 MB
Quick formatting tips-369627.mp4	19.5 MB
Reducing data entry time by expanding AutoCorrect options-430659.mp4	19.8 MB
Resizing, moving, copying, and manipulating charts and other objects-422773.mp4	29.3 MB
Setting up custom views for quick access to different worksheet displays-430660.mp4	26.4 MB
Splitting and consolidating workbooks-388137.mp4	17.0 MB
Summarizing data from diverse ranges with Data _ Consolidate-415624.mp4	31.1 MB
The top five unknown but useful keyboard shortcuts-368816.mp4	22.9 MB
Tracking down cell dependencies across multiple worksheets and workbooks-430656.mp4	23.1 MB
Transposing data and charts for a different perspective on your data-410210.mp4	29.1 MB
Two-way lookup using the MATCH and INDEX functions-460711.mp4	53.5 MB
Using check boxes and Conditional Formatting together for dynamic displays-414067.mp4	39.3 MB
Using date and time as metrics in a PivotTable-387157.mp4	19.2 MB
Using formulas to calculate values across worksheets and workbooks-384434.mp4	22.4 MB
Using hyperlinks for rapidly switching worksheet locations and jumping to websites-430661.mp4	22.3 MB
Using list boxes and combo boxes to facilitate forms creation-420933.mp4	22.6 MB
Using option buttons, group boxes, and checkboxes to facilitate forms creation-430663.mp4	20.9 MB
Using Pick list, VLOOKUP, Table, and Chart together-385365.mp4	17.9 MB
Using scroll bars and spin buttons to facilitate forms creation-425940.mp4	24.7 MB
Using source data from a table to make your PivotTable more dynamic-379954.mp4	21.6 MB
Using the FORMULATEXT and N functions for worksheet and formula documentation-419138.mp4	14.6 MB
Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells-416917.mp4	22.0 MB
Using the REPT function to represent data visually-380984.mp4	7.2 MB
Using the TREND and GROWTH functions for projecting future results-424601.mp4	20.9 MB
Using wildcards (asterisk, tilde, and question mark)-447339.mp4	40.1 MB
Total files 50