Tabla de Contenidos: “…La hoja de cálculo Microsoft Excel 2010…”

Tabla de Contenidos: “…Connecting to files in Tableau Desktop -- Getting data from Microsoft Excel files -- Getting data from text (or delimited) files -- Importing geospatial file types to allow for visual analysis with maps -- Creating data models from statistical files -- Creating data models from JSON files -- Getting data from tables in PDF files -- Dealing with preformatted reporting files with data interpreter and pivoting columns to rows -- Connecting to servers through installed connectors -- Connecting to servers through other connectors -- Additional connectors -- Web data connectors -- Connecting to databases without a listed connection -- Connecting to the Tableau data server -- Summary -- Chapter 8: Building Data Models Using Relationships -- Technical requirements -- Using relationships to combine tables at the logical layer -- Many use cases with a single data model -- Ability to handle tables at different levels of aggregation -- Understanding the differences between relationships and joins -- Setting performance options for relationships -- Creating manual and wildcard unions in Tableau Desktop to add additional rows of data -- Manual union -- Summary -- Chapter 9: Building Data Models at the Physical Level -- Technical requirements -- Opening relationships to join at the physical layer through database joins -- Single use case and using the join for a filter -- Geospatial join type to drive map-based analysis -- Using joins to create a data model with row-level security -- Understanding custom SQL - when to use it and the pitfalls of using it -- Summary -- Chapter 10: Sharing and Extending Tableau Data Models -- Technical requirements -- Understanding live connections and extracts - scenarios for using each -- Creating extracts with the Tableau Hyper engine -- Understanding extracts and data source filters…”

“…Make informed business decisions with the beginner's guide to financial modeling using Microsoft Excel Financial Modeling in Excel For Dummies is your comprehensive guide to learning how to create informative, enlightening financial models today. …”

Tabla de Contenidos: “…Obtaining Data -- Overview -- Copying Local Files to the Docker Container -- Downloading from the Internet -- Introducing curl -- Saving -- Other Protocols -- Following Redirects -- Decompressing Files -- Converting Microsoft Excel Spreadsheets to CSV -- Querying Relational Databases -- Calling Web APIs -- Authentication -- Streaming APIs -- Summary -- For Further Exploration -- Chapter 4. …”

Tabla de Contenidos: “…FileNet Content Manager -- A granular and configurable security model -- A full spectrum of governance capabilities -- A configurable user experience -- Content capture with Datacap -- Document processing with AI -- AI-powered extraction -- Pre-trained models for document types -- Low-code application building -- Business users can train their own document types -- Summary -- Further reading -- Part 2: Use Cases and Best Practices -- Chapter 5: Task Automation with RPA -- Let's understand the business problem -- IBM RPA client/server topology -- RPA automation -- Reading from Microsoft Excel -- IBM RPA Studio -- WAL command language -- Reading the Excel table -- Using RPA to interact with SAP UI -- Creating a managed credential -- Interacting with SAP GUI -- IBM RPA Studio Recorder -- Packaging and deployment -- Publishing our tested robot -- Creating the launcher for our sales assistant -- Going further -- Subroutines -- Advanced topics - exception handling and troubleshooting -- Data validation -- Script logs -- Exception handling -- Leveraging other Cloud Pak for Business Automation features -- Unique Desktop Issues -- Sleep -- UI changes -- Simulate human behavior -- Further reading -- Chapter 6: Chatbot with RPA -- Technical requirements -- Business problems -- Developing a chatbot -- NLP -- IBM RPA Knowledge Bases -- Knowledge Base spreadsheet example -- Packaging and deployment -- Leveraging the knowledge base in the WAL language -- Configuring the bot service -- Azure Bot Service -- Programming the chatbot -- IBM RPA-hosted chat -- Advanced topic-chat history -- IBM RPA chatbot history local database -- IBM RPA chatbot history server database -- Summary -- Chapter 7: Workflow for Process Automation -- Technical requirements -- Problem statement -- Building the workflow process -- Creating the first process…”

Tabla de Contenidos: “…Sametime and workflow -- 6.1 Using Sametime within a workflow -- 6.2 The scenario -- 6.3 The AnnouncementSender application -- 6.3.1 The AnnouncementSender agent -- 6.4 The AnnouncementSender Web service -- 6.5 Sending rich text announcements with STLinks -- 6.6 Integrating with Microsoft Excel -- 6.6.1 Enabling Microsoft Excel for Web services -- 6.7 Summary -- Chapter 7. …”

Tabla de Contenidos: “…Options for storing Visio files for broader distribution -- Storage in OneDrive and OneDrive for Business -- Storage in SharePoint Online -- Adding Visio documents to Teams channels for reviewers (including shared channels) -- Publishing a Visio file in Microsoft Teams on a tab -- Using conversations and comments with Visio documents -- Removing comments from a Visio document -- Co-authoring in Teams and SharePoint -- Sharing a Visio file -- Protecting a Visio document from viewing -- Protecting a Visio document or parts from edits -- Summary -- Chapter 9: Integrating Visio with Other Microsoft Apps -- Technical requirements -- Exporting processes to Microsoft Word for documentation -- Enhancing the Word document -- Exporting diagrams to Microsoft PowerPoint for presentation -- Optional Visio add-in to provide extra features -- Exporting data to Microsoft Excel for integration -- Creating a report definition -- Running a report definition -- Optional Excel add-in to convert the report into a modern table -- Embedding processes in Microsoft Power BI for interaction -- Preparing a Visio diagram for Power BI -- Preparing data for Power BI -- Embedding into Power BI -- Summary -- Chapter 10: Customizing Master Shapes and Templates -- Technical requirements -- Understanding the importance of master shapes -- Viewing the Document Stencil -- Understanding the Drawing Explorer window -- Shape instances inherit values from a master shape -- Introducing the ShapeSheet -- Reviewing existing selected process master shapes -- Types of Shape Data -- Adding description shape data to existing master shapes -- Adding Duration to shape data -- Assigning line weight, style, or color by Owner -- Matching the shape color with the swimlane color -- Summary -- Chapter 11: Improving the Provided Flowchart Shapes -- Technical requirements…”

Tabla de Contenidos: “…Printing a register -- Exporting a register -- Chapter 10 Administering Bank and Credit Card Accounts -- Setting Up a Bank or Credit Card Account -- Making a Bank Deposit -- Making a Credit Card Payment -- Recording a Credit Card Credit -- Reconciling a Bank or Credit Card Account -- Chapter 11 Synchronizing with Financial Institutions -- Connecting QuickBooks Accounts to Financial Institutions -- Connecting . . . or not connecting -- Accessing bank and credit card-related pages in QuickBooks -- Being Direct: Connecting a Bank or Credit Card Account -- Managing uploaded or downloaded activity -- Reviewing transactions -- Automating downloaded activity with rules -- Creating rules -- Exporting and importing rules -- Fixing mistakes in uploaded or downloaded transactions -- Using Indirect Connections to Financial Institutions -- Downloading Web Connect and text files -- Opening text files in Microsoft Excel or Google Sheets -- Editing text files -- Saving CSV files -- Uploading Web Connect and CSV files -- Connecting to Online Providers through App Transactions -- Converting Paper Receipts to Electronic Transactions -- Chapter 12 Working with Purchase Orders, Estimates, Projects, and Tags -- Working with Purchase Orders -- Enabling the purchase order feature -- Creating purchase orders -- Copying an existing purchase order -- Receiving items against purchase orders -- Closing purchase orders -- Tracking open purchase orders -- Working with Estimates -- Preparing an estimate -- Copying an estimate to a purchase order -- Converting an estimate to an invoice -- Copying an existing estimate -- Creating a progress invoice for an estimate -- Managing Projects -- Turning on the Project feature -- Contrasting projects with sub-customers -- Creating a new project -- Adding transactions to a project -- Reporting on projects -- Updating project status…”

Tabla de Contenidos: “…. -- Browsing your model with Microsoft Excel -- How to do it... -- How it works... -- Chapter 4: Working in Tabular Models -- Introduction -- Opening an existing model -- How to do it... -- How it works... -- Importing data -- Getting ready -- How to do it... -- How it works... -- Modifying model relationships -- How to do it... -- How it works... -- Modifying model measures -- How to do it... -- How it works... -- Modifying model columns -- How to do it... -- How it works... -- Modifying model hierarchies -- How to do it... -- How it works... -- There's more... -- Creating a calculated table -- How to do it... -- How it works... -- There's more... -- Creating key performance indicators (KPIs) -- How to do it... -- How it works... -- Modifying key performance indicators (KPIs) -- How to do it... -- How it works... -- Deploying a modified model -- How to do it... -- How it works... -- There's more... -- Chapter 5: Administration of Tabular Models -- Introduction -- Managing tabular model properties -- [Changing data backup locations] -- Changing data backup locations -- Changing DirectQuery mode -- Changing workspace retention -- Changing workspace server -- Managing perspectives -- Getting ready -- How to do it... -- Adding a new perspective -- Editing a perspective -- Renaming a perspective -- Deleting a perspective -- Copying a perspective -- Managing partitions -- How to do it... -- Creating a Partition -- Editing a partition -- Processing partitions -- How it works... -- Managing roles -- Getting ready -- How to do it... -- Creating Admin role -- Creating a Read role -- Creating a read and process role…”

Tabla de Contenidos: “…Microsoft Teams -- Microsoft Outlook -- Microsoft Word -- Microsoft Excel -- Overviewing Microsoft Enterprise Mobility + Security -- Microsoft Intune -- Microsoft Cloud App Security -- System Center Configuration Manager -- Contoso Inc. using Microsoft 365 -- Introducing Microsoft Azure -- Introducing Azure Active Directory -- Introducing Azure Service Bus -- Introducing Azure Event Hubs -- Introducing Azure Logic Apps -- Introducing Azure API Management -- Introducing Azure Functions -- Introducing Azure SQL -- Introducing Azure Cosmos DB -- Introducing Azure Blob Storage -- Introducing Azure Synapse Analytics -- Introducing Azure IoT Hub and Azure IoT Central -- Introducing Azure Key Vault -- Introducing Azure DevOps -- Introducing Azure Monitor -- Contoso Inc. using Microsoft Azure -- Microsoft 365 and Microsoft Azure licensing overview -- Microsoft 365 licensing -- Microsoft Azure licensing -- Summary -- Section II: The Architecture -- Chapter 3: Understanding the Microsoft Power Platform Architecture -- Contoso Inc. starts architecting their planned Power Platform solution -- Understanding the Power Platform architecture -- Learning about the Microsoft cloud infrastructure -- Understanding the customer cloud structure -- User management -- License management -- Group management -- App registration -- Office 365 Activity Logging -- Learning about Power Platform technology -- Understanding Power Platform environments -- Microsoft Dataverse -- Microsoft Dataverse for Teams -- Capacity restrictions -- Power Platform data connectors -- Data Loss Prevention policies -- On-Premises Data Gateway -- Managed environments -- Learning about Power BI's structure -- Understanding the Power Platform and Dynamics 365 clients -- Learning about desktop clients -- Browser client -- Dynamics 365 App for Outlook -- Unified Service Desk…”

Tabla de Contenidos: “…Underlying technology -- Light-weight Directory Access Protocol (LDAP) -- eXtensible Markup Language (XML) -- Microsoft Excel for browsing XML files -- Certificates and encryption -- Secret Key Cryptography -- Public Key Cryptography -- Refinements on cryptographic techniques -- Secure Sockets Layer protocol -- The Record Layer -- The communication protocols -- Abbreviations and acronyms -- Related publications -- IBM Redbooks -- Other publications -- Online resources -- How to get IBM Redbooks -- Help from IBM -- Index -- Back cover…”

Tabla de Contenidos: “…. -- Other -- Project management/programming tools -- Microsoft Project -- Microsoft Excel -- AMS Realtime -- Oracle Primavera -- Computer-Aided Design (CAD): drawing/drafting -- Autodesk AutoCAD/Inventor, etc. -- Bentley Systems Microstation -- PTC Creo -- Computer-Aided Design (CAD): process design -- Bentley Systems Axsys.Process/PlantWise -- Computer-Aided Design (CAD): hydraulic design -- COMSOL Multiphysics -- Matlab/Simulink -- Autodesk® Simulation CFD -- Other -- Microsoft Visio -- Microsoft Access -- Further Reading -- 5 The Future of Process Plant Design -- Process porn -- Will first principles design replace heuristic design in future? …”

Tabla de Contenidos: “…24 Working with Multiple Projects -- Using Windows Commands -- Comparing Project Versions -- Displaying Tasks from Different Projects in the Same Window -- Creating Master Projects -- Creating Links Between Tasks in Separate Projects -- Consultants' Tips -- 25 Resolving Resource Allocation Problems -- Understanding How Resource Allocation Problems Occur -- Visualizing Resource Allocation Conditions -- Strategies for Correcting Resource Allocation Problems -- Consultants' Tips -- 26 Exporting and Importing Project Data -- Exchanging Project Files Across Microsoft Project Versions -- Exchanging Microsoft Project Data with Other Applications -- Working with Import/Export Maps to Select Your Project Data -- Exchanging Data with Microsoft Excel -- Working with Web-Enabled Project Data -- Working with Text File Formats -- Importing a Task List from Outlook -- Consultants' Tips -- 27 Manipulating Data Using Other Applications -- Copying Data Between Applications -- Linking Data Between Applications -- Working with Objects -- Placing Objects into Microsoft Project -- Placing Objects into Other Applications -- Consultants' Tips -- Index…”

Tabla de Contenidos: “…Cover -- FM -- Copyright -- Contributors -- Table of Contents -- Preface -- Chapter 1: Connecting to Data -- Introduction to Data -- Making the Most Out of This Book - Your Certification and Beyond -- Connecting to Sources -- Data Structure -- Choosing an Appropriate Data Source Type -- Content and Quality -- Level of detail: Dimensions and Measures -- Data Quality -- Technical Requirements -- Performance: Data Size and Structure -- Microsoft Excel (.xlsx) and Comma-Separated Values (.csv) Types -- Relational Databases -- Initial Data Connections -- Connecting to Tableau Server or Tableau Cloud -- Connecting to a File -- CSV and Excel Files -- .hyper or .tde Files -- JSON -- PDF -- Spatial Files -- Statistical Files -- Connecting to Databases and Cloud Services -- Default Server Connectors -- Custom SQL Queries -- Introduction to SQL and Custom Queries in Tableau -- Live versus Extract Connections -- Live Connections -- Data Extracts -- Other Factors Affecting Performance -- Connection Management: the Datasource Pane and Data Tab -- The Datasource Window -- The Data Tab -- Making New Connections in Existing Workbooks -- Replacing Data Sources -- Notes, Caveats, and Unsupported Data Sources -- Web-Based Data Access: Drivers and APIs -- Multidimensional Systems -- Summary -- Exam Readiness Drill - Chapter Review Questions -- Chapter 2: Transforming Data -- Introduction -- Types of Fields in Tableau -- Data Types -- Data Type Conversion -- Dimensions and Measures -- Dimensions and Measure Field Conversion -- Discrete and Continuous -- Dimension, Measure, Discrete, and Continuous Combinations -- Discrete and Continuous Color Legends -- Cleaning Data -- Assessing Data Quality -- Cleaning data on Tableau Desktop -- Duplicating and Renaming a Field Updating the Aliases -- Updating the Default Properties of Fields -- Data Interpreter…”

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

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