Catalog Search Results
Author
Series
Language
English
Description
This book completely and thoroughly covers every trick known about Subtotals in Excel. You will learn: How to get your data ready for subtotals, Adding Subtotals, Showing only the Subtotals, Sorting Subtotals, Formatting Subtotals, Subtotal Tricks, Subtotal Troubleshooting, Using the SUBTOTAL function without using the Subtotal command, using AGGREGATE, Creating Subtotals with VBA, Replacing Subtotals with Power Query.
Author
Language
English
Description
Updating the previous edition's tips to include features in Excel 2016, this new edition of MrExcel's popular software guide even incorporates suggestions sent in by readers. Each featured topic has a problem statement and description, followed by a broad strategy for solving the problem. MrExcel then walks readers through the specific steps to solve the issue. Alternate strategies are also provided, along with common scenarios that trip users up,...
Author
Series
Language
English
Description
Addressing a classroom teacher's need to simultaneous manage a classroom full of students, meet state mandated assessment standards for students, and track students' performance against a rubric, this overview of Excel shows how to put its features to use immediately in a classroom. Tracking attendance, grades, and books in the school library, creating reports to share with parents at parent-teacher conference time, and teaching basic charting concepts...
Author
Series
Language
English
Description
With examples from the world of science and engineering, this reference teaches scientists how to create graphs, analyze statistics and regressions, and plot and organize scientific data. Physicists and engineers can learn the tips and techniques of Excel-and tailor them specifically to their experiments, designs, and research. They will learn when to use NORMDIST vs NORMSDist and CONFIDENCE vs Z, how to keep data-validation lists on a hidden worksheet,...
6) Spreadsheet at 25: 25 Amazing Excel Examples that Evolved from the Invention that Changed the World
Author
Language
English
Description
From the 1979 invention by two MIT students of the visible calculator to the war between Lotus and Microsoft for dominance in the spreadsheet market, this book is a fascinating look at the software application that helped spur the entire computer industry. This loving look back at the early computer and technology evolution will teach anyone interested in computer history about the MIT students, Bricklin and Frankston, and their unique vision; how...
Author
Language
English
Description
This enthusiastic introduction provides support for Excel beginners and focuses on using the program immediately for maximum efficiency. With 1,104 screenshots and explicit information on everything from rows, columns, and cells to subtotaling, sorting, and pivot tables, this guide aims to alleviate the frustrations that come with using the program for the first time. This manual offers strategies for avoiding problems and streamlining efficiency...
Author
Language
English
Description
The 54 essential tips that all Excel users need to know. MrExcel LIVe provides users with a concise book that can be absorbed in under an hour. Includes a section with keyboard shortcuts. Anyone who uses Excel will be able to turn to any page and pick up tips that will save them hours of work.
Author
Language
English
Description
A follow-up to Excel Outside the Box, More Excel Outside the Box is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software's most challenging problems. Through a series of more than 30 techniques, tables, formulas, and charts, this guide details processes that may be used in any Excel application and across all disciplines. Creative approaches for building formulas within formulas, pivot tables, conditional...
Author
Language
English
Description
Drawn from actual excel conundrums posted on the author's website, www.mrexcel.com, this high-level resource is designed for people who want to stretch Excel to its limits. Tips for solving 100 incredibly difficult problems are covered in depth and include extracting the first letter of each word in a paragraph, validating URL's, generating random numbers without repeating, and hiding rows if cells are empty. The answers to these and other questions...
11) Excel 2007 Miracles Made Easy: Mr. Excel Reveals 25 Amazing Things You Can Do with the New Excel
Author
Language
English
Description
In this addendum to Learn Excel from Mr. Excel, the amazing new features offered in Excel 2007 are introduced. Revealing the features that make this new version the best new release of Excel since 1997, this guide provides the necessary information to teach users to quickly unleash the powerful new features in Excel 2007, create incredible-looking charts, customize color themes to match their corporate logo, utilize data-visualization tools, and learn...
Author
Language
English
Description
Updating the previous edition's tips to include features in Excel 2013, this new edition of Mr. Excel's popular software guide even incorporates suggestions sent in by readers. Each featured topic has a problem statement and description, followed by a broad strategy for solving the problem. Mr. Excel then walks readers through the specific steps to solve the issue. Alternate strategies are also provided, along with common scenarios that trip users...
Author
Series
Language
English
Description
New for Office 365 customers, one single formula sitting in one single cell can return many results. Those extra results will spill into adjacent cells. This is a major change to the calculation engine in Excel. This book covers the new functions added for Dynamic Arrays: SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY. It shows how Dynamic Arrays make the new XLOOKUP even more powerful. Dynamic arrays make every Excel calculation function more...
Author
Series
Language
English
Description
The most powerful Microsoft Excel features that can be used to sort through data to produce meaningful marketing analyses are outlined in this manual. Marketing managers will learn the math functions to produce budgets and forecasts, and how to use survey analysis to quickly spot trends using pivot tables and other analysis tools. Ideas for launch schedules, life cycle management, and other date-related information are also presented.
Author
Series
Language
English
Description
With examples from the world of science, this reference teaches scientists how to create graphs, analyze statistics and regressions, and plot and organize scientific data. Scientists can learn the tips and techniques of Excel-and tailor them specifically to their experiments, designs, and research. They will learn when to use NORMDIST vs NORMSDist and CONFIDENCE vs Z, how to keep data-validation lists on a hidden worksheet, use pivot tables to chart...
Author
Language
English
Description
Updating the previous edition's tips to include features in Office 365 and Excel 2019, this new edition of MrExcel's popular software guide even incorporates suggestions sent in by readers. Each featured topic has a problem statement and description, followed by a broad strategy for solving the problem. MrExcel then walks readers through the specific steps to solve the issue. Alternate strategies are also provided, along with common scenarios that...
Author
Language
English
Description
Rob Collie (PowerPivotPro) and Bill Jelen (MrExcel) join forces in this combined sequel to their best-selling Power Pivot books. Alchemy sets aside the fundamentals of past books and provides a series of practical, easy-to-follow "patterns" for dozens of common analysis, reporting, and dashboarding needs. Three "bonus" chapters introduce you to the newer members of the "Power BI" family – Power Query, Power View, and Power Map. Whether you are...
Author
Language
English
Description
Designed with Excel gurus in mind, this handbook outlines how to create formulas that can be used to solve everyday problems with a series of data values that standard Excel formulas cannot or would be too arduous to attempt. Beginning with an introduction to array formulas, this manual examines topics such as how they differ from ordinary formulas, the benefits and drawbacks of their use, functions that can and cannot handle array calculations, and...
Author
Language
English
Description
This Straight to the Point guide provides an introduction to data cleansing, which also goes by names such as data munging and data wrangling. Whatever the name, it basically means doing what needs to be done to make data useful and trustworthy. Data cleansing can include the following tasks: Deleting unnecessary headers, Deleting summary rows, Filling in gaps, Flattening a report, Merging and appending data from multiple sources. Pulling data from...
In Interlibrary Loan
Didn't find what you need? Items not owned by Pueblo Library can be requested from other Interlibrary Loan libraries to be delivered to your local library for pickup.
Didn't find it?
Can't find what you are looking for? Try our Materials Request Service. Submit Request