Название: MrExcel 2024: Igniting Excel, 7th EditionАвтор: Bill Jelen
Издательство: Holy Macro! Books, Tickling Keys
Год: 2024
Страниц: 695
Язык: английский
Формат: epub
Размер: 42.3 MB
Excel tips to skyrocket white-collar productivity.
Originally designed for Bill Jelen's live Power Excel seminars, the target audience already uses Excel 40 hours a week. These tips are the "aha" tips that uncover secret methods in Excel. The book covers general Excel functions, pivot tables, and formulas such as VLOOKUP and the new XLOOKUP. It introduces elements of modern Excel such as the Power Pivot Data Model and cleaning data with Power Query.
Simultaneously Edit a Workbook in Microsoft 365: For decades, some people have been wanting a better way to have multiple people in the same workbook at the same time. The old Shared Workbook functionality was awkward. People resorted to "only one person having write access at a time", which led to someone opening the file and then forgetting to close it before going for a two-hour lunch and tying up the file that whole time. After Google's spreadsheet product began offering the ability for multiple people to edit the same worksheet, the Excel team spent many years developing a feature that they call co-authoring. The feature was released to Microsoft 365 customers in the summer of 2017. The feature works great if everyone you are sharing with are on the same tenant.
Build Dashboards with Sparklines and Slicers: New tools debuted in Excel 2010 that let you create interactive dashboards that do not look like Excel. This figure shows an Excel workbook with two slicers, Region and Line, used to filter the data. Also in this figure, pivot charts plus a collection of sparkline charts illustrate sales trends. You can use a setup like this and give your manager’s manager a touch screen. All you have to do is teach people how to use the slicers, and they will be able to use this interactive tool for running reports.
Скачать MrExcel 2024: Igniting Excel, 7th Edition