Lynda - Excel Tips (Updated Apr, 2016)
File List
- Two-way lookup using the MATCH and INDEX functions.mp4 51.1 MB
- Working with formulas in tables.mp4 48.1 MB
- Meeting unusual filtering needs via Advanced Filter.mp4 47.9 MB
- Discovering time-saving tools in the Go To Special feature.mp4 40.2 MB
- Using wildcards (asterisk, tilde, and question mark).mp4 38.2 MB
- Using check boxes and Conditional Formatting together for dynamic displays.mp4 37.4 MB
- Custom formats using asterisk, semicolon, and brackets.mp4 35.7 MB
- Using Excel's error-checking functions.mp4 33.8 MB
- Building a flexible monthly table using functions.mp4 32.8 MB
- Auditing.mp4 31.1 MB
- Calculating with hours, minutes, and times of day.mp4 29.7 MB
- Summarizing data from diverse ranges with Data _ Consolidate.mp4 29.7 MB
- Creating Variable Conditional Formatting Rules.mp4 29.2 MB
- Locating Data Validation rules and violations.mp4 28.5 MB
- Resizing, moving, copying, and manipulating charts and other objects.mp4 27.9 MB
- Transposing data and charts for a different perspective on your data.mp4 27.7 MB
- ADDRESS, ROW, and COLUMN functions.mp4 27.7 MB
- Restoring missing column titles.mp4 26.4 MB
- Adding illustrations to your workbook.mp4 25.9 MB
- Adding comments and shapes.mp4 25.8 MB
- Exploring what-if scenarios using Goal Seek.mp4 25.3 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.3 MB
- Becoming more productive with these 10 tiny tips you'll use often.mp4 24.1 MB
- Custom formats, relative addressing, and conditional formatting.mp4 24.1 MB
- Using scroll bars and spin buttons to facilitate forms creation.mp4 23.5 MB
- Creating an Excel template.mp4 23.2 MB
- Creating colorful 3D buttons for worksheet annotation and macro buttons.mp4 22.1 MB
- Tracking down cell dependencies across multiple worksheets and workbooks.mp4 22.0 MB
- The top five unknown but useful keyboard shortcuts.mp4 21.9 MB
- Using list boxes and combo boxes to facilitate forms creation.mp4 21.6 MB
- Drawing borders and border grids.mp4 21.5 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.2 MB
- Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells.mp4 21.0 MB
- Create an Organization Chart.mp4 20.7 MB
- Using source data from a table to make your PivotTable more dynamic.mp4 20.6 MB
- Applying conditional formatting across rows of data.mp4 20.5 MB
- Handling Dates with unusual formats.mp4 20.4 MB
- Adding pictures as worksheet backgrounds.mp4 20.0 MB
- Using the TREND and GROWTH functions for projecting future results.mp4 19.9 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.4 MB
- Reducing data entry time by expanding AutoCorrect options.mp4 18.9 MB
- Accelerating Cut, Copy, Paste, and Insert tasks.mp4 18.9 MB
- Quick formatting tips.mp4 18.6 MB
- Using date and time as metrics in a PivotTable.mp4 18.3 MB
- Creating text, numerical, date, and time lists in a flash.mp4 17.9 MB
- Join data with new CONCAT and TEXTJOIN functions.mp4 17.6 MB
- Increasing your productivity with custom lists.mp4 17.2 MB
- Using Pick list, VLOOKUP, Table, and Chart together.mp4 17.1 MB
- Enhancing table filtering with slicers.mp4 16.8 MB
- Customizing templates to fit your unique needs.mp4 16.4 MB
- Splitting and consolidating workbooks.mp4 16.2 MB
- Dynamically presenting data via chart slicers.mp4 15.7 MB
- Highlighting PivotTable results with conditional formatting.mp4 15.3 MB
- Using the FORMULATEXT and N functions for worksheet and formula documentation.mp4 13.9 MB
- Converting charts into pictures.mp4 13.2 MB
- Parsing your data to create unique lists.mp4 12.5 MB
- Exploring various layouts for your PivotTable.mp4 11.0 MB
- Custom grouping in PivotTables.mp4 10.1 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
Download Torrent
Related Resources
Copyright Infringement
If the content above is not authorized, please contact us via activebusinesscommunication[AT]gmail.com. Remember to include the full url in your complaint.