Używamy cookies, aby ułatwić korzystanie z Portalu. Możesz określić warunki przechowywania, dostępu do plików cookies w Twojej przeglądarce. Dowiedz się więcej.
strona główna Strona główna | Nowości | Promocje | Zapowiedzi Twoje konto | Zarejestruj | Schowek | Kontakt | Pomoc
mapa działów
Szukaj: szukanie zaawansowane
Książki \ Aplikacje \ Excel

Microsoft Excel 2019 Formulas and Functions Język: 2


Cena Brutto: 159.60

Cena netto: 152.00

Wersja: Drukowana
Autor Paul McFedries
Liczba_stron 512
Wydawnictwo Microsoft Press
Data_Wydania 2019-04-20
Microsoft Excel 2019 Formulas and Functions

Use Excel 2019 and Office 365 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 the latest improvements to arrays, formula error handling, and statistics. 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 

• Radically simplify complex calculations with Office 365’s new dynamic arrays 

• 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 net present value and internal rate of return 

• Sort, filter, and analyze tabular data, from customers to inventory 

• Easily analyze huge data sets with PivotTable calculations 

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

Part I—Mastering Excel formulas

Chapter 1—Building basic formulas

Chapter 2—Creating advanced formulas

Chapter 3—Troubleshooting formulas

Part II—Harnessing the power of functions

Chapter 4—Understanding functions

Chapter 5—Working with text functions

Chapter 6—Working with logical and information functions 

Chapter 7—Working with lookup functions

Chapter 8—Working with date and time functions

Chapter 9—Working with math functions

Part III—Building business formulas

Chapter 10—Implementing basic business formulas

Chapter 11—Building descriptive statistical formulas

Chapter 12—Building inferential statistical formulas 

Chapter 13—Applying regression to track trends and make forecasts

Chapter 14—Building loan formulas

Chapter 15—Working with investment formulas

Chapter 16—Building discount formulas 

Part IV—Building business models

Chapter 17—Analyzing data with tables

Chapter 18—Analyzing data with PivotTables

Chapter 19—Using Excels business modeling tools

Chapter 20—Solving complex problems with Solver
Produkty Podobne
Excel 2019 PL. Kurs
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
Analizy Business Intelligence. Zaawansowane wykorzystanie Excela
Microsoft Excel 2019 Krok po kroku
Microsoft Excel 2019 Formulas and Functions
Microsoft Excel 2019. Przetwarzanie danych za pomocą tabel przestawnych
Microsoft Excel 2019 VBA and Macros
Microsoft Excel 2019 Pivot Table Data Crunching
Microsoft Excel 2019 Step by Step
Microsoft Excel 2019 Inside Out
Więcej produktów