Bøger udgivet af Questing Vole Press

The jargon associated with Microsoft Excel's pivot tables ("n-dimensional cross tabulations") makes them look complex, but they're really no more than an easy way to build concise, flexible summaries of long lists of raw values. If you're working with hundreds (or hundreds of thousands) of rows, then pivot tables are the best way to look at the same information in different ways, summarize data on the fly, and spot trends and relationships. This handy guide teaches you how to use Excel's most powerful feature to crunch large amounts of data, without having to write new formulas, copy and paste cells, or reorganize rows and columns. You can download the sample workbook to follow along with the author's examples.Create pivot tables from worksheet databases.Rearrange pivot tables by dragging, swapping, and nesting fields.Customize pivot tables with styles, layouts, totals, and subtotals.Combine numbers, dates, times, or text values into custom groups.Calculate common statistics or create custom formulas.Filter data that you don't want to see.Create and customize pivot charts.Unlink a pivot table from its source data.Control references to pivot table cells.Plenty of tips, tricks, and workarounds.Fully indexed and cross-referenced.Contents1. Pivot Table Basics2. Nesting Fields3. Grouping Items4. Calculations and Custom Formulas5. Filtering Data6. Charting Pivot Tables7. Tricks with Pivot TablesAbout the AuthorTim Hill is a statistician living in Boulder, Colorado. He holds degrees in mathematics and statistics from Stanford University and the University of Colorado. Tim has written self-teaching guides for Algebra, Trigonometry, Geometry, Precalculus, Advanced Precalculus, Permutations & Combinations, Mathematics of Money, and Excel Pivot Tables. When he's not crunching numbers, Tim climbs rocks, hikes canyons, and avoids malls.

No computer provides a trouble-free experience. This handy guide walks you through ways to diagnose, fix, and prevent the most common Mac hardware, software, and operating system problems. You'll learn how to handle problems confidently by using a systematic, iterative process and an array of built-in tools. Use startup commands, safe mode, and verbose mode to troubleshoot issues that occur before you log in. Degunk your Mac by resetting non-volatile memory and the system management controller. Use Activity Monitor, Disk Utility, OS X Recovery, and other specialized tools to analyze and fix problems. Diagnose and repair network and internet connectivity issues. Speed up a slow Mac. Repair disk and file permissions. Find and fix deviant system preferences. Delete damaged settings from OS X's Library folders. Learn where to find online solutions to esoteric problems. Covers Yosemite and earlier OS X versions. Plenty of tips, tricks, and timesavers. Fully indexed and cross-referenced. Contents 1. Getting Started 2. Using Startup Commands 3. Resetting the SMC 4. Resetting NVRAM 5. Starting in Safe Mode or Verbose Mode 6. Using OS X Recovery 7. Network Settings and Diagnostics 8. Resetting Network Settings 9. More Network Tricks 10. Slow Computers 11. Permissions Problems 12. Errant System Preferences 13. Exploring OS X's Libraries 14. Finding Solutions on the Web Index About the Author Diane Yee is a technical writer in Sunnyvale, California.

The jargon associated with Microsoft Excel's pivot tables ("n-dimensional cross tabulations") makes them look complex, but they're really no more than an easy way to build concise, flexible summaries of long lists of raw values. If you're working with hundreds (or hundreds of thousands) of rows, then pivot tables are the best way to look at the same information in different ways, summarize data on the fly, and spot trends and relationships. This handy guide teaches you how to use Excel's most powerful feature to crunch large amounts of data, without having to write new formulas, copy and paste cells, or reorganize rows and columns. You can download the sample workbook to follow along with the author's examples.Create pivot tables from worksheet databases.Rearrange pivot tables by dragging, swapping, and nesting fields.Customize pivot tables with styles, layouts, totals, and subtotals.Combine numbers, dates, times, or text values into custom groups.Calculate common statistics or create custom formulas.Filter data that you don't want to see.Create and customize pivot charts.Unlink a pivot table from its source data.Control references to pivot table cells.Plenty of tips, tricks, and workarounds.Fully indexed and cross-referenced.Contents1. Pivot Table Basics2. Nesting Fields3. Grouping Items4. Calculations and Custom Formulas5. Filtering Data6. Charting Pivot Tables7. Tricks with Pivot TablesAbout the AuthorTim Hill is a statistician living in Boulder, Colorado. He holds degrees in mathematics and statistics from Stanford University and the University of Colorado. Tim has written self-teaching guides for Algebra, Trigonometry, Geometry, Precalculus, Advanced Precalculus, Permutations & Combinations, Mathematics of Money, and Excel Pivot Tables. When he's not crunching numbers, Tim climbs rocks, hikes canyons, and avoids malls.

Perfect for new and experienced users, this no-fluff guide to Google Nexus 7 and 9 tablets is packed with details and tips on apps, services, settings, and documents. You'll also find step-by-step instructions for dictating, networking, sharing, troubleshooting, going online, and using Google Now. New and updated features covered include adaptive brightness, always-on "OK Google" detection, app-specific notification blocking, Battery Saver, battery-life prediction, Bluetooth Low Energy, Chromecast screen mirroring, device sharing, double-tap to wake, flashlight, guest users, lock-screen notifications, material design, non-Gmail email accounts, the Overview screen, priority interruptions (do-not-disturb mode), Quick Settings, screen pinning, Settings search, Smart Lock, Tap & Go, vibration, and the redesigned versions of Calendar, Camera, Contacts, Gmail, Hangouts, Maps, Photos, and Settings. Covers Android 5 Lollipop. Covers all Nexus 7 and Nexus 9 tablets, as well as other pure Android devices, including Nexus 10 and Google Play Edition tablets. Master the Home screen, Lock screen, and multitouch gestures. Secure your data from thieves, snoops, and rogue apps. Locate a lost or stolen Nexus remotely. Work with onscreen or wireless keyboards. Get instant search results for documents, pictures, music, mail, apps, contacts, settings, and more. Summon Google Now to get personalized information when you need it. Ask Google Search to find nearby businesses, set alarms, search the web, and more. Dictate anywhere that you can type. Squeeze out every minute of battery life. Connect to wireless networks with a few taps. Set up cellular, Bluetooth, and VPN connections. Mirror your tablet's screen to your TV. Back up your data to the cloud. Transfer files to and from your Windows PC or Apple Mac computer. Sync your documents, mail, contacts, appointments, reminders, notes, and messages wirelessly across your computers and mobile devices. See all your notifications in one place. Stop some or all notifications indefinitely or for a fixed duration. Browse the web with Chrome. Watch and subscribe to videos on the YouTube app. Send, receive, and manage all your email with the Gmail app. Make free phone calls or chat with friends on Hangouts. Post to Twitter or Facebook right from the app you're using. Manage your day-to-day life with Contacts, Calendar, Keep, and Clock. Find your way with Maps. Download apps, games, and updates from the Google Play store. Connect to Google's online multiplayer social gaming network. Play or cast music, movies, TV shows, and other media downloaded from the Google Play store. Capture, edit, and share photos and videos with Camera and Photos. Care for your Nexus and troubleshoot problems. Plenty of tips, tricks, and timesavers. Fully indexed and cross-referenced. Contents 1. Getting Started with Your Nexus 2. Touring Your Nexus 3. Securing Your Nexus 4. Typing and Editing 5. Wireless and Network Connections 6. Managing Your Accounts and Data 7. Connecting to Computers 8. Getting Notifications 9. Google Now 10. Google Search 11. Browsing the Web with Chrome 12. Watching YouTube Videos 13. Email, Messaging and Keeping in Touch 14. Organizing Your Life 15. Shopping for Apps, Games and Media 16. Maps and Navigation 17. Shooting, Viewing and Managing Photos 18. Nexus Care and Troubleshooting About the Author Chris Kennedy is a technical writer based in Boulder, Colorado. When he's not typing, Chris climbs rocks, revises his screenplays, and reads the journals of polar explorers.

Read this book for free at sqlrun.com. Perfect for end users, analysts, data scientists, and app developers, this best-selling guide will get you up and running with SQL, the language of databases. You'll find general concepts, practical answers, and clear explanations of what the various SQL statements can do. Hundreds of examples of varied difficulty encourage you to experiment and explore. Full-color SQL code listings help you see the elements and structure of the language. You can download the sample database to follow along with the author's examples.Covers Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, and Microsoft Access.Learn the core language for standard SQL, and variations for the most widely used database systems.Organize your database in terms of the relational model.Master tables, columns, rows, and keys.Retrieve, sort, and format data.Filter the data that you don't want to see.Convert and manipulate data with SQL's built-in functions and operators.Use aggregate functions to summarize data.Create complex SQL statements by using joins, subqueries, constraints, conditional logic, and metadata.Create, alter, and drop tables, indexes, and views.Insert, update, delete, and merge data.Execute transactions to maintain the integrity of your data.Avoid common pitfalls involving nulls.Troubleshoot and optimize queries.Plenty of tips, tricks, and timesavers.Fully cross-referenced, linked, and searchable.ContentsIntroduction1. Running SQL Programs2. The Relational Model3. SQL Basics4. Retrieving Data from a Table5. Operators and Functions6. Summarizing and Grouping Data7. Joins8. Subqueries9. Set Operations10. Inserting, Updating, and Deleting Rows11. Creating, Altering, and Dropping Tables12. Indexes13. Views14. TransactionsAbout the AuthorChris Fehily is a statistician and author based in San Francisco.

The jargon associated with Microsoft Excel's pivot tables ("n-dimensional cross tabulations") makes them look complex, but they're really no more than an easy way to build concise, flexible summaries of long lists of raw values. If you're working with hundreds (or hundreds of thousands) of rows, then pivot tables are the best way to look at the same information in different ways, summarize data on the fly, and spot trends and relationships. This handy guide teaches you how to use Excel's most powerful feature to crunch large amounts of data, without having to write new formulas, copy and paste cells, or reorganize rows and columns. You can download the sample workbook to follow along with the author's examples.Create pivot tables from worksheet databases.Rearrange pivot tables by dragging, swapping, and nesting fields.Customize pivot tables with styles, layouts, totals, and subtotals.Combine numbers, dates, times, or text values into custom groups.Calculate common statistics or create custom formulas.Filter data that you don't want to see.Create and customize pivot charts.Unlink a pivot table from its source data.Control references to pivot table cells.Plenty of tips, tricks, and workarounds.Fully indexed and cross-referenced.Contents1. Pivot Table Basics2. Nesting Fields3. Grouping Items4. Calculations and Custom Formulas5. Filtering Data6. Charting Pivot Tables7. Tricks with Pivot TablesAbout the AuthorTim Hill is a statistician living in Boulder, Colorado. He holds degrees in mathematics and statistics from Stanford University and the University of Colorado. Tim has written self-teaching guides for Algebra, Trigonometry, Geometry, Precalculus, Advanced Precalculus, Permutations & Combinations, Mathematics of Money, and Excel Pivot Tables. When he's not crunching numbers, Tim climbs rocks, hikes canyons, and avoids malls.

(The updated edition of this book for the Nexus 7, Nexus 9, and Android 5 Lollipop is also available.) Perfect for new and experienced users, this no-fluff guide to the Google Nexus 7 tablet is packed with tips and details on apps, services, settings, and documents. You'll also find step-by-step instructions for dictating, networking, sharing, troubleshooting, going online, and using Google Now. New apps and features covered include Camera, Clock, Google Keep, Android Device Manager, Play Games, Quick Settings, Lock-screen widgets, multiple users, restricted profiles, HDMI screen mirroring, external displays, Miracast, wireless charging, app verification, gesture typing, printing, cellular (LTE/HSPA+) connections, privacy options, Hangouts, the notification light, the remodeled Google Play store, and the updated versions of Chrome, Gmail, and Maps. Covers all Nexus 7 models and Android 4.4 (KitKat). Covers all Google Play edition (pure Android) tablets, including the LG G Pad 8.3. Master the Home screen, Lock screen, and multitouch gestures. Secure your data from thieves, snoops, and rogue apps. Locate a lost or stolen Nexus remotely. Work with onscreen or wireless keyboards. Get instant search results for documents, pictures, music, mail, apps, contacts, and more. Summon Google Now to get personalized information when you need it. Ask Google Search to find nearby businesses, set alarms, search the web, and more. Dictate anywhere that you can type. Connect to wireless networks with a few taps. Set up cellular, Bluetooth, and VPN connections. Mirror your tablet's screen to your TV. Back up your data to the cloud. Transfer files to and from your Windows PC or Apple Mac computer. Sync your documents, mail, contacts, appointments, reminders, notes, and messages wirelessly across your computers and mobile devices. See all your notifications in one place. Browse the web with Chrome. Watch and subscribe to videos on the YouTube app. Send, receive, and manage your email with Gmail or Email. Chat with family and friends on Hangouts. Post to Twitter or Facebook right from the app you're using. Manage your day-to-day life with Calendar, People, Google Keep, and Clock. Find your way with Maps. Download apps, games, and updates from the Google Play store. Connect to Google's online multiplayer social gaming network. Play music, movies, TV shows, and other media downloaded from the Google Play store. Capture, edit, and share photos and videos with Camera and Gallery. Care for your Nexus and troubleshoot problems. Plenty of tips, tricks, and timesavers. Fully indexed and cross-referenced. Contents 1. Getting Started with Your Nexus 7 2. Touring Your Nexus 3. Securing Your Nexus 4. Typing and Editing 5. Wireless and Network Connections 6. Managing Your Accounts and Data 7. Connecting to Computers 8. Getting Notifications 9. Google Now 10. Google Search 11. Browsing the Web with Chrome 12. Watching YouTube Videos 13. Email, Messaging and Keeping in Touch 14. Organizing Your Life 15. Shopping for Apps, Games and Media 16. Maps and Navigation 17. Shooting, Viewing and Managing Photos 18. Nexus Care and Troubleshooting About the Author Chris Kennedy is a technical writer based in Boulder, Colorado. When he's not typing, Chris climbs rocks, revises his screenplays, and reads the journals of polar explorers.

The jargon associated with Microsoft Excel's pivot tables ("n-dimensional cross tabulations") makes them look complex, but they're really no more than an easy way to build concise, flexible summaries of long lists of raw values. If you're working with hundreds (or hundreds of thousands) of rows, then pivot tables are the best way to look at the same information in different ways, summarize data on the fly, and spot trends and relationships. This handy guide teaches you how to use Excel's most powerful feature to crunch large amounts of data, without having to write new formulas, copy and paste cells, or reorganize rows and columns. You can download the sample workbook to follow along with the author's examples.Create pivot tables from worksheet databases.Rearrange pivot tables by dragging, swapping, and nesting fields.Customize pivot tables with styles, layouts, totals, and subtotals.Combine numbers, dates, times, or text values into custom groups.Calculate common statistics or create custom formulas.Filter data that you don't want to see.Unlink a pivot table from its source data.Control references to pivot table cells.Plenty of tips, tricks, and timesavers.Fully indexed and cross-referenced.Contents1. Pivot Table Basics2. Nesting Fields3. Grouping Items4. Calculations and Custom Formulas5. Filtering Data6. Tricks with Pivot TablesAbout the AuthorTim Hill is a statistician living in Boulder, Colorado. He holds degrees in mathematics and statistics from Stanford University and the University of Colorado. Tim has written self-teaching guides for Algebra, Trigonometry, Geometry, Precalculus, Advanced Precalculus, Permutations & Combinations, Mathematics of Money, and Excel Pivot Tables. When he's not crunching numbers, Tim climbs rocks, hikes canyons, and avoids malls.

Get up to speed on OS X Mountain Lion's major new features, including Notification Center, Dictation, Gatekeeper, Game Center, Messages, Notes, Reminders, and AirPlay Mirroring. Step-by-step tasks with graphics and examples. Concisely defined terms and concepts. Plenty of tips, tricks, and workarounds. Fully indexed and cross-referenced. Excerpted from "OS X Mountain Lion (Tech 102)" by Chris Kennedy. Contents 1. Installing Mountain Lion 2. Notification Center 3. Game Center 4. Dictation 5. Gatekeeper 6. Calendar 7. Contacts 8. Messages 9. Notes 10. Reminders 11. Share Sheets 12. Twitter Integration 13. Facebook Integration 14. AirPlay Mirroring 15. Software Updates via App Store 16. Power Nap 17. Deeper iCloud Integration 18. Features for China 19. Removed from Mountain Lion About the Author Chris Kennedy is a technical writer based in Boulder, Colorado. When he's not typing, Chris climbs rocks, revises his screenplays, and reads the journals of polar explorers.

Neighbors with hand-labeled DVD collections. Teenagers with 5000-song iPods. Entire countries sharing the same copy of Windows. Who are these people? They're file sharers and they account for a third of worldwide internet traffic. Their swag is anything that can be digitized and copied. But file-sharing networks aren't only for pirates. Musicians and writers use them to gauge their popularity. Artists and filmmakers use them to boost recognition. Government employees use them to secretly download WikiLeaks archives. TV producers use them to confirm audience measurements. Politicians and judges use them to make policy and rulings. Traders and marketers use them to spot trends. Learn how BitTorrent and peer-to-peer networks work Set up a BitTorrent client and find files to download Open, play, read, or run what you download Know the risks of file sharing and avoid fakes, scams, and viruses Fully indexed and cross-referenced Contents 1. The Terrain 2. Understanding BitTorrent 3. File Types 4. Malware 5. Archives 6. Installing a BitTorrent Client 7. BitTorrent Search Engines 8. Finding Torrents 9. Customizing Your Client 10. Downloading Torrents 11. Movies and TV Shows 12. Pictures 13. Music and Spoken Word 14. Books, Documents, and Fonts 15. Applications and Games

This no-nonsense guide provides students and self-learners with a clear and readable study of algebra's most important ideas. Tim Hill's distraction-free approach combines decades of tutoring experience with the proven methods of his Russian math teachers. The result: learn in a few weeks what conventional schools stretch into months.Teaches general principles that can be applied to a wide variety of problems.Avoids the mindless and excessive routine computations that characterize conventional textbooks.Treats algebra as a logically coherent discipline, not as a disjointed collection of techniques.Restores proofs to their proper place to remove doubt, convey insight, and encourage precise logical thinking.Omits digressions, excessive formalities, and repetitive exercises.Covers all the algebra needed to take a calculus course.Includes problems (with all solutions) that extend your knowledge rather than merely reinforce it.Contents1. A Few Basics2. Exponents3. Polynomials4. Factoring5. Linear & Quadratic Equations6. Inequalities & Absolute Values7. Coordinates in a Plane8. Functions & Graphs9. Straight Lines10. Circles11. Parabolas12. Types of Functions13. Logarithms14. Dividing Polynomials15. Systems of Linear Equations16. Geometric Progressions & Series17. Arithmetic Progressions18. Permutation & Combinations19. The Binomial Theorem20. Mathematical Induction21. SolutionsAbout the AuthorTim Hill is a statistician living in Boulder, Colorado. He holds degrees in mathematics and statistics from Stanford University and the University of Colorado. Tim has written self-teaching guides for Algebra, Trigonometry, Geometry, Precalculus, Advanced Precalculus, Permutations & Combinations, Mathematics of Money, and Excel Pivot Tables. When he's not crunching numbers, Tim climbs rocks, hikes canyons, and avoids malls.

This no-nonsense guide provides students and self-learners with a clear and readable study of trigonometry's most important ideas. Tim Hill's distraction-free approach combines decades of tutoring experience with the proven methods of his Russian math teachers. The result: learn in a few days what conventional schools stretch into months.Teaches general principles that can be applied to a wide variety of problems.Avoids the mindless and excessive routine computations that characterize conventional textbooks.Treats trigonometry as a logically coherent discipline, not as a disjointed collection of techniques.Restores proofs to their proper place to remove doubt, convey insight, and encourage precise logical thinking.Omits digressions, excessive formalities, and repetitive exercises.Covers all the trigonometry needed to take a calculus course.Includes problems (with all solutions) that extend your knowledge rather than merely reinforce it.Contents1. A Few Basics2. Radian Measure3. The Trig Functions4. Trig Values for Special Angles5. Graphs of Trig Functions6. The Major Formulas7. Inverse Trig Functions8. The Law of Cosines (and Sines)9. Solutions10. Trig Cheat SheetAbout the AuthorTim Hill is a statistician living in Boulder, Colorado. He holds degrees in mathematics and statistics from Stanford University and the University of Colorado. Tim has written self-teaching guides for Algebra, Trigonometry, Geometry, Precalculus, Advanced Precalculus, Permutations & Combinations, Mathematics of Money, and Excel Pivot Tables. When he's not crunching numbers, Tim climbs rocks, hikes canyons, and avoids malls.