Learn Excel from Bill Jelen with this daily 2 minute video podcast.
Create a pivot table that drives a SmartArt diagram. Episode 1184 shows you how.
Labels: accounting, business, Excel, MrExcel, pivot, smartart, spreadsheets, Table, technology, tutorial
posted by Bill at 10:54 PM
|
0 comments
Is the fill handle smart enough to fill in quarters and halves? Maybe. Maybe not.
Labels: accounting, business, Excel, MrExcel, spreadsheets, technology, tutorial
posted by Bill at 10:50 PM
|
0 comments
Today's 'Dueling Excel' podcast - Episode 1182, with Bill Jelen and Mike Gel Girvin - shows you how to visually present statistical values (+/-) in a cell.
Labels: accounting, business, Excel, MrExcel, spreadsheets, statistics, technology, tutorial
posted by Bill at 10:37 AM
|
0 comments
Today, learn how to create a dropdown that allows you to change the chart displayed on your worksheet! View Episode 1181 to learn this tip!
Labels: accounting, business, charting, Excel, MrExcel, named range, spreadsheets
posted by Bill at 7:01 PM
|
0 comments
A workbook that was working perfectly in Excel 2003 starts failing in Excel 2007. For no apparent reason, the links will no longer update. Episode 1174 Episode 1174 show why and how to fix this problem forever.
Labels: accounting, business, Excel, MrExcel, spreadsheets, technology, tutorial
posted by Bill at 10:15 AM
|
2 comments
Paula asks how to take a range and turn it on its side.
Labels: accounting, business, Excel, MrExcel, spreadsheets, technology, transpose, tutorial
posted by Bill at 9:09 PM
|
0 comments
Today's dueling Excel podcast shows how to do a picture lookup in Excel.
Labels: accounting, business, Excel, MrExcel, Picture, spreadsheets, technology, tutorial
posted by Bill at 3:00 AM
|
0 comments
Another look at Formula Speed in Excel: I have to do a lookup to find both a city and a day. Rather than using a concatenated lookup, two alternative formulas that perfom faster.
Labels: accounting, business, Excel, Formula Speed, MrExcel, Offset, spreadsheets, SUMIFS, technology, tutorial
posted by Bill at 5:27 PM
|
0 comments
Another look at Formula Speed in Excel: I have to do a lookup to find both a city and a day. Rather than using a concatenated lookup, two alternative formulas that perfom faster.
Labels: accounting, business, Excel, Formula Speed, MrExcel, Offset, spreadsheets, SUMIFS, technology, tutorial
posted by Bill at 3:00 AM
|
0 comments
Szilvia noted a strange anomoly in Excel 2007 pivot tables. Microsoft started appearing at the top of every customer list! Episode 1170 Episode 1170 takes a look at this mystery and the solution.
Labels: accounting, business, Excel, MrExcel, Pivot Table, spreadsheets, technology, tutorial
posted by Bill at 3:00 AM
|
0 comments
Joe asks if there is any way to do a Filtered Paste operation. I can't figure it out, so I had to resort to a macro. Check out Episode 977 and see if you have a better way.
Labels: accounting, business, Excel, Filter, MrExcel, spreadsheets, technology, tutorial
posted by Bill at 9:00 AM
Ute from Germany sends in a better way to show negative points in a column chart in a red color. His cool trick works for Excel 97-2003. Episode 674 will show you how.
Labels: accounting, business, charting, charts, Excel, MrExcel, spreadsheets, technology, tutorial
posted by Bill at 9:00 AM
Hamideh sends in an interesting question. He set up a really cool custom number format to prevent people from having to enter 4 dashes in a part number. However... now Find appears not to work. In Episode 673, I will show you the hidden setting to assist with the Find.
Labels: accounting, business, Excel, MrExcel, spreadsheets, technology, tutorial
posted by Bill at 9:00 AM
