MrExcel Publishing
Your One Stop for Excel Tips & Solutions
Microsoft MVP

Excel 2019: Discover New Functions by Using fx

July 18, 2019 - by Bill Jelen

Discover New Functions by Using fx. Photo Credit: David Blume at Unsplash.com

There are 400+ functions in Excel. Instead of taking 450 pages to describe every function, I am going to teach you how to find the function that you need.

The Excel 2007 formulas tab introduced a huge fx Insert Function icon. But you don’t need to use the one on the Formulas tab; the same icon has been to the left of the formula bar ever since I can remember.

A simple model to calculate a car payment. The principal of 25995 is in B1. The Term of 60 months in B2. The interest rate of 5.25% in B3. The payment cell of B5 is selected. You can either choose Insert Function on the Formulas tab, or click the small script fx to the left of the formula bar.

If you are trying to figure out how to calculate a loan payment, the Insert Function dialog will help. Click the icon next to the formula bar. In the Search for a Function box, type what you are trying to do. Click Go. The Select a Function box shows functions related to your search term. Click on a function in that box to see the description at the bottom of the dialog.

continue reading »

More Reading

Audit a Worksheet With Spreadsheet Inquire. Photo Credit: Michael Rodock at Unsplash.com

Excel 2019: Audit a Worksheet With Spreadsheet Inquire »

July 17, 2019 - by Bill Jelen

Inquire was developed by a company called Prodiance that offered the slick Spreadsheet Compare tool for $145 per person per year. The Excel team liked it so much that Microsoft bought out Prodiance and gave the tool for free to anyone who is on Pro Plus, Professional Plus, or Enterprise Level E3.

Excel See Which Cells Depend on the Current Cell. Photo Credit: Edgar Castrejon at Unsplash.com

Excel 2019: See Which Cells Depend on the Current Cell »

July 15, 2019 - by Bill Jelen

I previously explained how to Trace Precedents to See What Cells Flow into a Formula. Sometimes you have the opposite problem: You want to see which cells rely on the value in the current cell.

read more articles »

IMA Data Analytics Leveraging Excel

Featured Products

Microsoft Excel 2019 Inside Out

Microsoft Excel 2019 Inside Out »

Dive into Microsoft Excel 2019–and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to make the most of Excel’s most powerful tools for analyzing data and making better decisions.

Cleaning Excel Data With Power Query Straight To The Point

Cleaning Excel Data With Power Query Straight To The Point »

This book provides a quick Straight-to-the-Point introduction to Power Query. There’s a lot here, and there’s also a lot that’s not here. Reading this book will be like sitting down at a café and striking up a conversation with the person at the next table, where you learn enough random stuff about that person to decide if you want to know more and keep in touch.

Excel Dynamic Arrays Straight to the Point

Excel Dynamic Arrays Straight to the Point »

The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.

Excel Subtotals Straight to the Point

Excel Subtotals Straight to the Point »

I used to use the Subtotals feature daily after downloading mainframe data. This book covers every tip and trick for using Subtotals.

Excel JavaScript UDFs Straight to the Point

Excel JavaScript UDFs Straight to the Point »

JavaScript custom functions - UDFs can be used like any other native functions or UDFs in Excel. This book shows the process of creating JavaScript UDFs in Excel Developer Preview for Office Insider program subscribers.

The Absolute Guide to Dashboarding & Reporting with Power BI

The Absolute Guide to Dashboarding & Reporting with Power BI »

Learn Power BI Dashboarding Techniques by Watching A Pro!

see more products »