Программы

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.

Master VBA automation quickly and easily to get more out of Excel Excel VBA 24-Hour Trainer, 2nd Edition is the quick-start guide to getting more out of Excel, using Visual Basic for Applications. This unique book/video package has been updated with fifteen new advanced video lessons, providing a total of eleven hours of video training and 45 total lessons to teach you the basics and beyond. This self-paced tutorial explains Excel VBA from the ground up, demonstrating with each advancing lesson how you can increase your productivity. Clear, concise, step-by-step instructions are combined with illustrations, code examples, and downloadable workbooks to give you a practical, in-depth learning experience and results that apply to real-world scenarios. This is your comprehensive guide to becoming a true Excel power user, with multimedia instruction and plenty of hands-on practice. Program Excel's newest chart and pivot table object models Manipulate the user interface to customize the look and feel of a project Utilize message boxes, input boxes, and loops to yield customized logical results Interact with and manipulate Word, Access, PowerPoint, and Outlook from Excel If you're ready to get more out of this incredibly functional program, Excel VBA 24-Hour Trainer, 2nd Edition provides the expert instruction and fast, hands-on learning you need.

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!

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.

Maximize your Excel experience with VBA Excel 2016 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2016. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. Over 800 pages of tips, tricks, and best practices shed light on key topics, such as the Excel interface, file formats, enhanced interactivity with other Office applications, and improved collaboration features. In addition to the procedures, tips, and ideas that will expand your capabilities, this resource provides you with access to over 100 online example Excel workbooks and the Power Utility Pak, found on the Mr. Spreadsheet website. Understanding how to leverage VBA to improve your Excel programming skills can enhance the quality of deliverables that you produce—and can help you take your career to the next level. Explore fully updated content that offers comprehensive coverage through over 900 pages of tips, tricks, and techniques Leverage templates and worksheets that put your new knowledge in action, and reinforce the skills introduced in the text Access online resources, including the Power Utility Pak, that supplement the content Improve your capabilities regarding Excel programming with VBA, unlocking more of your potential in the office Excel 2016 Power Programming with VBA is a fundamental resource for intermediate to advanced users who want to polish their skills regarding spreadsheet applications using VBA.

Your one-stop guide to all things Excel 2016 Excel 2016 All-in-One For Dummies, the most comprehensive Excel reference on the market, is completely updated to reflect Microsoft's changes in the popular spreadsheet tool. It offers you everything you need to grasp basic Excel functions, such as creating and editing worksheets, setting up formulas, importing data, performing statistical functions, editing macros with Visual Basic—and beyond. In no time, your Excel skills will go from 'meh' to excellent. Written by expert Greg Harvey, who has sold more than 4.5 million copies of his previous books combined and has taught and trained extensively in Microsoft Excel, this all-encompassing guide offers everything you need to get started with Excel. From generating pivot tables and performing financial functions to performing error trapping and building and running macros—and everything in between—this hands-on, friendly guide makes working with Excel easier than ever before. Serves as the ideal reference for solving common questions and Excel pain points quickly and easily Helps to increase productivity and efficiency when working in Excel Fully updated for the new version of Excel Covers basic and more advanced Excel topics If working in Excel occasionally makes you want to scream, this will be the dog-eared, dust-free reference you'll turn to again and again.

Authoritative, hands-on guidance for Skype Business administrators Mastering Skype for Business 2015 gives administrators the comprehensive coverage they need to effectively utilize Skype for Business. Fully up to date for the 2015 release, this guide walks you through industry best practices for planning, design, configuration, deployment, and management with clear instruction and plenty of hands-on exercises. Case studies illustrate the real-world benefits of Unified Communication, and provide expert experiences working with Skype for Business. From server roles, infrastructure, topology, and security to telephony, cloud deployment, and troubleshooting, this guide provides the answers you need and the insight that will make your job easier. Sample automation scripts help streamline your workflow, and full, detailed coverage helps you exploit every capability Skype for Business has to offer. Skype for Business enables more robust video conferencing, and integrates with Office, Exchange, and SharePoint for better on-premises and cloud operations. Organizations are turning to Skype for Business as a viable PBX replacement, and admins need to be up to speed and ready to go. This book provides the clear, explicit instructions you need to: Design, configure, and manage IM, voice mail, PBX, and VoIP Connect to Exchange and deploy Skype for Business in the cloud Manage UC clients and devices, remote access, federation, and public IM Automate management tasks, and implement cross-team backup-and-restore The 2015 version is the first Skype to take advantage of the Windows 10 'touch first' capabilities to provide fast, natural, hands-on control of communications, and users are eager to run VoIP, HD video conferencing, collaboration, instant messaging, and other UC features on their mobile devices. Mastering Skype for Business 2015 helps you get Skype for Business up and running quickly, with hands-on guidance and expert insight.

The quickest way to do the books! Finances don’t have to put you in a funk! With the help of this all-encompassing book, you’ll get the easy-to-follow instruction you need to get your business’ ducks in a row—without ever losing your cool. Whether you’re a numbers person or have never spent much time with a calculator, you’ll discover how to use QuickBooks 2019 to make it easier than ever to handle your finances. This value-priced reference combines eight content-rich mini-books into one complete package, providing the answers you need to get the most out of the latest version of QuickBooks. No stone is left unturned, giving you everything you need to turn what used to be harrowing tasks into simple items you can check off on your to-do list. Helps you use QuickBooks to ease accounting chores, financial management, and business planning Provides guidance from an industry expert Shows you how to set up a QuickBooks accounting system, load the master files lists, invoice customers, pay vendors, track inventory, manage cash and bank accounts, and more Gives helpful troubleshooting tips to make your accounting easy Your time is precious—why waste a minute when QuickBooks can make it easier? Get started today!

В методических указаниях рассмотрено выполнение всех необходимых операций создания календарно-ресурсного плана проекта, его контроль и исполнение. Для освоения материала требуются начальные навыки работы с MS Excel, Word. Предназначены для проведения практических занятий по дисциплинам в области управления проектами в современной компании с использованием программного продукта MS Project для студентов всех специальностей и уровней подготовки.

Лабораторный практикум предназначен для освоения обучающимися основных принципов и методов работы в ГГИС Micromine. Содержит краткие сведения об основных принципах работы в среде ГГИС Micromine. Рассмотрены вопросы организации и хранения геолого-маркшейдерских данных; основные функциональные возможности структурных модулей системы и их команды; основы построения каркасных и блочных моделей рудных тел, а также решения на их основе ряда задач. В каждой лабораторной работе представлены контрольные вопросы для самоконтроля знаний и список рекомендуемой литературы. Лабораторный практикум предназначен для обучающихся по специальности 21.05.04 «Горное дело», специализации «Маркшейдерское дело» и других специализаций данной специальности.

This book fills a gap between high-level overview texts that are often too general and low-level detail oriented technical handbooks that lose sight the «big picture». This book discusses SOA from the low-level perspective of middleware, various XML-based technologies, and basic service design. It also examines broader implications of SOA, particularly where it intersects with business process management and process modeling. Concrete overviews will be provided of the methodologies in those fields, so that students will have a hands-on grasp of how they may be used in the context of SOA.

Pioneering work shows how using Diagrams facilitates the design of better AI systems The publication of Diagrammatic Reasoning in AI marks an important milestone for anyone seeking to design graphical user interfaces to support decision-making and problem-solving tasks. The author expertly demonstrates how diagrammatic representations can simplify our interaction with increasingly complex information technologies and computer-based information systems. In particular, the book emphasizes how diagrammatic user interfaces can help us better understand and visualize artificial intelligence (AI) systems. It examines how diagrammatic reasoning enhances various AI programming strategies used to emulate human thinking and problem-solving, including: Expert systems Model-based reasoning Inexact reasoning such as certainty factors and Bayesian networks Logic reasoning A key part of the book is its extensive development of applications and graphical illustrations, drawing on such fields as the physical sciences, macroeconomics, finance, business logistics management, and medicine. Despite such tremendous diversity of usage, in terms of applications and diagramming notations, the book classifies and organizes diagrams around six major themes: system topology; sequence and flow; hierarchy and classification; association; cause and effect; and logic reasoning. Readers will benefit from the author's discussion of how diagrams can be more than just a static picture or representation and how diagrams can be a central part of an intelligent user interface, meant to be manipulated and modified, and in some cases, utilized to infer solutions to difficult problems. This book is ideal for many different types of readers: practitioners and researchers in AI and human-computer interaction; business and computing professionals; graphic designers and designers of graphical user interfaces; and just about anyone interested in understanding the power of diagrams. By discovering the many different types of diagrams and their applications in AI, all readers will gain a deeper appreciation of diagrammatic reasoning.

The human-computer interactions are more and more present in our everyday life, and lead to many conceptual and methodological problems for the designers and evaluators of interactive systems. This book is about Human-Computer Interaction in Transport domain, in which the traveler becomes a user of information systems, particularly before and during the travel(s). This book will focus on traveler information and personalized systems, using a human-centered design approach.

A computational perspective on partial order and lattice theory, focusing on algorithms and their applications This book provides a uniform treatment of the theory and applications of lattice theory. The applications covered include tracking dependency in distributed systems, combinatorics, detecting global predicates in distributed systems, set families, and integer partitions. The book presents algorithmic proofs of theorems whenever possible. These proofs are written in the calculational style advocated by Dijkstra, with arguments explicitly spelled out step by step. The author’s intent is for readers to learn not only the proofs, but the heuristics that guide said proofs. Introduction to Lattice Theory with Computer Science Applications: Examines; posets, Dilworth’s theorem, merging algorithms, lattices, lattice completion, morphisms, modular and distributive lattices, slicing, interval orders, tractable posets, lattice enumeration algorithms, and dimension theory Provides end of chapter exercises to help readers retain newfound knowledge on each subject Includes supplementary material at www.ece.utexas.edu/~garg Introduction to Lattice Theory with Computer Science Applications is written for students of computer science, as well as practicing mathematicians.

Evolutionary algorithms are bio-inspired algorithms based on Darwin’s theory of evolution. They are expected to provide non-optimal but good quality solutions to problems whose resolution is impracticable by exact methods. In six chapters, this book presents the essential knowledge required to efficiently implement evolutionary algorithms. Chapter 1 describes a generic evolutionary algorithm as well as the basic operators that compose it. Chapter 2 is devoted to the solving of continuous optimization problems, without constraint. Three leading approaches are described and compared on a set of test functions. Chapter 3 considers continuous optimization problems with constraints. Various approaches suitable for evolutionary methods are presented. Chapter 4 is related to combinatorial optimization. It provides a catalog of variation operators to deal with order-based problems. Chapter 5 introduces the basic notions required to understand the issue of multi-objective optimization and a variety of approaches for its application. Finally, Chapter 6 describes different approaches of genetic programming able to evolve computer programs in the context of machine learning.

This book presents the necessary concepts for the design and testing of radiofrequency and high-speed circuits. Signal and propagation theory is presented for the various circuit levels, from the chip to the PCB. The co-existence of high-speed wideband signals of radiofrequency signals and supply circuits is developed in order to provide design rules for engineers and Masters-level students. The subjects covered include: interconnections and signal integrity; spectral analysis techniques for high-speed signals; design techniques for signal integrity; the transmission-line concept; methods for temporal analysis and techniques for frequency domain analysis for connectics.

The design, implementation and validation of avionics and aeronautical systems have become extremely complex tasks due to the increase of functionalities that are deployed in current avionics systems and the need to be able certify them before putting them into production. This book proposes a methodology to enable the rapid prototyping of such a system by considering from the start the certification aspects of the solution produced. This method takes advantage of the model-based design approaches as well as the use of formal methods for the validation of these systems. Furthermore, the use of automatic software code generation tools using models makes it possible to reduce the development phase as well as the final solution testing. This book presents, firstly, an overview of the model-based design approaches such as those used in the field of aeronautical software engineering. Secondly, an original methodology that is perfectly adapted to the field of aeronautical embedded systems is introduced. Finally, the authors illustrate the use of this method using a case study for the design, implementation and testing of a new generation aeronautical router.

This title concerns the use of a particle filter framework to track objects defined in high-dimensional state-spaces using high-dimensional observation spaces. Current tracking applications require us to consider complex models for objects (articulated objects, multiple objects, multiple fragments, etc.) as well as multiple kinds of information (multiple cameras, multiple modalities, etc.). This book presents some recent research that considers the main bottleneck of particle filtering frameworks (high dimensional state spaces) for tracking in such difficult conditions.