“…The authors also provide a link for downloading Microsoft Excel workbooks they’ve developed and that are used throughout the book that include VBA (Visual Basic for Applications) code for certain functions or commands. …”

“…This edition contains more practical examples than ever -- all updated for the newest versions of Microsoft Excel. You'll find downloadable practice files, templates, data sets, and sample models -- including complete solutions you can put right to work in business, school, or anywhere else."…”

Tabla de Contenidos: “…B.4.4 Test the table-structured file nickname -- B.5 Microsoft Excel data source -- B.5.1 Microsoft Excel data source considerations -- B.5.2 Set up Excel ODBC data source name on Windows -- B.5.3 Create the ODBC wrapper -- B.5.4 Create the ODBC server definition -- B.5.5 Create the ODBC nickname -- B.5.6 Test the ODBC nickname -- B.6 WebSphere MQ data source -- B.6.1 Install WebSphere MQ AMI -- B.6.2 Enable the federated database for WebSphere MQ UDFs -- B.6.3 Setup access to your WebSphere MQ queues -- B.7 DB2 UDB for z/OS data source -- B.7.1 Catalog DB2 UDB for z/OS -- B.7.2 Create the DB2 UDB for z/OS wrapper -- B.7.3 Create the DB2 UDB for z/OS server definition -- B.7.4 Create the DB2 UDB for z/OS user mappings -- B.7.5 Create the DB2 UDB for z/OS nickname -- B.7.6 Test the DB2 UDB for z/OS nickname -- B.8 Lotus Extended Search data source -- B.8.1 Create the LES wrapper -- B.8.2 Create the LES server definition -- B.8.3 Create the LES user mappings -- B.8.4 Create the LES nickname -- B.8.5 Test the LES nickname -- B.8.6 Register the Extended Search custom function -- Related publications -- IBM Redbooks -- Other publications -- Online resources -- How to get IBM Redbooks -- Help from IBM -- Index -- Back cover…”

Acceso restringido usuarios UPSA

“…Users can build statistical tables based on specific variables, view and print reports as multidimensional tables or graphs, and download statistical data in IVT, XLS and CSV formats for use with Beyond 20/20's statistical software, Microsoft Excel or other programs…”

“…Simple Linear Regression Analysis, a more formal numerical technique that calculates the line of best fit subject to defined 'goodness of fit' criteria. Microsoft Excel is used to demonstrate how to decide whether the line of best fit is a good fit, or just a solution in search of some data. …”

“…Part I MICROSOFT WORD TRICKS Chapter 1 Text Tricks Chapter 2 Formatting Tricks Chapter 3 Document Tricks Chapter 4 Page Layout Tricks Part II MICROSOFT EXCEL TRICKS Chapter 5 Formula and Function Tricks Chapter 6 Workbook and Worksheet Tricks Chapter 7 Data Analysis Tricks Chapter 8 Chart Tricks III MICROSOFT POWERPOINT TRICKS Chapter 9 Slide and Presentation Tricks Chapter 10 Animation Tricks Chapter 11 Slide Show Tricks IV MICROSOFT OUTLOOK TRICKS Chapter 12 Email Tricks Chapter 13 Calendar and Contacts Tricks V MICROSOFT ACCESS TRICKS 14 Table and Query Tricks Chapter 15 Form and Report Tricks APPENDIXES Author Bio Paul McFedries is well-known as a teacher of Office, Windows, and programming, particularly VBA. …”

Tabla de Contenidos: “…Benefits of forecasting beyond the wall Forecasts, projects and contracts Forecasting tools and techniques Sales forecasting Quantitative forecasting using Microsoft Excel Useful Excel tools Forecast frequency and automation Measuring and improving forecast accuracy Forecast financial statements New product sales forecasting Other factors to consider in sales forecasts 3 Essential background financial skills for budgeting Cheaper is not always better: cost and value in budgeting Accruals, cash and commitment accounting and budgeting Understanding profit and loss account figures Review of accruals accounting Direct and indirect methods of producing cash flow accounting The balance sheet The master budget Costs Value analysis and value engineering Activity based costing (ABC) The breakeven model Cost structure Capital expenditure planning 4 How should the budget be built? …”

“…Discover how to: Manage the entire BI lifecycle, from determining key performance indicators to building dashboards Use web-based Microsoft Excel services and publish workbooks on a SharePoint Server Mash up data from multiple sources and create Data Analysis Expressions (DAX) using PowerPivot Create data-driven diagrams that provide interactive processes and context with Microsoft Visio Services Use dashboards, scorecards, reports, and key performance indicators to monitor and analyze your business Use SharePoint to view BI reports side by side, no matter which tools were used to produced them…”

“…Esta guía práctica presenta en detalle las diferentes funciones de la popular hoja de cálculo Microsoft® Excel 2021. Se dirige a todas aquellas personas que desean descubrir el conjunto de sus funciones y profundizar en ellas. …”
Acceso con credenciales UPSA.

“…Esta guía práctica presenta con detalle las diferentes funciones de la popular hoja de cálculo Microsoft® Excel; se ha redactado con la versión Excel disponible con una suscripción Microsoft 365. …”
Acceso con credenciales UPSA.

“…La investigación en este proyecto es de tipo descriptivo, requiere de un diseño cuantitativo llevado a un estudio de caso, en el cual se realiza una macro con el programa Microsoft Excel, para ser implementado al programa contable SunSystem en la organización World Visión. …”
Enlace del recurso

Tabla de Contenidos: “…The OnDisconnection Catch-22 BugTemplate Utility Code; Displaying Outlook Property Pages; Communicating with a COM Addin; Summary; Chapter 7: COM Addins and the Outlook User Interface; Working with Menus and Toolbars; VSTO Interface Handlers; AxHost; Working with the Ribbon; Custom Task Panes; Form Regions; Custom Views; Summary; Chapter 8: Interfacing Outlook with Other Applications; Microsoft Word; Microsoft Excel; Microsoft Access; Web Browser; Summary; Chapter 9: Real-World Outlook Programming; Supporting Multiple Versions of Outlook; Addin Deployment; Outlook Programming Limitations…”

“…Esta guía práctica presenta en detalle las diferentes funciones de la popular hoja de cálculo Microsoft® Excel; ha sido redactada utilizando la versión 2019 de Excel e integra las novedades y diferencias de la versión de Excel perteneciente a Office 365. …”
Acceso con credenciales UPSA.

“…Esta guía práctica presenta con detalle las diferentes funciones de la popular hoja de cálculo Microsoft® Excel 2016; se dirige a todas aquellas personas que desean descubrir el conjunto de sus funciones y profundizar en ellas. …”
Acceso con credenciales UPSA.

“…Esta guía práctica presenta con detalle las diferentes funciones de la popular hoja de cálculo Microsoft® Excel 2013; se dirige a todas aquellas personas que desean descubrir el conjunto de sus funciones y profundizar en ellas. …”
Acceso con credenciales UPSA.

“…Este manual presenta de forma detallada todas las funciones de Microsoft® Excel 2007. Tras una descripción del entorno, totalmente nuevo con respecto a las versiones precedentes, y un paseo por la gestión de libros y hojas de cálculo, se presentan todas las técnicas para introducir y modificar datos (introducción de números, fechas, fórmulas, creación de series de datos, etc.). …”
Acceso con credenciales UPSA.

“…Get up to speed quickly with Microsoft Excel 2019. See how easy it is to create, edit, sort, analyze, summarize, and format data. …”

Tabla de Contenidos: “…""Contents""; ""About the Author""; ""Acknowledgments""; ""Introduction""; ""Chapter 1: Financial Modeling: An Overview""; ""Financial Modeling: A Definition""; ""Microsoft Excel as the Modelerâ€?s Tool""; ""Where Are Financial Models Used?""…”

Tabla de Contenidos: “…Indexing as a method for data analysis; Relative Time-Based Indexes; Relative Regional Indexes; Weighting the Index Number; Chapter Summary; Exercise Problems; Appendix I: Key Terminology and Formula in Statistics; Appendix II: Guide for Using Microsoft Excel 2003 in This Textbook; Appendix III: Mathematical Relationships; Appendix IV: Answers to End of Chapter Exercises; Bibliography; Index…”