Home > Authors

Bill Jelen

Bill Jelen, Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill was a regular guest on "Call for Help with Leo Laporte" and has produced more than 1,200 episodes of his daily video podcast, "Learn Excel from MrExcel." He is the author of 30 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. You will most frequently find Bill taking his show on the road, doing half-day Power Excel seminars wherever he can find a room full of accountants or Excellers. Before founding MrExcel.com, Jelen spent 12 years in the trenches working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives near Akron, Ohio with his wife, Mary Ellen, and his sons, Josh and Zeke.

1.
Excel PivotTables, PowerPivot, Power View, and Power Map with MrExcel LiveLessons (Video Training)Download
Excel PivotTables, PowerPivot, Power View, and Power Map with MrExcel LiveLessons (Video Training)
2.
Power Excel 2013 with MrExcel LiveLessons (Video Training) , Downloadable VersionDownload
Power Excel 2013 with MrExcel LiveLessons (Video Training) , Downloadable Version
3.
Excel 2013 Charts and GraphsDownload
Excel 2013 Charts and Graphs
4. Excel 2013 Charts and GraphsExcel 2013 Charts and Graphs
5. Excel 2013 VBA and MacrosExcel 2013 VBA and Macros
6.
Excel 2013 VBA and MacrosDownload
Excel 2013 VBA and Macros
7. Excel 2013 In DepthExcel 2013 In Depth
8. Excel 2013 Pivot Table Data CrunchingExcel 2013 Pivot Table Data Crunching
9.
Excel 2013 In DepthDownload
Excel 2013 In Depth
10.
Excel 2013 Pivot Table Data CrunchingDownload
Excel 2013 Pivot Table Data Crunching
11. Pivot Table Data Crunching: Microsoft Excel 2010Pivot Table Data Crunching: Microsoft Excel 2010
12.
Pivot Table Data Crunching: Microsoft Excel 2010Download
Pivot Table Data Crunching: Microsoft Excel 2010
13. Power Excel 2010 with MrExcel LiveLessons (Video Training)Power Excel 2010 with MrExcel LiveLessons (Video Training)
14. Charts and Graphs: Microsoft Excel 2010Charts and Graphs: Microsoft Excel 2010
15.
Power Excel 2010 with MrExcel LiveLessons, Downloadable VersionDownload
Power Excel 2010 with MrExcel LiveLessons, Downloadable Version
16.
Charts and Graphs: Microsoft Excel 2010, Portable DocumentsDownload
Charts and Graphs: Microsoft Excel 2010, Portable Documents
17.
Microsoft Excel 2010 In DepthDownload
Microsoft Excel 2010 In Depth
18. Microsoft Excel 2010 In DepthMicrosoft Excel 2010 In Depth
19. VBA and Macros: Microsoft Excel 2010VBA and Macros: Microsoft Excel 2010
20.
VBA and Macros: Microsoft Excel 2010Download
VBA and Macros: Microsoft Excel 2010
21.
PowerPivot for the Data Analyst: Microsoft Excel 2010Download
PowerPivot for the Data Analyst: Microsoft Excel 2010
22. PowerPivot for the Data Analyst: Microsoft Excel 2010PowerPivot for the Data Analyst: Microsoft Excel 2010
23. Excel VBA and Macros with MrExcel LiveLessons (Video Training)Excel VBA and Macros with MrExcel LiveLessons (Video Training)
24.
Excel VBA and Macros with MrExcel LiveLessons (Video Training), (Downloadable Video)Download
Excel VBA and Macros with MrExcel LiveLessons (Video Training), (Downloadable Video)
25. Power Excel 2007 with MrExcel (Video Training)Power Excel 2007 with MrExcel (Video Training)
26.
Power Excel 2007 with MrExcel LiveLessons (Video Training), (Downloadable Video)Download
Power Excel 2007 with MrExcel LiveLessons (Video Training), (Downloadable Video)
27. VBA and Macros for Microsoft Office Excel 2007VBA and Macros for Microsoft Office Excel 2007
28.
VBA and Macros for Microsoft Office Excel 2007 (Adobe Reader)Download
VBA and Macros for Microsoft Office Excel 2007 (Adobe Reader)
29. Charts and Graphs for Microsoft Office Excel 2007Charts and Graphs for Microsoft Office Excel 2007
30.
Charts and Graphs for Microsoft Office Excel 2007 (Adobe Reader)Download
Charts and Graphs for Microsoft Office Excel 2007 (Adobe Reader)
31. Pivot Table Data Crunching for Microsoft Office Excel 2007Pivot Table Data Crunching for Microsoft Office Excel 2007
32.
Pivot Table Data Crunching for Microsoft Office Excel 2007Download
Pivot Table Data Crunching for Microsoft Office Excel 2007
33. Special Edition Using Microsoft Office Excel 2007Special Edition Using Microsoft Office Excel 2007
34.
Special Edition Using Microsoft Office Excel 2007 (Adobe Reader)Download
Special Edition Using Microsoft Office Excel 2007 (Adobe Reader)
35.
Leveraging SmartArt Graphics in the 2007 Microsoft Office System: Using Office 2007's New Business Diagramming Tools (Digital Short Cut)Download
Leveraging SmartArt Graphics in the 2007 Microsoft Office System: Using Office 2007's New Business Diagramming Tools (Digital Short Cut)
36. Pivot Table Data CrunchingPivot Table Data Crunching
37.
Pivot Table Data Crunching (Adobe Reader)Download
Pivot Table Data Crunching (Adobe Reader)
38. VBA and Macros for Microsoft ExcelVBA and Macros for Microsoft Excel
39.
VBA and Macros for Microsoft Excel, Adobe ReaderDownload
VBA and Macros for Microsoft Excel, Adobe Reader
1.
OnHomeandOffice (Video): Microsoft Excel 2010: Frequency Chart
Jun 16, 2011
2.
OnHomeandOffice (Video): Microsoft Excel 2010: Trend Line
Jun 16, 2011
3.
OnHomeandOffice (Video): Microsoft Excel 2010: Negative Data Bar
Jun 16, 2011
4.
OnHomeandOffice (Video): Microsoft Excel 2010: Format Painter
Jun 16, 2011
5.
OnHomeandOffice (Video): Microsoft Excel 2010: Pivot List
Jun 16, 2011
6.
OnHomeandOffice (Video): Microsoft Excel 2010: Word Processing
Jun 16, 2011
7.
OnHomeandOffice (Video): Microsoft Excel 2010: Slowmotion
Jun 9, 2011
8.
OnHomeandOffice (Video): Microsoft Excel 2010: Work Days
Jun 9, 2011
9.
OnHomeandOffice (Video): Microsoft Excel 2010: Filter by Selection
Jun 9, 2011
10.
OnHomeandOffice (Video): Microsoft Excel 2010: Compare Two Lists
Jun 9, 2011
11.
OnHomeandOffice (Video): Microsoft Excel 2010: Double Space
Jun 9, 2011
12.
OnHomeandOffice (Video): Microsoft Excel 2010: Two Slicers
Jun 2, 2011
13.
OnHomeandOffice (Video): Microsoft Excel 2010: Slicers
Jun 2, 2011
14.
OnHomeandOffice (Video): Microsoft Excel 2010: Year Over Year
Jun 2, 2011
15.
OnHomeandOffice (Video): Microsoft Excel 2010: Top Ten (Pivot Tables)
Jun 2, 2011
16.
OnHomeandOffice (Video): Microsoft Excel 2010: Fill Blanks
Jun 2, 2011
17.
OnHomeandOffice (Video): Microsoft Excel 2010: V Lookup
Jun 2, 2011
18.
OnHomeandOffice (Video): Microsoft Excel 2010: Two-Way Lookup
May 25, 2011
19.
OnHomeandOffice (Video): Microsoft Excel 2010: Sorting Subtotals
May 25, 2011
20.
OnHomeandOffice (Video): Microsoft Excel 2010: Pivot Table
May 25, 2011
21.
OnHomeandOffice (Video): Microsoft Excel 2010: Sum and Count
May 25, 2011
22.
OnHomeandOffice (Video): Microsoft Excel 2010: Subtotals
May 18, 2011
23.
OnHomeandOffice (Video): Microsoft Excel 2010: Worksheets Side by Side
May 18, 2011
24.
OnHomeandOffice (Video): Microsoft Excel 2010: Group Mode
May 18, 2011
25.
OnHomeandOffice (Video): Microsoft Excel 2010: Customize All Future Workbooks
May 18, 2011
26.
OnHomeandOffice (Video): Microsoft Excel 2010: Custom Sorting
May 11, 2011
27.
OnHomeandOffice (Video): Microsoft Excel 2010: Fast Worksheet Copy
May 11, 2011
28.
OnHomeandOffice (Video): Microsoft Excel 2010: Recent Files
May 11, 2011
29.
OnHomeandOffice (Video): Microsoft Excel 2010: Interactive Chart
May 4, 2011
30.
OnHomeandOffice (Video): Microsoft Excel 2010: Chart Templates
May 4, 2011
31.
OnHomeandOffice (Video): Microsoft Excel 2010: Bubble Charts
May 4, 2011
32.
OnHomeandOffice (Video): Microsoft Excel 2010: Combination Chart
May 4, 2011
33.
OnHomeandOffice (Video): Microsoft Excel 2010: Filling 1,2,3
May 4, 2011
34.
OnHomeandOffice (Video): Microsoft Excel 2010: IFERROR
May 4, 2011
35.
OnHomeandOffice (Video): Microsoft Excel 2010: Chart New Data
May 4, 2011
36.
OnHomeandOffice (Video): Microsoft Excel 2010: Sparklines
Apr 26, 2011
37.
OnHomeandOffice (Video): Microsoft Excel 2010: Sparkline Labels
Apr 26, 2011
38.
OnHomeandOffice (Video): Microsoft Excel 2010: SUMIFS
Apr 26, 2011
39.
OnHomeandOffice (Video): Microsoft Excel 2010: Formulas to Values
Apr 26, 2011
40.
OnHomeandOffice (Video): Microsoft Excel 2010: Picture Background Removal
Apr 26, 2011
41.
OnHomeandOffice (Video): IF Formula in Excel - Part 2 (Video)
Mar 4, 2009
42.
OnHomeandOffice (Video): Fill Handle Tricks (Video)
Mar 4, 2009
43.
OnHomeandOffice (Video): Subtotals Part 3 - Format Subtotal Lines (Video)
Mar 4, 2009
44.
OnHomeandOffice (Video): Copy Worksheets by Ctrl+Drag Worksheet Tab & Group Mode (video)
Mar 4, 2009
45.
OnHomeandOffice (Video): See all Formulas in Excel (Video)
Mar 4, 2009
46.
OnHomeandOffice (Video): IF formula in Excel - Part 1 (Video)
Mar 4, 2009
47.
OnHomeandOffice (Video): Converting Live Formulas to Value (Video)
Mar 4, 2009
48.
OnHomeandOffice (Video): Creating a Pivot Table in Excel 2003 (Video)
Mar 4, 2009
49.
OnHomeandOffice (Video): Filter by Selection (Video)
Mar 4, 2009
50.
OnHomeandOffice (Video): What-If Analysis in Excel (Video)
Mar 4, 2009
51.
OnHomeandOffice (Video): Setting up Data for Quick Sorting (Video)
Mar 4, 2009
52.
OnHomeandOffice (Video): VLOOKUP Formulas in Excel - Part 1 (Video)
Mar 4, 2009
53.
OnHomeandOffice (Video): Avoid the AutoSum Icon When Recording a Macro (Video)
Mar 4, 2009
54.
OnHomeandOffice (Video): Subtotals Part 2 - Copy Subtotal Lines (Video)
Mar 4, 2009
55.
OnHomeandOffice (Video): Subtotals Part 1 - Add Subtotals in Seconds (Video)
Mar 4, 2009
56.
OnHomeandOffice (Video): Improve the Fill Handle Using a Custom List (Video)
Mar 4, 2009
57.
OnHomeandOffice (Video): Goal Seek in Excel (Video)
Mar 4, 2009
58.
OnHomeandOffice (Video): Pivot Tables - Summarizing Daily Dates by Months or Years (Video)
Mar 4, 2009
59.
OnHomeandOffice (Video): Three Ways of Entering Formulas in Excel (Video)
Mar 4, 2009
60.
OnHomeandOffice (Video): Pivot Tables - Replicating a Report for Every Customer (Video)
Mar 4, 2009
61.
OnHomeandOffice (Video): Record your First Macro in Excel 2007 (Video)
Mar 4, 2009
62.
OnHomeandOffice (Video): Creating a Pivot Table in Excel 2007 (Video)
Mar 4, 2009
63.
OnHomeandOffice (Video): Discover New Functions in Excel (Video)
Mar 4, 2009
64.
OnHomeandOffice (Video): Ways to Run a Macro (Video)
Mar 4, 2009
65.
OnHomeandOffice (Video): Adding Pivot Table Calculations in Excel 2003 (Video)
Mar 4, 2009
66.
OnHomeandOffice (Video): Changing a Pivot Table in Excel 2007 (Video)
Mar 4, 2009
67.
OnHomeandOffice (Video): Unhide all Worksheets with a Macro (Video)
Mar 4, 2009
68.
OnHomeandOffice (Video): Join Text in One Column with Text in Another Column. Copy a Formula by Double-Clicking the Fill Handle (Video)
Mar 4, 2009
69.
OnHomeandOffice (Video): VLOOKUP Formulas in Excel - Part 2 (Video)
Mar 4, 2009
70.
OnHomeandOffice (Video): Turn a Range on its Side with Paste Special Transpose (Video)
Mar 4, 2009
71.
OnHomeandOffice (Video): Formula Auditing in Excel, Including Evaluate Formula (Video)
Mar 4, 2009
72.
OnHomeandOffice (Video): Pivot Tables - Top 10 Customer Report (Video)
Mar 4, 2009
73.
OnHomeandOffice (Video): Record your First Macro in Excel 2003 (Video)
Mar 4, 2009
74.
OnHomeandOffice (Video): Breaking Apart Text (Video)
Mar 4, 2009
75.
OnHomeandOffice (Video): SUMIF and SUMIFS in Excel (Video)
Mar 4, 2009
76.
OnHomeandOffice (Video): Record a Macro When the Cell Pointer Moves (Video)
Mar 4, 2009
77.
OnHomeandOffice (Video): Pie Chart Tricks (Video)
Mar 3, 2009
78.
OnHomeandOffice (Video): Chart Different Orders of Magnitude on a Chart (Video)
Mar 3, 2009
79.
OnHomeandOffice (Video): Drag and Drop New Data on a Chart (Video)
Mar 3, 2009
80.
OnHomeandOffice (Video): Create a Chart With One Click & Customize by Right Clicking (Video)
Mar 3, 2009

Bill Jelen