Lynda Excel Tips Updated Apr 2016

/

Two-way lookup using the MATCH and INDEX functions.mp4

Working with formulas in tables.mp4

Meeting unusual filtering needs via Advanced Filter.mp4

Discovering time-saving tools in the Go To Special feature.mp4

Using wildcards (asterisk, tilde, and question mark).mp4

Using check boxes and Conditional Formatting together for dynamic displays.mp4

Custom formats using asterisk, semicolon, and brackets.mp4

Using Excel's error-checking functions.mp4

Building a flexible monthly table using functions.mp4

Auditing.mp4

Calculating with hours, minutes, and times of day.mp4

Summarizing data from diverse ranges with Data _ Consolidate.mp4

Creating Variable Conditional Formatting Rules.mp4

Locating Data Validation rules and violations.mp4

Resizing, moving, copying, and manipulating charts and other objects.mp4

Transposing data and charts for a different perspective on your data.mp4

ADDRESS, ROW, and COLUMN functions.mp4

Restoring missing column titles.mp4

Adding illustrations to your workbook.mp4

Adding comments and shapes.mp4

Exploring what-if scenarios using Goal Seek.mp4

Setting up custom views for quick access to different worksheet displays.mp4

Controlling worksheet security by allowing selected users to edit specific cell ranges.mp4

Becoming more productive with these 10 tiny tips you'll use often.mp4

Custom formats, relative addressing, and conditional formatting.mp4

Using scroll bars and spin buttons to facilitate forms creation.mp4

Creating an Excel template.mp4

Creating colorful 3D buttons for worksheet annotation and macro buttons.mp4

Tracking down cell dependencies across multiple worksheets and workbooks.mp4

The top five unknown but useful keyboard shortcuts.mp4

Using list boxes and combo boxes to facilitate forms creation.mp4

Drawing borders and border grids.mp4

Using formulas to calculate values across worksheets and workbooks.mp4

Using hyperlinks for rapidly switching worksheet locations and jumping to websites.mp4

Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells.mp4

Create an Organization Chart.mp4

Using source data from a table to make your PivotTable more dynamic.mp4

Applying conditional formatting across rows of data.mp4

Handling Dates with unusual formats.mp4

Adding pictures as worksheet backgrounds.mp4

Using the TREND and GROWTH functions for projecting future results.mp4

Using option buttons, group boxes, and checkboxes to facilitate forms creation.mp4

Adding, managing, and printing comments for worksheet documentation.mp4

Reducing data entry time by expanding AutoCorrect options.mp4

Accelerating Cut, Copy, Paste, and Insert tasks.mp4

Quick formatting tips.mp4

Using date and time as metrics in a PivotTable.mp4

Creating text, numerical, date, and time lists in a flash.mp4

Join data with new CONCAT and TEXTJOIN functions.mp4

Increasing your productivity with custom lists.mp4

Using Pick list, VLOOKUP, Table, and Chart together.mp4

Enhancing table filtering with slicers.mp4

Customizing templates to fit your unique needs.mp4

Splitting and consolidating workbooks.mp4

Dynamically presenting data via chart slicers.mp4

Highlighting PivotTable results with conditional formatting.mp4

Using the FORMULATEXT and N functions for worksheet and formula documentation.mp4

Converting charts into pictures.mp4

Parsing your data to create unique lists.mp4

Exploring various layouts for your PivotTable.mp4

Custom grouping in PivotTables.mp4

Creating dynamic charts with in-cell conditional formatting.mp4

Using the REPT function to represent data visually.mp4

Total files 63