MrExcel 2024: Igniting Excel, 7th Edition by Bill Jelen (.ePUB)
File Size: 42.3 MB
MrExcel 2024: Igniting Excel, 7th Edition by Bill Jelen
Requirements: .ePUB reader, 42.3 MB
Overview: 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. 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.
Genre: Non-Fiction > Tech & Devices
Free Download links: