December 24, 2020 - by Bill Jelen
Consider a few of these settings after you choose File, Options:
General, Start Up Options, Unselect Show The Start Screen When This Application Starts to skip the Home screen. Excel will open directly to a blank workbook. (Thanks to Dave Marriott)
Excel 2020: Create Your Own QAT Routines Using VBA Macros »
December 23, 2020 - by Bill Jelen
There are several short macros you can add to your Personal Macro Workbook and then add to the QAT. In this tip, you will see how to create the Personal Macro Workbook, type some macros, and then assign them to icons on the QAT.
Excel 2020: Customize the Quick Access Toolbar »
December 16, 2020 - by Bill Jelen
Even though the Excel team does not think many features are Home-tab-worthy, you can add your favorite features to the Quick Access Toolbar (QAT).
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.
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 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.
Microsoft Excel 2019 VBA and Macros »
Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won’t find anywhere else, and create automated reports that are amazingly powerful.
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.
Excel 2019 Business Basics & Beyond »
Are you tired of tracking financial elements of your business manually, do you have to prepare staffing schedules by hand, or do you simply want to know how to get more information from your business data? Learn how to harness your business data and put it to use for you.