Financial Modeling in Excel For DummiesDanielle Stein Fairhurst
The most popular and best selling computer software ebooks at the Apple iBookstore.
Chart of the top computer software ebook best sellers was last updated:
Financial Modeling in Excel For DummiesDanielle Stein Fairhurst
Turn your financial data into insightful decisions with this straightforward guide to financial modeling with Excel Interested in learning how to build practical financial models and forecasts but concerned that you don’t have the math skills or technical know-how? We’ve got you covered! Financial decision-making has never been easier than with Financial Modeling in Excel For Dummies . Whether you work at a mom-and-pop retail store or a multinational corporation, you can learn how to build budgets, project your profits into the future, model capital depreciation, value your assets, and more. You’ll learn by doing as this book walks you through practical, hands-on exercises to help you build powerful models using just a regular version of Excel, which you’ve probably already got on your PC. You’ll also: Master the tools and strategies that help you draw insights from numbers and data you’ve already got Build a successful financial model from scratch, or work with and modify an existing one to your liking Create new and unexpected business strategies with the ideas and conclusions you generate with scenario analysis Don’t go buying specialized software or hiring that expensive consultant when you don’t need either one. If you’ve got this book and a working version of Microsoft Excel, you’ve got all the tools you need to build sophisticated and useful financial models in no time!
The iPhone 13 Pro and iPhone 13 Pro MaxPatricia Spaulding
This book covers all you need to know about the new iPhone 13 pro max. It's easy to comprehend and self explanatory. as well as step-by-step instructions and visual aids to help you comprehend. The following are some of the things you'll discover from reading this guide: How to Set Up and Get Started How to set up cellular service How to connect to the internet How to change common iPhone 13 Settings How to access features from the Lock Screen How to open apps How to use the iPhone 13 cameras How to use the cinematic mode How to take a screenshot or screen recording How to change the wallpaper How to take photos and videos How to adjust the shutter volume Have Siri announce calls How to set up Apple Cash Family How to share your internet connection How to allow phone calls on your device How to cut, copy, and paste between iPhone and other devices How to connect iPhone and your computer with a cable How to sync iPhone with your computer How to transfer files between iPhone and your computer How to use Siri How to make phone calls How to use built-in security and privacy protections And many more. You can also check the look inside feature. To get this guide, scroll up and the click the BUY-NOW icon with 1-CLICK on the top right corner and Download Now!!!
Grokking AlgorithmsAditya Bhargava
"This book does the impossible: it makes math fun and easy!" - Sander Rossel, COAS Software Systems Grokking Algorithms is a fully illustrated, friendly guide that teaches you how to apply common algorithms to the practical problems you face every day as a programmer. You'll start with sorting and searching and, as you build up your skills in thinking algorithmically, you'll tackle more complex concerns such as data compression and artificial intelligence. Each carefully presented example includes helpful diagrams and fully annotated code samples in Python. Learning about algorithms doesn't have to be boring! Get a sneak peek at the fun, illustrated, and friendly examples you'll find in Grokking Algorithms on Manning Publications' YouTube channel. Continue your journey into the world of algorithms with Algorithms in Motion , a practical, hands-on video course available exclusively at Manning.com (www.manning.com/livevideo/algorithms-?in-motion). Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. About the Technology An algorithm is nothing more than a step-by-step procedure for solving a problem. The algorithms you'll use most often as a programmer have already been discovered, tested, and proven. If you want to understand them but refuse to slog through dense multipage proofs, this is the book for you. This fully illustrated and engaging guide makes it easy to learn how to use the most important algorithms effectively in your own programs. About the Book Grokking Algorithms is a friendly take on this core computer science topic. In it, you'll learn how to apply common algorithms to the practical programming problems you face every day. You'll start with tasks like sorting and searching. As you build up your skills, you'll tackle more complex problems like data compression and artificial intelligence. Each carefully presented example includes helpful diagrams and fully annotated code samples in Python. By the end of this book, you will have mastered widely applicable algorithms as well as how and when to use them. What's Inside • Covers search, sort, and graph algorithms • Over 400 pictures with detailed walkthroughs • Performance trade-offs between algorithms • Python-based code samples About the Reader This easy-to-read, picture-heavy introduction is suitable for self-taught programmers, engineers, or anyone who wants to brush up on algorithms. About the Author Aditya Bhargava is a Software Engineer with a dual background in Computer Science and Fine Arts. He blogs on programming at adit.io. Table of Contents • Introduction to algorithms • Selection sort • Recursion • Quicksort • Hash tables • Breadth-first search • Dijkstra's algorithm • Greedy algorithms • Dynamic programming • K-nearest neighbors
Mythical Man-Month, TheFrederick P. Brooks Jr.
Few books on software project management have been as influential and timeless as The Mythical Man-Month . With a blend of software engineering facts and thought-provoking opinions, Fred Brooks offers insight for anyone managing complex projects. These essays draw from his experience as project manager for the IBM System/360 computer family and then for OS/360, its massive software system. Now, 20 years after the initial publication of his book, Brooks has revisited his original ideas and added new thoughts and advice, both for readers already familiar with his work and for readers discovering it for the first time. The added chapters contain (1) a crisp condensation of all the propositions asserted in the original book, including Brooks' central argument in The Mythical Man-Month: that large programming projects suffer management problems different from small ones due to the division of labor; that the conceptual integrity of the product is therefore critical; and that it is difficult but possible to achieve this unity; (2) Brooks' view of these propositions a generation later; (3) a reprint of his classic 1986 paper "No Silver Bullet"; and (4) today's thoughts on the 1986 assertion, "There will be no silver bullet within ten years."
Fundamentals of Data EngineeringJoe Reis & Matt Housley
Data engineering has grown rapidly in the past decade, leaving many software engineers, data scientists, and analysts looking for a comprehensive view of this practice. With this practical book, you'll learn how to plan and build systems to serve the needs of your organization and customers by evaluating the best technologies available through the framework of the data engineering lifecycle. Authors Joe Reis and Matt Housley walk you through the data engineering lifecycle and show you how to stitch together a variety of cloud technologies to serve the needs of downstream data consumers. You'll understand how to apply the concepts of data generation, ingestion, orchestration, transformation, storage, and governance that are critical in any data environment regardless of the underlying technology. This book will help you: Get a concise overview of the entire data engineering landscapeAssess data engineering problems using an end-to-end framework of best practicesCut through marketing hype when choosing data technologies, architecture, and processesUse the data engineering lifecycle to design and build a robust architectureIncorporate data governance and security across the data engineering lifecycle
QuickBooks 2022 All-in-One For DummiesStephen L. Nelson
The soup-to-nuts QuickBooks reference that will make your small business life so much simpler! QuickBooks makes it quick to do your books, and QuickBooks 2022 All-in-One For Dummies makes it easy. The leading small business accounting software will become your best friend, helping you cut costs (no more expensive financial services) and save time, with all your accounting and payroll info in one place. With this value-priced, bestselling reference, you’ve got access to 8 mini-books that give you the answers you need to make running a small business that much more manageable. Inside, you’ll discover the key features of QuickBooks, plus refresh your memory on double-entry bookkeeping and all the other basics of small business accounting. This jargon-free guide shows you, step-by-step, how to plan your perfect budget, simplify tax returns, manage inventory, create invoices, track costs, generate reports, and accurately check off every other financial task that comes across your desk! Get the most out of QuickBooks 2022, including all the latest features and updates Sharpen your finance and accounting know-how with a friendly rundown of the must-knows Keep yourself in business with a solid budget, a world-class business plan, and clean payroll Take the headache out of tax time with QuickTime’s automated tax preparation QuickBooks All-in-One 2022 For Dummies is the trusted go-to that will save you time and allow you to focus on the business of running your small business!
Essential ScrumKenneth S. Rubin
A Practical Guide to the Most Popular Agile Process The Single-Source, Comprehensive Guide to Scrum for All Team Members, Managers, and Executives If you want to use Scrum to develop innovative products and services that delight your customers, Essential Scrum is the complete, single-source reference you’ve been searching for. Leading Scrum coach and trainer Kenny Rubin illuminates the values, principles, and practices of Scrum, and describes flexible, proven approaches that can help you implement it far more effectively. Whether you are new to Scrum or years into your use, this book will introduce, clarify, and deepen your Scrum knowledge at the team, product, and portfolio levels. Drawing from Rubin’s experience helping hundreds of organizations succeed with Scrum, this book provides easy-to-digest descriptions enhanced by more than two hundred illustrations based on an entirely new visual icon language for describing Scrum’s roles, artifacts, and activities. Essential Scrum will provide every team member, manager, and executive with a common understanding of Scrum, a shared vocabulary they can use in applying it, and practical knowledge for deriving maximum value from it.
Scrivener For DummiesGwen Hernandez
No matter what you want to write, Scrivener makes it easier. Whether you’re a planner, a seat-of-the-pants writer, or something in between, Scrivener provides tools for every stage of the writing process. Scrivener For Dummies walks you step-by-step through this popular writing software’s best features. This friendly For Dummies guide starts with the basics, but even experienced scriveners will benefit from the helpful tips for getting more from their favourite writing software. Walks you through customizing project templates for your project needs Offers useful advice on compiling your project for print and e-book formats Helps you set up project and document targets and minimize distractions to keep you on track and on deadline Explains how to storyboard with the corkboard, create collections, and understand their value Shows you how to use automated backups to protect your hard work along the way From idea inception to manuscript submission, Scrivener for Dummies makes it easier than ever to plan, write, organize, and revise your masterpiece in Scrivener.
Take Control of Scrivener 3Kirk McElhearn
Create and organize writing projects with ease using Scrivener 3! Version 1.1.1, updated June 4, 2021 Compose a masterpiece with Literature & Latte's Scrivener. Whether you're writing science fiction, a historical novel, or a zombie travelogue, learn how Scrivener's powerful tools can take your work to the next level. Kirk McElhearn shows you how to collect notes, organize your work, arrange and rearrange sections, and more. Covers Mac, Windows, and iOS/iPadOS versions! Scrivener is a powerful tool for managing long-form writing projects—like novels and screenplays—and Take Control of Scrivener 3 gives you all the details you need to know to harness its potential. In this book, best-selling author Kirk McElhearn walks you through setting up, organizing, writing, formatting, revising, and compiling a Scrivener project, whether you’re working on a Mac, a Windows PC, or in iOS/iPadOS. Using this extensive guide, you’ll be able to: • Meet Scrivener: Learn about the Scrivener philosophy and its basic layout • Start your project: Pick a template and add existing materials to your project • Brainstorm and organize: Discover three different ways to work with your material using the Binder, Corkboard, and Outliner. • Set up your writing environment and avoid distractions: Choose default fonts and colors, opt for Script Mode if you’re writing a script or screenplay, and simplify your workspace by hiding interface elements or by using Composition Mode or Full Screen Mode. • Make the most of key features: Learn how to work with styles; use annotations and comments; add footnotes and endnotes; view more than one file at once; use collections to view selected items from the Binder; store bookmarks and project notes; and share and synchronize your project with others. • Go further with Scrivener: Get the details on special features like Scrivenings View (write in sections, but view as a single document) and Snapshots (allows you to make and view periodic backups of your text). • Revise and edit your work: Learn how to find and replace text, and work with revisions. • Use Scrivener in iOS and iPadOS: Sync your projects to iOS/iPadOS and work on an iPhone or iPad. • Print and export: Understand the process of preparing your project to be printed, and what’s involved in compiling it so that it can be exported in a different format. Kirk also highlights the many changes to Scrivener since the last version (see the What's New section below), including updates to the interface, styles, outlining and metadata capabilities, and improved searching and writing features. In addition, he explains brand-new features in Scrivener 3, including Bookmarks (lets you store references to other sections of your project), Linguistic Focus (Mac only—highlights specific elements such as dialog, adverbs, or adjectives), Section types (such as Chapter Text and Scene), and Copyholders (allows you to view three or four documents at once).
Learn Microsoft Excel 2021 for OS X & Mac 2021Greg Harvey
Your complete guide to Microsoft Excel 2021 Excel is the number one number-crunching program just about everywhere. Everything you need to know to take advantage of this winning spreadsheet application is right here! Learn how to create, edit, share and review worksheets. Then take your skills to another level by creating formulas, editing macros, generating pivot tables, charting and analyzing data, and so much more—take a deep dive into Excel with this all-in-one approach! 8 Books Inside… Excel Basics Worksheet Design Formulas and Functions Worksheet Collaboration and Review Charts and Graphics Data Management Data Analysis Macros and VBA From the Back Cover Your complete guide to Microsoft Excel 2021 Excel is the number one number-crunching program just about everywhere. Everything you need to know to take advantage of this winning spreadsheet application is right here! Learn how to create, edit, share and review worksheets. Then take your skills to another level by creating formulas, editing macros, generating pivot tables, charting and analyzing data, and so much more―take a deep dive into Excel with this all-in-one approach! 8 Books Inside… Excel Basics Worksheet Design Formulas and Functions Worksheet Collaboration and Review Charts and Graphics Data Management Data Analysis Macros and VBA
The Definitive Refactoring Guide, Fully Revamped for Ruby With refactoring, programmers can transform even the most chaotic software into well-designed systems that are far easier to evolve and maintain. What’s more, they can do it one step at a time, through a series of simple, proven steps. Now, there’s an authoritative and extensively updated version of Martin Fowler’s classic refactoring book that utilizes Ruby examples and idioms throughout–not code adapted from Java or any other environment. The authors introduce a detailed catalog of more than 70 proven Ruby refactorings, with specific guidance on when to apply each of them, step-by-step instructions for using them, and example code illustrating how they work. Many of the authors’ refactorings use powerful Ruby-specific features, and all code samples are available for download. Leveraging Fowler’s original concepts, the authors show how to perform refactoring in a controlled, efficient, incremental manner, so you methodically improve your code’s structure without introducing new bugs. Whatever your role in writing or maintaining Ruby code, this book will be an indispensable resource. This book will help you Understand the core principles of refactoring and the reasons for doing it Recognize “bad smells” in your Ruby code Rework bad designs into well-designed code, one step at a time Build tests to make sure your refactorings work properly Understand the challenges of refactoring and how they can be overcome Compose methods to package code properly Move features between objects to place responsibilities where they fit best Organize data to make it easier to work with Simplify conditional expressions and make more effective use of polymorphism Create interfaces that are easier to understand and use Generalize more effectively Perform larger refactorings that transform entire software systems and may take months or years Successfully refactor Ruby on Rails code
Write Great Code, Volume 1, 2nd EditionRandall Hyde
Understanding the Machine , the first volume in the landmark Write Great Code series by Randall Hyde, explains the underlying mechanics of how a computer works. This, the first volume in Randall Hyde's Write Great Code series, dives into machine organization without the extra overhead of learning assembly language programming. Written for high-level language programmers, Understanding the Machine fills in the low-level details of machine organization that are often left out of computer science and engineering courses. Learn: How the machine represents numbers, strings, and high-level data structures, so you'll know the inherent cost of using them.How to organize your data, so the machine can access it efficiently.How the CPU operates, so you can write code that works the way the machine does.How I/O devices operate, so you can maximize your application's performance when accessing those devices.How to best use the memory hierarchy to produce the fastest possible programs. Great code is efficient code. But before you can write truly efficient code, you must understand how computer systems execute programs and how abstractions in programming languages map to the machine's low-level hardware. After all, compilers don't write the best machine code; programmers do. This book gives you the foundation upon which all great software is built. NEW IN THIS EDITION, COVERAGE OF: Programming languages like Swift and JavaCode generation on modern 64-bit CPUsARM processors on mobile phones and tabletsNewer peripheral devicesLarger memory systems and large-scale SSDs
Scrivener 3 for MacRobert Roughton
Learn to use Scrivener V3 for Mac like a seasoned professional. Understand what the tools on the toolbar do and breeze through Scrivener to create your amazing story without having to search for help each time you want to use a feature. If you’ve heard of Scrivener, you’ve probably heard of its amazing features; how it simplifies writing, enables you to be a more productive writer and when your amazing work is complete, to easily export to all the major eBook and paperback self-publishing platforms. You may have heard how it can free you from having to search for and convince an agent or publisher to even consider your work amongst the thousands of other budding authors by allowing you to self-publish and become a successful author in your chosen genre. Should you choose the 'traditional' approach, Scrivener will help you output your masterpiece in an industry standard format agents and publishers require. One minor hitch is, first you have to learn how to use the amazing Scrivener software. This can be very time-consuming even confusing if you try to learn from the Scrivener users manual which is technical and includes every conceivable function and feature of the program. This book will provide the information you need to quickly become proficient with Scrivener and enable you to write and export professionally structured books. The creative aspect is up to you. What you will find in this book: Clearly laid out information on how to make the most of Scrivener. Plenty of screenshots with options clearly described including easy to follow arrowed and numbered steps. What you will learn: How to Plan, organize, write and revise your masterpiece. How to customize the Scrivener environment to suit your workflow. If you’ve started with another program, how to import that content and easily sort it into chapters and scenes. How to use the Scrivener editing mode that best suits your style and workflow. Compile your project for export to an ebook, print or as a manuscript for submission to an agent or publisher. And very importantly, how to set up a backup strategy to protect your precious work. If you’re ready to take the next step to becoming a published author, click on the buy button and we’ll get started.
Teach Yourself VISUALLY Microsoft TeamsMatt Wade & Sven Seidenberg
Discover the power of Microsoft Teams with this intuitive and timely new guide Microsoft Teams is unlocking the potential of remote work and virtual meetings at a time when they couldn’t be more necessary. Its feature-rich interface and ease-of-use promise to bring your team together—as long as you can harness its full suite of capabilities. In Teach Yourself VISUALLY Microsoft Teams , Microsoft experts and authors Matt Wade and Sven Seidenberg turn their years of engineering and IT experience loose on the virtual collaboration software now used by over one hundred million people across the globe. Using the book’s huge collection of vibrant and full-sized images and walkthroughs, you’ll see exactly what you need to do in order to: Realize the key benefits of Teams by using its messaging and video-conferencing capabilities to stay connected with your colleagues Manage multiple teams and channels to use Teams across your organization Extend the functionality of Teams by using additional apps and add-ons Learn valuable tips, best practices, and work-arounds to make the most of and avoid the landmines in Teams Rapidly becoming the central hub for working in Microsoft 365, Microsoft Teams promises to transform the way you work and communicate. And you’ll master it faster and easier by using this ultimate guide to get the most out of Microsoft’s latest and greatest software!
Digital ArtDavid Cousens
A complete guide to making computer artworks, from dynamic action scenes to fantasy landscapes. Today, digital art appears everywhere - in print, on television, and in the movies. With the rapid advancement of digital art tools, illustration using these methods of is often faster and more effective. This illustrated guide shows you how to create digital artworks using Photoshop and other popular software platforms. Award-winning illustrator David Cousens guides you through various creative tools and effects, suitable for both beginners and experienced artists. These include: • RGB, CMYK and DPI • Pen, brush and custom shape tools • Blurs, filters, layer masks and blending modes • Perspective, proportions and the rule of thirds • Retouching and effects, such as retro pixel art, silkscreen and charcoal effects. • And much more! Including useful screengrabs to guide you through these instructions, Digital Art will have you creating brilliant artwork in no time.
Coding All-in-One For DummiesChris Minnick
Software Engineering for Absolute BeginnersNico Loubser
Start programming from scratch, no experience required. This beginners’ guide to software engineering starts with a discussion of the different editors used to create software and covers setting up a Docker environment. Next, you will learn about repositories and version control along with its uses. Now that you are ready to program, you’ll go through the basics of Python, the ideal language to learn as a novice software engineer. Many modern applications need to talk to a database of some kind, so you will explore how to create and connect to a database and how to design one for your app. Additionally you will discover how to use Python’s Flask microframework and how to efficiently test your code. Finally, the book explains best practices in coding, design, deployment, and security. Software Engineering for Absolute Beginners answers the question of what topics you should know when you start out to learn software engineering. This book covers a lot of topics, and aims to clarify the hidden, but very important, portions of the software development toolkit. After reading this book, you, a complete beginner, will be able to identify best practices and efficient approaches to software development. You will be able to go into a work environment and recognize the technology and approaches used, and set up a professional environment to create your own software applications. You will: Explore the concepts that you will encounter in the majority of companies doing software developmentCreate readable code that is neat as well as well-designedBuild code that is source controlled, containerized, and deployableSecure your codebaseOptimize your workspace
Excel 2019 For DummiesGreg Harvey
The bestselling Excel book on the market — now in a new edition covering the latest version of Excel! Excel is the spreadsheet and data analysis tool of choice for people across the globe who utilize the Microsoft Office suite to make their work and personal lives easier. It is estimated that 1 in 7 people on the planet use Microsoft Office! If you’re one of them, and want to get up to speed on the latest changes in Excel, you’ve come to the right place. Excel 2019 For Dummies has been updated to reflect the major changes and features made to Excel and covers everything you need to know to perform any spreadsheet task at hand. It includes information on creating and editing worksheets, formatting cells, entering formulas, creating and editing charts, inserting graphs, designing database forms, adding database records, using seek-and-find options, printing, adding hyperlinks to worksheets, saving worksheets as web pages, adding existing worksheet data to an existing webpage, pivot tables, pivot charts, formulas and functions, Excel data analysis, sending worksheets via e-mail, and so much more! Get to know the new Excel interface Become a pro at the spreadsheet and data analysis tool that’s available as part of the Microsoft Office suite Find time-tested and trusted advice from bestselling author and expert Greg Harvey Use Excel to streamline your processes and make your work life easier than ever before Written by a bestselling author and seasoned educator, Excel 2019 For Dummies makes it easier than ever to get everything out of this powerful data tool.
Pragmatic Programmer, TheDavid Thomas
“One of the most significant books in my life.” –Obie Fernandez, Author, The Rails Way “Twenty years ago, the first edition of The Pragmatic Programmer completely changed the trajectory of my career. This new edition could do the same for yours.” –Mike Cohn, Author of Succeeding with Agile , Agile Estimating and Planning , and User Stories Applied “. . . filled with practical advice, both technical and professional, that will serve you and your projects well for years to come.” –Andrea Goulet, CEO, Corgibytes, Founder, LegacyCode.Rocks “. . . lightning does strike twice, and this book is proof.” –VM (Vicky) Brasseur, Director of Open Source Strategy, Juniper Networks The Pragmatic Programmer is one of those rare tech books you’ll read, re-read, and read again over the years. Whether you’re new to the field or an experienced practitioner, you’ll come away with fresh insights each and every time. Dave Thomas and Andy Hunt wrote the first edition of this influential book in 1999 to help their clients create better software and rediscover the joy of coding. These lessons have helped a generation of programmers examine the very essence of software development, independent of any particular language, framework, or methodology, and the Pragmatic philosophy has spawned hundreds of books, screencasts, and audio books, as well as thousands of careers and success stories. Now, twenty years later, this new edition re-examines what it means to be a modern programmer. Topics range from personal responsibility and career development to architectural techniques for keeping your code flexible and easy to adapt and reuse. Read this book, and you’ll learn how to: Fight software rot Learn continuously Avoid the trap of duplicating knowledge Write flexible, dynamic, and adaptable code Harness the power of basic tools Avoid programming by coincidence Learn real requirements Solve the underlying problems of concurrent code Guard against security vulnerabilities Build teams of Pragmatic Programmers Take responsibility for your work and career Test ruthlessly and effectively, including property-based testing Implement the Pragmatic Starter Kit Delight your users Written as a series of self-contained sections and filled with classic and fresh anecdotes, thoughtful examples, and interesting analogies, The Pragmatic Programmer illustrates the best approaches and major pitfalls of many different aspects of software development. Whether you’re a new coder, an experienced programmer, or a manager responsible for software projects, use these lessons daily, and you’ll quickly see improvements in personal productivity, accuracy, and job satisfaction. You’ll learn skills and develop habits and attitudes that form the foundation for long-term success in your career. You’ll become a Pragmatic Programmer. Register your book for convenient access to downloads, updates, and/or corrections as they become available. See inside book for details.
QuickBooks Online For DummiesDavid H. Ringstrom
Get a handle on the world’s most popular cloud bookkeeping and accounting app QuickBooks Online comes second-to-none in providing simple and powerful bookkeeping and accounting features that can streamline your business, make you more profitable, and organize your company’s finances. But if you’re not quite sure how to make it all work, or if you just want to get a grip on its newest features, QuickBooks Online For Dummies is the companion you need to make the most of your favorite cloud accounting software. This book walks you through each and every step of creating an invoice or credit memo, recording a sale, paying bills, setting up and managing your inventory, and tracking your business checkbook and credit cards. It also includes: New updates on exporting data to Microsoft Excel or Google Sheets so that you can analyze your business data new ways. Stepwise walkthroughs of how to install and set up a new instance of QuickBooks Online for your business or personal accounts. Exclusive tips for bookkeepers and accountants working with clients in QuickBooks Online, including new techniques for automating monthly reports that you create in Excel from data that you export from QuickBooks. Whether you’re a small business owner, an accountant, a bookkeeper, or just someone trying to help their boss keep up with their accounting records, QuickBooks Online For Dummies is the resource you need to make the most popular cloud bookkeeping and accounting software in the world work for you!
Excel VBA Programming For DummiesDick Kusleika
Find out what Excel is capable of with this step-by-step guide to VBA Short of changing the tires on your car, Microsoft Excel can do pretty much anything. And the possibilities are even more endless when you learn to program with Excel Visual Basic for Applications (VBA). Regardless of your familiarity with Excel VBA, Excel VBA Programming For Dummies can enhance your experience with the popular spreadsheet software. Pretty soon, you'll be doing things you didn't think were possible in Excel, from automating processes to writing your own worksheet functions. You'll learn how to: Understand the basic tools and operations of Visual Basic for Applications Create custom spreadsheet functions that make life easier for you and the people maintaining your spreadsheets Deal with errors and exceptions and eliminate the bugs in your code Perfect for anyone who's never even heard of Excel VBA, Excel VBA Programming For Dummies is also a fantastic resource for intermediate and advanced Excel users looking for a heads-up on the latest features and newest functionality of this simple yet powerful scripting language.
Excel All-in-One For DummiesPaul McFedries & Greg Harvey
Excel-erate your productivity with the only guide you'll need to the latest versions of Microsoft Excel Microsoft Excel offers unsurpassed functionality and accessibility for data exploration and analysis to millions of users around the world. And learning to unlock its full potential is easier than you can imagine with help from Excel All-in-One For Dummies. Follow along with Excel expert and veteran author Paul McFedries as he walks you through every feature and technique you need to know to get the most out of this powerful software. You'll learn how to design worksheets, use formulas and functions, collaborate with colleagues and review their work, create charts and graphics, manage and analyze data, and create macros. Plus, you'll discover all the capabilities Microsoft has included in the newest versions of Excel, including dark mode and accessibility features. This indispensable reference allows you to: Get a firm grasp of Excel basics with the book's step-by-step guides before moving on to more advanced topics, like data analysis Access up-to-date information on all the new versions of Excel, including the ones bundled with Microsoft 365, Office 2021, and the LTSC/Enterprise Edition Enjoy the convenience of a single, comprehensive resource detailing everything you need to know about Excel Perfect for people coming to Excel for the very first time, Excel All-in-One For Dummies, Office 2021 Edition is also a must-read resource for anyone looking for a refresher on foundational or advanced Excel techniques.
Outlook 2016 For DummiesBill Dyszel
Be more productive and simplify your life with Outlook 2016! Ever feel like you're drowning in your inbox? Outlook 2016 For Dummies helps you lower the metaphorical water levels by quickly prioritizing incoming email. Instead of wading through messages and tasks all day, use Outlook as it was intended—as a productivity tool—to organize your tasks on the to-do bar, filter junk email, make the most of Outlook's anti-phishing capabilities, manage email folders, use smart scheduling tools, leverage RSS support, collect electronic business cards, and integrate your Microsoft OneNote, Project, Access, and SharePoint files. This book is updated to reflect the latest and greatest features integrated into the Outlook 2016 user interface to ensure you're at the top of your Outlook game. With over 1.1 billion users worldwide and 90% market share for productivity suites, a figure that roughly translates into one in seven people the world over, odds are you'll need to learn how to use Microsoft Office programs—including Outlook—if you want to excel in the workplace. Get up to speed on the new and improved features of Microsoft Office 2016 Take advantage of often overlooked features that can simplify your day Discover new ways to filter junk email—and reclaim the hours that you spend sorting through spam each year Organize tasks and schedule meetings, keeping everyone up to date on the latest project and account progress If you're ready to take your productivity to the next level Outlook 2016 For Dummies is a must-read!
Microsoft Excel 2019 VBA and MacrosBill Jelen
Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad explain how to build more powerful, reliable, and efficient Excel spreadsheets. Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won’t find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Excel 2019 and Excel in Office 365. You’ll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions. By reading this book, you will: Quickly master Excel macro development Work more efficiently with ranges, cells, and formulas Generate automated reports and quickly adapt them for new requirements Learn to automate pivot tables to summarize, analyze, explore, and present data Use custom dialog boxes to collect data from others using Excel Improve the reliability and resiliency of your macros Integrate data from the internet, Access databases, and other sources Automatically generate charts, visualizations, sparklines, and Word documents Create powerful solutions with classes, collections, and custom functions Solve sophisticated business analysis problems more rapidly About This Book For everyone who wants to get more done with Microsoft Excel in less time For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data
The Complete Guide to Logic Pro's ScripterPhilip Regan
Beginning SwiftUIGreg Lim
In this book, we take you on a fun, hands-on and pragmatic journey to learning iOS 14 development using SwiftUI. You'll start building your first SwiftUI app within minutes. Every section is written in a bite-sized manner and straight to the point as I don’t want to waste your time (and most certainly mine) on the content you don't need. In the end, you will have the skills to create an app and submit it to the app store. In the course of this book, we will cover: Chapter 1: Introduction Chapter 2: Body Mass Index Calculator Chapter 3: To Do List App Using List Chapter 4: Persistent Data Using Core Data Chapter 5: Extending Core Data to CloudKit Chapter 6: Getting Data from an API: GitHub Users Chapter 7: Machine Learning with Core ML Chapter 8: C.R.U.D. Notes App with Firebase/Firestore Chapter 9: Building Cross Platform Apps in SwiftUI The goal of this book is to teach you SwiftUI development in a manageable way without overwhelming you. We focus only on the essentials and cover the material in a hands-on practice manner for you to code along.
iMac (M1 2021) Complete GuideScott Edward
The new 24-inch iMac is a remarkable machine; powered by Apple’s new M1 processor, it feels modern and up-to-date in a way that iMacs haven’t for a number of years. It’s now powered by the same silicon that you ‘ll find in the new MacBook Pro, iPad Pro and MacBook Air, and there are important changes both under the hood and on the surface—everything from a refreshed color scheme to a new magnetic power cord. Indeed, just one glance shows that the iMac’s profile been slenderized and modernized. The usual 21.5-inch screen has been scaled up to 24-inches without making the computer itself any larger (thank a much smaller bezel), and the iMac is now available in up to seven colors, depending upon which model you choose. This book will help you with a collection of ACTIONABLE tips and tricks. It contains specific step-by-step instructions that are well organized and easy to read. With the aid of the screenshots, even a new user of Mac can understand this book easily. Here is a Preview of what you will learn: New features on your iMac iMac Magic Keyboard iMac Magic Mouse Set up your iMac Apple Account on Mac The desktop, menu bar, and Help on your Mac The Finder on your Mac The Dock on your Mac Notification Center on your Mac Siri on your Mac Display settings for your Mac Spotlight on your Mac Use iCloud and Continuity Screen Time on Mac Use Handoff on your Mac Sidecar on your Mac Continuity Sketch and Continuity Markup on your Mac Unlock your Mac and approve tasks with Apple Watch Use AirPlay on your Mac Use AirPrint on your Mac Use AirDrop on your Mac Apps included with your iMac Keyboard shortcuts on your Mac Take a screenshot on your Mac Security features for iMac Important safety information for your MacAnd so much more! Download your copy of “iMac (M1 2020) Complete Guide”.
Excel 2013 All-in-One For DummiesGreg Harvey
The comprehensive reference, now completely up-to-date for Excel 2013! As the standard for spreadsheet applications, Excel is used worldwide - but it's not always user-friendly. However, in the hands of veteran bestselling author Greg Harvey, Excel gets a whole lot easier to understand! This handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more. The featured minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA. Covers the changes in the newest version as well as familiar tasks, such as creating and editing worksheets, setting up formulas, and performing statistical functions Walks you through the new analysis tools that help make it easier to visualize data with the click of a mouse Details new ways to explore your data more intuitively and then analyze and display your results with a single click Whether you're an Excel newbie or a veteran user to wants to get familiar with the latest version, Excel 2013 All-in-One For Dummies has everything you need to know.
Excel 2019 BibleMichael Alexander, Richard Kusleika & John Walkenbach
The complete guide to Excel 2019 Whether you are just starting out or an Excel novice, the Excel 2019 Bible is your comprehensive, go-to guide for all your Excel 2019 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more. Navigate this powerful tool for business, home management, technical work, and much more with the only resource you need, Excel 2019 Bible. Create functional spreadsheets that work Master formulas, formatting, pivot tables, and more Get acquainted with Excel 2019's new features and tools Whether you need a walkthrough tutorial or an easy-to-navigate desk reference, the Excel 2019 Bible has you covered with complete coverage and clear expert guidance.
User Story MappingJeff Patton & Peter Economy
User story mapping is a valuable tool for software development, once you understand why and how to use it. This insightful book examines how this often misunderstood technique can help your team stay focused on users and their needs without getting lost in the enthusiasm for individual product features. Author Jeff Patton shows you how changeable story maps enable your team to hold better conversations about the project throughout the development process. Your team will learn to come away with a shared understanding of what you’re attempting to build and why. Get a high-level view of story mapping, with an exercise to learn key concepts quicklyUnderstand how stories really work, and how they come to life in Agile and Lean projectsDive into a story’s lifecycle, starting with opportunities and moving deeper into discoveryPrepare your stories, pay attention while they’re built, and learn from those you convert to working software
Robert C. Martin Clean Code Collection, TheRobert C. Martin
The Robert C. Martin Clean Code Collection consists of two bestselling eBooks: Clean Code: A Handbook of Agile Software Craftmanship by Robert C. Martin The Clean Coder: A Code of Conduct for Professional Programmers by Robert C. Martin In Clean Code , legendary software expert Robert C. Martin has teamed up with his colleagues from Object Mentor to distill their best agile practice of cleaning code "on the fly" into a book that will instill within you the values of a software craftsman and make you a better programmer—but only if you work at it. You will be challenged to think about what's right about that code and what's wrong with it. More important, you will be challenged to reassess your professional values and your commitment to your craft. In The Clean Coder , Martin introduces the disciplines, techniques, tools, and practices of true software craftsmanship. This book is packed with practical advice—about everything from estimating and coding to refactoring and testing. It covers much more than technique: It is about attitude. Martin shows how to approach software development with honor, self-respect, and pride; work well and work clean; communicate and estimate faithfully; face difficult decisions with clarity and honesty; and understand that deep knowledge comes with a responsibility to act. Readers of this collection will come away understanding How to tell the difference between good and bad codeHow to write good code and how to transform bad code into good codeHow to create good names, good functions, good objects, and good classesHow to format code for maximum readabilityHow to implement complete error handling without obscuring code logicHow to unit test and practice test-driven developmentWhat it means to behave as a true software craftsmanHow to deal with conflict, tight schedules, and unreasonable managersHow to get into the flow of coding and get past writer’s blockHow to handle unrelenting pressure and avoid burnoutHow to combine enduring attitudes with new development paradigmsHow to manage your time and avoid blind alleys, marshes, bogs, and swampsHow to foster environments where programmers and teams can thriveWhen to say "No"—and how to say itWhen to say "Yes"—and what yes really means
Excel 2016 VBA and MacrosBill Jelen
MASTER CORE EXCEL 2016 TOOLS FOR BUILDING POWERFUL, RELIABLE SPREADSHEETS! Use this guide to automate virtually any routine task: save yourself hours, days, maybe even weeks! Make Excel do things you thought were impossible, discover macro techniques you won’t find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information, so you can act on it… capture data from anywhere, and use it anywhere… automate Excel 2016’s best new features. You’ll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with bonus examples, macros, and solutions–straight from MrExcel! Get started fast with Excel macro development Work efficiently with ranges, cells, and formulas Build super-fast applications with arrays Automate Excel’s new pivot table enhancements Collect user data with custom dialogs Make your macros more reliable and resilient Pull data from the Internet with web queries Use advanced classes, collections, and custom functions Build sophisticated business analysis solutions Read and write to Access or SQL Server databases Control other Office programs, and Windows itself Write code that also works on older Excel versions Start writing Office Store-style Excel Apps About MrExcel Library Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will Dramatically increase your productivity–saving you 50 hours a year or more Present proven, creative strategies for solving real-world problems Show you how to get great results, no matter how much data you have Help you avoid critical mistakes that even experienced users make This book is part of Que’s Content Update Program. As Microsoft updates features of Excel, sections of this book will be updated or new sections will be added to match the updates to the software. See inside for details .
Microsoft Excel 365 BibleMichael Alexander & Dick Kusleika
Your personal, hands-on guide to the latest and most useful features in Microsoft Excel 365 Excel 365 is Microsoft’s latest cloud-based version of its world-famous spreadsheet app. Powerful and user-friendly, it’s an ideal solution for businesses and people looking to make sense of—and draw intelligence from—their data. The Excel 365 Bible carries over the best content from the best-selling Excel 2019 Bible while reflecting how a new generation uses Excel in Excel 365. The authoring team with their decades of Excel and business intelligence experience and recognition from the Excel community as Excel MVPs delivers an accessible and authoritative roadmap to Excel 365. Interested in the basics? You’ll learn to create spreadsheets and workbooks and navigate the user interface. If you’re ready for more advanced topics you can skip right to the material on creating visualizations, crafting custom functions, and using Visual Basic for Applications to script automations. You’ll also get: Over 900 pages of powerful tips, tricks, and strategies to unlock the full potential of Microsoft Excel 365 Guidance on how to import, manage, and analyze large amounts of data Advice on how to craft predictions and “What-If Analyses” based on data you already have Perfect for anyone new to Excel, as well as experts and advanced users, the Excel 365 Bible is your comprehensive, go-to guide for everything you need to know about the world’s most popular, easy-to-use spreadsheet software.
Excel VBA: A Step-By-Step Tutorial For Beginners To Learn Excel VBA Programming From ScratchPeter Bradley
While you can manipulate Excel to a fair degree through the use of formulas alone, there are always going to be tasks that require you to move and sort data in ways that are limited through the use of this knowledge alone. In these situations, it will generally be much more efficient time-wise to just create a program that can automate the task you are attempting. If you like the sound of this but don't know what steps to take to make it a reality, then Excel VBA: A Step-By-Step Tutorial For Beginners To Learn Excel VBA Programming From Scratch is the book you have been waiting for. In order to ensure you have all the tools you need at your disposal, this book will discuss everything you need to know about VBA, starting with the basics including accessing this feature in modern spreadsheets. Next, you will learn how to make the most of macros by using existing Excel data. You will then learn about the many ways both variables as well as If/Then statements can be used to take your macros to the next level. From there, you will learn about some more complicated concepts include looping, as well as a number of additional tools that are sure to prove useful from time to time. You will then learn about common errors to watch out for while debugging and some additional tips for success to keep in mind while working with VBA to ensure you get started on the right foot. So, what are you waiting for? Stop dreaming about improving your Excel performance and start taking steps to make this dream a reality, buy this book today!
Adrenaline Junkies and Template ZombiesTom DeMarco
This is the digital version of the printed book (Copyright © 2008). Adrenaline junkies, dead fish, project sluts, true believers, Lewis and Clark, template zombies . . . Most developers, testers, and managers on IT projects are pretty good at recognizing patterns of behavior and gut-level hunches, as in, “I sense that this project is headed for disaster.” But it has always been more difficult to transform these patterns and hunches into a usable form, something a team can debate, refine, and use. Until now. In Adrenaline Junkies and Template Zombies, the six principal consultants of The Atlantic Systems Guild present the patterns of behavior they most often observe at the dozens of IT firms they transform each year, around the world. The result is a quick-read guide to identifying nearly ninety typical scenarios, drawing on a combined one-hundred-and-fifty years of project management experience. Project by project, you’ll improve the accuracy of your hunches and your ability to act on them. The patterns are presented in an easy-reference format, with names designed to ease communication with your teammates. In just a few words, you can describe what’s happening on your project. Citing the patterns of behavior can help you quickly move those above and below you to the next step on your project. You’ll find classic patterns such as these: News Improvement Management by Mood Ring Piling On Rattle Yer Dags Natural Authority Food++ Fridge Door and more than eighty more! Not every pattern will be evident in your organization, and not every pattern is necessarily good or bad. However, you’ll find many patterns that will apply to your current and future assignments, even in the most ambiguous circumstances. When you assess your situation and follow your next hunch, you'll have the collective wisdom of six world-class consultants at your side.
Mastering Professional ScrumStephanie Ockerman
“Our job as Scrum professionals is to continually improve our ability to use Scrum to deliver products and services that help customers achieve valuable outcomes. This book will help you to improve your ability to apply Scrum.” –From the Foreword by Ken Schwaber, co-author of Scrum Mastering Professional Scrum is for anyone who wants to deliver increased value by using Scrum more effectively. Leading Scrum practitioners Stephanie Ockerman and Simon Reindl draw on years of Scrum training and coaching to help you return to first principles and apply Scrum with the professionalism required to achieve its transformative potential. The authors aim to help you focus on proven Scrum approaches for improving quality, getting and using fast feedback, and becoming more adaptable, instead of “going through the motions” and settling for only modest improvements. Whether you’re a Scrum Master, Development Team member, or Product Owner, you’ll find practical advice for facing challenges with transparency and courage, overcoming a wide array of common challenges, and continually improving your Scrum practice. Realistically assess your current Scrum practice, and identify areas for improvement Recognize what a great Scrum Team looks like and get there Focus on “Done”–not “sort-of-Done” or “almost-Done” Measure and optimize the value delivered by every Product Increment Improve the way you plan, develop, and grow Clear away wider organizational impediments to agility and professionalism Overcome common misconceptions that stand in the way of progress Register your book for convenient access to downloads, updates, and/or corrections as they become available. See inside book for details.
Mastering AWS CloudFormationKaren Tovmasyan
Build scalable and production-ready infrastructure in Amazon Web Services with CloudFormation Key Features Leverage AWS CloudFormation templates to manage your entire infrastructure Get up and running with writing your infrastructure as code and automating your environment Simplify infrastructure management and increase productivity with AWS CloudFormation Book Description DevOps and the cloud revolution have forced software engineers and operations teams to rethink how to manage infrastructures. With this AWS book, you'll understand how you can use Infrastructure as Code (IaC) to simplify IT operations and manage the modern cloud infrastructure effectively with AWS CloudFormation. This comprehensive guide will help you explore AWS CloudFormation from template structures through to developing complex and reusable infrastructure stacks. You'll then delve into validating templates, deploying stacks, and handling deployment failures. The book will also show you how to leverage AWS CodeBuild and CodePipeline to automate resource delivery and apply continuous integration and continuous delivery (CI/CD) practices to the stack. As you advance, you'll learn how to generate templates on the fly using macros and create resources outside AWS with custom resources. Finally, you'll improve the way you manage the modern cloud in AWS by extending CloudFormation using AWS serverless application model (SAM) and AWS cloud development kit (CDK). By the end of this book, you'll have mastered all the major AWS CloudFormation concepts and be able to simplify infrastructure management. What you will learn Understand modern approaches to IaC Develop universal and reusable CloudFormation templates Discover ways to apply continuous delivery with CloudFormation Implement IaC best practices for the AWS Cloud Provision massive applications across multiple regions and accounts Automate template generation and software provisioning for AWS Extend CloudFormation with custom resources and template macros Who this book is for If you are a developer who wants to learn how to write templates, a DevOps engineer interested in deployment and orchestration, or a solutions architect looking to understand the benefits of managing infrastructure with ease, this book is for you. Prior understanding of the AWS Cloud is necessary.
97 Things Every Data Engineer Should KnowTobias Macey
Take advantage of today's sky-high demand for data engineers. With this in-depth book, current and aspiring engineers will learn powerful real-world best practices for managing data big and small. Contributors from notable companies including Twitter, Google, Stitch Fix, Microsoft, Capital One, and LinkedIn share their experiences and lessons learned for overcoming a variety of specific and often nagging challenges. Edited by Tobias Macey, host of the popular Data Engineering Podcast, this book presents 97 concise and useful tips for cleaning, prepping, wrangling, storing, processing, and ingesting data. Data engineers, data architects, data team managers, data scientists, machine learning engineers, and software engineers will greatly benefit from the wisdom and experience of their peers. Topics include: The Importance of Data Lineage - Julien Le DemData Security for Data Engineers - Katharine JarmulThe Two Types of Data Engineering and Data Engineers - Jesse AndersonSix Dimensions for Picking an Analytical Data Warehouse - Gleb MezhanskiyThe End of ETL as We Know It - Paul SingmanBuilding a Career as a Data Engineer - Vijay KiranModern Metadata for the Modern Data Stack - Prukalpa SankarYour Data Tests Failed! Now What? - Sam Bail
Clean CodeRobert C. Martin
Even bad code can function. But if code isn’t clean, it can bring a development organization to its knees. Every year, countless hours and significant resources are lost because of poorly written code. But it doesn’t have to be that way. Noted software expert Robert C. Martin presents a revolutionary paradigm with Clean Code: A Handbook of Agile Software Craftsmanship . Martin has teamed up with his colleagues from Object Mentor to distill their best agile practice of cleaning code “on the fly” into a book that will instill within you the values of a software craftsman and make you a better programmer–but only if you work at it. What kind of work will you be doing? You’ll be reading code–lots of code. And you will be challenged to think about what’s right about that code, and what’s wrong with it. More importantly, you will be challenged to reassess your professional values and your commitment to your craft. Clean Code is divided into three parts. The first describes the principles, patterns, and practices of writing clean code. The second part consists of several case studies of increasing complexity. Each case study is an exercise in cleaning up code–of transforming a code base that has some problems into one that is sound and efficient. The third part is the payoff: a single chapter containing a list of heuristics and “smells” gathered while creating the case studies. The result is a knowledge base that describes the way we think when we write, read, and clean code. Readers will come away from this book understanding How to tell the difference between good and bad code How to write good code and how to transform bad code into good code How to create good names, good functions, good objects, and good classes How to format code for maximum readability How to implement complete error handling without obscuring code logic How to unit test and practice test-driven development This book is a must for any developer, software engineer, project manager, team lead, or systems analyst with an interest in producing better code.
iBooks Author: The Definitive GuideTrailer Park Inc.
Unlock the full power and potential of iBooks Author with our #1 Bestselling interactive manual! Built using iBooks Author by experienced designers and developers, our book will get you up and running in no time. Through interactive galleries, video demonstrations, and invaluable professional tips and tricks, "iBooks Author: The Definitive Guide" gives you everything needed to quickly learn and master this innovative digital publishing application. Topics Include: • Template Overview • Creating Table of Contents and Glossary • Adding Text, Images and Interactive Content • Working with HTML5 Widgets and 3D Objects • Previewing and Publishing • Professional Tips & Tricks
Excel 2010 All-in-One For DummiesGreg Harvey
A comprehensive, up-to-date, user-friendly guide to Excel 2010 Excel is the standard for spreadsheet applications and is used worldwide, but it's not always user-friendly. That makes it a perfect For Dummies topic, and this handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more. Eight minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA. Excel is the leading spreadsheet/data analysis software and is used throughout the world; the newest revision includes upgraded tools and a redesigned interface For Dummies books are the bestselling guides to Excel, with more than three million copies sold Excel 2010 All-in-One For Dummies covers the changes in the newest version as well as familiar tasks, such as creating and editing worksheets, setting up formulas, and performing statistical functions Eight self-contained minibooks cover the basics, worksheet design, formulas and functions, worksheet collaboration, presenting data in charts and graphics, data management, data analysis, and creating macros with VBA. Newcomers to Excel as well as veterans who just want to learn the latest version will find Excel 2010 All-in-One For Dummies has everything they need to know.
Numbers for iPad (2015 Edition) (Vole Guides)Sean Kells
A newer edition of this book is available: "Numbers for iPad & iPad Pro (Vole Guides)" by Sean Kells. This handy guide covers all of Numbers for iOS, Apple's chart-topping spreadsheet app tuned to work with your iPad, iPhone, and iPod touch. If you're coming from Numbers for Mac or Microsoft Excel, you'll find all the steps needed to transfer your spreadsheets and make a painless transition from point-and-click to tap-and-drag. • Use just your fingers to create spreadsheets with tables, charts, graphics, and media. • Create spreadsheets based on Apple's professionally designed templates or your own custom templates. • Store spreadsheets in iCloud or third-party cloud locations such as Dropbox or Google Drive. • Use Handoff to pass spreadsheets seamlessly between your Mac, iPhone, iPad, and iPod touch. • Organize your spreadsheets into folders. • Restrict access to your spreadsheets by password-protecting them. • Add multiple sheets and tables to your spreadsheets. • Print spreadsheets wirelessly from an AirPrint-capable printer. • Edit and format cells and use the built-in editing tools. • Enter data with sliders, steppers, pop-up menus, checkboxes, star ratings, and intelligent keyboards. • Add comments and highlights to your work. • Cut, copy, paste, merge, fill, and sort cells. • Use forms to edit lists easily. • Enter, copy, move, and troubleshoot formulas. • Choose from more than 250 built-in functions and operators to build formulas. • Chart your data to reveal trends and relationships. • Embellish your spreadsheets with photos, videos, text boxes, arrows, lines, and shapes. • Export Numbers, Excel, PDF, or CSV files. • Import Numbers, Excel, or CSV files. • Send copies of spreadsheets via email, Messages, or AirDrop. • Transfer spreadsheets via remote server. • Use iCloud to store, share, sync, or collaborate on spreadsheets online. • Plenty of tips, tricks, and timesavers. • Fully cross-referenced, linked, and searchable. Contents 1. Getting Started with Numbers 2. Spreadsheet Basics 3. Entering Data 4. Formulas and Functions 5. Charts 6. Media, Text Boxes, and Shapes 7. Sharing and Converting Spreadsheets About the Author Sean Kells is a human-interface designer based in Seattle, Washington. When he's not pushing pixels, Sean paints foreboding seascapes, plays backgammon for blood, and takes his dog surfing. Sean has written guides to Numbers, Pages, Keynote, and iBooks.
How To Setup Find My iPhoneMobility
iPad 3 & iOS 6Chris Kennedy
Perfect for new and experienced users, this no-fluff guide to the Apple iPad is packed with details on settings, apps, documents, and iCloud. You'll also find step-by-step instructions for dictating, networking, sharing, troubleshooting, going online, and using Siri. New features covered include Siri, Maps, Privacy, Shared Photo Streams, Do Not Disturb, Facebook integration, Clock, Guided Access, Safari and Mail improvements, and remodeled stores. • Master the Home screen and multitouch gestures. • Secure your data from thieves, snoops, and rogue apps. • Work with onscreen or wireless keyboards. • Get instant search results for documents, pictures, music, mail, apps, contacts, and more. • Ask Siri to find nearby businesses, set alarms, search the web, and more. • Dictate anywhere that you can type. • Connect to wireless networks with a couple of taps. • Set up cellular, Bluetooth, and VPN connections. • Mirror your iPad's screen to your TV wirelessly via AirPlay. • Back up your data to iCloud or iTunes. • Use iCloud to store and access the latest versions of your documents online. • Sync your documents, mail, contacts, appointments, reminders, notes, and messages wirelessly across your iPad, iPhone, iPod touch, and Mac. • See all your notifications in one place. • Browse the web with Safari. • Send, receive, and manage your email with Mail. • Chat with family and friends with Messages or FaceTime. • Post to Twitter or Facebook right from the app you're using. • Manage your day-to-day life with Calendar, Contacts, Notes, Reminders, and Clock. • Find your way with Maps. • Download and install apps and updates from the App Store. • Read books, magazines, and newspapers with iBooks and Newsstand. • Play games on Game Center, Apple's online multiplayer social gaming network. • Play music, movies, TV shows, and other media downloaded from the iTunes Store. • Capture, edit, and share photos and videos with Camera, Photos, and Photo Booth. • Care for your iPad and troubleshoot problems. • Plenty of tips, tricks, and workarounds. • Fully cross-referenced, linked, and searchable. Contents 1. Getting Started with Your iPad 2. Touring Your iPad 3. Securing Your iPad 4. Typing, Editing & Searching 5. Dictation & Siri 6. Wireless & Network Connections 7. iCloud, iTunes & Notifications 8. Browsing the Web 9. Email, Messaging & Video Calls 10. Organizing Your Life 11. Shopping in the App Store 12. Reading Books, Newspapers & Magazines 13. Playing Games 14. Downloading and Playing Music & Videos 15. Shooting, Viewing & Managing Photos 16. iPad Care & Troubleshooting About the Author Chris Kennedy is a technical writer based in Boulder, Colorado. When he's not planting power-user tips on blogs, Chris climbs rocks, revises his screenplays, and reads the journals of polar explorers.
FileMaker Pro 11: The Missing ManualSusan Prosser & Stuart Gripman
This hands-on, friendly guide shows you how to harness FileMaker's power to make your information work for you. With a few mouse clicks, the FileMaker Pro 11 database helps you create and print corporate reports, manage a mailing list, or run your entire business. FileMaker Pro 11: The Missing Manual helps you get started, build your database, and produce results, whether you're running a business, pursuing a hobby, or planning your retirement. It's a thorough, accessible guide for new, non-technical users, as well as those with more experience. Start up: Get your first database up and running in minutes Catalog your data: Organize contacts, to-do items, and product information with speedy data-entry and sorting tools Create professional documents: Publish reports, invoices, and more, with ease Add visual power and clarity: Create colorful charts to illustrate and summarize your data Harness processing power: Crunch numbers and search text with dozens of built-in formulas Learn advanced topics: Explore the high-level features of FileMaker Pro Advanced and FileMaker Server
iBooks for iPad (2015 Edition) (Vole Guides)Sean Kells
A newer edition of this book is available: "iBooks for iPad & iPad Pro (Vole Guides)" by Sean Kells. This handy guide covers all of iBooks, Apple's chart-topping ebook reader tuned to work with your iPad, iPhone, iPod touch, and Mac. If you're coming from the Amazon Kindle or Barnes & Noble Nook, you'll find the steps needed to make a smooth transition to iBooks. • Use just your fingers to page through books, read PDF files, interact with multimedia textbooks, create bookmarks, and highlight and annotate passages. • Use built-in search and navigation features to find words or phrases anywhere in a book and quickly jump to specific pages. • Share quotes from books via Mail, Messages, Twitter, or Facebook. • Adjust screen brightness for ambient light and change a book's text size, font, and layout to suit your eyesight and reading speed. • Stock and organize your library by buying books from the iBooks Store, downloading free (and DRM-free) books from the internet, and converting books to EPUB format. • Sync your library across all your iOS devices automatically. • Subscribe to magazines and newspapers or buy single issues. • Plenty of tips, tricks, and timesavers. • Fully cross-referenced, linked, and searchable. Contents 1. Getting Started with iBooks 2. Stocking Your Library 3. Organizing Your Library 4. Reading Books 5. Reading PDFs 6. Newsstand 7. Interactive Textbooks About the Author Sean Kells is a human-interface designer based in Seattle, Washington. When he's not pushing pixels, Sean paints foreboding seascapes, plays backgammon for blood, and takes his dog surfing. Sean has written guides to Numbers, Pages, Keynote, and iBooks.
Pages for iPad (2015 Edition) (Vole Guides)Sean Kells
A newer edition of this book is available: "Pages for iPad & iPad Pro (Vole Guides)" by Sean Kells. This handy guide covers all of Pages for iOS, Apple's chart-topping word processor tuned to work with your iPad, iPhone, and iPod touch. If you're coming from Pages for Mac or Microsoft Word, you'll find all the steps needed to transfer your documents and make a painless transition from point-and-click to tap-and-drag. • Use just your fingers to create documents with text, lists, footnotes, tables, charts, graphics, and media. • Create documents based on Apple's professionally designed templates or your own custom templates. • Store documents in iCloud or third-party cloud locations such as Dropbox or Google Drive. • Use Handoff to pass documents seamlessly between your Mac, iPhone, iPad, and iPod touch. • Organize your documents into folders. • Restrict access to your documents by password-protecting them. • Set the paper size and adjust page margins. • Insert repeating headers and footers. • Number pages automatically. • Use watermarks to stamp your documents with a logo or mark them as confidential. • Print documents wirelessly from an AirPrint-capable printer. • Edit and format text and use the built-in editing tools. • Add comments and highlights to your work. • Track changes in your documents. • Use paragraph and character styles to maintain a consistent look. • Create bulleted, lettered, or numbered lists. • Flow text into multiple columns. • Change the line spacing and alignment of paragraphs. • Set paragraph margins and first-line indents. • Use tab stops to align columns of text or numbers. • Insert manual page, column, or line breaks. • Insert footnotes or endnotes. • Embellish your documents with photos, videos, text boxes, arrows, lines, and shapes. • Wrap text around objects. • Organize, format, and sort text or numbers in tables. • Chart your data to show trends and relationships. • Export Pages, Word, PDF, or ePub files. • Import Pages, Word, or text files. • Send copies of documents via email, Messages, or AirDrop. • Transfer documents via remote server. • Use iCloud to store, share, sync, or collaborate on documents online. • Plenty of tips, tricks, and timesavers. • Fully cross-referenced, linked, and searchable. Contents 1. Getting Started with Pages 2. Document Basics 3. Editing Text 4. Formatting Text 5. Media, Text Boxes, and Shapes 6. Tables 7. Charts 8. Sharing and Converting Documents About the Author Sean Kells is a human-interface designer based in Seattle, Washington. When he's not pushing pixels, Sean paints foreboding seascapes, plays backgammon for blood, and takes his dog surfing. Sean has written guides to Numbers, Pages, Keynote, and iBooks.
"When everybody zigs, zag," says Marty Neumeier in this fresh view of brand strategy. ZAG follows the ultra-clear "whiteboard overview" style of the author’s first book, THE BRAND GAP, but drills deeper into the question of how brands can harness the power of differentiation. The author argues that in an extremely cluttered marketplace, traditional differentiation is no longer enough—today companies need “radical differentiation” to create lasting value for their shareholders and customers. In an entertaining 3-hour read you’ll learn: - why me-too brands are doomed to fail - how to "read" customer feedback on new products and messages - the 17 steps for designing “difference” into your brand - how to turn your brand’s “onliness” into a “trueline” to drive synergy - the secrets of naming products, services, and companies - the four deadly dangers faced by brand portfolios - how to “stretch” your brand without breaking it - how to succeed at all three stages of the competition cycle From the back cover: In an age of me-too products and instant communications, keeping up with the competition is no longer a winning strategy. Today you have to out-position, out-maneuver, and out-design the competition. The new rule? When everybody zigs, zag. In his first book, THE BRAND GAP, Neumeier showed companies how to bridge the distance between business strategy and design. In ZAG, he illustrates the number-one strategy of high-performance brands—radical differentiation. ZAG is an AIGA Design Press book, published under Peachpit's New Riders imprint in partnership with AIGA. For a quick peek inside ZAG, go to www.zagbook.com.
Designing Data-Intensive ApplicationsMartin Kleppmann
Data is at the center of many challenges in system design today. Difficult issues need to be figured out, such as scalability, consistency, reliability, efficiency, and maintainability. In addition, we have an overwhelming variety of tools, including relational databases, NoSQL datastores, stream or batch processors, and message brokers. What are the right choices for your application? How do you make sense of all these buzzwords? In this practical and comprehensive guide, author Martin Kleppmann helps you navigate this diverse landscape by examining the pros and cons of various technologies for processing and storing data. Software keeps changing, but the fundamental principles remain the same. With this book, software engineers and architects will learn how to apply those ideas in practice, and how to make full use of data in modern applications. Peer under the hood of the systems you already use, and learn how to use and operate them more effectivelyMake informed decisions by identifying the strengths and weaknesses of different toolsNavigate the trade-offs around consistency, scalability, fault tolerance, and complexityUnderstand the distributed systems research upon which modern databases are builtPeek behind the scenes of major online services, and learn from their architectures