Программы
Различные книги в жанре ПрограммыExcel 2013 Formulas
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.
Excel 2013 Bible
Excel at Excel with the help of this bestselling spreadsheet guide John Walkenbach's name is synonymous with excellence in computer books that decipher the complexities of Microsoft Excel. Known as «Mr. Spreadsheet,» Walkenbach shows you how to maximize the power of Excel 2013 while bringing you up to speed on the latest features. This perennial bestseller is fully updated to cover all the new features of Excel 2013, including how to navigate the user interface, take advantage of various file formats, master formulas, analyze data with PivotTables, and more. Whether you're an Excel beginner who is looking to get more savvy or an advanced user looking to become a power user, this latest edition provides you with comprehensive coverage as well as helpful tips, tricks, and techniques that you won't find anywhere else. Shares the invaluable insight of Excel guru and bestselling author «Mr. Spreadsheet» John Walkenbach as he guides you through every aspect of Excel 2013 Provides essential coverage of all the newest features of Excel 2013 Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience Features a website that includes downloadable templates and worksheets from the book Chart your path to fantastic formulas and stellar spreadsheets with Excel 2013 Bible!
Office 2013 For Dummies
Office 2013 For Dummies is the key to your brand new Office! Packed with straightforward, friendly instruction, this update to one of the bestselling Office books of all time gets you thoroughly up to speed and helps you learn how to take full advantage of the new features in Office 2013. After coverage of the fundamentals, you'll discover how to spice up your Word documents, edit Excel spreadsheets and create formulas, add pizazz to your PowerPoint presentation, and much more. Helps you harness the power of all five Office 2013 applications: Word, Excel, PowerPoint, Outlook, and Access Discusses typing and formatting text in Word and easy ways to dress up your documents with color, graphics, and more Demonstrates navigating and editing an Excel spreadsheet, creating formulas, and charting and analyzing Excel data Walks you through creating a PowerPoint presentation and adding some punch with color, sound, pictures, and videos Explores Outlook, including configuring e-mail, storing contacts, organizing tasks, scheduling your time, and setting appointments Delves into designing Access databases, including editing, modifying, searching, sorting, and querying; also covers viewing and printing reports, and more The fun and friendly approach of Office 2013 For Dummies makes doing Office work easy and efficient!
Microsoft Business Intelligence Tools for Excel Analysts
Bridge the big data gap with Microsoft Business Intelligence Tools for Excel Analysts The distinction between departmental reporting done by business analysts with Excel and the enterprise reporting done by IT departments with SQL Server and SharePoint tools is more blurry now than ever before. With the introduction of robust new features like PowerPivot and Power View, it is essential for business analysts to get up to speed with big data tools that in the past have been reserved for IT professionals. Written by a team of Business Intelligence experts, Microsoft Business Intelligence Tools for Excel Analysts introduces business analysts to the rich toolset and reporting capabilities that can be leveraged to more effectively source and incorporate large datasets in their analytics while saving them time and simplifying the reporting process. Walks you step-by-step through important BI tools like PowerPivot, SQL Server, and SharePoint and shows you how to move data back and forth between these tools and Excel Shows you how to leverage relational databases, slice data into various views to gain different visibility perspectives, create eye-catching visualizations and dashboards, automate SQL Server data retrieval and integration, and publish dashboards and reports to the web Details how you can use SQL Server’s built-in functions to analyze large amounts of data, Excel pivot tables to access and report OLAP data, and PowerPivot to create powerful reporting mechanisms You’ll get on top of the Microsoft BI stack and all it can do to enhance Excel data analysis with this one-of-a-kind guide written for Excel analysts just like you.
Excel 2013 All-in-One For Dummies
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 2013 Power Programming with VBA
Maximize your Excel 2013 experience using VBA application development The new Excel 2013 boasts updated features, enhanced power, and new capabilities. Naturally, that means John Walkenbach returns with a new edition of his bestselling VBA Programming book and covers all the methods and tools you need to know in order to program with Excel. With this comprehensive guide, «Mr. Spreadsheet» shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Featuring a complete introduction to Visual Basic for Applications and fully updated for the latest features of Excel 2013, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA. Offers an analysis of Excel application development and a complete introduction to VBA Features invaluable advice from «Mr. Spreadsheet» himself, bestselling author John Walkenbach, who demonstrates all the techniques you need to create Excel applications, both large and small Covers navigating the Excel interface, formatting worksheets, interacting with other Office applications, working with collaboration tools, and using sample workbooks and John Walkenbach's award-winning Power Utility Pak to help enhance your Excel skills Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you wont find anywhere else Excel 2013 Power Programming with VBA is packed with procedures, tips, and ideas for achieving Excel excellence with VBA.
Microsoft Office Home and Student Edition 2013 All-in-One For Dummies
The go-to reference for the new Office Home & Student 2013 The Home & Student version of Microsoft Office targets the home and education markets, covering the four applications most used outside the workplace: Word, Excel, PowerPoint, and OneNote. The minibooks in this essential All-in-One guide include real-world examples and projects that cover the new features and capabilities of Office 2013. Straightforward advice and beneficial projects help you to learn the basics of creating a resume in Word, establishing a home budget in Excel, developing a dynamic school presentation with PowerPoint, and taking notes in OneNote. Targets home and school users of Office 2013, who primarily use Word, Excel, PowerPoint, and OneNote Walks you through how to use Office 2013 for everyday projects, such as creating a cover letter in Word or reusable templates in Excel Demonstrates how to jazz up a school presentation with PowerPoint Provides you with straightforward instructions for taking notes in OneNote Shares common Office 2010 tools and details the basics of the Office ribbon Office Home & Student 2013 All-in-One For Dummies is an easy-to-understand guide to the essentials of Office 2013!
QuickBooks 2014 All-in-One For Dummies
Keep your budget on track and your business booming with QuickBooks 2014 All-in-One For Dummies! QuickBooks is your one-stop shop for taking care of all those financial chores that are essential to keep your small business up and running, and this all-in-one guide makes managing your books easier than ever. Written by CPA and trusted financial author Stephen L. Nelson, this popular For Dummies bestseller has been updated for the latest version of QuickBooks and financial practices. You'll find eight self-contained minibooks that start with the basics of bookkeeping and accounting and walk you all the way through creating business plans and taking advantage of other business resources. Helps you understand accounting procedures and concepts, set up QuickBooks for your business needs, and start speaking the language of finance Explains how to invoice customers, pay vendors, monitor inventory, track accounts, and computer employee wages and payroll deductions Covers important accounting tasks like preparing financial statements, filing taxes, planning a budget, developing a business plan, forecasting, and assessing the health of your business Includes eight minibooks: An Accounting Primer, Getting Ready to Use QuickBooks, Bookkeeping Chores, Accounting Chores, Financial Management, Business Plans, Care & Maintenance, and Additional Business Resources Don't put off those pesky accounting tasks any longer! QuickBooks 2014 All-in-One For Dummies makes managing your business finances a snap and gives you the confidence to tackle the books like a pro.
Big Data For Dummies
Find the right big data solution for your business or organization Big data management is one of the major challenges facing business, industry, and not-for-profit organizations. Data sets such as customer transactions for a mega-retailer, weather patterns monitored by meteorologists, or social network activity can quickly outpace the capacity of traditional data management tools. If you need to develop or manage big data solutions, you'll appreciate how these four experts define, explain, and guide you through this new and often confusing concept. You'll learn what it is, why it matters, and how to choose and implement solutions that work. Effectively managing big data is an issue of growing importance to businesses, not-for-profit organizations, government, and IT professionals Authors are experts in information management, big data, and a variety of solutions Explains big data in detail and discusses how to select and implement a solution, security concerns to consider, data storage and presentation issues, analytics, and much more Provides essential information in a no-nonsense, easy-to-understand style that is empowering Big Data For Dummies cuts through the confusion and helps you take charge of big data solutions for your organization.
Beginning SharePoint 2013. Building Business Solutions
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.