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: 163.80

Cena netto: 156.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
Zrozumieć Excela. VBA - makra i funkcje
Zrozumieć Excela. Obliczenia i wykresy
Excel 2019 PL. Biblia
Kompletny przewodnik po DAX, wyd. 2 rozszerzone. Analiza biznesowa przy użyciu Microsoft Power BI, SQL Server Analysis Services i Excel
Excel 2019 PL w biurze i nie tylko
VBA dla Excela 2019 PL. 234 praktyczne przykłady
Zestaw Excel 2019 (Przetwarzanie danych + Analiza i modelowanie danych)
Zrozumieć Excela. Funkcje i wyrażenia
Microsoft Excel 2019: Formuły i funkcje
ABC Excel 2019 PL
Więcej produktów