Book picks similar to
Excel 2007 Formulas [With CDROM] by John Walkenbach


reference
non-fiction
business
mba-required-reading

Data Analysis Using SQL and Excel


Gordon S. Linoff - 2007
    This book helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. Each chapter explains when and why to perform a particular type of business analysis in order to obtain useful results, how to design and perform the analysis using SQL and Excel, and what the results should look like.

Windows 10: The Missing Manual


David Pogue - 2015
    Windows 10 (a free update to users of Windows 8 or Windows 7) fixes a number of the problems introduced by the revolution in Windows 8 and offers plenty of new features, such as the new Spartan web browser, Cortana voice-activated "personal assistant," new universal apps (that run on tablet, phone, and computer), and more. But to really get the most out of the new operating system, you're going to need a guide.Thankfully, Windows 10: The Missing Manual will be there to help. Like its predecessors, this book from the founder of Yahoo Tech, previous New York Times columnist, bestselling author, and Missing Manuals creator David Pogue illuminates its subject with technical insight, plenty of wit, and hardnosed objectivity for beginners, veteran standalone PC users, new tablet owners, and those who know their way around a network.

SEO 2013 & Beyond: Search Engine Optimization Will Never Be The Same Again


Andy Williams - 2012
    Panda was designed to remove low quality content from the search engine results pages. The surprise to many were some of the big name casualties that were taken out by the update. On 24th April 2012, Google went in for the kill when they released the Penguin update. Few SEOs that had been in the business for any length of time could believe the carnage that this update caused. If Google's Panda was a 1 on the Richter scale of updates, Penguin was surely a 10. It completely changed the way we need to think about SEO. On September 28th 2012, Google released a new algorithm update targeting exact match domains (EMDs). I have updated this book to let you know the consequences of owning EMDs and added my own advice on choosing domain names. While I have never been a huge fan of exact match domains anyway, many other SEO books and courses teach you to use them. I'll tell you why I think those other courses and books are wrong.The EMD update was sandwiched in between another Panda update (on the 27th September) and another Penguin update (5th October).Whereas Panda seems to penalize low quality content, Penguin is more concerned about overly aggressive SEO tactics. Stuff that SEOs had been doing for years, not only didn't work any more, but now can actually cause your site to be penalized and drop out of the rankings. That’s right, just about everything you have been taught about Search Engine Optimization in the last 10 years can be thrown out the Window. Google have moved the goal posts. I have been working in SEO for around 10 years and have always tried to stay within the guidelines laid down by Google. This has not always been easy because to compete with other sites, it often meant using techniques that Google frowned upon. Now, if you use those techniques, Google is likely to catch up with you and demote your rankings. In this book, I want to share with you the new SEO. The SEO for 2013 and Beyond.

U.S. History, Volume II: 1865-Present


Boundless - 2013
    History textbook is a college-level, introductory textbook that covers the exciting subject of U.S. History. Volume II covers 1865 through the present day. Boundless works with subject matter experts to select the best open educational resources available on the web, review the content for quality, and create introductory, college-level textbooks designed to meet the study needs of university students.This textbook covers:Reconstruction: 1865-1877 -- The End of the War, The Aftermath of the War, The Battle over Reconstruction, Reconstruction in the South, The Reconstructed South, The Grant PresidencyThe Gilded Age: 1870-1900 -- The Gilded Age, The Second Industrial Revolution, The Rise of the City, The Rise of Big Business, The Rise of Immigration, Work in Industrial America, The Transformation of the West, Conquest in the West, The Transformation of the South, Politics in the Gilded Age, Urban Reform, Corruption and Reform, The Agrarian and Populist Movements, The Silver SolutionRace, Empire, and Culture in the Gilded Age: 1870-1900 -- Culture in the Gilded Age, Popular Culture, Cheap Amusements, Education, The Rise of Realism, Labor and Domestic Tensions, The Labor Wars, War, Empire, and an Emerging American World PowerThe Progressive Era: 1890-1917 -- The Progressive Era, Labor, Local, and Political Reform, The Politics of Progressivism, Grassroots Progressivism, Progressivism: Theory and Practice, Changing Ideas of Freedom, Roosevelt's Progressivism, Roosevelt's Second Term, From Roosevelt to Taft, Woodrow Wilson and Progressivism, The Limits of ProgressivismWorld War I: 1914-1919 -- The Wilson Administration, American Neutrality, America's Entry into the War, America and WWI, The War at Home, The "American", The Fight for Peace, Diplomacy & Negotiations at the War's End, The Transition to Peace: 1919-21From the New Era to the Great Depression: 1920-1933 -- The New Era, The Roaring Twenties, The Culture of Change, Resistance to Change, Wall Street Crash of 1929, The Great DepressionThe New Deal: 1933-1940 -- Franklin D. Roosevelt and the First New Deal, The New Deal, Critical Interpretations of the New Deal, The Social Cost of the Depression, Toward a Welfare State, Roosevelt's Second Term, Culture in the Thirties, The Second New Deal, The Legacy of the New DealFrom Isolation to World War II: 1930-1943 -- Non-Interventionism, The Beginning of the War, Conflict in Europe, Conflict in the Pacific, America's Early Involvement, Mobilization in the U.S., Social Effects of the War, The War in Germany, The War in the Pacific, The End of WWIIThe Cold War: 1947-1991 -- Origins of the Cold War, The Cold War, Truman and the Fair Deal, The Cold War and KoreaThe Politics and Culture of Abundance: 1943-1960 -- The Politics of Abundance, The Culture of Abundance, The Eisenhower Administration, The Policy of Containment, The Emergence of the Civil Rights MovementThe Sixties: 1960-1969 -- The Election of 1960, The Expansion of the Civil Rights Movement, Counterculture, The John F. Kennedy Administration, The Lyndon B. Johnson AdministrationThe Conservative Turn of America: 1968-1989 -- The Nixon Administration, Watergate, The Ford Administration, The Carter Administration, The Reagan AdministrationThe Challenges of Globalization and the Coming Century: After 1989 -- The George H.W. Bush Administration, America's Emerging Culture, The Clinton Administration, Globalization and the U.S.

DAX Formulas for PowerPivot: The Excel Pro's Guide to Mastering DAX


Rob Collie - 2012
    Written by the world’s foremost PowerPivot blogger and practitioner, the book’s concepts and approach are introduced in a simple, step-by-step manner tailored to the learning style of Excel users everywhere. The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce and include lessons on the difference between calculated columns and measures, how formulas can be reused across reports of completely different shapes, how to merge disjointed sets of data into unified reports, how to make certain columns in a pivot behave as if the pivot were filtered while other columns do not, and how to create time-intelligent calculations in pivot tables such as “Year over Year” and “Moving Averages” whether they use a standard, fiscal, or a complete custom calendar. The “pattern-like” techniques and best practices contained in this book have been developed and refined over two years of onsite training with Excel users around the world, and the key lessons from those seminars costing thousands of dollars per day are now available to within the pages of this easy-to-follow guide.

Hard Core Poor - a book on extreme thrift


Kelly Sangree - 2014
    I hope it helps you too!

Beginning iPhone 3 Development: Exploring the iPhone SDK


Dave Mark - 2009
    Updated and revised for iPhone SDK 3, many of the discussions in the original book have been clarified to make some of the more complex topics easier to understand. In addition, all of the projects have been rebuilt from scratch using the SDK 3 templates.Assuming only a minimal working knowledge of Objective-C, and written in a friendly, easy-to-follow style, this book offers a complete soup-to-nuts course in iPhone and iPod touch programming. The book starts with the basics, walking you through the process of downloading and installing Apple's free iPhone SDK, and then stepping you though the creation of your first simple iPhone application. From there, you'll learn to integrate all the interface elements iPhone users have come to know and love, such as buttons, switches, pickers, toolbars, and sliders. You'll master a variety of design patterns, from the simplest single view to complex hierarchical drill-downs. The confusing art of table building will be demystified, and you'll see how to save your data using the iPhone file system. You'll also learn how to save and retrieve your data using SQLite, iPhone's built-in database management system. In addition, you'll also learn about Core Data, an important persistence mechanism that has just been added with SDK 3.And there's much more! You'll learn to draw using Quartz 2D and OpenGL ES, add multitouch gestural support (pinches and swipes) to your applications, and work with the camera, photo library, accelerometer, and built-in GPS. You'll discover the fine points of application preferences and learn how to localize your apps for multiple languages. You can discover more about this book, download source code, and find support forums at the book's companion site, at www.iphonedevbook.com.The iPhone 3 update to the best-selling and most recommended book for iPhone developers Packed full of tricks, techniques, and enthusiasm for the new SDK from a developer perspective The most complete, useful, and up-to-date guide to all things having to do with Apple's iPhone SDK

Amazon Elastic Compute Cloud (EC2) User Guide


Amazon Web Services - 2012
    This is official Amazon Web Services (AWS) documentation for Amazon Compute Cloud (Amazon EC2).This guide explains the infrastructure provided by the Amazon EC2 web service, and steps you through how to configure and manage your virtual servers using the AWS Management Console (an easy-to-use graphical interface), the Amazon EC2 API, or web tools and utilities.Amazon EC2 provides resizable computing capacity—literally, server instances in Amazon's data centers—that you use to build and host your software systems.

A Second Wind: Time to Own Your Future


T.D. Jakes - 2016
    Jakes challenges the faithful to be more effective in earning their livelihoods by providing a diverse range of strategies that will turn their work life into an abundant life. While focusing on his core mission to preach the gospel worldwide, T.D. Jakes has seen many good people not spend enough quality time with family, friends, and God. They have gotten so swept up in the daily grind that they have failed to live the rich life that God desires for each of His people. In his new book, Jakes provides readers with strategies that will help them rejuvenate their life and turn their "busyness" into a "business." All readers-not just entrepreneurs-will benefit from Jakes' insightful advice so that they can use the days God has blessed them with wisely and finish each day strong!

Tata


Morgen Witzel - 2010
    1 Lakh/ below US$ 2500 car), is set to change our perception of India': on the threshold of becoming a truly global brand.*s oldest and most respected corporate brand. With a major international presence, in a variety of areas including steel, tea, chemicals, communications and software, Tata now stands 65th in the world brand valuation league. But what is the Tata brand all about? What are its values? How do people perceive it, in India and around the world? In this absorbing and informed book Morgen Witzel digs into the heart of the Tata enterprise, describes its origins, how Tata's reputation and image evolved, and how the group has worked to transform that image into a powerful and valuable brand. Tata: The Evolution of a Corporate Brand goes to the core of the Tata ethos to explore the unique relationship between the Tata group and the Indian people, a relationship that goes beyond the achievements of a successful business to its social contributions for its employees and the society at large. Finally it asks how that reputation will be perceived and understood as Tata moves into global markets. Whether you re an entrepreneur, a manager, a marketer, or an interested Tata loyalist this book will help you understand the durability of the brand and inspire you with the values it holds onto in the global economy.

An Introduction to APIs


Brian Cooksey - 2016
    We start off easy, defining some of the tech lingo you may have heard before, but didn’t fully understand. From there, each lesson introduces something new, slowly building up to the point where you are confident about what an API is and, for the brave, could actually take a stab at using one.

Into the Darkness: The Harrowing True Story of the Titanic Disaster: Riveting First-Hand Accounts of Agony, Sacrifice and Survival


Alan J. Rockwell - 2017
    No human being who stood on her decks that fateful night was alive to commemorate the event on its 100th anniversary. Their stories are with us, however, and the lessons remain. From the moment the world learned the Titanic had sunk, we wanted to know, who had survived? Those answers didn’t come until the evening of Thursday, April 18, 1912―when the Cunard liner Carpathia finally reached New York with the 706 survivors who had been recovered from Titanic’s lifeboats. Harold Bride, “Titanic’s surviving wireless operator,” relayed the story of the ship’s band. “The way the band kept playing was a noble thing. I heard it first while still we were working wireless when there was a ragtime tune for us. The last I saw of the band, when I was floating out in the sea with my lifebelt on, it was still on deck playing ‘Autumn.’ How they ever did it I cannot imagine.” There were stories of heroism―such as that of Edith Evans, who was waiting to board collapsible Lifeboat D, the last boat to leave Titanic, when she turned to Caroline Brown and said, “You go first. You have children waiting at home.” The sacrifice cost Evans her life, but as Mrs. Brown said later, “It was a heroic sacrifice, and as long as I live I shall hold her memory dear as my preserver, who preferred to die so that I might live.” There was mystery. There was bravery. There was suspense. There was cowardice. Most men who survived found themselves trying to explain how they survived when women and children had died. But mostly, there was loss. On her return to New York after picking up Titanic’s survivors, Carpathia had become known as a ship of widows. Rene Harris, who lost her husband, Broadway producer Henry Harris, in the disaster, later spoke of her loss when she said, “It was not a night to remember. It was a night to forget.” Drawing on a wealth of previously unpublished letters, memoirs, and diaries as well as interviews with survivors and family members, veteran author and writer Alan Rockwell brings to life the colorful voices and the harrowing experiences of many of those who lived to tell their story. More than 100 years after the RMS Titanic met its fatal end, the story of the tragic wreck continues to fascinate people worldwide. Though many survivors and their family members disappeared into obscurity or were hesitant to talk about what they went through, others were willing to share their experiences during the wreck and in its aftermath. This book recounts many of these first-hand accounts in graphic, compelling detail.

Learning SAS by Example: A Programmer's Guide


Ron Cody - 2007
    In an instructive and conversational tone, Cody clearly explains how to program SAS, illustrating with one or more real-life examples and giving a detailed description of how the program works.

CompTIA Project+ Study Guide Authorized Courseware: Exam PK0–003


Kim Heldman - 2010
    You'll find complete coverage of all exam objectives, including key topics such as project planning, execution, delivery, closure, and others. CompTIA's Project+ is the foundation-level professional exam in the complex world of project management; certified project managers often choose to go on and obtain their Project Management Professional (PMP) certifications as well Provides complete coverage of all exam objectives for CompTIA's first update to the Project+ exam in six years Covers project planning, execution, delivery, change, control, communication, and closure Demonstrates and reinforces exam preparation with practical examples and real-word scenarios Includes a CD with Sybex test engine, practice exams, electronic flashcards, and a PDF of the book Approach the new Project+ exam with confidence with this in-depth study guide! Reviews

Mastering Excel Macros: Introduction (Book 1)


Mark Moore - 2014
    Everybody wants to learn them. You're not a programmer though. How is a non technical user going to learn how to program? You do want to use macros to make your work easier but are you really going to sit down with a huge programming textbook and work your way through every. single. boring. page? Like most people, you'll start with great enthusiasm and vigor but after a few chapters, the novelty wears off. It gets boring. I'm going to try and change that and make learning macro programming entertaining and accessible to non-techies. First of all, programming Excel macros is a huge topic. Let's eat the elephant one bite at a time. Instead of sitting down with a dry, heavy text, you will read very focused, to the point topics. You can then immediately use what you learned in the real world. This is the first lesson in the series. You will learn what macros are, how to access them, a tiny bit of programming theory (just so you have a clue as to what's going on) and how to record macros. As with all my other lessons, this one has a follow along workbook that you can use to work through the exercises. The images in the lessons are based on Excel 2013 for Windows.