 |
Copy Visible Excel Worksheet Data Posted by: ClintEJr
Video duration: 394 seconds See how to Copy or Export only visible Excel worksheet data retaining all formulas, subtotals and worksheet formatting and deleting all hidden rows and hidden columns. Related: copy, copying, cut, data, dppi, excel, export, exporting, ez-format, ez-split, filters, formula, formulas, microsoft, outlines, paste, spreadsheet, subtotal, subtotals, totals, visible, worksheet |
 |
Split Excel Worksheet to New Workbooks Posted by: ClintEJr
Video duration: 191 seconds Create multiple identically formatted Excel worksheets by automatically splitting the data in one Excel worksheet by all values or only selected values in any one column. Easily exclude data in hidden columns and hidden rows. Create new split worksheets in one workbook or in multiple workbooks. Related: add-in, add-ins, addin, addins, column, data, excel, formatted, list, microsoft, split, splitting, spreadsheet, spreadsheets, subtotaled, subtotals, tool, tools, totaled, totals, workbook, workbooks, worksheet, worksheets |
 |
Changing Excel Subtotals On-the-Fly Posted by: ClintEJr
Video duration: 545 seconds See how to quickly create and then change Excel subtotals on-the-fly including using Excel Formulas for Percent and Average Fields. Related: bold, bolded, change, changing, creating, data, dppi, excel, ez-format, ez-split, filters, formulas, make, making, microsoft, mixed, shade, shaded, subtotals |
 |
Quick & Easy Excel Charts No. 1 Posted by: ClintEJr
Video duration: 150 seconds EZ-Chart2 for Excel quickly and easily creates custom formatted Excel XY, XYZ and Combination Charts with automatic data summarization, automatic Chart Titles, chart exports, individual charts per X value, easy sorting and on-the-fly recalculation and display using 11 standard Excel formulas. Related: 2-y, 2y, add-in, add-ins, addin, addins, automatic, axis, bar, best, better, chart, charts, combination, create, creating, custom, data, easy, excel, fast, line, make, making, microsoft, pie, quick, sort, summarization, tool, tools, xy, xyz |
 |
Automatic Excel Worksheet Formatting Posted by: ClintEJr
Video duration: 228 seconds Overview of how to quickly format new Excel Worksheet Data and how to completely automate creating 100% identically formatted Worksheets for fields previously formatted. Related: add-in, add-ins, auto, automatcially, automatic, data, dppi, excel, ez-format, ez-split, format, formatting, microsoft, spreadsheet, subtotaling, subtotals, tool, tools, worksheet |
 |
Age Dates and use in Excel PivotTables Posted by: ClintEJr
Video duration: 276 seconds Create over 20 "Aged Date" and "Reformatted Date" type calculated fields for use in Excel PivotTables created by Excel or EZ-Pivot. There are eight variations of Accounting Type "Aged Dates" like the popular Current, 31-60, 61-90, 91-120, 120+ Aging. Related: accounting, active, add-in, add-ins, aged, aging, agings, analysis, best, better, calculated, column, columns, custom, customize, date, demo, demonstration, drill, drills, excel, ez-format, fields, formulas, free, how, make, making, microsoft, pivot, pivotcharts, pivottable, pivottables, reformatted, row, rows, summarization, summarized, summarizing, tab, table, tables, tool, tools |
 |
Splitting Excel Name and Text Fields Posted by: ClintEJr
Video duration: 210 seconds See how to quickly split the Left, Center or Right portion of a "Name" field or any Excel Text field to a new field without creating the required Excel formulas. Related: active, add-in, add-ins, best, better, center, column, custom, customize, demo, demonstration, excel, extract, extracting, ez-split, field, free, how, left, make, making, microsoft, name, right, separator, split, splitting, tab, text, tool, tools |
 |
Quick & Easy Excel Charts No. 2 Posted by: ClintEJr
Video duration: 117 seconds In seconds and without changing your Excel worksheet formatting automatically summarize the data and create identical custom formatted Excel XY, Combination and XYZ Charts. Sort in Ascending or Descending order by selecting Fields on the Sort Menu. Charts immediately update to reflect the requested sort order! Related: 2-y, 2d, 3d, add-in, add-ins, addin, addins, automatic, bar, best, better, chart, charts, combination, create, creating, data, easy, excel, fast, instantly, line, make, making, microsoft, pie, quick, realtime, sort, sorting, summarize, summarizing, tool, tools, xy, xyz |
 |
Splitting Excel Worksheets by Values Posted by: ClintEJr
Video duration: 196 seconds See how to extract or split the data in one combined Excel worksheet to new individual worksheets / workbooks each containing only data for one selected value in any field. For example, split one worksheet containing the sales information for all Salesmen into multiple new worksheets / workbooks each containing the sales information for only one of the selected salemen. Related: add-in, add-ins, best, better, copy, copying, custom, customize, data, demo, demoonstration, excel, extract, extracting, ez-split, field, free, how, make, microsoft, new, selected, split, splitting, spreadsheet, text, tool, tools, values, worksheet |
 |
50% Shorter QuickBooks Excel Reports Posted by: ClintEJr
Video duration: 126 seconds Use EZ-Quick for Excel to Automatically Reformat QuickBooks Financial and Budget Reports exported to Excel. In seconds reformatted Reports print in one-half to one-fifth the number of pages and are better formatted. Related: add-in, add-ins, addin, addins, automatic, automatically, best, better, budget, descriptions, easy, excel, fast, fewer, financial, formatting, headings, instantly, intuit, merge, merging, microsoft, pages, print, printing, quick, quickbooks, quickly, reformat, reformatting, reports, tool, tools |
 |
Filling Blank Cells in Excel Worksheets Posted by: ClintEJr
Video duration: 144 seconds See how to quickly fill-in blank Excel data cells from data in the cells above for blank cells in either one column or in all columns in an Excel List. Related: above, active, add-in, add-ins, best, better, blank, cell, cells, column, columns, copy, copying, custom, customize, data, demo, demonstration, empty, excel, ez-split, field, fields, fill, fill-in, filling, filling-in, free, how, make, making, microsoft, spreadsheet, tab, tool, tools, worksheet |
 |
Fast Dynamics GP SmartList Excel Exports Posted by: ClintEJr
Video duration: 207 seconds See how to export Microsoft Dynamics GP SmartList query results to Excel at speeds up to 200 times faster than the Great Plain's SmartList standard Excel Export. Related: builder, business, dynamics, excel, export, exports, fast, faster, fastest, favorite, format, formatting, gp, great, microsoft, plains, print, printing, smartlist, solutions |
 |
Splitting Excel Workbooks by Tab Posted by: ClintEJr
Video duration: 140 seconds See how to create one new Excel Workbook for each selected tab or selected sheet in the currently active workbook. Related: active, add-in, add-ins, best, better, copy, copying, create, creating, custom, customize, demo, demonstration, excel, ez-split, free, how, make, making, microsoft, new, selected, sheets, split, splitting, tab, tabs, tool, tools, workbooks, worksheets |
 |
Copy Subsets of Data to New Sheet Posted by: ClintEJr
Video duration: 113 seconds See how to quickly extract, copy or subset all of the data in an Excel worksheet for only the user selected values in any field to a new worksheet. Related: active, add-in, add-ins, best, better, columns, copy, copying, custom, customize, data, demo, demonstration, excel, extract, extracting, ez-split, free, group, how, make, making, microsoft, rows, select, selected, subset, subsets, subsetting, tab, tool, tools, values |
 |
Spreading Excel Number Fields Posted by: ClintEJr
Video duration: 142 seconds See how to quickly spread the Numeric Values in one column to new automatically created columns for each unique value in a second column. Related: active, add-in, add-ins, amounts, auto, automatically, best, better, columns, custom, customize, data, demo, demonstration, excel, ez-split, fields, free, how, make, making, microsoft, new, number, numbers, numeric, spread, spreading, tab, tool, tools, values |
 |
Quickly Format Excel Worksheets Posted by: ClintEJr
Video duration: 201 seconds See how to quickly format data, create a reusable Excel worksheet format template, and reuse the format template to auto create an identically formatted worksheet in seconds. Related: create, data, dppi, excel, format, formatted, formatting, microsoft, presentation, products, reuse, spreadsheet, worksheet |
 |
Quickly Make Excel Charts Posted by: ClintEJr
Video duration: 127 seconds See how to create identically formatted Excel Charts in seconds using automatically summarized data and saved Excel Chart Templates. Related: 3d, add-in, add-ins, addin, addins, bar, best, better, chart, charts, combination, create, custom, customize, excel, format, how, line, make, microsoft, pie, reuse, save, template, templates, tool, tools, xy, xyz |
 |
Resort Subtotaled Data by Subtotals Posted by: ClintEJr
Video duration: 210 seconds Very practical but manually impossible! An example would be resorting "Subtotals by Customer Name" in descending order by the Customer's Sales subtotals to view the Customer data from highest to lowest. Resort Subtotaled Excel Data in ascending or descending order by the Subtotal Amounts of any field for visually better Data Analysis. Related: analysis, create, creating, data, excel, make, making, microsoft, rank, ranking, resort, resorting, sort, sorting, spreadsheet, spreadsheets, subtotal, subtotals, workbooks, worksheet, worksheets |
 |
Changing Excel Subtotal Row Height Posted by: ClintEJr
Video duration: 113 seconds See how to quickly change the height of all Subtotal rows in an Excel worksheet. Related: add-in, add-ins, bold, bolding, break, breaks, change, changing, creating, excel, ez-format, formula, formulas, gradient, height, making, marketplace, microsoft, office, row, rows, shade, shading, spreadsheet, subtotal, subtotaling, subtotals, tool, tools, types, xcelerator |
 |
Chart Counts & Sums on Two Y-Axes Posted by: ClintEJr
Video duration: 151 seconds See how to automatically summarize data and quickly create both Excel XY and Excel Combination Charts with user customized Excel Chart formats or Chart templates. Learn when to use Excel Combination Charts rather than Excel XY Charts. Related: 2-y, 2d, 2y, 3d, add-in, add-ins, addin, addins, automatic, automatically, axis, bar, best, better, chart, charts, combination, create, creating, custom, customize, data, easy, excel, fast, instantly, line, make, making, microsoft, pie, quick, quickly, reuse, reusing, save, saving, sort, sorting, summarization, summarize, tool, tools, xy, xyz |
