Excel 2019 Project Book Excel 2019 Project Book

Excel 2019 Project Book

Spreadsheets • Databases • Case Studies

    • ¥6,400
    • ¥6,400

発行者による作品情報

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.



Project Set 1: Simple Spreadsheets Using Basic Excel Capabilities

Project Set 2: Absolute Addressing

Project Set 3: Cash Flow Projects

Project Set 4: Simple Decisions Using the IF( ) Function

Project Set 5: Making Multiple Choices Using VLOOKUP( )

Project Set 6: Applications and Graphing

Project Set 7: Database Projects

How-to Guides

Basic Application Types

Index

ジャンル
コンピュータ/インターネット
発売日
2021年
9月29日
言語
EN
英語
ページ数
175
ページ
発行者
Mercury Learning and Information
販売元
Stylus Publishing, LLC
サイズ
18.8
MB

似たブック

Excel Course Excel Course
2013年
Excel for Scientists and Engineers Excel for Scientists and Engineers
2005年
Statistical Functions in Excel Statistical Functions in Excel
2021年
20 Most Powerful Conditional Formatting Techniques 20 Most Powerful Conditional Formatting Techniques
2017年
EXCELSIOR! EXCELSIOR!
2018年
Maths Function in Excel Maths Function in Excel
2021年