June 29, 2020 - by Bill Jelen
A new STOCKHISTORY function debuted in the beta channel of Excel for Office 365 last week. The function is able to pull historical stock prices and exchange rates at a daily, weekly or monthly interval.
STOCKHISTORY is an example of one of the new Dynamic Array formulas. A single formula will spill into adajent cells. For an overview of Dynamic Arrays, read Excel 2019: Dynamic Arrays Can Spill article.
Walk / Ride / Run #ForSmitty This Week »
June 23, 2020 - by Bill Jelen
Our good friend Chris “Smitty” Smith is in hospice this week, after a three year battle with cancer. I met Smitty when he was in the process of writing 29,536 answers at the MrExcel Message Board. Smitty became a Microsoft MVP for many years. He then actually joined the Excel team, and worked on cleaning up the Excel Help files.
What Is The Difference Between Microsoft Office Classic and Premium »
June 15, 2020 - by Bill Jelen
The retail box for Microsoft Office 2019 Home & Student makes it clear that you are not getting Outlook, Access or Publisher when you buy Excel 2019. But in the feature description for Word, Excel, Power Point and OneNote it says that you are getting “Classic” instead of “Premium”. What does that really mean?
Excel Custom Functions Straight to the Point »
Excel Custom Functions can be used like any other native functions or user defined functions in Excel. This book shows the process of creating Excel Custom Functions.
Power Excel With MrExcel - 2019 Edition »
This is the print book edition of "Power Excel with MrExcel - 2019 Edition" - by Bill Jelen. Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis.
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 »
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.
Microsoft Excel 2019 Pivot Table Data Crunching »
Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365.
Excel Dynamic Arrays Straight to the Point 2nd Edition »
Fifteen months after Dynamic Arrays debuted for Office Insiders, the functions are being released to General Availability. This second edition of the book has been updated with new examples: see how Dynamic Arrays make XLOOKUP better. The chapter on the logic behind arrays has been expanded.