Download link
File List
-
Two-way lookup using the MATCH and INDEX functions.mp4 51.06 MB
Working with formulas in tables.mp4 48.15 MB
Meeting unusual filtering needs via Advanced Filter.mp4 47.89 MB
Discovering time-saving tools in the Go To Special feature.mp4 40.18 MB
Using wildcards (asterisk, tilde, and question mark).mp4 38.23 MB
Using check boxes and Conditional Formatting together for dynamic displays.mp4 37.43 MB
Custom formats using asterisk, semicolon, and brackets.mp4 35.72 MB
Using Excel's error-checking functions.mp4 33.85 MB
Building a flexible monthly table using functions.mp4 32.81 MB
Auditing.mp4 31.07 MB
Calculating with hours, minutes, and times of day.mp4 29.73 MB
Summarizing data from diverse ranges with Data _ Consolidate.mp4 29.68 MB
Creating Variable Conditional Formatting Rules.mp4 29.23 MB
Locating Data Validation rules and violations.mp4 28.54 MB
Resizing, moving, copying, and manipulating charts and other objects.mp4 27.95 MB
Transposing data and charts for a different perspective on your data.mp4 27.73 MB
ADDRESS, ROW, and COLUMN functions.mp4 27.67 MB
Restoring missing column titles.mp4 26.37 MB
Adding illustrations to your workbook.mp4 25.94 MB
Adding comments and shapes.mp4 25.75 MB
Exploring what-if scenarios using Goal Seek.mp4 25.26 MB
Setting up custom views for quick access to different worksheet displays.mp4 25.2 MB
Controlling worksheet security by allowing selected users to edit specific cell ranges.mp4 24.26 MB
Becoming more productive with these 10 tiny tips you'll use often.mp4 24.13 MB
Custom formats, relative addressing, and conditional formatting.mp4 24.07 MB
Using scroll bars and spin buttons to facilitate forms creation.mp4 23.54 MB
Creating an Excel template.mp4 23.18 MB
Creating colorful 3D buttons for worksheet annotation and macro buttons.mp4 22.08 MB
Tracking down cell dependencies across multiple worksheets and workbooks.mp4 22.04 MB
The top five unknown but useful keyboard shortcuts.mp4 21.87 MB
Using list boxes and combo boxes to facilitate forms creation.mp4 21.59 MB
Drawing borders and border grids.mp4 21.47 MB
Using formulas to calculate values across worksheets and workbooks.mp4 21.4 MB
Using hyperlinks for rapidly switching worksheet locations and jumping to websites.mp4 21.24 MB
Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells.mp4 20.96 MB
Create an Organization Chart.mp4 20.67 MB
Using source data from a table to make your PivotTable more dynamic.mp4 20.62 MB
Applying conditional formatting across rows of data.mp4 20.52 MB
Handling Dates with unusual formats.mp4 20.37 MB
Adding pictures as worksheet backgrounds.mp4 20.05 MB
Using the TREND and GROWTH functions for projecting future results.mp4 19.94 MB
Using option buttons, group boxes, and checkboxes to facilitate forms creation.mp4 19.9 MB
Adding, managing, and printing comments for worksheet documentation.mp4 19.42 MB
Reducing data entry time by expanding AutoCorrect options.mp4 18.92 MB
Accelerating Cut, Copy, Paste, and Insert tasks.mp4 18.9 MB
Quick formatting tips.mp4 18.57 MB
Using date and time as metrics in a PivotTable.mp4 18.31 MB
Creating text, numerical, date, and time lists in a flash.mp4 17.93 MB
Join data with new CONCAT and TEXTJOIN functions.mp4 17.57 MB
Increasing your productivity with custom lists.mp4 17.21 MB
Using Pick list, VLOOKUP, Table, and Chart together.mp4 17.11 MB
Enhancing table filtering with slicers.mp4 16.78 MB
Customizing templates to fit your unique needs.mp4 16.4 MB
Splitting and consolidating workbooks.mp4 16.17 MB
Dynamically presenting data via chart slicers.mp4 15.67 MB
Highlighting PivotTable results with conditional formatting.mp4 15.29 MB
Using the FORMULATEXT and N functions for worksheet and formula documentation.mp4 13.93 MB
Converting charts into pictures.mp4 13.18 MB
Parsing your data to create unique lists.mp4 12.53 MB
Exploring various layouts for your PivotTable.mp4 11 MB
Custom grouping in PivotTables.mp4 10.12 MB
Creating dynamic charts with in-cell conditional formatting.mp4 9.21 MB
Using the REPT function to represent data visually.mp4 6.82 MB
Download Info
-
Tips
“Lynda - Excel Tips (Updated Apr, 2016)” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.
-
DMCA Notice and Takedown Procedure
If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.