Catalog Search Results
Author
Publisher
Holy Macro! Books
Pub. Date
2022.
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," 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,...
Author
Publisher
Holy Macro! Books
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, 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,...
Author
Publisher
Holy Macro! Books
Pub. Date
[2018]
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
Publisher
Holy Macro! Books
Pub. Date
2022.
Language
English
Description
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...
Author
Publisher
Holy Macro! Books
Pub. Date
[2018]
Language
English
Description
Are you tired of tracking financial elements of your business manually, do you have to prepare staffing schedules by hand, or do you simply want to know how to get more information from your business data? Learn how to harness your business data and put it to use for you. Learn the basics of Excel, including a comprehensive review of every tab of the Excel Ribbon. See how to best display your data for maximum impact with formatting tools, Data Tables,...
Author
Publisher
Holy Macro! Books
Pub. Date
2019.
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
Publisher
Holy Macro! Books
Pub. Date
[2020]
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."--
Author
Publisher
Holy Macro! Books
Pub. Date
[2015]
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...
11) Cool Excel Sh*t
Author
Publisher
Holy Macro! Books
Pub. Date
[2021]
Language
English
Description
"Cool Excel Sh*t 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 50 techniques, formulas, dynamic arrays, and VBA macros, this guide details processes that may be used in any application and across all disciplines. Includes a section on techniques using Dynamic Arrays in Excel."--
Author
Publisher
Holy Macro! Books
Pub. Date
[2016]
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
2013.
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
Publisher
Holy Macro! Books
Pub. Date
[2019]
Language
English
Description
Excel users are used to build custom functions-called user-defined functions (UDFs)-in Windows and Mac versions of the application. UDFs can be simply written in Visual Basic Editor (VBE) using the Visual Basic for Applications (VBA) language. UDFs are not portable to Excel Online and Excel for iOS due to the missing VBA capability on these platforms. Therefore, Microsoft has improved the JavaScript API that was already being used for Office add-in...
Author
Publisher
Holy Macro! Books
Pub. Date
[2015]
Language
English
Description
Power Query is one component of the Power BI (Business Intelligence) product from Microsoft, and M" is the name of the programming language created by it. As more business intelligence pros begin using Power Pivot, they find that they do not have the Excel skills to clean the data in Excel; Power Query solves this problem. This book shows how to use the Power Query tool to get difficult data sets into both Excel and Power Pivot, and is solely devoted...
Author
Publisher
Holy Macro! Books
Pub. Date
2011.
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
2012.
Language
English
Description
VLOOKUP is a function in Excel that enables people to use Excel like a database, joining data on different worksheets. VLOOKUP Awesome Quick is an ehnanced eBook designed to get the reader up to speed with the VLOOKUP function in Excel. The book starts with the basics of "Explain a VLOOKUP in plain English", "How to Enter Your First VLOOKUP", how to troubleshoot VLOOKUP when you get all #N/A or a few #N/A errors. Steps to make VLOOKUP easier. Real-life...
18) Slaying Excel Dragons: A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun
Author
Publisher
Holy Macro! Books
Pub. Date
2011.
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
Publisher
Holy Macro! Books
Pub. Date
[2019]
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 headersDeleting summary rowsFilling in gapsFlattening a reportMerging and appending data from multiple sourcesPulling data from source X...
Author
Publisher
Holy Macro! Books
Pub. Date
2013.
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...
Didn't find it?
Can't find what you are looking for? Try our Materials Request Service. Submit Request