How to make effective workbook and worksheet templates fast mode formats How to perform custom calculations and formulas What kind of creative graphic and persuasive How to describe your worksheets with SmartArt, pictures, and more What can be done solving business problems with Excel How to analyze data with pivot tables How to automate tasks with VBA Who this book is to Beginning and intermediate users who are looking to get up to speed quickly with the application of Excel 2011 and use it productively, both online and offline. Table of Contents Learning Secrets Excel: Mac Excel Interface Configuration: Mac to Suit the Way You Work Creating Effective and Template Formatting Workbooks Worksheets you quickly and efficiently performing a Custom Calculation with Excel Formulas Using the Built-In Function Creates s clear and persuasive? Graphs Using Data Bars, Color Scales, Icon Sets, and Sparklines Illustrations with SmartArt your worksheet, Pictures, and Creating More Using Database Table Solving Business Questions with What-If Analysis, Goal Seek, and Solver Analyzing Data with PivotTables Collaborating and Sharing with Mac and Windows Automating Tasks with Macros and VBA