Tabla de Contenidos: “…Microsoft® Office Excel 2003: Step by Step; Getting Help; Getting Help with Microsoft Excel 2003; Using the Book's CD-ROM; Installing the Practice Files; Using the Practice Files; Uninstalling the Practice Files; Conventions and Features; Microsoft Office Specialist Skills Standards; Microsoft Office Specialist Expert Skill Standards; Taking a Microsoft Office Specialist Certification Exam; Selecting a Microsoft Office Specialist Certification Level; Microsoft Office Specialist Skills Standards; The Exam Experience; Test-Taking Tips; College Credit Recommendation; For More Information…”

Materias: “…Microsoft Excel (Computer file)…”

Materias: “…Microsoft Excel (Computer file)…”

Materias: “…Microsoft Excel (Computer file)…”

Materias: “…Microsoft Excel (Computer file)…”

“…Balanced Scorecards & Operational Dashboards with Microsoft Excel…”

Materias: “…Microsoft Excel (Programa de ordenador)…”

Tabla de Contenidos: “…Introduction to financial analysis and modeling -- Excel 2007 and previous Excel versions -- Excel basics -- Advanced excel features -- Making decisions and looking up values -- Analyzing data -- Answering what-if questions -- Finding iterative solutions -- Doing statistical analysis -- Using Excel's financial functions -- Other useful Excel functions…”

Tabla de Contenidos: “…; Same Engines, Just Different Visuals; What do we mean by the "tough" or "valuable" stuff?; Power Pivot (in Excel) Versions; Power Pivot for Excel 2010; Power Pivot for Excel 2013 - Only Available in "Pro Plus" Excel; Differences in User Interface: 2010, 2013, 2016; When We Said "Cosmetic" We Meant "Awkward"; 32-bit or 64-bit?…”

Tabla de Contenidos: “…Cover -- Title page -- Copyright and credit -- Foreword -- Contributors -- Table of Contents -- Preface -- Part 1 - Dashboards and Reports in Modern Excel -- Chapter 1: Dashboards, Reports, and M365 Excel -- Introducing dashboards and reports -- Meeting modern business needs -- The characteristics of a dashboard -- The different versions of Microsoft Excel -- Excel 365 -- Excel 2021 -- Older versions of Excel -- Summary -- Further reading -- Chapter 2: Common Dashboards in Large Companies -- Major types of dashboards -- Understanding the sales dashboard -- Understanding the financial analysis dashboard -- Understanding the HR dashboard -- Understanding the supply chain and logistics dashboard -- Understanding the marketing dashboard -- Summary -- Part 2 - Keeping Your Eyes on Automation -- Chapter 3: The Importance of Connecting Directly to the Primary Data Sources -- The different ways to bring data into Excel -- Copying and pasting data into Excel -- Importing data from flat files -- Importing data from databases -- Importing data from cloud platforms -- Connecting directly to the primary data source -- Common issues and how to overcome them -- Summary -- Chapter 4: Power Query: the Ultimate Data Transformation Tool -- Introduction to Power Query -- Connecting to over 100 different data sources -- Transforming data in Power Query -- Appending data from multiple sources in one data table -- Merging data from two tables into one table -- Common data transformations -- Choose Columns -- Keep Rows and Remove Rows -- Unpivot Columns and Pivot Columns -- Group By -- Fill Series and Remove Empty -- Replace Values -- Important tips -- Understanding Close &amp -- Load To -- Demystifying the underlying M code -- Summary -- Chapter 5: PivotTable and Power Pivot -- Mastering Pivot Tables -- The role of Slicers -- Dynamic reports with PivotTables…”

Materias:

Enlace del recurso

Acceso restringido usuarios UPSA

Acceso restringido usuarios UPSA

Acceso restringido usuarios UPSA

Materias: “…Microsoft Excel (Computer file)…”
Enlace del recurso

Materias: “…EXCEL 2007 Aplicaciones…”

Materias: “…Microsoft Excel (Computer file)…”