Microsoft Excel Simple Projects


Book Description

Projects for language arts, social studies, science and math. Provided templates can be modified to meet specific needs. Project samples also provided




Microsoft Office(r) Simple Projects


Book Description







Microsoft Excel


Book Description

Includes CD with templates and project samples.




Excel 2019 Project Book


Book Description

Designed as a project and case-oriented approach to learning Excel, the emphasis of this book is on learning by doing. The book presents a series of progressively reinforcing problem sets, which allow the exploration of real-life business problems. First, the background, theory, formulas, and calculations are discussed, followed by the design of Excel spreadsheets, which support the creation of effective spreadsheets for these applications. Finally, the proper solution and other related aspects are discussed, forming a cohesive set of practical application problems. Some of the topics explored include amortization tables, weighted averages, cash flows, payroll calculations, break even analysis, and spreadsheet databases. Excel techniques include formulas and functions, cell addressing, conditional and lookup functions, graphs, sorting, and filtering. FEATURES: Provides 30 projects, several How-to Guides, and Application Types to learn Excel skills using problems, applications, and case studies featuring practical business problems Explores formulas and functions, financial functions, cell addressing, conditional functions, lookup functions, graphs, sorting, and filtering, amortization tables, future values of an investment, weighted averages, cash flows, payroll calculations, break even analysis, economic order quantity, spreadsheet databases, and more Instructor resources available with four Excel video tutorials and images from the text.




Microsoft Excel


Book Description

Projects for language arts, social studies, science and math. Provided templates can be modified to meet specific needs. Project samples also provided




Teaching Macroeconomics with Microsoft Excel®


Book Description

Humberto Barreto shows professors how to teach macroeconomic models and incorporate data using Microsoft Excel® with free files and videos.




Project Management Metrics, KPIs, and Dashboards


Book Description

Essential strategies from Harold Kerzner on measuring project management performance The maze-like path of today's projects reflects a business environment that's growing in complexity. Factors influencing projects, such as new advancements in computer technology, an unpredictable economy, and the increase in stakeholder involvement make metrics and key performance indicators (KPI) for project management an important focus. Such measures are commonly used to help an organization define and evaluate how successful it is, typically, in terms of making progress towards its long-term organizational goals. Project Management Metrics, KPIs, and Dashboards helps functional managers gain a thorough understanding of what metrics are and how they can be best implemented to gain traction in a fast-paced and diverse working atmosphere. With content aligned with PMI's PMBOK® Guide, this book offers extensive coverage on KPIs and how they may be monitored, using techniques such as business dashboards to assist in prescribing meaningful business strategies. After reading this book, functional managers will bolster their awareness of what good metrics management really entails—and be armed with the knowledge to measure performance more effectively. This book begins with basic KPI principles, helping functional managers deal with such key issues as: Successfully integrating KPIs and metrics into managing a project within a business strategy Important business dashboard techniques used in monitoring performance What is really important to different stakeholders in a project Managing resistance to change Next the book explores the key questions to ask before implementing a dashboard or reporting system. Some of these questions include: What are your needs? What is involved in integration? What's involved in operations and maintenance? What does the system cost? How long will the system last? Throughout the book, helpful illustrations clarify complex concepts and processes. These illustrations are also available as PowerPoint slides for course and seminar presentations.




Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365)


Book Description

Use Excel 365 and Excel 2021 core features to build spreadsheets that solve business problems and deliver reliable answers. Drawing on his unsurpassed experience, Paul McFedries helps you make the most of formulas and functions, including recent improvements ranging from dynamic arrays to XLOOKUP and LET. McFedries' step-by-step projects walk you through handling key tasks, from building timesheets to projecting cash flow and aging receivables. His practical examples and clear instructions demystify intermediate-to-advanced-level formula construction, and help you leverage Excel's most useful functions in your everyday work. Becoming an Excel expert has never been easier! By reading this book, you will: Improve business analyses by adding intelligence and knowledge to your models Replace cumbersome formulas with convenient predefined functions Use modern lookups to make your formulas more powerful and flexible Simplify complex calculations with dynamic arrays in Excel 365 and Excel 2021 Use conditional formatting to reveal anomalies, problems, or opportunities Calculate loan payments, interest costs, terms, and amortization schedules Project the future value of investments, and plan to achieve investment goals Master essential discounting and cash-flow analysis tools, including NPV and IRR Sort, filter, and analyze any tabular data, from customers to inventory Easily analyze huge datasets with PivotTable calculations Perform sophisticated what-if analyses, scenario planning, and forecasting Optimize profit, cost, or operational efficiency with Solver About This Book For everyone who wants to get more done with Microsoft Excel in less time For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data




Office 2003 Programming


Book Description

* Builds real applications that can be customized and used commercially. * Provides real-world examples, each of which offers a fundamental lesson in approaching data structure and code. * Friendly, open and targeted chapters that can be absorbed one lesson at a time.