By J. Peter Bruzzese J. Peter Bruzzese teaches Microsoft Windows Vista…now get the most out of it, faster and more easily than ever before! J. Peter Bruzzese shows you how to maximize your Vista productivity and fun with 100 quick video lessons. | 5:02 | Nov 14, 2009 |  |
By Bill Jelen Change the pivot table calculation from a normal sum in Excel 2003. Create running totals or percentage of totals. | 5:28 | Mar 4, 2009 | |
By Bill Jelen Never use the AutoSum icon when you are recording a macro. Learn how to get around this annoying problem. | 6:24 | Mar 4, 2009 | |
By Bill Jelen Do you have City, State, and Zip Code all in a single column and need to sort by zip code? Learn how to break the data into 3 columns. | 5:23 | Mar 4, 2009 | |
By Bill Jelen Learn how to change an existing pivot table in Excel 2007. | 3:54 | Mar 4, 2009 | |
By Bill Jelen Convert Excel formulas to their current values. | 6:03 | Mar 4, 2009 | |
By Bill Jelen Faster ways to make a copy of your Excel worksheet. How to make changes to multiple worksheets at one time. | 6:00 | Mar 4, 2009 | |
By Bill Jelen Pivot tables are an amazing tool for summarizing data. Create your first pivot table in Excel 2003. | 4:32 | Mar 4, 2009 | |
By Bill Jelen Pivot tables are an amazing tool for summarizing data. Learn how to create your first pivot table in Excel 2007. | 3:59 | Mar 4, 2009 | |
By Bill Jelen With 356 functions in Excel, there is probably already a solution for your calculation. Learn how to discover new functions in Excel. | 4:58 | Mar 4, 2009 | |
By Bill Jelen Faster ways to use the fill handle when you are creating an Excel worksheet. | 5:53 | Mar 4, 2009 | |
By Bill Jelen Access has offered Filter by Selection for many years. Don't you wish Excel offered the same functionality? It does! | 4:21 | Mar 4, 2009 | |
By Bill Jelen Explore how a worksheet is working by using the Formula Auditing tools. | 5:43 | Mar 4, 2009 | |
By Bill Jelen If you need to back into an answer in Excel, use the Goal Seek command. | 4:50 | Mar 4, 2009 | |
By Bill Jelen Perform conditional calculations in Excel using the IF function. | 6:17 | Mar 4, 2009 | |
By Bill Jelen Make the Excel IF function more powerful by using AND, OR, and NOT functions. | 5:56 | Mar 4, 2009 | |
By Bill Jelen Teach the Excel fill handle how to extend lists from your company, such as cost centers, plant locations, and so on. | 4:36 | Mar 4, 2009 | |
By Bill Jelen Do you have first name in column A and last name in column B? Learn how to join these together into a single column. | 5:55 | Mar 4, 2009 | |
By Bill Jelen Once you've created the perfect pivot table, replicate the pivot table for every customer, product, or region. | 4:37 | Mar 4, 2009 | |
By Bill Jelen Summarize daily dates up to monthly or yearly data in Excel 2007. | 5:29 | Mar 4, 2009 | |
By Bill Jelen Create a report of the Top 10 customers in your Excel pivot table. | 4:31 | Mar 4, 2009 | |
By Bill Jelen Unfortunately, the macro recorder frequently fails. There is one setting you can change to allow more of your macros to work. | 6:03 | Mar 4, 2009 | |
By Bill Jelen Record your first macro in Excel 2003. | 5:35 | Mar 4, 2009 | |
By Bill Jelen Record your first macro in Excel 2007 | 5:17 | Mar 4, 2009 | |
By Bill Jelen See all formulas in an Excel workbook at once. Also - highlight all formulas in Excel. | 5:24 | Mar 4, 2009 | |
By Bill Jelen How to set up data for easy sorting and analysis | 5:03 | Mar 4, 2009 | |
By Bill Jelen Add hundreds of Excel subtotals in seconds. | 4:47 | Mar 4, 2009 | |
By Bill Jelen See only the subtotal lines and how to copy those rows to a new workbook | 4:32 | Mar 4, 2009 | |
By Bill Jelen Learn how to Format the subtotal lines. | 5:16 | Mar 4, 2009 | |
By Bill Jelen Do conditional sums in Excel using SUMIF and the new Excel 2007 SUMIFS functions | 5:25 | Mar 4, 2009 | |
By Bill Jelen Three different ways to enter a formula in Excel. Includes a discussion of relative and absolute references. | 5:58 | Mar 4, 2009 | |
By Bill Jelen Turn an Excel table on its side with Transpose. And I'll show you how to Transpose with a formula. | 4:41 | Mar 4, 2009 | |
By Bill Jelen Loop through all worksheets in the current workbook to unhide them. | 6:45 | Mar 4, 2009 | |
By Bill Jelen Use VLOOKUP to match up data from two Excel lists. | 5:57 | Mar 4, 2009 | |
By Bill Jelen Advanced VLOOKUP uses in Excel. | 5:37 | Mar 4, 2009 | |
By Bill Jelen Run a macro from a keystroke, a button, an icon or a duck. | 6:35 | Mar 4, 2009 | |
By Bill Jelen Perform 100 Excel what-if analyses in seconds. | 5:13 | Mar 4, 2009 | |
By Bill Jelen See details when your Excel chart contains differing orders of magnitude | 6:17 | Mar 3, 2009 | |
By Bill Jelen Create an Excel chart with one keystroke. Quick ways to customize the chart. | 5:51 | Mar 3, 2009 | |
By Bill Jelen Add new data to an existing Excel chart. | 4:47 | Mar 3, 2009 | |
By Bill Jelen Learn cool tricks with Excel pie charts. Explode one slice or bring the small slices around to the front. | 6:24 | Mar 3, 2009 | |
Account Sign In
View your cart