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