For example, you’ll learn about statistics, forecasting, optimization models, Monte Carlo simulation, inventory modeling, and the mathematics of waiting in line. In addition to learning about Excel formulas, you will learn some important math in a painless fashion. By looking at the questions that begin each chapter, you’ll gain an idea about the types of problems you’ll be able to solve after mastering a chapter’s topics. You should be able to master the content of most chapters with at most two hours of study. Generally, the chapters in this book are short and organized around a single concept. Finally, we've increased the coverage of Power Pivot, Macros, and Power Query. It also covers the new Data types that have been added. This new edition covers new functions (STOCKHISTORY, LET, LAMBDA, XLOOKUP) and new array functions. A lot has changed in Office 365 since the previous edition.
Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide helps you use Excel to ask the right questions and get accurate, actionable answers. Master business modeling and analysis techniques with Microsoft Excel and Office 365 and transform data into bottom-line results. Издательство: Microsoft Press/Pearson Education Название: Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th edition
0 kommentar(er)
