mysteries impossible livelessons spreadsheets

books:

Charts and Graphs for Microsoft Office Excel 2007 (Business Solutions)

2 reviews
Bill Jelen

Que, 2007

Wonderful way to discover excel 2007's charts & drawing tools
I bought this book as soon as it was available, since I know Bill Jelen personally and know his great talent for teaching. I learned quite a bit from this book, often wondering "How the heck did he ever find THIS trick?" I probably learned about Excel 2007 charts the same time Bill did, but he became the instant expert, and with so many interesting examples and figures, it's easy & fun to learn. ...

Special Edition Using Microsoft(R) Office Excel 2007

5 reviews
Bill Jelen

Que, 2006

Everything there is to know about Excel 2007
Excel 2007 is a fairly major rewrite of the old Excel that we all came to know and love. The old Excel, whether it was Excel 97, 2000, XP, or 2003 was pretty much the same program. It had just about the same look and feel. To be sure Microsoft marketing made lots of smoke about the new features in each edition, but in reality there wasn't much fire behind that smoke. With Excel 2007 there are ...

Pivot Table Data Crunching (Business Solutions)

24 reviews
Bill Jelen, Michael Alexander

Que, 2005

Pivot tables - to know them is to love them
Accountants, sales managers, and everybody who uses Excel for data analysis: Listen up! Learn to use pivot tables, you just gotta! You will be able to slice, dice, and mince your data in a few minutes instead of hours. Forget fiddling around with sorting, subtotaling, linking cells, and the general time-consuming stuff that goes into report generation. This book is a good, ...

VBA and Macros for Microsoft Excel (Business Solutions)

18 reviews
Bill Jelen, Tracy Syrstad

Que, 2004

Excellent
I recommend this book for anyone who uses VBA to automate tasks. This book advanced my self-taught trial and error skills immensely and I use the techniques daily.

VBA and Macros for Microsoft Office Excel 2007 (Business Solutions)

1 review
Bill Jelen, Tracy Syrstad

Que, 2007

Excellent Excel/VBA resource
This book was very helpful for some projects that I needed to accomplish with Excel & VBA. Some of the chapters were extremely enlightening in seeing the big picture of using VBA with Excel and other MS Office applications. Other chapters are excellent resources that I will refer to many times in the future. I would recommend this book for both the beginner (in using VBA) as well as the ...

Pivot Table Data Crunching for Microsoft Office Excel 2007 (Business Solutions)

7 reviews
Bill Jelen, Michael Alexander

Que, 2007

Great stuff
This book helped tremendously during my early stages using PT, without a doubt I would recommend this book to someone who just started to incorporate Pivot Table into their work. One recommendation, It would be nice if a CD with all the work examples came with the book, unfortunately you have to download the example files from a website.

Power Excel 2007 with MrExcel (Video Training) (LiveLessons)
Bill Jelen

Que, 2008

Power Excel 2007 with MrExcel Mastering the Smartest, Fastest Ways to Use Excel 2007 Bill Jelen For anyone who wants to get more done in less time with Excel 2007?from entrepreneurs to financial analysts, marketers to office managers! Bill Jelen (?MrExcel?) presents focused, practical videos that teach you Excel 2007?s best new techniques: supercharged solutions for charting, calculating, formatting, data analysis, ...

Learn Excel 97 Through Excel 2007 from Mr. Excel: 377 Excel Mysteries Solved!
Bill Jelen

Holy Macro! Books, 2007

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 through the specific steps to solve the ...

Guerilla Data Analysis Using Microsoft Excel

11 reviews
Bill Jelen

Holy Macro! Books, 2002

Great quick reference
I have been using Excel for years doing data analysis and charting. I found the short, easy to understand write up on Pivot tables worth the price of the book. Plus there are dozens of other tips that have already made me more productive.

Power One Note: Unleash the Power of One Note

3 reviews
Kathy Jacobs, Bill Jelen

Holy Macro! Books, 2004

Very good book: Has SP1 info for OneNote
This is a very good book on OneNote! If you have OneNote you should get this book. It is the only book about OneNote that I am aware of that has been written with the SP1 enhancements in mind. Whole chapters were added to cover new SP1 features. The book has a chapter on the live interactive sharing of notes over a network. There is a chapter on controlling OneNote programmatically ...

Excel 2007 Miracles Made Easy: Mr. Excel Reveals 25 Amazing Things You Can Do with the New Excel

5 reviews
Bill Jelen

Holy Macro! Books, 2007

A Book on What's New In Excel 2007
I think there are two reasons for buying a book on Excel 2007. First, of coure, is if you are new to Excel. I suppose that there are some people out there who don't know Excel. If you're one of these, this is not the book for you. Second, and I expect far more common comes in two versions. (1) you know and use Excel and are wondering if it is worth while to spend the money to pay for an ...

Excel Gurus Gone Wild: Do the IMPOSSIBLE with Microsoft Excel
Bill Jelen

Holy Macro! Books, 2008

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 ...

Excel for Marketing Managers (Excel for Professionals series)
Ivana Taylor, Bill Jelen

Holy Macro! Books, 2006

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.

Mr Excel ON EXCEL: Excel 97, 2000, 2002

25 reviews
Joseph Rubin, Bill Jelen

Holy Macro! Books, 2003

Better reference guide than tutorial
This book, errors and all, can be used very effectively as a reference guide and for problem solving on occasion. As a tutorial this book suffers from poor organization and scenario development. The overall impression is that you are never quite sure of what you are doing - or why - until you have finished. Look at this book for tips and tricks - learn Excel somewhere else.

Power Excel 2003 with MrExcel (Video Training) (LiveLessons)
Bill Jelen

Que, 2008

<>Power Excel 2003 with MrExcel LiveLessons Mastering the Smartest, Fastest Ways to Use Excel Bill Jelen DVD includes: 6+ hours of video instruction More than 80 tips and techniques Features that can be learned in less than Five minutes Bill Jelen (?MrExcel?) presents focused, practical videos that teach you powerful new ways to chart, calculate, build PivotTables, automate workbooks, wrangle your data, and more! ...

Excel for Auditors: Audit Spreadsheets Using Excel 97 through Excel 2007 (Excel for Professionals series)

2 reviews
Bill Jelen, Dwayne K. Dowell

Holy Macro! Books, 2006

Especially for Auditors Who Already Use Excel
The use of Excel for performing accounting tupe applications is well known and straight forward. In auditing, however, the straight addition type functions that work well in accounting are not adequate. In auditing you need to look at data in many different ways to try to find anomolies (or since Sarbanes-Oxley, fraud) in the financial statements. This book is intended for Auditors (but I bet ...

Holy Macro! It's 2,500 Excel VBA Examples: Every Snippet of Excel VBA Code You'll Ever Need

2 reviews
Hans Herber, Bill Jelen, ...

Holy Macro! Books, 2006

Holy Macro! It's 2,500 Excel VBA Examples: Every Snippet of Excel VBA Code You'll Ever Need
I would like to type my review about the mentioned book I bought 2 months ago, but I haven't received this book. Can someone help me? I'd like to know when I receive this book. Thank you!!!!

Excel for Teachers (Excel for Professionals series)
Colleen Conmy, Bill Jelen, ...

Holy Macro! Books, 2006

Addressing a classroom teacher's need to simultaneously 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 ...

Learn Excel from Mr. Excel: 277 Excel Mysteries Solved

72 reviews
Bill Jelen

Holy Macro! Books, 2005

Great excel reference
This book is filled with everything you ever wanted to know about excel. Great reference with fun tips like games and making your excel talk!

search for books
impossible, livelessons, mysteries, professionals, spreadsheets

Impressum / about us