Microsoft Excel 2010 Data Analysis and Business Modeling by Winston W
Читать

Microsoft Excel 2010 Data Analysis and Business Modeling by Winston W

Microsoft Excel 2010 Data Analysis And Business Modeling is a practical guide to learning spreadsheet techniques. The book adopts a learn-by-doing approach. The first chapter in the book talks about the new features introduced in Excel 2010. From chapter two, the book follows a new format. Each page opens with a list of questions, which are then answered by means of various techniques. Each chapter covers a narrow and specific topic. Till chapter 37 we learn most of the basics such as lookup function, time function, index and match function, and date function. This is followed by advanced functions such as COUNTIF, SUMIF, OFFSET, and INDIRECT cropping.