Oz du Soleil's Books

Guerrilla Data Analysis Using Microsoft Excel

Overcoming Crap Data and Excel Skirmishes

By: MrExcel's Holy Macro! Books,Oz du Soleil,Bill Jelen

Write a review Read reviews Take a Quiz Solve Book Puzzle

Guerrilla Data Analysis Using Microsoft Excel

Overcoming Crap Data and Excel Skirmishes

By: MrExcel's Holy Macro! Books,Oz du Soleil,Bill Jelen

Master Excel data analysis with this hands-on guide. Learn efficient techniques, advanced functions, and best practices for real-world scenarios. Key Features Hands-on techniques for efficient Excel data analysis Advanced functions and best practices for real-world scenarios Step-by-step guidance on complex tasks like data validation and dynamic arrays Book DescriptionUnlock Microsoft Excel's hidden potential with this dynamic guide designed for data professionals and enthusiasts. You'll start by reviewing Excel basics before advancing to powerful tools like Excel Tables, Pivot Tables, and Power Query. Each chapter enhances your ability to analyze and visualize data efficiently, from complex lookups and dynamic arrays to essential data validation techniques that ensure accuracy and integrity in your spreadsheets. As you progress, you'll learn how to protect your work with advanced sheet protection methods and collaboration tools for seamless teamwork. The book also covers sophisticated functions like INDIRECT, OFFSET, and LET, preparing you to tackle complex data challenges. Additionally, you'll receive critical advice on avoiding the pitfalls of machine learning-driven features and maintaining clean, organized data. By the end of the guide, you'll have mastered Excel's advanced capabilities, empowering you to streamline workflows, optimize data processes, and make confident, data-driven decisions. This guide is your comprehensive resource for transforming your approach to data analysis with Excel.What you will learn Master Excel tables and dynamic spreadsheets Use VLOOKUP and XLOOKUP effectively Create and manipulate PivotTables Clean and validate data with Excel tools Apply conditional formatting and de-duping techniques Implement data models and relationships in Excel Who this book is for This book is ideal for data analysts, business professionals, and Excel users who need to enhance their data analysis skills. Readers should have a basic understanding of Excel and be familiar with its interface. No advanced Excel knowledge is required, but a willingness to learn and apply new techniques is essential.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

277

Publisher

Packt Publishing Ltd

Published Date

ISBN 10

1836644027

ISBN 13

9781836644026

Excel Data Cleansing Straight to the Point

By: Oz du Soleil

Write a review Read reviews Take a Quiz Solve Book Puzzle

Excel Data Cleansing Straight to the Point

By: Oz du Soleil

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 to complete data in source YSplitting names from addressesIdentifying and deleting duplicate recordsConverting units of measurement in multiple sources

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

Publisher

Tickling Keys, Inc.

Published Date

ISBN 10

1615471502

ISBN 13

9781615471508

Guerrilla Data Analysis Using Microsoft Excel

2nd Edition Covering Excel 2010/2013

By: Oz du Soleil,Bill Jelen

Write a review Read reviews Take a Quiz Solve Book Puzzle

Guerrilla Data Analysis Using Microsoft Excel

2nd Edition Covering Excel 2010/2013

By: Oz du Soleil,Bill Jelen

This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These tips have been honed by Oz du Soleil, a former financial analyst charged with taking mainframe data and turning it into useful information quickly, and "Mr. Excel" himself, Bill Jelen. Topics include data quality, validation, perfectly sorting with one click, matching lists of data, data consolidation, data subtotals, pivot tables, pivot charts, tables, and much more. This new edition has been updated for Excel 2013.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

223

Publisher

Tickling Keys, Inc.

Published Date

ISBN 10

1615473432

ISBN 13

9781615473434

Cleaning Excel Data With Power Query Straight to the Point

By: Oz du Soleil

Write a review Read reviews Take a Quiz Solve Book Puzzle

Cleaning Excel Data With Power Query Straight to the Point

By: Oz du Soleil

Author Oz Du Soleil's area of frustration with Excel is cleaning data. From his earliest days with Excel, he has found himself constantly needing to fix names that are ALLCAPS, peel addresses away from phone numbers, and fixing all the many other things that prevent data from being useful. In this intro to Power Query, Oz shows you five core techniques in Excel Power Query: Splitting data, Filling blanks, Joining data sets, grouping and summarizing, and adding columns using Column From Examples.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

102

Publisher

Tickling Keys, Inc.

Published Date

ISBN 10

1615471499

ISBN 13

9781615471492

YOU: Being Beautiful

The Owner's Manual to Inner and Outer Beauty

By: Michael F. Roizen,Mehmet Oz

Write a review Read reviews Take a Quiz Solve Book Puzzle

YOU: Being Beautiful

The Owner's Manual to Inner and Outer Beauty

By: Michael F. Roizen,Mehmet Oz

Most people think that beauty revolves around such things as lipstick, sweet eyes, or skinny jeans -- all those things that we can see (and obsess over) in the mirror. But the fact is that beauty isn't some superficial pursuit, and it's not some random act that you can thank (or curse) your ancestors for. There are, in fact, scientific standards to beauty. Beauty is purposeful, because it's how humans have historically communicated who we are to potential mates. Beauty, in fact, is really about your health and happiness. In this groundbreaking book, Dr. Michael F. Roizen and Dr. Mehmet C. Oz bust the myths and stereotypes about the way we view ourselves -- and how we define beauty. In these pages, you'll find out why beauty isn't as much about your vanity as it is about your humanity. The doctors take a scientific, informative, and entertaining look at the three levels of beauty and explain how they all work together to form a complete and authentic YOU. Those three levels of beauty are: Looking Beautiful: Your appearance influences your self-esteem and has major health implications. Here, the docs will tell you how you can look the way you want. Feeling Beautiful: So what if you have luscious lips or gorgeous locks if your joints creak and you have the energy of a rug? The docs will tell you how to improve your energy levels, beat back your life-altering aches and pains, and come to grips with some of life's toughest stresses. Being Beautiful: By improving your relationships with your loved ones as well as with others, you'll be well on your way to finding true happiness. That's the ultimate goal: Having all three levels of beauty working together so you can have a happy and healthy life. You'll start off by taking the ultra-revealing and validated YOU-Q Test to help you assess where you are on your own beauty scale and where you want to be. Take the test, see how well you do; then use the book to help you improve your score. With their usual candor and honesty, Dr. Roizen and Dr. Oz break down the mechanics of beauty and explain how little adjustments in your routine can help you become a happier, healthier person. You will learn about the biology of beauty, take YOU Tests to determine where you are on the beauty scale, get tons of YOU Tips to help you improve your life, as well as learn the secrets of the Ultimate Beautiful Day. From hair to toenails, Dr. Roizen and Dr. Oz go through every part of your body to explain how different foods, vitamins, creams, gels, and injections can really boost your looks. They scrutinize the beauty myths that bombard us every day and offer an unbiased perspective on which ones cause more harm than good. You will be able to revamp your beauty regimen (or start a new one from scratch). They'll also take a close look at chronic pain, mood swings, low energy, and financial stresses. And they'll dive into the science of building relationships, finding happiness, and using spirituality to help you define your own levels of true beauty. Dr. Roizen and Dr. Oz act as tour guides navigating the tricky but exciting terrain of today's beauty industry. YOU: Being Beautiful is your all-inclusive ticket into the world -- the real world -- of beauty.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

547

Publisher

Simon and Schuster

Published Date

ISBN 10

1416572392

ISBN 13

9781416572398

Oz Clarke's Pocket Wine Guide 2010

By: Oz Clarke

Write a review Read reviews Take a Quiz Solve Book Puzzle

Oz Clarke's Pocket Wine Guide 2010

By: Oz Clarke

Over 1,600 entries on wines, producers, grapes, and wine regions from around the world.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

360

Publisher

Sterling Publishing Company, Inc.

Published Date

ISBN 10

140277124X

ISBN 13

9781402771248

Oz Clarke's New Wine Atlas

Wines and Wine Regions of the World

By: Oz Clarke

Write a review Read reviews Take a Quiz Solve Book Puzzle

Oz Clarke's New Wine Atlas

Wines and Wine Regions of the World

By: Oz Clarke

Through its unique cartography--more than 75 spectacular, hand-painted panoramic maps--and Clarke's lively and opinionated prose, this revolutionary atlas illustrates and explains the vital connections between the land, the winemaker, and the wine. Full color. Maps & photos.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

344

Publisher

Houghton Mifflin Harcourt

Published Date

ISBN 10

0151009139

ISBN 13

9780151009138

Oz Clarke's Pocket Wine Guide 2005

By: Oz Clarke

Write a review Read reviews Take a Quiz Solve Book Puzzle

Oz Clarke's Pocket Wine Guide 2005

By: Oz Clarke

Spanish Edition. In this book you will find a clear explanation of what Scripture says about getting and maintaining economic prosperity.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

328

Publisher

Houghton Mifflin

Published Date

ISBN 10

0151011001

ISBN 13

9780151011001

The Wine Book

By: Oz Clarke

Write a review Read reviews Take a Quiz Solve Book Puzzle

The Wine Book

By: Oz Clarke

Publisher description -- Oz Clarke writes for wine drinkers who want a straightforward, unsnobby approach to wine, who are eager to learn about new and old wines, who require unpretentious advice on the practicalities of tasting, serving and storing wine, and who, last but not least, are enchanted by the romance of the subject and the sheer beauty of the world's great wine locations. The reader is taken on an expertly guided tour of the wine world, covering all the major wine-producing countries.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

262

Publisher

Gramercy

Published Date

ISBN 10

0517641623

ISBN 13

9780517641620

Red & White

An unquenchable thirst for wine

By: Oz Clarke

Write a review Read reviews Take a Quiz Solve Book Puzzle

Red & White

An unquenchable thirst for wine

By: Oz Clarke

SHORTLISTED FOR THE 2018 ANDRE SIMON AWARD SHORTLISTED FOR THE FORTNUM AND MASON DRINK BOOK AWARD SHORTLISTED FOR THE JAMES BEARD AWARD With Red & White, Oz Clarke has reinvented wine writing. This is a book to read for pleasure, rather than merely refer to. Combining fast-paced witty memoir with passionately opinionated guide, Oz pops the cork on his life-long love affair with wine. The best loved wine communicator of our time, Oz Clarke is the guest you want at your table, the person to select the wine, and the ideal drinking companion. He explains how, why & where he fell in love with wine; he explains the essentials of how wine is grown and made today; then takes you into the world's wine regions and introduces you to the wines he loves. Oz reveals how he tastes wine and how you can enjoy wine whatever the budget. He covers with equal care & attention all categories of wine, from the blue-chip to the most affordable. With Red & White, you are in the hands of the best-informed and the most inspirational guide, and you will pick up, without even trying, a wealth of knowledge that Oz is bursting to share with you. With climate change and the move to organic & sustainable practices, wine is evolving faster than ever before. And hundreds of local grape varieties, until recently facing extinction, are also being rediscovered. There have never been so many brilliant & original wines. To discover them, all you need is a glass in your hand, a sense of adventure, and Oz's Red & White as your companion & inspiration!

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

668

Publisher

Little, Brown Book Group

Published Date

ISBN 10

1408710153

ISBN 13

9781408710159

Oz Clarke's Pocket Wine Guide 2006

By: Oz Clarke

Write a review Read reviews Take a Quiz Solve Book Puzzle

Oz Clarke's Pocket Wine Guide 2006

By: Oz Clarke

Idispensable as ever, Oz Clarke's now-classic pocket wine guide has been thoroughly and meticulously revised and updated for 2006, with much-anticipated lists of favorite wines, top values, and producers and regions to watch, as well as with new vintage reports. As user-friendly as it is complete, "Oz Clarke's Pocket Wine Guide 2006" lists each wine, grape, winery, producer, and region alphabetically for easy reference. It is a perfect pocket reference for novices--and essential for the seasoned wine lover wanting the latest information.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

328

Publisher

Houghton Mifflin

Published Date

ISBN 10

0151011508

ISBN 13

9780151011506

Oz Clarke's New Encyclopedia of Wine

By: Oz Clarke

Write a review Read reviews Take a Quiz Solve Book Puzzle

Oz Clarke's New Encyclopedia of Wine

By: Oz Clarke

Now available in paperback, this A-Z reference has been updated to reflect the latest developments in the world of wine. 700 color photos.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

420

Publisher

Mariner Books

Published Date

ISBN 10

0156029405

ISBN 13

9780156029407

Oz Clarke's Pocket Wine Guide 2004

By: Oz Clarke

Write a review Read reviews Take a Quiz Solve Book Puzzle

Oz Clarke's Pocket Wine Guide 2004

By: Oz Clarke

Clarke's now-classic pocket wine guide has been revised and updated for 2004, including much anticipated lists of "World Class Wines That Don't Cost the Earth," "Best Lookalikes to the Classics," and "The 10 Best-Kept Secrets.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

328

Publisher

Houghton Mifflin

Published Date

ISBN 10

0151008183

ISBN 13

9780151008186

Oz and James's Big Wine Adventure

By: James May,Oz Clarke

Write a review Read reviews Take a Quiz Solve Book Puzzle

Oz and James's Big Wine Adventure

By: James May,Oz Clarke

An inspiring introduction to French wine with a unique travel angle, tied in to a primetime 6-part BBC2 series, Oz and James's Big Wine Adventure brings us French wine made simple. Oz Clarke - award-winning writer, critic and committed Francophile - is one of the world's leading authorities on French wine. James May - overgrown boy racer , Top Gear presenter and journalist - knows nothing about wine and loathes what he calls 'wine ponces'. In Sideways style, they travel through the regions of France for 6 weeks. Oz teaches James about wine with the aim of turning him into a top sommelier, while the pair eat together, get drunk together and sometimes have to sleep together for a few nights under canvas. Divided by region, Oz and James's Big Wine Adventure cuts through the fear and snobbery that surround French wine, providing an informative, entertaining and accessible guide to the French regions and their wines. Beautifully illustrated with over 80 landscape photographs and location shots, it is full of useful information on wine-making, wine culture, regions and tips on how to seek out the best the French vineyards have to offer.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

312

Publisher

Random House

Published Date

ISBN 10

1448141931

ISBN 13

9781448141937

Oz Clarke's Pocket Wine Guide 2003

By: Oz Clarke

Write a review Read reviews Take a Quiz Solve Book Puzzle

Oz Clarke's Pocket Wine Guide 2003

By: Oz Clarke

The latest edition of this indispensable, pocket-sized guide has been thoroughly updated and offers Clarke's always-anticipated lists such as "World Class Wines that Don't Cost the Earth" and "The Ten Best-Kept Secrets." Two-color photos throughout.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

328

Publisher

Houghton Mifflin

Published Date

ISBN 10

0151008760

ISBN 13

9780151008766

Oz Clarke's Pocket Wine Guide 2008

By: Oz Clarke

Write a review Read reviews Take a Quiz Solve Book Puzzle

Oz Clarke's Pocket Wine Guide 2008

By: Oz Clarke

Oz Clarke’s now-classic pocket wine guide has been thoroughly and meticulously revised and updated for 2008, with much-anticipated lists of favorite wines, top values, producers and regions to watch, new vintage reports, and a country-by-country index.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

352

Publisher

Houghton Mifflin Harcourt

Published Date

ISBN 10

0151013284

ISBN 13

9780151013289

Oz Clarke's Pocket Wine Guide 2009

By: Oz Clarke

Write a review Read reviews Take a Quiz Solve Book Puzzle

Oz Clarke's Pocket Wine Guide 2009

By: Oz Clarke

Indispensable as ever, Oz Clarke's now-classic pocket wine guide has been thoroughly and meticulously revised and updated for 2009, with much-anticipated lists of favorite wines, top values, and producers and regions to watch, as well as new vintage reports. For increased browsability, this year's guide also includes a country-by-country index.As user-friendly as it is complete,Oz Clarke's Pocket Wine Guide 2009 lists each wine, grape, winery, producer, and region alphabetically for easy reference. It is a perfect pocket reference for novices--and essential for the seasoned wine lover wanting the latest information.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

356

Publisher

Houghton Mifflin Harcourt

Published Date

ISBN 10

0151013608

ISBN 13

9780151013609

Oz Clarke's Pocket Wine Guide 1999

By: Oz Clarke

Write a review Read reviews Take a Quiz Solve Book Puzzle

Oz Clarke's Pocket Wine Guide 1999

By: Oz Clarke

Amateur and connoisseur alike can be overwhelmed by the seemingly infinite variety of wine today-unless they have Oz Clarke in their pocket. The clearest, most complete, most affordable, and most enjoyable pocket guide to every wine in the world, Oz Clarke's Pocket Wine Guide instantly creates order out of chaos, in the restaurant or the wine shop, and does do with an irrestible enthusiasm.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

312

Publisher

Houghton Mifflin

Published Date

ISBN 10

0151004307

ISBN 13

9780151004300

Oz Clarke's Pocket Wine Guide 2001

By: Oz Clarke

Write a review Read reviews Take a Quiz Solve Book Puzzle

Oz Clarke's Pocket Wine Guide 2001

By: Oz Clarke

The 2001 edition of Oz Clarke's acclaimed guide is completely updated and laced with his famously witty and opinionated recommendations and warnings about the world's wines. This edition brings even more of Clarke's picks of the best wines in many categories and a look at the new opportunities provided by the Internet. Distinguished particularly by its ease of use, Oz Clarke's Pocket Wine Guide provides more than 1,600 entries covering every aspect of wine today. Clarke's intuitive A-to-Z format ensures that you will find the wine you are looking for, wherever it comes from. In addition, Clarke discusses how wine is made, modern wine styles, storing wines, vintages, and the world of winemaking from Germany to New Zealand.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

328

Publisher

Houghton Mifflin

Published Date

ISBN 10

0151006342

ISBN 13

9780151006342

Oz Clarke's Pocket Wine Guide 2002

By: Oz Clarke

Write a review Read reviews Take a Quiz Solve Book Puzzle

Oz Clarke's Pocket Wine Guide 2002

By: Oz Clarke

Featuring an easy-to-use A-to-Z format, this pocket guide has new features including a series of intriguing personal lists--Oz's Favorites, Best-Kept Secrets, Producers to Watch--and an expanded glossary of wine terms. 2-color photos throughout.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

328

Publisher

Houghton Mifflin

Published Date

ISBN 10

0151009120

ISBN 13

9780151009121

Book's by Oz du Soleil

Username

Password

Password again

Birthday

Email