Catalog Search Results
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
Publisher
Holy Macro! Books
Pub. Date
2016.
Physical Desc
1 online resource (213 pages)
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. --Provided by publisher.
Author
Series
Publisher
Holy Macro! Books
Pub. Date
2014.
Physical Desc
1 online resource (250 pages)
Language
English
Description
Top-level training tailored to specific needs. 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...
Author
Publisher
Holy Macro! Books
Pub. Date
2011.
Physical Desc
1 online resource (827 pages)
Language
English
Description
"Updating the previous edition's tips to make them compatible with Excel 2010, and featuring tips that are only available in Excel 2010, 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
Publisher
Holy Macro! Books
Pub. Date
2013.
Physical Desc
1 online resource (180 pages)
Language
English
Description
Exciting Excel for everyday usage. 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.--Provided by the publisher....
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...
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
"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. * * Please...
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
Tips and tricks for analyzing big data. 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...
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...
Author
Series
Language
English
Description
"Providing the tools and techniques necessary for finding errors and fraud in audits, this guide for auditors looking to better validate their Microsoft Excel spreadsheets provides techniques for performing a risk assessment and gathering spreadsheet and other data from company systems. Performing audit data analysis using data and analytical management functions and pinpointing the common errors in spreadsheets with focused Excel tests is discussed,...
Author
Language
English
Description
"This updated edition of Excel 2007 Miracles Made Easy features the amazing new upgrades offered in Excel 2010 and prepares users to transition to it. Covering only the revised components in Excel 2010, this manual shows how to navigate the ribbon interface and leverage the new business-intelligence tools within. With information on everything from using pivot tables to calculating Texas Hold 'Em probabilities, this indispensable reference features...
14) Slaying Excel Dragons: A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun
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
"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
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. --Provided by publisher.
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
"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
"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
You have just been promoted into a job that requires more Excel skills than ever. You are floundering, drowning in a sea of spreadsheets. This book walks you through the program in an accessible way-everything from vlookups, pivot tables, and Power Query to Power BI and Power Pivot. The Excel Survival Kit is small enough to slip into your purse and carry with you to the office.
Didn't find it?
Can't find what you are looking for? Try our Materials Request Service. Submit Request