This EBook shows you how to take basic rows and columns of data and to manage it and turn it into useful information that can be incorporated into the decision making process. We start with Excel’s simple basic Database features of sorting and filtering data and then take a look at subtotals and nested subtotals. From there, we explore one of Excel’s most exciting features – the pivot table. The course than discusses how to use Database functions and apply conditional formatting to data. This course is an updated version of an earlier course EXMCMDEX0713. Table of Contents
Delivery Method: Online QAS Self Study.
Version: Excel 2007/2010/2013/2016
Prerequisites: Basic file management skills (open/close) are assumed. Basic Excel skills of navigation, using cell references and basic formulas such as =SUM() are assumed.
Advanced Preparation: None