Программы - скачать книги или читать онлайн. Страница 29

Pick your Excel task, find it fast, and get it done with Just the Steps! If you want to see how to do a particular Excel task, this is the perfect book. Each page includes step-by-step instruction in one column and illustrations and screenshots in the other column, so you have all the information you need in one place—no flipping pages! Improve your Excel skills with just the steps for entering spreadsheet data, building formulas, protecting excel data, formatting cells, designing spreadsheets with graphics, managing workbooks, changing worksheet values, sorting and filtering data, creating charts, creating PivotTables, building macros, integrating Excel into other Office programs, and—whew!—still more. Explains essentials tasks for Excel 2010, the spreadsheet application that is part of the Microsoft Office 2010 suite Shows you just the steps for numerous Excel tasks using an easy-to-follow, two-column page layout, with step-by-step instruction on one side and illustrations and screenshots on the other Covers entering spreadsheet data, building formulas, protecting excel data, formatting cells, designing spreadsheets with graphics, managing workbooks, changing worksheet values, sorting and filtering data, creating charts, creating PivotTables, and building macros Walks you step by step through collaborating in Excel and integrating or using Excel with Word, PowerPoint, and Access Make your tasks easier, improve your Excel skills, and get better results with this step-by-step guide.

Master two of the most powerful features of Excel Even if you use Excel all the time, you may not be up to speed on two of Excel's most useful features. PivotTable and PivotChart turn long lists of unreadable data into dynamic, easy-to-read tables and charts that highlight the information you need most; you can tweak results with a click or easily fuse data from several sources into one document. Now you can learn how to tap these powerful Excel tools with this practical guide. Using a series of step-by-step tutorials and easy-to-follow screenshots, this book shows you in a visual way how to create and customize PivotTables and PivotCharts, use them to analyze business data, and ultimately achieve more with less work. Explains the benefits PivotTables and PivotCharts, two powerful features of Excel that allow users to create dynamic spreadsheets Covers creating and customizing, analyzing business data, building custom calculations, linking to external data sources (including Access databases, Word tables, Web pages, XML data, SQL Server databases, and OLAP cubes), creating macros to automate tasks, and more Uses step-by-step tutorials and easy-to-follow screenshots, a «learn by seeing» approach for visual learners Practical, visual, and packed with content, this is the book you need to ramp up your Excel skills with PivotTables and PivotCharts.

Learn to build business solutions with SharePoint 2013 Now in its third edition, this perennial bestseller features a complete overhaul for the latest version of SharePoint. A must-have for building business solutions in SharePoint, real-world scenarios address critical information management problems and detailed descriptions explain how to efficiently and successfully handle these challenges. Plus, best practices for configuration and customization round out the coverage of getting started with SharePoint 2013 so that you can confidently make this platform work for your business today. Examines product functionality alongside realistic scenarios to provide you with contextual relevance Addresses managing permissions, reporting in SharePoint, and working with access services Offers updated content on working with lists, libraries, workflow, content types, and web parts Reviews social features, forms management, business connectivity services, and more Beginning SharePoint 2013 is an ideal introduction to the latest iteration of this popular content management provider.

Get the most out of Excel 2013 with this exceptional advice from Mr. Spreadsheet himself! Excel 2013 is excellent, but there's lots to learn to truly excel at Excel! In this latest addition to his popular Mr. Spreadsheet's Bookshelf series, John Walkenbach, aka «Mr. Spreadsheet,» shares new and exciting ways to accomplish and master all of your spreadsheet tasks. From taming the Ribbon bar to testing and tables, creating custom functions, and overcoming «impossible» charts, mixing nesting limits, and more, 101 Excel 2013 Tips, Tricks, & Timesavers will save you time and help you avoid common spreadsheet stumbling blocks. Reveals ways to maximize the power of Excel to create robust applications Draws on John Walkenbach's years of experience using Excel and writing more than 50 books Shares tips and tricks for dealing with function arguments, creating add-ins, using UserForms, working with dynamic chart data, and changing data entry orientation Provides shortcuts and helpful techniques for sorting more than three columns, entering fake data for testing purposes, and setting up powerful pivot tables 101 Excel 2013 Tips, Tricks, & Timesavers is packed with information that you need to know in order to confidently and seamlessly master the challenges that come with using Excel!

Книга основана на авторской методике обучения, отработанной за двадцать лет преподавания студентам архитектурно-строительных специальностей. Рассматриваются основные приемы работы при индивидуальном проектировании, общие принципы построения и операций редактирования, правила создания геометрических форм, основы проектирования средствами конструкционных элементов, создание сложных объемных моделей, в том числе собственных библиотечных элементов, работа с источниками света и покрытиями для создания реалистичных изображений с помощью механизма CineRender, формирование макета проекта. Подробно рассмотрены новые возможности ArchiCAD 20. Для практического освоения приемов работы предложено большое количество примеров, файлы которых выложены на сайте издательства.

The perennial bestseller—now in a new edition for QuickBooks 2018 QuickBooks 2018 For Dummies is here to make it easier than ever to familiarize yourself with the latest version of the software. It shows you step by step how to build the perfect budget, simplify tax return preparation, manage inventory, track job costs, generate income statements and financial reports, and every other accounting-related task that crosses your desk at work. Written by highly qualified CPA Stephen L. Nelson, this trusted bestseller shows you how to get the most out of the software that helps over six million small businesses manage their finances. Removing the need to hire expensive financial professionals, it empowers you to take your small business' finances into your own hands. Handle your financial and business management tasks more effectively Implement QuickBooks and get the most out of its features Create invoices and credit memos with ease Pay bills, prepare payroll, and record sales receipts If you're a small business owner, manager, or employee who utilizes QuickBooks at work, this bestselling guide has answers for all of your business accounting needs.

How to make customers feel good about doing what you want Learn how companies make us feel good about doing what they want. Approaching persuasive design from the dark side, this book melds psychology, marketing, and design concepts to show why we’re susceptible to certain persuasive techniques. Packed with examples from every nook and cranny of the web, it provides easily digestible and applicable patterns for putting these design techniques to work. Organized by the seven deadly sins, it includes: Pride – use social proof to position your product in line with your visitors’ values Sloth – build a path of least resistance that leads users where you want them to go Gluttony – escalate customers’ commitment and use loss aversion to keep them there Anger – understand the power of metaphysical arguments and anonymity Envy – create a culture of status around your product and feed aspirational desires Lust – turn desire into commitment by using emotion to defeat rational behavior Greed – keep customers engaged by reinforcing the behaviors you desire Now you too can leverage human fallibility to create powerful persuasive interfaces that people will love to use – but will you use your new knowledge for good or evil? Learn more on the companion website, evilbydesign.info.

Learn the ins and outs of Bitcoin so you can get started today Bitcoin For Dummies is the fast, easy way to start trading crypto currency, with clear explanations and expert advice for breaking into this exciting new market. Understanding the mechanisms and risk behind Bitcoin can be a challenge, but this book breaks it down into easy-to-understand language to give you a solid grasp of just where your money is going. You'll learn the details of Bitcoin trading, how to set up your Bitcoin wallet, and everything you need to get started right away. An in-depth discussion on security shows you how to protect yourself against some of the riskier aspects of this open-source platform, helping you reduce your risks in the market and use Bitcoin safely and effectively. Bitcoin uses peer-to-peer technology to operate with no central authority or banks, with transaction management and issuing of Bitcoins carried out collectively by the network. Bitcoin allows easy mobile payments, fast international payments, low- or no-fee transactions, multi-signature capabilities, and more, but the nuances of the market can be difficult to grasp. This informative guide lays it all out in plain English, so you can strengthen your understanding and get started now. Understand the ins and outs of the Bitcoin market Learn how to set up your Bitcoin wallet Protect yourself against fraud and theft Get started trading this exciting new currency The Bitcoin market is huge, growing quickly, and packed with potential. There's also some risk, so you need to go in fully informed and take steps to manage your risk wisely. Bitcoin For Dummies is the clear, quick, easy-to-follow guide to getting started with Bitcoin.

Leverage the full power of Excel formulas Excel 2016 Formulas is fully updated to cover all of the tips, tricks, and techniques you need to maximize the power of Excel 2016 through the use of formulas. This comprehensive book explains how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. Whether you're a beginner, a power user, or somewhere in between this is your essential go-to for the latest on Excel formulas. When conducting simple math or building highly complicated spreadsheets that require formulas up to the task, leveraging the right formula can heighten the accuracy and efficiency of your work, and can improve the speed with which you compile and analyze data. Understanding which formulas to use and knowing how to create a formula when you need to are essential. Access tips, tricks, and techniques that have been fully updated to reflect the latest capabilities of Microsoft Excel Create and use formulas that have the power to transform your Excel experience Leverage supplemental material online, including sample files, templates, and worksheets from the book

The complete guide to Excel 2016, from Mr. Spreadsheet himself Whether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel 2016 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities by expert author and Excel Guru John Walkenbach 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 2016 Bible. Create functional spreadsheets that work Master formulas, formatting, pivot tables, and more Get acquainted with Excel 2016's new features and tools Customize downloadable templates and worksheets Whether you need a walkthrough tutorial or an easy-to-navigate desk reference, the Excel 2016 Bible has you covered with complete coverage and clear expert guidance.

Let Hadoop For Dummies help harness the power of your data and rein in the information overload Big data has become big business, and companies and organizations of all sizes are struggling to find ways to retrieve valuable information from their massive data sets with becoming overwhelmed. Enter Hadoop and this easy-to-understand For Dummies guide. Hadoop For Dummies helps readers understand the value of big data, make a business case for using Hadoop, navigate the Hadoop ecosystem, and build and manage Hadoop applications and clusters. Explains the origins of Hadoop, its economic benefits, and its functionality and practical applications Helps you find your way around the Hadoop ecosystem, program MapReduce, utilize design patterns, and get your Hadoop cluster up and running quickly and easily Details how to use Hadoop applications for data mining, web analytics and personalization, large-scale text processing, data science, and problem-solving Shows you how to improve the value of your Hadoop cluster, maximize your investment in Hadoop, and avoid common pitfalls when building your Hadoop cluster From programmers challenged with building and maintaining affordable, scaleable data systems to administrators who must deal with huge volumes of information effectively and efficiently, this how-to has something to help you with Hadoop.

Maximize the power of Excel 2013 formulas with this must-have Excel reference John Walkenbach, known as «Mr. Spreadsheet,» is a master at deciphering complex technical topics and Excel formulas are no exception. This fully updated book delivers more than 800 pages of Excel 2013 tips, tricks, and techniques for creating formulas that calculate, developing custom worksheet functions with VBA, debugging formulas, and much more. Demonstrates how to use all the latest features in Excel 2013 Shows how to create financial formulas and tap into the power of array formulas Serves as a guide to using various lookup formulas, working with conditional formatting, and developing custom functions Shares proven solutions for handling typical (and not-so-typical) Excel formula challenges Includes links to the «Mr. Spreadsheet» website, which contains all the templates and worksheets used in the book, plus access to John Walkenbach's award-winning Power Utility Pak. From charts to PivotTables and everything in between, Excel 2013 Formulas is your formula for Excel success.