2016
Lynda
Dennis Taylor
8:06
English

This tips-based course will show Excel users productivity-boosting tricks, cool hidden features, need-to-know functions, and advanced content on subjects such as using PivotTables for data analysis. Tune in every Tuesday for a new tip from expert Dennis Taylor. Each tutorial is a short, self-contained lesson guaranteed to give you new insights into Excel.

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

lynda.com/Excel-tutorials/Excel-Tips/363001-2.html

Download File Size:1.42 GB

---