“…It presents simple simulation models built in universal spreadsheet software such as Microsoft Excel®. These realistically reflect the varying and erratic sources of uncertainty and price dynamics that uniquely characterize real estate. …”

Tabla de Contenidos: “…-- Installation -- Fabric operations -- Using run operation -- Using get operation -- Using put operation -- Using sudo operation -- Using prompt operation -- Using reboot operation -- Executing your first Fabric file -- More about the fab tool -- Discover system health using Fabric -- Other useful features in Fabric -- Fabric roles -- Fabric context managers -- Summary -- Chapter 11: Generating System Reports and System Monitoring -- Collecting data from Linux -- Sending generated data through email -- Using the time and date modules -- Running the script on a regular basis -- Managing users in Ansible -- Linux systems -- Microsoft Windows -- Summary -- Chapter 12: Interacting with the Database -- Installing MySQL on an automation server -- Securing the installation -- Verifying the database installation -- Accessing the MySQL database from Python -- Querying the database -- Inserting records into the database -- Summary -- Chapter 13: Ansible for System Administration -- Ansible terminology -- Installing Ansible on Linux -- On RHEL and CentOS -- Ubuntu -- Using Ansible in ad hoc mode -- How Ansible actually works -- Creating your first playbook -- Understanding Ansible conditions, handlers, and loops -- Designing conditions -- Creating loops in ansible -- Trigger tasks with handlers -- Working with Ansible facts -- Working with the Ansible template -- Summary -- Chapter 14: Creating and Managing VMware Virtual Machines -- Setting up the environment -- Generating a VMX file using Jinja2 -- Building the VMX template -- Handling Microsoft Excel data -- Generating VMX files -- VMware Python clients -- Installing PyVmomi -- First steps with pyvmomi -- Changing the virtual machine state -- There's more -- Using Ansible playbook to manage instances…”

Tabla de Contenidos: “…Common table expressions -- Pivot tables -- Joining data from multiple tables -- New York taxi data -- Reading remote files with the HTTPFS extension -- Location lookup -- Taxi trip cost and tipping -- Finding the most expensive trip with window functions -- Summary -- Chapter 4: DuckDB Operations and Performance -- Technical requirements -- Exploring DuckDB indexes -- Downloading the book review dataset from Kaggle -- Preparing the book review dataset -- Reviewing and indexing the book review dataset -- Explaining the query plan -- Creating an index -- Optimizing the file read performance of DuckDB -- File partitioning -- Parquet predicate pushdown -- Run-time profiling exercise -- Working with timestamps -- TIMESTAMP -- TIMESTAMPTZ - Timestamps with time zones -- Exploring timestamps with time zone functions -- Binning and functions using time zone functions -- Time and window functions -- The Apollo 11 mission -- Interval data -- The LEAD and LAG window functions -- Summary -- Chapter 5: DuckDB Extensions -- Technical requirements -- Expanding DuckDB capabilities with extensions -- Available extensions in DuckDB -- The SQLite extension -- Reading and writing remote files using the HTTPFS extension -- Full-text search indexes -- Working with geospatial data -- The spatial extension -- Reading Microsoft Excel files -- Points within a polygon -- Summary -- Chapter 6: Semi-Structured Data Manipulation -- Technical requirements -- Exploring nested data types -- The LIST data type -- The MAP data type -- The STRUCT data type -- Working with lists -- Preparing the data -- List aggregation -- List functions -- List comprehensions -- Working with JSON -- The JSON extension -- Creating JSON objects -- Importing JSON data -- Unpacking lists with the unnest function -- Working with inconsistent schemas -- Querying JSON data from an API -- Summary…”

Tabla de Contenidos: “…-- 3 How to Use This Book -- 4 Book Structure -- 5 Chapter Style -- 6 Examples and Exercises -- 7 Verification of Code and Calculations - Best Practice -- 8 Website: www.wiley.com/go/rprogramming.com -- 9 R or Microsoft Excel? -- 10 Caveats -- 11 Acknowledgements -- 1 R : What You Need to Know to Get Started -- 1.1 Introduction -- 1.2 Getting Started: Installation of R and RStudio -- 1.2.1 Installing R -- 1.2.2 What Is RStudio? …”

Tabla de Contenidos: “…4.9 Adding Graphics to Document -- 4.9.1 Pictures -- 4.9.2 Editing a Picture -- 4.9.3 Drawing Objects -- 4.10 Mail Merge -- 4.10.1 Components of a Mail Merge -- 4.10.2 Mail Merge Steps -- 4.11 Printing a Document -- 4.11.1 Setting Page Margins -- 4.11.2 Print Preview -- 4.11.3 Printing the Document -- 4.12 Important Keyboard Shortcuts -- Summary -- Exercises -- Chapter 5: Power Point Presentations and Spreadsheets -- 5.1 Introduction -- 5.2 Starting Microsoft Office PowerPoint 2003 -- 5.2.1 Microsoft PowerPoint Environment -- 5.3 Working with PowerPoint 2003 -- 5.3.1 Creating a New Presentation -- 5.3.2 Opening a Presentation -- 5.3.3 Saving a Presentation -- 5.4 Designing a Presentation -- 5.4.1 Choosing Design Template -- 5.4.2 Using Masters -- 5.4.3 Working with Slides -- 5.4.4 Working with Text -- 5.4.5 Running Slides -- 5.5 Spreadsheets -- 5.6 Starting Microsoft Office Excel 2003 -- 5.6.1 Microsoft Excel Environment -- 5.7 Working with Excel Workbook -- 5.7.1 Creating an Excel Workbook -- 5.7.2 Opening an Existing Workbook -- 5.7.3 Saving Workbook -- 5.7.4 Closing a Workbook -- 5.8 Working with Worksheet -- 5.8.1 Entering Data in Cells -- 5.8.2 Editing a Worksheet -- 5.8.3 Using Cut, Copy, and Paste in Excel -- 5.9 Inserting Charts -- 5.9.1 Creating Charts -- 5.9.2 Using Chart Toolbar -- 5.9.3 Saving a Chart -- Summary -- Exercises -- Chapter 6: Information Technology and the Internet -- 6.1 Introduction -- 6.2 Information Technology (IT) -- 6.3 Internet -- 6.3.1 Evolution of Internet -- 6.3.2 Basic Internet Terms -- 6.3.3 Getting Connected to the Internet -- 6.3.4 Internet Services -- 6.3.5 Data over Internet -- Summary -- Exercises -- Chapter 7: Problem Solving and Program Planning -- 7.1 Introduction -- 7.1.1 Planning the Computer Program -- 7.1.2 Program Development Cycle -- 7.2 Program Design Tools -- 7.2.1 Algorithms -- 7.2.2 Flowchart…”

Tabla de Contenidos: “…Analytical Master Data Management -- 9.5 - Master Data Management as an Enabler for Managed Self-Service BI -- 9.6 - Master Data Management as an Enabler for Total Quality Management -- 9.6.1 - MDS Object Model -- 9.6.1.1 - Models -- 9.6.1.2 - Entities -- 9.6.1.3 - Members -- 9.6.1.4 - Attributes -- 9.6.1.5 - Attribute Groups -- 9.6.1.6 - Hierarchies -- 9.6.2 - Master Data Manager -- 9.6.3 - Explorer -- 9.6.3.1 - Microsoft Excel and MDS -- 9.6.4 - Version Management -- 9.6.5 - Integration Management -- 9.6.6 - System Administration -- 9.6.7 - User and Group Permissions -- 9.7 - Creating a Model -- 9.7.1 - Creating Entities -- 9.7.2 - Creating Business Rules -- 9.8 - Importing a Model -- 9.9 - Integrating MDS with the Data Vault and Operational Systems -- 9.9.1 - Stage Tables -- 9.9.1.1 - Using T-SQL to Stage Master Data into Microsoft Master Data Services -- 9.9.1.2 - Using SQL Server Integration Services to Stage Master Data into Microsoft Master Data Services -- 9.9.2 - Subscription Views -- References -- Chapter 10 - Metadata Management -- 10.1 - What Is Metadata? …”

Tabla de Contenidos: “…-- Modeling File Sources, Including Microsoft Excel -- Overview -- Setting Up Connectivity and Importing File Metadata Using ODBC Drivers -- Creating the Physical Model -- Modeling XML Sources -- Overview -- Setting Up Connectivity to XML Sources…”

Tabla de Contenidos: “…Using Quick Styles and Effects -- Aligning, arranging, and distributing objects -- Chapter 11 Making Your Slide Shows Sing -- Using Transitions to Create a Polished-Looking Presentation -- Applying transitions -- Transition options -- Using Custom Animation -- Animating text or graphics -- Animating a chart or SmartArt graphic -- Creating Interactivity with Action Buttons -- Share and Share Alike -- Printing hard copy -- Exporting (saving) your presentations as files -- Chapter 12 Presentation Prowess -- Working with the Basic PowerPoint Tools -- Ribbon and Quick Access toolbar customization -- Customize ribbon tabs and tab groups by rearranging them -- Creating ribbon tabs and tab groups -- Customizing the Quick Access toolbar -- Proofing and reference tools -- Commenting on slides -- Templates and other miscellaneous tools -- Using Hyperlinks -- Recording Narration -- Making the Most of Your PowerPoint Presentation -- Rehearsing and setting slide timings -- Using the presenter tools -- Working with a single display -- Part 4 Crunching Data with Microsoft's Most Excellent Excel -- Chapter 13 Getting to Know Microsoft Excel -- Interfacing with Excel's User Interface -- Understanding the Concept of Rows, Columns, and Cells -- Using the Views -- Navigating within Your Worksheets -- Chapter 14 Crunching Numbers (and Data) with Excel -- Working with Templates -- Choosing a local template -- Working with online templates -- Entering, Formatting, and Editing Data in Cells -- Copying and Pasting Data (and Formatting) between Cells -- AutoFilling Cells -- Understanding Formulas and Functions -- Creating a formula -- Keeping track of Excel formulas with Formula Builder -- Using the Error Checking Feature -- Sorting and Filtering Data -- Sorting data -- Using filters to narrow your data searches -- Finding and Replacing Data…”

“…It provides examples of altering the style elements and the effect on the main ODS destinations, while also discussing common pitfalls that programmers can avoid while working with tables, Microsoft Excel, Microsoft Power Point, and PDF output…”

“…It includes numerous case studies and a Microsoft Excel based software tool to allow planners to evaluate the business case for implementing various water conservation activities. …”

“…It then moves on to more technical topics, such as the principles of financial modeling and the proper way to approach a financial modeling assignment, before covering key application areas for modeling in Microsoft Excel. What You'll Learn Understand the accounting and finance concepts that underpin working financial models Approach financial issues and solutions from a modeler's perspective Think about end users when developing a financial model Plan, design, and build a financial model Who This Book Is For Beginning to intermediate modelers who wish to expand and enhance their knowledge of using Excel to build and analyze financial models…”

“…An konkreten Beispielen und Problemstellungen lernen Sie, wie sie bereits bekannte Microsoft Office-Anwendungen (Microsoft Excel, Microsoft Visio) zur Geschäftsdatenanalyse einsetzen und in Verbindung mit SharePoint Server 2010 zur Veröffentlichung und Verteilung verwenden können…”

“…—Eric Gruber, Microsoft “Excellent coverage of the most important features and techniques of developing ASP.NET 2.0 applications, with plenty of sample code.” …”

“…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!…”

“…An expert on a range of Microsoft products from Office Suite and MS Access to MS Project and more, Guy is the author of thirty seven O'Reilly titles, including "Learning Microsoft Excel 2016", "Microsoft Project for Software Developers", and "Learning SQL"…”

“…The book concludes with view factor computations of bifacial solar photovoltaic based on the finite element method using two programming languages to demonstrate that Python offers a better platform than Microsoft Excel-Visual Basic for Applications where computation time is a significant modelling challenge…”

“…To facilitate the application of the costing method to actual projects, a basic tool was developed using Microsoft Excel, which is called a water supply costing processor. …”

“…Expert on a range of Microsoft products from Office Suite and MS Access to MS Project and more, Guy is the author of thirty seven O'Reilly titles, including Learning Microsoft Excel 2016, Microsoft Project For Software Developers, and Learning SQL…”

“…As an expert on a range of Microsoft products from Office Suite and MS Access to MS Project and more, Guy is the author of thirty seven O'Reilly titles, including Learning Microsoft Excel 2016, Microsoft Project For Software Developers, and Learning SQL…”

“…Configuration requise (pour le cd-rom) : PC ou Mac avec les logiciels Microsoft Excel (fichiers .xls) et Acrobat Reader (fichiers .pdf), et un navigateur web (fichiers .html). …”