February 21, 2019 - by Bill Jelen
If you want each report to have the name of the worksheet as a title, use the following formula:
=TRIM(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,20)) &" Report"
Excel 2019: Fast Worksheet Copy »
February 20, 2019 - by Bill Jelen
You can right-click any sheet tab and choose Move or Copy to make a copy of a worksheet. But that is the very slow way to copy a worksheet. The fast way: Hold down the Ctrl key and drag the worksheet tab to the right.
Excel 2019: Fill Jan, Feb, ..., Dec, Total »
February 19, 2019 - by Bill Jelen
While you can edit any custom list that you create, you cannot edit the first four lists in the Custom Lists dialog.
Covering a variety of Excel simulations, from gambling to genetics, this introduction is for people interested in modeling future events, without the cost of an expensive textbook.
Power Pivot for Excel and its close cousin Power BI Desktop are Microsoft’s tightly-related pair of revolutionary analytical tools – tools that are fundamentally changing the way organizations work with data.
Pivot Table Data Crunching: Microsoft Excel 2016 »
Use Excel 2016 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control! Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power.
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.
Supercharge Excel When You Learn to Write DAX For Power Pivot »
Hands-on book to learn and master the DAX language!
Experienced with Excel? Don’t let Excel 2016 make you feel like a beginner again! This new full-color edition of the bestselling book has been completely overhauled. Gone is unnecessary and rarely used content; emphasis is on the most-used and new aspects of Excel 2016.