| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/001 - Hide and unhide worksheets securely.mp4 |
17 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/001 - Hide and unhide worksheets securely.srt |
12 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/002 - Resizing, moving, copying, and manipulating charts and other objects.mp4 |
27.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/002 - Resizing, moving, copying, and manipulating charts and other objects.srt |
19 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/003 - Using list boxes and combo boxes to facilitate forms creation.mp4 |
21.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/003 - Using list boxes and combo boxes to facilitate forms creation.srt |
15 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/004 - Using the FORMULATEXT and N functions for worksheet and formula documentation.mp4 |
16.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/004 - Using the FORMULATEXT and N functions for worksheet and formula documentation.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/005 - Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells.mp4 |
23.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/005 - Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells.srt |
15 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/006 - Summarizing data from diverse ranges with Data - Consolidate.mp4 |
29.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/006 - Summarizing data from diverse ranges with Data - Consolidate.srt |
18 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/007 - Using check boxes and conditional formatting together for dynamic displays.mp4 |
40.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/007 - Using check boxes and conditional formatting together for dynamic displays.srt |
23 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/008 - Becoming more productive with these 10 tiny tips you'll use often.mp4 |
24.1 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/008 - Becoming more productive with these 10 tiny tips you'll use often.srt |
16 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/009 - Transposing data and charts for a different perspective on your data.mp4 |
30.3 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/009 - Transposing data and charts for a different perspective on your data.srt |
17 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/010 - Applying conditional formatting across rows of data.mp4 |
20.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/010 - Applying conditional formatting across rows of data.srt |
12 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/011 - Exploring various layouts for your PivotTable.mp4 |
13.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/011 - Exploring various layouts for your PivotTable.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/012 - Splitting and consolidating workbooks.mp4 |
20.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/012 - Splitting and consolidating workbooks.srt |
13 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/013 - Using date and time as metrics in a PivotTable.mp4 |
23.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/013 - Using date and time as metrics in a PivotTable.srt |
13 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/014 - Adding illustrations to your workbook.mp4 |
33.6 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/014 - Adding illustrations to your workbook.srt |
23 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/015 - Using a pick list, VLOOKUP, table, and chart together.mp4 |
22.6 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/015 - Using a pick list, VLOOKUP, table, and chart together.srt |
16 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/016 - Using formulas to calculate values across worksheets and workbooks.mp4 |
29.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/016 - Using formulas to calculate values across worksheets and workbooks.srt |
22 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/017 - Dynamically presenting data via chart slicers.mp4 |
20.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/017 - Dynamically presenting data via chart slicers.srt |
14 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/018 - Parsing your data to create unique lists.mp4 |
14.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/018 - Parsing your data to create unique lists.srt |
7 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/019 - Using the REPT function to represent data visually.mp4 |
8.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/019 - Using the REPT function to represent data visually.srt |
6 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/020 - Using source data from a table to make your PivotTable more dynamic.mp4 |
25 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/020 - Using source data from a table to make your PivotTable more dynamic.srt |
15 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/021 - Accelerating Cut, Copy, Paste, and Insert tasks.mp4 |
23.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/021 - Accelerating Cut, Copy, Paste, and Insert tasks.srt |
15 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/022 - Increasing your productivity with custom lists.mp4 |
20.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/022 - Increasing your productivity with custom lists.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/023 - Highlighting PivotTable results with conditional formatting.mp4 |
19.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/023 - Highlighting PivotTable results with conditional formatting.srt |
12 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/024 - Customizing templates to fit your unique needs.mp4 |
20.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/024 - Customizing templates to fit your unique needs.srt |
12 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/025 - Creating dynamic charts with in-cell conditional formatting.mp4 |
11.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/025 - Creating dynamic charts with in-cell conditional formatting.srt |
6 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/026 - Enhancing table filtering with slicers.mp4 |
20.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/026 - Enhancing table filtering with slicers.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/027 - Converting charts into pictures.mp4 |
15.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/027 - Converting charts into pictures.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/028 - Custom grouping in PivotTables.mp4 |
13 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/028 - Custom grouping in PivotTables.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/029 - Quick formatting tips.mp4 |
23.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/029 - Quick formatting tips.srt |
15 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/030 - The top five unknown but useful keyboard shortcuts.mp4 |
25.6 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/030 - The top five unknown but useful keyboard shortcuts.srt |
12 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/031 - Using the TREND and GROWTH functions for projecting future results.mp4 |
21.6 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/031 - Using the TREND and GROWTH functions for projecting future results.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/032 - Using scroll bars and spin buttons to facilitate forms creation.mp4 |
23.6 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/032 - Using scroll bars and spin buttons to facilitate forms creation.srt |
19 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/033 - Creating colorful 3D buttons for worksheet annotation and macro buttons.mp4 |
21.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/033 - Creating colorful 3D buttons for worksheet annotation and macro buttons.srt |
12 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/034 - Calculating with hours, minutes, and times of day.mp4 |
29.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/034 - Calculating with hours, minutes, and times of day.srt |
18 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/035 - Tracking down cell dependencies across multiple worksheets and workbooks.mp4 |
21.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/035 - Tracking down cell dependencies across multiple worksheets and workbooks.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/036 - Discovering time-saving tools in the Go To Special feature.mp4 |
40 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/036 - Discovering time-saving tools in the Go To Special feature.srt |
21 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/037 - Adding, managing, and printing comments for worksheet documentation.mp4 |
19.3 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/037 - Adding, managing, and printing comments for worksheet documentation.srt |
14 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/038 - Reducing data entry time by expanding AutoCorrect options.mp4 |
19 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/038 - Reducing data entry time by expanding AutoCorrect options.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/039 - Setting up custom views for quick access to different worksheet displays.mp4 |
25.1 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/039 - Setting up custom views for quick access to different worksheet displays.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/040 - Using hyperlinks for rapidly switching worksheet locations and jumping to websites.mp4 |
21.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/040 - Using hyperlinks for rapidly switching worksheet locations and jumping to websites.srt |
14 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/041 - Controlling worksheet security by allowing selected users to edit specific cell ranges.mp4 |
24.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/041 - Controlling worksheet security by allowing selected users to edit specific cell ranges.srt |
13 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/042 - Using option buttons, group boxes, and checkboxes to facilitate forms creation.mp4 |
19.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/042 - Using option buttons, group boxes, and checkboxes to facilitate forms creation.srt |
14 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/043 - Exploring what-if scenarios using Goal Seek.mp4 |
28 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/043 - Exploring what-if scenarios using Goal Seek.srt |
16 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/044 - Creating text, numerical, date, and time lists in a flash.mp4 |
17.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/044 - Creating text, numerical, date, and time lists in a flash.srt |
12 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/045 - Creating variable conditional formatting rules.mp4 |
30.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/045 - Creating variable conditional formatting rules.srt |
14 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/046 - Handling dates with unusual formats.mp4 |
20.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/046 - Handling dates with unusual formats.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/047 - Using wildcards (asterisk, tilde, and question mark).mp4 |
38.1 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/047 - Using wildcards (asterisk, tilde, and question mark).srt |
18 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/048 - Custom formats using asterisk, semicolon, and brackets.mp4 |
39.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/048 - Custom formats using asterisk, semicolon, and brackets.srt |
22 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/049 - Meeting unusual filtering needs via Advanced Filter.mp4 |
47.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/049 - Meeting unusual filtering needs via Advanced Filter.srt |
22 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/050 - Create an organization chart.mp4 |
23.6 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/050 - Create an organization chart.srt |
17 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/051 - Two-way lookup using the MATCH and INDEX functions.mp4 |
50.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/051 - Two-way lookup using the MATCH and INDEX functions.srt |
22 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/052 - Using Excel error-checking functions.mp4 |
33.6 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/052 - Using Excel error-checking functions.srt |
20 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/053 - Custom formats, relative addressing, and conditional formatting.mp4 |
23.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/053 - Custom formats, relative addressing, and conditional formatting.srt |
16 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/054 - Auditing.mp4 |
30.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/054 - Auditing.srt |
18 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/055 - Adding comments and shapes.mp4 |
25.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/055 - Adding comments and shapes.srt |
16 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/056 - Drawing borders and border grids.mp4 |
21.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/056 - Drawing borders and border grids.srt |
13 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/057 - Building a flexible monthly table using functions.mp4 |
32.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/057 - Building a flexible monthly table using functions.srt |
24 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/058 - Adding pictures as worksheet backgrounds.mp4 |
20 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/058 - Adding pictures as worksheet backgrounds.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/059 - ADDRESS, ROW, and COLUMN functions.mp4 |
27.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/059 - ADDRESS, ROW, and COLUMN functions.srt |
16 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/060 - Join data with new CONCAT and TEXTJOIN functions.mp4 |
17.6 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/060 - Join data with new CONCAT and TEXTJOIN functions.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/061 - Working with formulas in tables.mp4 |
48.1 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/061 - Working with formulas in tables.srt |
28 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/062 - Locating data validation rules and violations.mp4 |
28.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/062 - Locating data validation rules and violations.srt |
15 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/063 - Creating an Excel template.mp4 |
23.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/063 - Creating an Excel template.srt |
16 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/064 - Restoring missing column titles.mp4 |
26.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/064 - Restoring missing column titles.srt |
14 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/065 - Creating a pick list dependent on another pick list.mp4 |
18.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/065 - Creating a pick list dependent on another pick list.srt |
14 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/066 - Using command shortcuts with the Alt key.mp4 |
20.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/066 - Using command shortcuts with the Alt key.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/067 - Set up a macro for sorting dynamic data.mp4 |
28.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/067 - Set up a macro for sorting dynamic data.srt |
19 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/068 - Use random number functions for sorting and creating sample data.mp4 |
28.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/068 - Use random number functions for sorting and creating sample data.srt |
20 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/069 - Use calcuated fields and calculated items in a PivotTable.mp4 |
26.3 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/069 - Use calcuated fields and calculated items in a PivotTable.srt |
17 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/070 - Replace characters by position with the REPLACE function.mp4 |
15.6 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/070 - Replace characters by position with the REPLACE function.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/071 - Work with formulas in tables.mp4 |
30 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/071 - Work with formulas in tables.srt |
18 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/072 - Keystroke shortcuts from A to Z Using the Ctrl key.mp4 |
55 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/072 - Keystroke shortcuts from A to Z Using the Ctrl key.srt |
31 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/073 - Use special tricks for working with dates in charts.mp4 |
33.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/073 - Use special tricks for working with dates in charts.srt |
21 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/074 - Use a data form for data entry and exploring data.mp4 |
24.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/074 - Use a data form for data entry and exploring data.srt |
13 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/075 - Creating an Excel template to simplify updating a monthly file.mp4 |
19.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/075 - Creating an Excel template to simplify updating a monthly file.srt |
14 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/076 - Calculate dates efficiently using Excel's hidden function - DATEDIF.mp4 |
22.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/076 - Calculate dates efficiently using Excel's hidden function - DATEDIF.srt |
14 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/077 - Create dynamic sheet name references with the INDIRECT function.mp4 |
19.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/077 - Create dynamic sheet name references with the INDIRECT function.srt |
12 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/078 - Avoid errors and hidden data with the powerful AGGREGATE function.mp4 |
20.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/078 - Avoid errors and hidden data with the powerful AGGREGATE function.srt |
13 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/079 - Hide worksheets, row, columns, cells and other Excel elements.mp4 |
27.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/079 - Hide worksheets, row, columns, cells and other Excel elements.srt |
15 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/080 - Use slicers and charts together for dynamic presentations.mp4 |
29.1 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/080 - Use slicers and charts together for dynamic presentations.srt |
18 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/081 - Save a chart as a template Use the template for current or new charts.mp4 |
18.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/081 - Save a chart as a template Use the template for current or new charts.srt |
12 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/082 - MAXIFS and MINIFS added to the COUNTIF-SUMIF family of functions.mp4 |
22.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/082 - MAXIFS and MINIFS added to the COUNTIF-SUMIF family of functions.srt |
15 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/083 - Adjust a chart's source data and adjust its series order.mp4 |
25.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/083 - Adjust a chart's source data and adjust its series order.srt |
17 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/084 - Use the OFFSET function for tabulating moving data.mp4 |
30.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/084 - Use the OFFSET function for tabulating moving data.srt |
20 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/085 - Alter numeric data without formulas.mp4 |
37.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/085 - Alter numeric data without formulas.srt |
19 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/086 - Use Flash Fill to rapidly combine or separate columnar data.mp4 |
34.3 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/086 - Use Flash Fill to rapidly combine or separate columnar data.srt |
19 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/087 - Adjust banded-row formatting.mp4 |
57.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/087 - Adjust banded-row formatting.srt |
28 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/088 - Change the shape of comment boxes and other objects.mp4 |
19.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/088 - Change the shape of comment boxes and other objects.srt |
13 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/089 - How and when to use the 10 rounding functions in Excel.mp4 |
35.3 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/089 - How and when to use the 10 rounding functions in Excel.srt |
24 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/090 - Calculate faster with the AutoSum button and AutoSum keystroke shortcut.mp4 |
18.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/090 - Calculate faster with the AutoSum button and AutoSum keystroke shortcut.srt |
13 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/091 - How to use mixed cell references.mp4 |
23.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/091 - How to use mixed cell references.srt |
16 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/092 - Activate the Speak On Enter and Speak Cells features.mp4 |
14.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/092 - Activate the Speak On Enter and Speak Cells features.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/093 - Accelerate data entry with five special techniques.mp4 |
31.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/093 - Accelerate data entry with five special techniques.srt |
23 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/094 - Insert a text box or shape and link a cell's content to it.mp4 |
17 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/094 - Insert a text box or shape and link a cell's content to it.srt |
12 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/095 - Use Watch Window and other techniques to track changing cells.mp4 |
29.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/095 - Use Watch Window and other techniques to track changing cells.srt |
16 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/096 - How to create time interval entrie.mp4 |
32.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/096 - How to create time interval entrie.srt |
21 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/097 - How to create frequency tabulations and distributions.mp4 |
24.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/097 - How to create frequency tabulations and distributions.srt |
14 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/098 - Create an expanded list from a summary using PivotTable techniques.mp4 |
36.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/098 - Create an expanded list from a summary using PivotTable techniques.srt |
13 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/099 - Solve matching issues with matching phone numbers and SS numbers.mp4 |
35.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/099 - Solve matching issues with matching phone numbers and SS numbers.srt |
18 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/100 - Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative.mp4 |
16.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/100 - Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative.srt |
14 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/101 - Use outlining tools to quickly expand and collapse data for dynamic presentations.mp4 |
35.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/101 - Use outlining tools to quickly expand and collapse data for dynamic presentations.srt |
18 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/102 - Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting.mp4 |
30.1 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/102 - Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting.srt |
18 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/103 - Create lists of all 2nd Tuesdays, last Tuesdays. and other date series.mp4 |
29.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/103 - Create lists of all 2nd Tuesdays, last Tuesdays. and other date series.srt |
19 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/104 - Create linkage formulas that refer to other worksheets and workbooks.mp4 |
29.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/104 - Create linkage formulas that refer to other worksheets and workbooks.srt |
21 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/105 - Formula nesting - Using multiple functions in the same formula.mp4 |
39 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/105 - Formula nesting - Using multiple functions in the same formula.srt |
25 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/106 - Keyboard shortcuts for numeric formats.mp4 |
25.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/106 - Keyboard shortcuts for numeric formats.srt |
15 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/107 - Use the Subtotal command to analyze data with single- or multiple-level subtotals.mp4 |
41.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/107 - Use the Subtotal command to analyze data with single- or multiple-level subtotals.srt |
17 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/108 - Work with MAX, MAXIFS, LARGE, and related functions.mp4 |
24.6 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/108 - Work with MAX, MAXIFS, LARGE, and related functions.srt |
16 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/109 - Use the dynamic TODAY and NOW functions for real-time up-to-date calculations.mp4 |
24.3 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/109 - Use the dynamic TODAY and NOW functions for real-time up-to-date calculations.srt |
17 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/110 - Use the FIND, MID, LEFT, and RIGHT functions.mp4 |
29.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/110 - Use the FIND, MID, LEFT, and RIGHT functions.srt |
19 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/111 - Flip the left-to-right order of columns with the INDEX function or sort by columns.mp4 |
29.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/111 - Flip the left-to-right order of columns with the INDEX function or sort by columns.srt |
15 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/112 - Working with hidden data when copying cells and creating charts.mp4 |
40.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/112 - Working with hidden data when copying cells and creating charts.srt |
22 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/113 - Use conditional formatting data bars to accentuate negative data.mp4 |
11.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/113 - Use conditional formatting data bars to accentuate negative data.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/114 - Creative use of sparklines in merged cells with axes.mp4 |
19 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/114 - Creative use of sparklines in merged cells with axes.srt |
13 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/115 - Copy formats quickly using dragging techniques and the Format Painter.mp4 |
17.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/115 - Copy formats quickly using dragging techniques and the Format Painter.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/116 - Displaying multiple worksheets and workbooks together.mp4 |
32.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/116 - Displaying multiple worksheets and workbooks together.srt |
20 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/117 - Tips for creating and updating sample data.mp4 |
31.6 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/117 - Tips for creating and updating sample data.srt |
21 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/118 - Use conditional formatting to overcome formatting limitations of the IF function.mp4 |
24.1 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/118 - Use conditional formatting to overcome formatting limitations of the IF function.srt |
16 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/119 - Use VLOOKUP, MATCH, and INDEX functions with array formulas.mp4 |
29.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/119 - Use VLOOKUP, MATCH, and INDEX functions with array formulas.srt |
19 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/120 - Summarize data from different worksheets with a PivotTable.mp4 |
23.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/120 - Summarize data from different worksheets with a PivotTable.srt |
13 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/121 - AutoFill shortcuts for date series, one-two week intervals, EOM, and formulas.mp4 |
20.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/121 - AutoFill shortcuts for date series, one-two week intervals, EOM, and formulas.srt |
13 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/122 - Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions.mp4 |
24.3 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/122 - Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions.srt |
15 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/123 - Use custom formulas in data validation to keep out bad data.mp4 |
35 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/123 - Use custom formulas in data validation to keep out bad data.srt |
23 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/124 - Dealing with circular errors.mp4 |
22.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/124 - Dealing with circular errors.srt |
15 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/125 - Tips for creating charts quickly.mp4 |
19.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/125 - Tips for creating charts quickly.srt |
13 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/126 - Creating heat maps using conditional formatting.mp4 |
34.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/126 - Creating heat maps using conditional formatting.srt |
16 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/127 - Using the INDEX function to extract data by row and column.mp4 |
28.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/127 - Using the INDEX function to extract data by row and column.srt |
20 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/128 - Displaying tips when using Excel in presentations.mp4 |
29.6 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/128 - Displaying tips when using Excel in presentations.srt |
12 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/129 - The Wrap Text, Merge and Center, and Indent options.mp4 |
30.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/129 - The Wrap Text, Merge and Center, and Indent options.srt |
17 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/130 - Using fill effects (gradients, patterns, styles) for colorful cell background variations.mp4 |
17.1 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/130 - Using fill effects (gradients, patterns, styles) for colorful cell background variations.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/131 - Working with multiple worksheets simultaneously.mp4 |
26 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/131 - Working with multiple worksheets simultaneously.srt |
18 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/132 - Exploring font choices not found on the Home tab.mp4 |
11.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/132 - Exploring font choices not found on the Home tab.srt |
7 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/133 - Using WordArt for special titles and headings.mp4 |
14.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/133 - Using WordArt for special titles and headings.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/134 - Creating a two-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions.mp4 |
22.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/134 - Creating a two-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions.srt |
13 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/135 - Borders and gridlines - Exploring variations, options, and differences.mp4 |
25.1 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/135 - Borders and gridlines - Exploring variations, options, and differences.srt |
16 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/136 - New Excel 2016 chart types Tree map and sunburst.mp4 |
30.1 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/136 - New Excel 2016 chart types Tree map and sunburst.srt |
15 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/137 - Freezing column and row titles.mp4 |
41.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/137 - Freezing column and row titles.srt |
15 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/138 - Use data validation to force entries to be uppercase or lowercase.mp4 |
25.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/138 - Use data validation to force entries to be uppercase or lowercase.srt |
20 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/139 - Avoiding common chart distortions.mp4 |
32.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/139 - Avoiding common chart distortions.srt |
21 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/140 - Use the new funnel chart available in Excel 365.mp4 |
10.6 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/140 - Use the new funnel chart available in Excel 365.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/141 - Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character.mp4 |
15.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/141 - Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character.srt |
12 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/142 - Recognizing Excel Formula errors #NA, #VALUE!, #REF!, #DIV0!, #NUM, and #NAME!.mp4 |
28.1 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/142 - Recognizing Excel Formula errors #NA, #VALUE!, #REF!, #DIV0!, #NUM, and #NAME!.srt |
18 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/143 - Creating cross-totals with the SUMIFS function and mixed references.mp4 |
17.6 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/143 - Creating cross-totals with the SUMIFS function and mixed references.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/144 - New Excel 2016 chart types Histogram, Pareto, and box, and whisker.mp4 |
28 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/144 - New Excel 2016 chart types Histogram, Pareto, and box, and whisker.srt |
18 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/145 - Using the AND and OR functions independently or within IF functions.mp4 |
27.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/145 - Using the AND and OR functions independently or within IF functions.srt |
18 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/146 - Vertical and horizontal alignment settings and orientation options.mp4 |
18.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/146 - Vertical and horizontal alignment settings and orientation options.srt |
13 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/147 - Sorting tips and shortcuts.mp4 |
32.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/147 - Sorting tips and shortcuts.srt |
16 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/148 - A look at new chart types in Excel 2016 - Waterfall.mp4 |
18 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/148 - A look at new chart types in Excel 2016 - Waterfall.srt |
13 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/149 - Work with formulas and formats Decimals and fractions.mp4 |
13.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/149 - Work with formulas and formats Decimals and fractions.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/150 - Creating mixed reference formulas; converting to a table; applying conditional formatting.mp4 |
27.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/150 - Creating mixed reference formulas; converting to a table; applying conditional formatting.srt |
14 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/151 - Control gridlines in charts and on worksheets.mp4 |
21.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/151 - Control gridlines in charts and on worksheets.srt |
15 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/152 - Use the INDIRECT function with intersection formulas and range names to extract data.mp4 |
20.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/152 - Use the INDIRECT function with intersection formulas and range names to extract data.srt |
12 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/153 - Using Expand-Collapse on PivotTables and PivotCharts for rapid display changes.mp4 |
22 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/153 - Using Expand-Collapse on PivotTables and PivotCharts for rapid display changes.srt |
14 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/154 - Control phone number and postal code formats using built-in options or customized formats.mp4 |
18.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/154 - Control phone number and postal code formats using built-in options or customized formats.srt |
13 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/155 - Change the default Excel chart type; create and use chart templates.mp4 |
19.1 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/155 - Change the default Excel chart type; create and use chart templates.srt |
12 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/156 - Create your own customized date and time formats.mp4 |
22.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/156 - Create your own customized date and time formats.srt |
15 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/157 - Create on-screen warnings and reminders with comments or data validation messages.mp4 |
18.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/157 - Create on-screen warnings and reminders with comments or data validation messages.srt |
12 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/158 - Use REPLACE for formats only, for data only, or for both.mp4 |
22.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/158 - Use REPLACE for formats only, for data only, or for both.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/159 - Create numeric formats - Display in thousands or millions.mp4 |
35.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/159 - Create numeric formats - Display in thousands or millions.srt |
22 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/160 - Converting dates like 20102006 into usable date entries.mp4 |
12 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/160 - Converting dates like 20102006 into usable date entries.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/161 - Create custom lists for letter series like A to Z.mp4 |
28.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/161 - Create custom lists for letter series like A to Z.srt |
12 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/162 - Freeze Panes and Split.mp4 |
30.3 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/162 - Freeze Panes and Split.srt |
12 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/163 - NETWORKDAYS.INTL and WORKDAY.INTL.mp4 |
14.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/163 - NETWORKDAYS.INTL and WORKDAY.INTL.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/164 - Calculate % of change.mp4 |
14 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/164 - Calculate % of change.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/165 - Fill in all blank cells within a range with either formatting or data.mp4 |
16.6 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/165 - Fill in all blank cells within a range with either formatting or data.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/166 - Use the COUNT and COUNTA functions.mp4 |
13.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/166 - Use the COUNT and COUNTA functions.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/167 - Use workbook protection to prevent use of sheet commands.mp4 |
18 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/167 - Use workbook protection to prevent use of sheet commands.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/168 - Rank data with the RANK and RANK.AVG functions.mp4 |
16.1 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/168 - Rank data with the RANK and RANK.AVG functions.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/169 - Use nonstandard fiscal years and quarters in PivotTables.mp4 |
18.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/169 - Use nonstandard fiscal years and quarters in PivotTables.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/170 - Identify or extract unique entries in a list.mp4 |
22.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/170 - Identify or extract unique entries in a list.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/171 - Keyboard, mouse, and command techniques for viewing worksheets.mp4 |
27.1 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/171 - Keyboard, mouse, and command techniques for viewing worksheets.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/172 - Create artistic charts with random numbers.mp4 |
22.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/172 - Create artistic charts with random numbers.srt |
15 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/173 - Extract day, month, and year from date fields.mp4 |
13.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/173 - Extract day, month, and year from date fields.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/174 - Compare data with EXACT, FIND, and SEARCH functions.mp4 |
13.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/174 - Compare data with EXACT, FIND, and SEARCH functions.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/175 - How to covert ROMAN numberals.mp4 |
13.3 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/175 - How to covert ROMAN numberals.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/176 - Use range names for more readable formulas.mp4 |
15.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/176 - Use range names for more readable formulas.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/177 - Customize your Quick Access Toolbar.mp4 |
20.3 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/177 - Customize your Quick Access Toolbar.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/178 - Conditional formatting based on date proximity.mp4 |
13.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/178 - Conditional formatting based on date proximity.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/179 - How to adjust names.mp4 |
16.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/179 - How to adjust names.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/180 - Differences and limitations of converting data to a table.mp4 |
18.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/180 - Differences and limitations of converting data to a table.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/181 - Avoid the #DIV0 error message.mp4 |
13.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/181 - Avoid the #DIV0 error message.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/182 - Explore formatting options not available on the Home tab.mp4 |
15.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/182 - Explore formatting options not available on the Home tab.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/183 - Control table formatting with custom formats.mp4 |
12.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/183 - Control table formatting with custom formats.srt |
6 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/184 - Use date functions for age and tenure calculations.mp4 |
16.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/184 - Use date functions for age and tenure calculations.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/185 - Avoid unintentional entries when typing code numbers.mp4 |
9.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/185 - Avoid unintentional entries when typing code numbers.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/186 - Sorting by moving columns.mp4 |
15.3 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/186 - Sorting by moving columns.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/187 - Calculating cumulative totals.mp4 |
11.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/187 - Calculating cumulative totals.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/188 - Using the CONVERT function for different numbering systems.mp4 |
12.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/188 - Using the CONVERT function for different numbering systems.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/189 - Creating an automatically expanding chart by basing it on a table.mp4 |
11.3 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/189 - Creating an automatically expanding chart by basing it on a table.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/190 - Keystroke shortcuts using the Alt key.mp4 |
14.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/190 - Keystroke shortcuts using the Alt key.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/191 - Using the Solver Add-in.mp4 |
11.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/191 - Using the Solver Add-in.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/192 - Column widths, row heights, merging cells, and related formatting issues.mp4 |
11 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/192 - Column widths, row heights, merging cells, and related formatting issues.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/193 - Adjusting default layouts and date grouping in PivotTables.mp4 |
11.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/193 - Adjusting default layouts and date grouping in PivotTables.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/194 - Auditing cell content with Watch Window and dependent cell formulas.mp4 |
9.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/194 - Auditing cell content with Watch Window and dependent cell formulas.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/195 - Use the LEN and REPT functions for specialized cell testing and display options.mp4 |
10.6 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/195 - Use the LEN and REPT functions for specialized cell testing and display options.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/196 - Use the TRIM and CLEAN functions to remove excess spaces and non-printing characters.mp4 |
12 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/196 - Use the TRIM and CLEAN functions to remove excess spaces and non-printing characters.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/197 - Create double-spaced and triple-spaced printouts while repeating column headings.mp4 |
12.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/197 - Create double-spaced and triple-spaced printouts while repeating column headings.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/198 - Helpful keystroke shortcuts.mp4 |
21.3 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/198 - Helpful keystroke shortcuts.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/199 - Identify weekdays and weekend days in data.mp4 |
12 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/199 - Identify weekdays and weekend days in data.srt |
7 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/200 - Use chart and filter for presentations.mp4 |
9.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/200 - Use chart and filter for presentations.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/201 - Create picture links.mp4 |
19.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/201 - Create picture links.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/202 - How to use the error-checking rules in Excel.mp4 |
13.6 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/202 - How to use the error-checking rules in Excel.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/203 - Protect worksheets and lock cells.mp4 |
17.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/203 - Protect worksheets and lock cells.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/204 - Use mixed addresses in Excel formulas.mp4 |
12.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/204 - Use mixed addresses in Excel formulas.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/205 - Rapid filtering with Filter by Selection.mp4 |
12.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/205 - Rapid filtering with Filter by Selection.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/206 - Display large values.mp4 |
17.3 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/206 - Display large values.srt |
7 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/207 - Tracking down conditional formatting and data validation rules.mp4 |
18.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/207 - Tracking down conditional formatting and data validation rules.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/208 - Transposing data and using the TRANSPOSE function.mp4 |
13.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/208 - Transposing data and using the TRANSPOSE function.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/209 - Displaying gridlines, borders, and column_row headings when printing.mp4 |
13.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/209 - Displaying gridlines, borders, and column_row headings when printing.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/210 - Exploring some of the 200-plus SmartArt graphic options.mp4 |
9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/210 - Exploring some of the 200-plus SmartArt graphic options.srt |
7 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/211 - Using the CEILING and FLOOR functions for specialized rounding needs.mp4 |
11.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/211 - Using the CEILING and FLOOR functions for specialized rounding needs.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/212 - Inserting, reshaping, and formatting shapes - Rectangles, arrows, stars, and banners.mp4 |
12.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/212 - Inserting, reshaping, and formatting shapes - Rectangles, arrows, stars, and banners.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/213 - Tabulating totals with the VLOOKUP function and array constants.mp4 |
13.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/213 - Tabulating totals with the VLOOKUP function and array constants.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/214 - Working with array formulas more easily.mp4 |
11.1 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/214 - Working with array formulas more easily.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/215 - Using the new UNIQUE function to count and copy unique list entries.mp4 |
10.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/215 - Using the new UNIQUE function to count and copy unique list entries.srt |
6 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/216 - Creating and updating sample data.mp4 |
15.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/216 - Creating and updating sample data.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/217 - Format macros to make you a more efficient Excel user.mp4 |
14.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/217 - Format macros to make you a more efficient Excel user.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/218 - Use the new SORT and SORTBY functions to extract sorted lists.mp4 |
17.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/218 - Use the new SORT and SORTBY functions to extract sorted lists.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/219 - Use themes to adjust worksheet colors, fonts, and effects.mp4 |
11.3 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/219 - Use themes to adjust worksheet colors, fonts, and effects.srt |
7 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/220 - Calculate loan payments and investments with PMT and FV functions.mp4 |
12.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/220 - Calculate loan payments and investments with PMT and FV functions.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/221 - Use the XLOOKUP function to replace VLOOKUP.mp4 |
15 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/221 - Use the XLOOKUP function to replace VLOOKUP.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/222 - Chart display options with blank cells in source data.mp4 |
10.1 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/222 - Chart display options with blank cells in source data.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/223 - Adjust Conditional Formatting rules by altering percentage breakpoints.mp4 |
12.1 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/223 - Adjust Conditional Formatting rules by altering percentage breakpoints.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/224 - Discover new formula capabilities with new functions and dynamic arrays.mp4 |
13.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/224 - Discover new formula capabilities with new functions and dynamic arrays.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/225 - Sort or filter data based on color font or cell color background.mp4 |
23.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/225 - Sort or filter data based on color font or cell color background.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/226 - Simplify the use of special characters and symbols.mp4 |
11.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/226 - Simplify the use of special characters and symbols.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/227 - Select from over 800 icons to enliven worksheets.mp4 |
16.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/227 - Select from over 800 icons to enliven worksheets.srt |
12 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/228 - Use the new RANDARRAY function that replaces RAND and RANDBETWEEN.mp4 |
15.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/228 - Use the new RANDARRAY function that replaces RAND and RANDBETWEEN.srt |
12 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/229 - How and when to use an area chart.mp4 |
11.1 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/229 - How and when to use an area chart.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/230 - Insert colorful images with the People Graph Add-in.mp4 |
14.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/230 - Insert colorful images with the People Graph Add-in.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/231 - Use formulas to create interactive charts.mp4 |
11.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/231 - Use formulas to create interactive charts.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/232 - Track variables using the Scenario Manager.mp4 |
16.3 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/232 - Track variables using the Scenario Manager.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/233 - Get totals quickly without creating formulas.mp4 |
16.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/233 - Get totals quickly without creating formulas.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/234 - Use column or row references to create dynamic formulas.mp4 |
13.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/234 - Use column or row references to create dynamic formulas.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/235 - Overcoming obstacles when working with dates in charts.mp4 |
12.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/235 - Overcoming obstacles when working with dates in charts.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/236 - Create map-type charts based on geographical locations.mp4 |
9.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/236 - Create map-type charts based on geographical locations.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/237 - Techniques for creating date series.mp4 |
10.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/237 - Techniques for creating date series.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/238 - Extract filtered data with data validation and the FILTER function.mp4 |
14 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/238 - Extract filtered data with data validation and the FILTER function.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/239 - Use Find and Replace to change cell contents and formats.mp4 |
21.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/239 - Use Find and Replace to change cell contents and formats.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/240 - Add formula tools and symbols to the Quick Access Toolbar.mp4 |
16.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/240 - Add formula tools and symbols to the Quick Access Toolbar.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/241 - Change PivotTable settings for titles and summaries.mp4 |
16.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/241 - Change PivotTable settings for titles and summaries.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/242 - Use the Excel filtering capability for dates.mp4 |
13.1 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/242 - Use the Excel filtering capability for dates.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/243 - Use worksheet names in formulas.mp4 |
11.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/243 - Use worksheet names in formulas.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/244 - Use data validation rules with special phone and social security formats.mp4 |
12.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/244 - Use data validation rules with special phone and social security formats.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/245 - Work with time calculations in formulas.mp4 |
11.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/245 - Work with time calculations in formulas.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/246 - Prevent and locate duplicate worksheet entries.mp4 |
13.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/246 - Prevent and locate duplicate worksheet entries.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/247 - Look forward and backward using EDATE and other date functions.mp4 |
15.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/247 - Look forward and backward using EDATE and other date functions.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/248 - Display and highlight worksheet formula cells.mp4 |
15.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/248 - Display and highlight worksheet formula cells.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/249 - Split or join columnar data with Text to Columns or Flash Fill.mp4 |
13.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/249 - Split or join columnar data with Text to Columns or Flash Fill.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/250 - Highlight milestone data with conditional formatting and cumulative formulas.mp4 |
12.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/250 - Highlight milestone data with conditional formatting and cumulative formulas.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/251 - Use the XMATCH function to replace MATCH.mp4 |
9.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/251 - Use the XMATCH function to replace MATCH.srt |
6 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/252 - Create a powerful macro.mp4 |
13.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/252 - Create a powerful macro.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/253 - Work with hidden and visible data in filtered and subtotaled lists.mp4 |
21.6 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/253- Work with hidden and visible data in filtered and subtotaled lists.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/254 - Use TODAY, NOW, YEARFRAC, and DATEDIF.mp4 |
16 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/254 - Use TODAY, NOW, YEARFRAC, and DATEDIF.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/255 - Use data validation rules to prevent duplicate entries in a range.mp4 |
16 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/255 - Use data validation rules to prevent duplicate entries in a range.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/256 - Use various techniques to hide cells, rows, columns, and worksheets.mp4 |
18.1 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/256 - Use various techniques to hide cells, rows, columns, and worksheets.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/257 - Align, arrange, and rotate shapes in worksheets.mp4 |
17.3 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/257 - Align, arrange, and rotate shapes in worksheets.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/258 - File documentation with the Workbook Statistics button.mp4 |
11.3 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/258 - File documentation with the Workbook Statistics button.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/259 - Avoid misleading visuals when rescaling.mp4 |
13.6 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/259 - Avoid misleading visuals when rescaling.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/260 - Use the Fill Justify feature to wrap long text.mp4 |
10.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/260 - Use the Fill Justify feature to wrap long text.srt |
7 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/261 - Create range names from Column and Row headings.mp4 |
12.1 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/261 - Create range names from Column and Row headings.srt |
7 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/262 - Use the SUBSTITUTE and REPLACE functions.mp4 |
14.3 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/262 - Use the SUBSTITUTE and REPLACE functions.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/263 - Accelerate Conditional Formatting with the Quick Access Toolbar.mp4 |
13.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/263 - Accelerate Conditional Formatting with the Quick Access Toolbar.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/264 - Use wildcard symbols in functions.mp4 |
18 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/264 - Use wildcard symbols in functions.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/265 - Use wildcard symbols in filtering and commands.mp4 |
20.6 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/265 - Use wildcard symbols in filtering and commands.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/266 - Condense lengthy nested IF functions with the newer IFS function.mp4 |
11.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/266 - Condense lengthy nested IF functions with the newer IFS function.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/267 - Add flair to charts with these formatting options Gap width, shadow, glow, 3D, and more.mp4 |
14.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/267 - Add flair to charts with these formatting options Gap width, shadow, glow, 3D, and more.srt |
12 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/268 - Control worksheet security by allowing selected users to edit specific cell ranges.mp4 |
15.3 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/268 - Control worksheet security by allowing selected users to edit specific cell ranges.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/269 - Retrieve vital data based on location using the Geography tool.mp4 |
11.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/269 - Retrieve vital data based on location using the Geography tool.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/270 - Use the new SEQUENCE function to quickly build numeric and date arrays.mp4 |
10.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/270 - Use the new SEQUENCE function to quickly build numeric and date arrays.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/271 - Calculating text length and word count with LEN, TRIM, and SUBSTITUTE functions.mp4 |
14.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/271 - Calculating text length and word count with LEN, TRIM, and SUBSTITUTE functions.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/272 - Create a list box to facilitate selection of data from a list.mp4 |
14.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/272 - Create a list box to facilitate selection of data from a list.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/273 - Use various Excel count functions - COUNT, COUNTA, COUNTBLANK, and more.mp4 |
14.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/273 - Use various Excel count functions - COUNT, COUNTA, COUNTBLANK, and more.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/274 - Enhance readability with banded rows via conditional formatting.mp4 |
18.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/274 - Enhance readability with banded rows via conditional formatting.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/275 - Seven different ways to drag data using the Ctrl, Shift, and Alt keys.mp4 |
16.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/275 - Seven different ways to drag data using the Ctrl, Shift, and Alt keys.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/276 - Use the SWITCH function - Compare with IFS, CHOOSE, and other lookup functions.mp4 |
13.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/276 - Use the SWITCH function - Compare with IFS, CHOOSE, and other lookup functions.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/277 - Adjust charts quickly with quick layout, change colors, and chart styles options.mp4 |
10.6 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/277 - Adjust charts quickly with quick layout, change colors, and chart styles options.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/278 - Analyze PivotTable data with 13 different Show Values As options.mp4 |
21.8 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/278 - Analyze PivotTable data with 13 different Show Values As options.srt |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/279 - Expand-collapse or sort displayed results when using the SUBTOTAL command.mp4 |
22.2 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/279 - Expand-collapse or sort displayed results when using the SUBTOTAL command.srt |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/280 - Use the AGGREGATE function to circumvent errors and ignore hidden data.mp4 |
21.4 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/280 - Use the AGGREGATE function to circumvent errors and ignore hidden data.srt |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/281 - Use the F9 key to evaluate parts of a formula, recalculate random entries, and control iteration.mp4 |
17.9 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/281 - Use the F9 key to evaluate parts of a formula, recalculate random entries, and control iteration.srt |
12 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/282 - Using last-to-first (bottom-up) searches with XLOOKUP and XMATCH.mp4 |
13.7 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/282 - Using last-to-first (bottom-up) searches with XLOOKUP and XMATCH.srt |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/123_Book1.zip |
460 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/124_Quick_Charts.zip |
862 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/125_Heat_Maps.zip |
51 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/126_INDEX_Function.zip |
492 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/127_Display_Tips.zip |
334 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/128_Wrap_text_Merge_Indent.zip |
60 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/129_Fill_Effects.zip |
25 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/130_Multiple_Worksheets.zip |
17 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/131_Other_Font_Options.zip |
367 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/132_WordArt_Variations.zip |
426 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/133_Weekday_Weekend.zip |
512 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/134_Two_Way_Lookups.zip |
361 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/135_Borders_Gridlines.zip |
438 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/149_Decimals_and_Fractions.zip |
26 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/150_Mixed_References.zip |
65 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/151_Chart_gridlines_and_borders.zip |
65 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/152_INDIRECT_Intersection_RangeNames.zip |
19 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/153_Expand_Collapse_PivotTables.zip |
123 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/154_Phone_and_ZipCode_Formats.zip |
13 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/155_Default_Chart_Type_and_Chart_Templates.zip |
40 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/156_Date_Time_Formats.zip |
120 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/157_Comments_and_Reminders.zip |
183 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/158_Replace_Format_or_Content.zip |
155 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/159_Number_Formats.zip |
41 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/160_Date_Format_Conversions.zip |
134 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/161_Custom_Lists.zip |
118 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/162_Freeze_Panes_and_Split_Screens.zip |
115 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/163_NETWORKDAYS_and_WORKDAY.zip |
27 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/164_Percent_change_and_Goal_Seek.zip |
22 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/165_Fill_in_Blanks.zip |
153 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/166_COUNT_COUNTA_and_Status_Bar.zip |
144 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/167_Excel_Sheet_Commands.zip |
219 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/168_Ranking_Data.zip |
58 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/169_PivotTable_Date_Grouping.zip |
151 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/170_Unique_and_Duplicate_Data.zip |
211 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/171_Zoom_and_Display_Variations.zip |
259 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/172_Abstract_Art_with_Random_Numbers_and_Excel_Charts.zip |
73 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/173_YEAR_MONTH_DAY_WEEKDAY.zip |
226 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/174_EXACT_FIND_SEARCH_Functions.zip |
16 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/175_ROMAN_ARABIC.zip |
20 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/176_Range_Names.zip |
165 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/177_Customize_the_Quick_Access_Toolbar.zip |
60 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/178_Adjusting_Names.zip |
19 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/179_Date_Proximity_Formatting_final.zip |
19 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/180_Table_Differences.zip |
237 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/181_Avoiding_DIV_Error.zip |
30 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/182_FormattingOptions.zip |
238 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/183_New_Table_Style.zip |
123 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/184_Date_Calculations.zip |
128 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/185_Unintentional_Entries.zip |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/186_Sort_by_Moving_Columns.zip |
39 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/187_Cumulative_Totals.zip |
12 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/188_CONVERT_Function.zip |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/189_Alt_Key_Shortcuts.zip |
25 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/189_Chart_based_on_a_Table.zip |
7 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/190_Solver.zip |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/191_Columns_Widths.zip |
15 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/192_PivotTable_Settings.zip |
67 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/194_LEN_and_REPT.zip |
39 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/194_Watch_Window.zip |
105 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/195_TRIM_and_CLEAN.zip |
75 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/196_Double_and_Triple_Spaced_Printing.zip |
147 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/197_Helpful_Keystroke_Shortcuts.zip |
306 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/198_Weekdays_and_Weekends.zip |
248 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/199_Charts_and_Filters.zip |
16 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/200_Linking_Pictures.zip |
66 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/201_Error_Checking_Indicators.zip |
316 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/202_Worksheet_Protection.zip |
56 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/203_Mixed_Cell_Addresses.zip |
18 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/204_Filter_by_Selection.zip |
73 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/205_Displaying_Large_Values.zip |
33 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/206_ConditionalFormatting_and_DataValidation.zip |
107 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/207_CheckBox_ConditionalFormatting.zip |
107 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/208_Transpose.zip |
16 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/209_Borders_Gridlines_Printing.zip |
16 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/210_SmartArt.zip |
17 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/211_GoTo_Special.zip |
406 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/212_CEILINGandFLOOR.zip |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/213_Shapes_and_Stars.zip |
16 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/214_Array_Constants_withVLOOKUP.zip |
15 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/215_AdvancedFilter.zip |
345 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/216_ArrayFormulaUpdates.zip |
128 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/217_UNIQUE_function.zip |
41 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/218_Sample_Data.zip |
51 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/219_Utility_Macros.zip |
17 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/220_SORT_and_SORTBY_Functions.zip |
63 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/221_Themes.zip |
40 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/222_Financial_Functions.zip |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/223_BlankCellsInCharts.zip |
333 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/224_CondFormattingBreakpoints.zip |
21 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/225_New_Formulas.zip |
45 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/226_Sort_by_Color.zip |
74 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/227_Special_Characters.zip |
13 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/228_Icons.zip |
42 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/229_Random_Functions.zip |
13 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/230_Area_Charts.zip |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/231_People_Graph.zip |
59 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/232_GrowingChart.zip |
14 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/233_ScenarioManager.zip |
27 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/234_Status_Bar.zip |
65 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/235_Columns_and_Rows.zip |
60 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/236_Dates_in_Charts.zip |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/237_Geographic_Maps.zip |
8 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/238_Date_Time_Series.zip |
16 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/239_Data_Validation_and_Filter.zip |
70 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/240_Find_Select.zip |
158 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/241_AverageCountSubscript.zip |
57 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/242_CopyFormats.zip |
23 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/243_XLOOKUP_Function.zip |
165 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/244_PivotTable_Settings.zip |
46 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/245_FilterYearDay.zip |
28 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/246_Sheet_Names.zip |
74 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/247_Phone_ZipFormats.zip |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/248_Time_Math.zip |
48 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/249_Prevent_Locate_Duplicates.zip |
78 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/250_EDate_EMonth_DatedIF.zip |
129 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/251_Find_Highlight_Formula_cells.zip |
16 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/252_Text_Columns_Flash_Fill.zip |
11 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/253_Cumulative_Formulas.zip |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/254_XMATCH_Function.zip |
38 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/255_Hidden_Visible_Data.zip |
85 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/256_Macro_Highlight_Formula_Cells.zip |
17 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/257_TODAY_NOW_Date_Functions.zip |
57 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/258_Prevent_Duplicates.zip |
49 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/259_Hide_cells_rows_columns_sheets.zip |
173 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/260_Align_Arrange_Rotate_Shapes.zip |
18 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/261_Worksheet_Statistics.zip |
427 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/262_Re_scaling_Column_and_Line_Charts.zip |
57 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/263_Fill_Justify_Wrap_Text.zip |
9 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/264_Names_Based_On_Column_Row_Headings.zip |
10 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/265_SUBSTITUTE_and_REPLACE_Functions.zip |
63 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/266_Buttons_for_Conditional_Formatting.zip |
191 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/267_Wildcards_Part_1_Filter_and_Commands.zip |
28 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/268_Wildcards_Part_2_Functions_.zip |
293 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/269_IFS_Function.zip |
121 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/270_Chart_Formatting_Gap_Width_Shadow_Glow_3D.zip |
30 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/271_Protect_Cell_Ranges.zip |
56 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/272_Geography_Data.zip |
16 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/273_SEQUENCE_function.zip |
439 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/274_LEN_SUBSTITUTE_and_TRIM_functions.zip |
14 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/275_List_Box.zip |
127 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/276_COUNT_COUNTA_and_COUNTBLANK_functions.zip |
52 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/277_Banded_Rows_or_Columns.zip |
181 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/278_Dragging_cells_with_Ctrl_Shift_and_Alt_Keys.zip |
81 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/279_SWITCH_function.zip |
21 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/280_Chart_Design_Tools.zip |
27 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/281_PivotTable_Analysis.zip |
77 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/282_Subtotal.zip |
120 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/283_AGGREGATE_Function.zip |
235 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/284_The_F9_Key.zip |
21 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/285_XLOOKUP_XMATCH.zip |
77 KB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/Ex_Files_Excel_Tips_Weekly_2018_Q1.zip |
1.1 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/Ex_Files_Excel_Tips_Weekly_2018_Q2.zip |
1.5 MB |
| (2015-2020) Excel Tips Weekly (Updated 03.11.2020)-IVY/Exercise Files/Ex_Files_Excel_Tips_Weekly_2018_Q3.zip |
1.5 MB |
Magnet link
