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
Designed with the Excel guru in mind, this handbook introduces advanced and creative solutions, and hacks to the software's most challenging problems. Through a series of more than 50 techniques, tables, formulas, and charts, this guide details processes that may be used in any Excel application, across all disciplines. Creative approaches for building formulas within formulas, pivot tables, conditional formatting, and mastering array formulas are...
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...
Author
Language
English
Description
These are the 125 essential tips that all Excel users need to know. MrExcel LX provides users with a concise book that can be absorbed in under two hours. 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
Covering a variety of Excel simulations, from gambling to genetics, this introduction is for people interested in modeling future events, without the cost of an expensive textbook. The simulations covered offer a fun alternative to the usual Excel topics and include situations such as roulette, password cracking, sex determination, population growth, and traffic patterns, among many others.
Author
Language
English
Description
The 40 essential tips that all Excel users need to know Crowdsourced by more than 300 contributors who collaborated on choosing the 40 best Excel tips, MrExcel XL provides users with a concise book that can be absorbed in under an hour. Each tip is explained with text, screenshots, and a custom illustration. 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
Containing 277 business case studies that illustrate nearly every aspect of Excel, this book presents real-life business problems and works them through to their solutions. In addition to exemplary solutions, each case analysis considers alternate approaches and gotchas, and includes a summary of the necessary commands and functions. Excel files that can be downloaded and worked through step-by-step are included for each case.
Author
Language
English
Description
This Tableau training manual contains 300+ images and 25,000 words which are segmented into eight (8) sections. To complement the written word in the manual, the author has provided URLs in this digital manual which enable the buyer to download eight (8) Tableau Packaged Workbooks - These are actual software examples that reflect the outcome of each lesson. The manual is written in narrative form and progresses from connecting to data to sophisticated...
Author
Language
English
Description
Microsoft Excel is one of the most powerful tools a business owner, manager, or new employee has at their disposal, and this guide teaches how to harness business data and put it to use. Using real-world examples of a small business in operation, the book covers topics such as preparing financial statements, how to best display data for maximum impact with formatting tools, data tables, charts and pivot tables, using customer information to create...
Author
Language
English
Description
Updating the previous edition's tips to make them compatible with Excel 2007, and featuring new tips that are only available in Excel 2007, 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...
Author
Language
English
Description
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," during his 10-year run as a financial analyst charged with taking mainframe data and turning it into useful information quickly. Topics include perfectly sorting with one click every time, matching lists of data, data consolidation, data subtotals, pivot tables, and much more.
Author
Language
English
Description
Written in a question-and-answer format, this lowest-level beginner book covers the extreme basics of using spreadsheets in Excel. Instead of delving into advanced topics that scare most Excel novices away, the guide starts at a much more basic level, quickly providing a passable knowledge of the program and allowing users to overcome their fears and frustrations. It answers hundreds of common questions, including Can I delete data from a spreadsheet...
Author
Language
English
Description
This Excel user's guide to VSTO-the new Excel Macro programming language being promoted by Microsoft-shows how to perform the equivalent VBA actions with VSTO. The differences between the VSTO and VBA development environments are explained, helping Excel users decide if they should embrace VSTO or seek out other technologies.
Author
Series
Language
English
Description
Written specifically for finance managers, Excel for the CFO explains the best features of Excel that allow for the automation of regular processes and help reduce the processing time spent on analytics. The book explores the entire gamut of finance-related functions and is focused on practical approaches to using Excel-including Pivot Tables, Goal Seek, Scenario Builder, and VBA-in problem solving to deliver quality results. Using case studies across...
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