Lynda - Excel Tips (Updated Jan 06, 2016)
- 收录时间:2018-05-08 15:57:39
- 文件大小:1GB
- 下载次数:16
- 最近下载:2020-06-26 23:15:27
- 磁力链接:
-
文件列表
- Two-way lookup using the MATCH and INDEX functions-460711.mp4 51MB
- Meeting unusual filtering needs via Advanced Filter-447341.mp4 48MB
- Discovering time-saving tools in the Go To Special feature-430657.mp4 40MB
- Using wildcards (asterisk, tilde, and question mark)-447339.mp4 38MB
- Using check boxes and Conditional Formatting together for dynamic displays-414067.mp4 37MB
- Custom formats using asterisk, semicolon, and brackets-447340.mp4 36MB
- Calculating with hours, minutes, and times of day-429254.mp4 30MB
- Summarizing data from diverse ranges with Data _ Consolidate-415624.mp4 30MB
- Creating Variable Conditional Formatting Rules-447337.mp4 29MB
- Resizing, moving, copying, and manipulating charts and other objects-422773.mp4 28MB
- Transposing data and charts for a different perspective on your data-410210.mp4 28MB
- Adding illustrations to your workbook-386195.mp4 26MB
- Exploring what-if scenarios using Goal Seek-445784.mp4 25MB
- Setting up custom views for quick access to different worksheet displays-430660.mp4 25MB
- Controlling worksheet security by allowing selected users to edit specific cell ranges-430662.mp4 24MB
- Becoming more productive with these 10 tiny tips you'll use often-411964.mp4 24MB
- Using scroll bars and spin buttons to facilitate forms creation-425940.mp4 24MB
- Creating colorful 3D buttons for worksheet annotation and macro buttons-427854.mp4 22MB
- Tracking down cell dependencies across multiple worksheets and workbooks-430656.mp4 22MB
- The top five unknown but useful keyboard shortcuts-368816.mp4 22MB
- Using list boxes and combo boxes to facilitate forms creation-420933.mp4 22MB
- Using formulas to calculate values across worksheets and workbooks-384434.mp4 21MB
- Using hyperlinks for rapidly switching worksheet locations and jumping to websites-430661.mp4 21MB
- Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells-416917.mp4 21MB
- Create an Organization Chart-447342.mp4 21MB
- Using source data from a table to make your PivotTable more dynamic-379954.mp4 21MB
- Applying conditional formatting across rows of data-408645.mp4 21MB
- Handling Dates with unusual formats-447338.mp4 20MB
- Using the TREND and GROWTH functions for projecting future results-424601.mp4 20MB
- Using option buttons, group boxes, and checkboxes to facilitate forms creation-430663.mp4 20MB
- Adding, managing, and printing comments for worksheet documentation-430658.mp4 19MB
- Reducing data entry time by expanding AutoCorrect options-430659.mp4 19MB
- Accelerating Cut, Copy, Paste, and Insert tasks-378860.mp4 19MB
- Quick formatting tips-369627.mp4 19MB
- Using date and time as metrics in a PivotTable-387157.mp4 18MB
- Creating text, numerical, date, and time lists in a flash-447336.mp4 18MB
- Increasing your productivity with custom lists-377482.mp4 17MB
- Using Pick list, VLOOKUP, Table, and Chart together-385365.mp4 17MB
- Enhancing table filtering with slicers-372453.mp4 17MB
- Customizing templates to fit your unique needs-374002.mp4 16MB
- Splitting and consolidating workbooks-388137.mp4 16MB
- Dynamically presenting data via chart slicers-383664.mp4 16MB
- Highlighting PivotTable results with conditional formatting-375504.mp4 15MB
- Using the FORMULATEXT and N functions for worksheet and formula documentation-419138.mp4 14MB
- Converting charts into pictures-371409.mp4 13MB
- Parsing your data to create unique lists-383074.mp4 13MB
- Exploring various layouts for your PivotTable-397767.mp4 11MB
- Custom grouping in PivotTables-370424.mp4 10MB
- Creating dynamic charts with in-cell conditional formatting-373128.mp4 9MB
- Using the REPT function to represent data visually-380984.mp4 7MB
