Kategoria BISAC: Computers >> Business & Productivity Software - Spreadsheets

Power Query for Power BI and Excel is a book for people who are tired of copying and pasting data into Excel worksheets. Power Query, part of the Microsoft Power BI suite, is a tool that automates the process of getting data into Excel and will save you hours of dull, repetitive, and error-prone work Power Query makes it easy to extract data from many different data sources, filter that data, aggregate it, clean it and perform calculations on it, finally loading that data into either your worksheet or directly into the new Excel 2013 Data Model used by Power Pivot. This concise,...

Data Analysis Using SQL and Excel, 2nd Edition shows you how to leverage the two most popular tools for data query and analysis--SQL and Excel--to perform sophisticated data analysis without the need for complex and expensive data mining tools. Written by a leading expert on business data mining, this book shows you how to extract useful business information from relational databases. You'll learn the fundamental techniques before moving into the -where- and -why- of each analysis, and then learn how to design and perform...

This is the first book to show the capabilities of Microsoft Excel to teach environmental sciences statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical environmental sciences problems. If understanding statistics isn't your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you.

Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in...

Visual Basic for Applications (VBA) is a programming language created by Microsoft that can be used to automate operations in Microsoft Excel. This textbook has been written for undergraduate students majoring in actuarial science and related areas who wish to learn the basic fundamentals and applications of Excel VBA. It can also be used as supplementary reading for courses related to computer programming, financial modelling, and information technology for business.

Dieses Handbuch ist die seminarbegleitende Unterlage zum Thema Power Query mit Excel. Es richtet sich an alle Anwender, die ihre Daten ohne lastige manuelle Arbeiten oder Programmierung komfortabel abrufen und fur die spatere Analyse aufbereiten mochten.

Power Query ist ein kostenloses Add-In fur Excel direkt von Microsoft. Es lauft innerhalb von Excel in einem eigenstandigen Fenster und ist spezialisiert auf den Import und die Bereinigung von Daten aller Art. In Excel 2016 ist Power Query bereits integriert. Die Werkzeugkiste von Power Query...

In this, the second in his two-part series, Ludwig Reinhard, PhD, moves deeper into the functionality of the Microsoft Dynamics 365 project-management and accounting module. While part one in the series provides a solid foundation in accounting and controlling methodologies as they apply to module setup and configuration, part two explores the module's versatile functionality in specific scenarios.

Reinhard shows you how to use the module to reach your goals. He covers such special accounting topics as ledger posting, investment projects, standard reporting tools, activity-based...