EXCEL 2019 PROJECT BOOK: Spreadsheets. Databases. Case StudiesКНИГИ » ОС И БД
Название: EXCEL 2019 PROJECT BOOK: Spreadsheets.Databases. Case Studies Автор: Gary Bronson, Jeffrey Hsu Издательство: Mercury Learning and Information Год: 2021 Формат: PDF Страниц: 180 Размер: 21,7 Mb Язык: English
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 arediscussed, 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 2019 Formulas and Functions Название: Microsoft Excel 2019 Formulas and Functions Автор(ы): McFedries Paul Издательство: Pearson Education Год: 2019 Формат: PDF Размер: 24 Мб ...
Beginning Big Data with Power BI and Excel 2013 Название: Beginning Big Data with Power BI and Excel 2013 Автор: Neil Dunlop Издательство: Apress Год: 2015 Формат: PDF Страниц: 258 Размер: 20,91 МБ...
Информация
Посетители, находящиеся в группе Гости, не могут оставлять комментарии к данной публикации.
Навигация
Вход на сайт
Реклама
EXCEL 2019 PROJECT BOOK: Spreadsheets. Databases. Case Studies 
