Excel - Calculator: Episode 1555
1,953 views · Published 29 April 2012 · 2:10 · Indexed 14 November 2026
Channel: MrExcel.com · 2012 · Education
Microsoft Excel Tutorial: Unleashing the Hidden Secrets of the Calculator Utility in Excel | MrExcel Podcast. Welcome to the MrExcel Podcast. In this episode, #1555, we're taking a break from our usual Excel tutorials to explore something a little different - the calculator. That's right, the simple tool we all use for basic math calculations actually has a lot more to offer than we may realize. Join me, Bill Jelen, as I dive into the world of the calculator and discover all of its hidden features. Did you know that in addition to basic arithmetic, the calculator also has functions for scientific calculations, hexadecimal conversions, and even statistics? And that's just the beginning. But wait, there's more! The calculator also has a unit conversion feature, making it easy to convert between different units of measurement. Need to know the temperature in Fahrenheit when it's given in Celsius? No problem, the calculator has you covered. And that's not all - there's also a date calculation feature, perfect for figuring out how many days, weeks, or even years have passed between two dates. But that's not all, folks. The calculator also has a variety of worksheets for tasks such as mortgage calculations, vehicle leases, and fuel economy. And the best part? All of these features are just one button click away on most keyboards. So next time you're in the calculator, take a moment to explore all of its capabilities. You may be surprised by what you find. Thanks for tuning in to this special Sunday edition of the MrExcel Podcast. Don't forget to check out our other episodes for more Excel tips and tricks. See you next time! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Calculator in Excel (00:36) Different types of calculators (00:50) Statistics calculator (01:12) Date calculation and unit conversion (01:39) Worksheets for various calculations (01:50) More than just the usual standard stuff (02:00) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Calculator Date calculation Fuel economy calculator Hexadecimal calculator Mortgage calculator Scientific calculator Statistics calculator Temperature conversion Unit conversion Vehicle lease calculator Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153365/ No...it's not a Learn Excel Podcast about Excel - it's about the Calculator Utility! Have you ever looked at the Toolbar selections? Did you ever wonder why Microsoft has included a 'Help' button for the Calculator? Check out Episode #1555 to learn a little bit more about Calculator from Microsoft. ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! http://www.mrexcel.com/learn2010/LE2010.html "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com for all of your Microsoft Excel Needs!
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920