TorBT - Torrents and Magnet Links Search Engine
Lynda - Excel Tips (Updated Apr, 2016)
- Date: 2026-09-13
- Size: 1.4 GB
- Files: 63
File Name
Size
Two-way lookup using the MATCH and INDEX functions.mp4
51 MB
Working with formulas in tables.mp4
48 MB
Meeting unusual filtering needs via Advanced Filter.mp4
48 MB
Discovering time-saving tools in the Go To Special feature.mp4
40 MB
Using wildcards (asterisk, tilde, and question mark).mp4
38 MB
Using check boxes and Conditional Formatting together for dynamic displays.mp4
37 MB
Custom formats using asterisk, semicolon, and brackets.mp4
36 MB
Using Excel's error-checking functions.mp4
34 MB
Building a flexible monthly table using functions.mp4
33 MB
Auditing.mp4
31 MB
Calculating with hours, minutes, and times of day.mp4
30 MB
Summarizing data from diverse ranges with Data _ Consolidate.mp4
30 MB
Creating Variable Conditional Formatting Rules.mp4
29 MB
Locating Data Validation rules and violations.mp4
28 MB
Resizing, moving, copying, and manipulating charts and other objects.mp4
28 MB
Transposing data and charts for a different perspective on your data.mp4
28 MB
ADDRESS, ROW, and COLUMN functions.mp4
28 MB
Restoring missing column titles.mp4
26 MB
Adding illustrations to your workbook.mp4
26 MB
Adding comments and shapes.mp4
26 MB
Exploring what-if scenarios using Goal Seek.mp4
25 MB
Setting up custom views for quick access to different worksheet displays.mp4
25 MB
Controlling worksheet security by allowing selected users to edit specific cell ranges.mp4
24 MB
Becoming more productive with these 10 tiny tips you'll use often.mp4
24 MB
Custom formats, relative addressing, and conditional formatting.mp4
24 MB
Using scroll bars and spin buttons to facilitate forms creation.mp4
24 MB
Creating an Excel template.mp4
23 MB
Creating colorful 3D buttons for worksheet annotation and macro buttons.mp4
22 MB
Tracking down cell dependencies across multiple worksheets and workbooks.mp4
22 MB
The top five unknown but useful keyboard shortcuts.mp4
22 MB
Using list boxes and combo boxes to facilitate forms creation.mp4
22 MB
Drawing borders and border grids.mp4
22 MB
Using formulas to calculate values across worksheets and workbooks.mp4
21 MB
Using hyperlinks for rapidly switching worksheet locations and jumping to websites.mp4
21 MB
Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells.mp4
21 MB
Create an Organization Chart.mp4
21 MB
Using source data from a table to make your PivotTable more dynamic.mp4
21 MB
Applying conditional formatting across rows of data.mp4
20 MB
Handling Dates with unusual formats.mp4
20 MB
Adding pictures as worksheet backgrounds.mp4
20 MB
Using the TREND and GROWTH functions for projecting future results.mp4
20 MB
Using option buttons, group boxes, and checkboxes to facilitate forms creation.mp4
20 MB
Adding, managing, and printing comments for worksheet documentation.mp4
19 MB
Reducing data entry time by expanding AutoCorrect options.mp4
19 MB
Accelerating Cut, Copy, Paste, and Insert tasks.mp4
19 MB
Quick formatting tips.mp4
19 MB
Using date and time as metrics in a PivotTable.mp4
18 MB
Creating text, numerical, date, and time lists in a flash.mp4
18 MB
Join data with new CONCAT and TEXTJOIN functions.mp4
18 MB
Increasing your productivity with custom lists.mp4
17 MB
Using Pick list, VLOOKUP, Table, and Chart together.mp4
17 MB
Enhancing table filtering with slicers.mp4
17 MB
Customizing templates to fit your unique needs.mp4
16 MB
Splitting and consolidating workbooks.mp4
16 MB
Dynamically presenting data via chart slicers.mp4
16 MB
Highlighting PivotTable results with conditional formatting.mp4
15 MB
Using the FORMULATEXT and N functions for worksheet and formula documentation.mp4
14 MB
Converting charts into pictures.mp4
13 MB
Parsing your data to create unique lists.mp4
12 MB
Exploring various layouts for your PivotTable.mp4
11 MB
Custom grouping in PivotTables.mp4
10 MB
Creating dynamic charts with in-cell conditional formatting.mp4
9.2 MB
Using the REPT function to represent data visually.mp4
6.8 MB