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.

Products

Articles

Podcasts

1.	Creating Charts in Excel 2013 That Show Trends May 3, 2013
2.	Customizing an Excel 2013 Pivot Table Mar 12, 2013
3.	Excel 2013 VBA and Macros: Referring to Ranges Feb 21, 2013
4.	Using the Excel 2013 Interface Feb 20, 2013
5.	Creating Microsoft Excel Charts That Show Trends Nov 29, 2010
6.	Unleash the Power of Excel with VBA Aug 5, 2010
7.	Microsoft Excel 2010 Keyboard Shortcuts Jul 29, 2010
8.	The Promise of PowerPivot in Excel 2010 Jul 27, 2010
9.	Creating Excel 2007 Charts That Show Trends Mar 26, 2008
10.	Customizing an Excel 2007 Pivot Table Apr 6, 2007
11.	The Mini Toolbar and Other Excel 2007 U.I. Improvements Feb 2, 2007
12.	Customizing Fields in a Pivot Table Jul 15, 2005
13.	Referring to Excel Ranges Jul 2, 2004

1.		Excel PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel LiveLessons (Video Training) By Bill Jelen $119.99
2.		Power Excel 2013 with MrExcel LiveLessons (Video Training) , Downloadable Version By Bill Jelen $39.99
3.		Excel 2013 Charts and Graphs By Bill Jelen $25.59
4.		Excel 2013 Charts and Graphs By Bill Jelen $31.99
5.		Excel 2013 VBA and Macros By Bill Jelen, Tracy Syrstad $31.99
6.		Excel 2013 VBA and Macros By Bill Jelen, Tracy Syrstad $25.59
7.		Excel 2013 In Depth By Bill Jelen $39.99
8.		Excel 2013 Pivot Table Data Crunching By Bill Jelen, Michael Alexander $31.99
9.		Excel 2013 In Depth By Bill Jelen $31.99
10.		Excel 2013 Pivot Table Data Crunching By Bill Jelen, Michael Alexander $25.59
11.		Pivot Table Data Crunching: Microsoft Excel 2010 By Bill Jelen, Michael Alexander $27.99
12.		Pivot Table Data Crunching: Microsoft Excel 2010 By Bill Jelen, Michael Alexander $22.39
13.		Power Excel 2010 with MrExcel LiveLessons (Video Training) By Bill Jelen $31.99
14.		Charts and Graphs: Microsoft Excel 2010 By Bill Jelen $31.99
15.		Power Excel 2010 with MrExcel LiveLessons, Downloadable Version By Bill Jelen $31.99
16.		Charts and Graphs: Microsoft Excel 2010, Portable Documents By Bill Jelen $25.59
17.		Microsoft Excel 2010 In Depth By Bill Jelen $25.59
18.		Microsoft Excel 2010 In Depth By Bill Jelen $31.99
19.		VBA and Macros: Microsoft Excel 2010 By Bill Jelen, Tracy Syrstad $31.99
20.		VBA and Macros: Microsoft Excel 2010 By Bill Jelen, Tracy Syrstad $25.59
21.		PowerPivot for the Data Analyst: Microsoft Excel 2010 By Bill Jelen $22.39
22.		PowerPivot for the Data Analyst: Microsoft Excel 2010 By Bill Jelen $27.99
23.		Excel VBA and Macros with MrExcel LiveLessons (Video Training) By Bill Jelen $39.99
24.		Excel VBA and Macros with MrExcel LiveLessons (Video Training), (Downloadable Video) By Bill Jelen $39.99
25.		Power Excel 2007 with MrExcel (Video Training) By Bill Jelen $31.99
26.		Power Excel 2007 with MrExcel LiveLessons (Video Training), (Downloadable Video) By Bill Jelen $31.99
27.		VBA and Macros for Microsoft Office Excel 2007 By Bill Jelen, Tracy Syrstad $31.99
28.		VBA and Macros for Microsoft Office Excel 2007 (Adobe Reader) By Bill Jelen, Tracy Syrstad $25.59
29.		Charts and Graphs for Microsoft Office Excel 2007 By Bill Jelen $31.99
30.		Charts and Graphs for Microsoft Office Excel 2007 (Adobe Reader) By Bill Jelen $25.59
31.		Pivot Table Data Crunching for Microsoft Office Excel 2007 By Bill Jelen, Michael Alexander $27.99
32.		Pivot Table Data Crunching for Microsoft Office Excel 2007 By Bill Jelen, Michael Alexander $22.39
33.		Special Edition Using Microsoft Office Excel 2007 By Bill Jelen $31.99
34.		Special Edition Using Microsoft Office Excel 2007 (Adobe Reader) By Bill Jelen $25.59
35.		Leveraging SmartArt Graphics in the 2007 Microsoft Office System: Using Office 2007's New Business Diagramming Tools (Digital Short Cut) By Bill Jelen $14.99
36.		Pivot Table Data Crunching By Bill Jelen, Michael Alexander $31.99
37.		Pivot Table Data Crunching (Adobe Reader) By Bill Jelen, Michael Alexander $22.39
38.		VBA and Macros for Microsoft Excel By Bill Jelen, Tracy Syrstad $35.99
39.		VBA and Macros for Microsoft Excel, Adobe Reader By Bill Jelen, Tracy Syrstad $25.59

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