Excel all-in-one / by David H. Ringstrom, Michael Alexander, Dick Kusleika, Paul McFedries, and Ken Bluttman.
Material type:
TextSeries: --For dummiesPublisher: Hoboken, NJ : John Wiley & Sons, Inc., [2025]Description: xxi, 792 pages : illustrations ; 24 cmContent type: - text
- unmediated
- volume
- 9781394344635
- 1394344635
- Microsoft 365 Excel all-in-one for dummies
- Microsoft Excel all-in-one for dummies
- Excel all-in-one for dummies
- 005.54 23
| Cover image | Item type | Current library | Home library | Collection | Shelving location | Call number | Materials specified | Vol info | URL | Copy number | Status | Notes | Date due | Barcode | Item holds | Item hold queue priority | Course reserves | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BOOK
|
Wasatch County Library Second Floor | General NonFiction | 005.54 Ringstrom (Browse shelf(Opens below)) | Checked out | 05/02/2026 | 34301002178871 |
Includes index.
"All new version"--Cover.
Introduction -- Getting started with Excel. Getting started with spreadsheets ; Carrying out basic calculations ; Formatting cells and worksheets ; Organizing data and creating tables ; Navigating worksheets and workbooks -- Working with formulas and functions. Tapping into formula and function fundamentals ; Saving time with function tools ; Building array formulas and functions ; Fixing errors in formulas -- Goring farther with functions. Calculating loans, interest, and depreciation ; Performing functional math ; Working with date and time functions ; Manipulating text with functions -- Analyzing data. Using basic data analysis techniques ; Working with data analysis tools ; Analyzing table data with functions -- Summarizing, visualizing, and illustrating data. Creating charts ; Creating and using PivotTables ; Performing PivotTable calculations ; Building PivotCharts -- Reporting and querying data. Introducing Power Pivot ; Advanced moves with PivotTables ; Working directly with internal data model ; Adding formulas to Power Pivot ; Meeting Power Query and its connection types -- Creating dashboards and reports. Getting in the dashboard state of mind ; Building a super model ; Dressing up your data tables ; Formatting your way to visualizations ; Displaying performance against a target -- Automating Excel with macros and VBA. Macro fundamentals ; Getting cozy with Visual Basic Editor ; The anatomy of macros ; Working with workbooks -- Index.
"Get a grip on the most essential features in the application, including built in templates, formulas, and PivotTables. You'll also learn how to make your data accessible with charts and graphics"--