Welcome to the only guidebook series that takes a visual approach to professional–level computer topics. Open the book and you?ll discover step–by–step screen shots that demonstrate over 190 key Excel data analysis techniques, including: Using Web–based applications in Excel Creating formulas and using functions Calculating interest rates and depreciation Working with statistical functions Using database functions Creating PivotTables and using Slicer Performing "what–if" analysis Automating Excel with macros Adding illustrations to worksheets Customizing the Ribbon High–resolution screen shots demonstrate each task Succinct explanations walk you through step by step Two–page lessons break big topics into bite–sized modules "Apply It" and "Extra" sidebars highlight useful tips
