Microsoft Excel eBooks

Microsoft Office Excel 2007 ProgrammingWelcome 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 140 key Excel programming techniques, including:Assigning digital signatures to macrosSetting properties for a projectAssigning values to a variableChanging the properties of an objectFormatting a numeric expressionProcessing a runtime errorSaving worksheets to another fileDisplaying a built-in dialog boxCreating custom Ribbon tabsBuilding and debugging add-insExtra Apply It"Apply It" and "Extra" sidebars highlight useful tipsHigh-resolution screen shots demonstrate each taskSuccinct explanations walk you thr...

The go to resource for how to use Excel dashboards and reports to better conceptualize dataMany Excel books do an adequate job of discussing the individual functions and tools that can be used to create an 'Excel Report. What they don't offer is the most effective ways to present and report data. Offering a comprehensive review of a wide array of technical and analytical concepts, Excel Reports and Dashboards helps Excel users go from reporting data with simple tables full of dull numbers, to presenting key information through the use of high-impact, meaningful reports and dashboards that will wow management both visually and substantively.Details how to analyze large amounts of data and report the results in a meaningful, eye-catching visualizationD...