Listing 1 - 10 of 308 | << page >> |
Sort by
|
Choose an application
Choose an application
Choose an application
Choose an application
Choose an application
Choose an application
Choose an application
Choose an application
This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, "MrExcel," and Oz do Soleil during their careers run as a financial analyst charged with taking mainframe data and turning it into useful information quickly. Topics include data quality, validation, perfectly sorting with one click every time, matching lists of data, data consolidation, data subtotals, pivot tables, pivot charts, tables and much more.
Choose an application
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. Updated annually, this edition for 2022 adds information on collaboration features, LET and LAMBDA functions, amazing new data types, dynamic array formulas, and more.
Choose an application
Quick and easy 6 page laminated guide loaded with essential functions and how to perform them in Excel 365 (and Excel 2019). Beginners and experienced users, can find hundreds of the most popular and useful functions fast with clear succinct steps to get the task done. Curtis Frye, author of multiple books on Excel, creator of many Lynda.com videos and an experienced corporate trainer used his experience and knowledge to cover the most relevant functions for users at different levels. Look for Excel 365, Excel 365 "Tips and Tricks", "Formulas" and "Pivot Tables" QuickStudy guides to have a complete power-user reference set.6 page laminated reference guide includes:Conditional FormatsHighlighting RulesData Bar, Color Scale & Icon Set FormatsManaging Conditional FormatsFiler Data Using SlicersWhat-If AnalysisAnalyzing Data Using ScenariosCalculating Alternatives Using Data TablesCalculating Target Values Using Goal SeekFinding Optimal Values Using SolverPivot Tables & Pivot ChartsTimelinesExcel Data ModelData ValidationSparklinesSuggested uses:Workspace - flat for easy storage and access at a moments notice to find a function you need to use, or to jog your memory for a function you do not use oftenCompany Training - reduce help-desk calls and keep productivity flowing for a team or for your entire companyStudents/Professors - make lives easier for students in many majors needing Excel for data management and calculation
Listing 1 - 10 of 308 | << page >> |
Sort by
|