Microsoft Excel 2016 2013 2010 2007 Tips Tricks and Shortcuts (Color Version): Learn Formulas, Functions and Formatting in 20 Mini-Lessons (Easy Learning Microsoft Office How-To Books)

(FULL COLOR PAPERBACK VERSION) 20 Mini-Lessons PLUS Videos Packed with Excel Tips, Tricks and Shortcuts Bite-Sized Learning Modules to Help You Work Smarter, Save Time and Increase Productivity Plus Links to 20 Companion Training Videos Create Your Spreadsheets, Calculations and Charts Easier, Smarter and Faster! Format Spreadsheets in a Snap Learn Easy Excel Tricks To Make You an Excel Expert Overnight! TOPICS INCLUDE: *Part I. Excel Basics: Creating a Simple Spreadsheet, Entering/Editing Data, Copy/Paste Tricks, Opening, Saving, Closing and Printing *Part II. Formulas and Functions: Basic and Advanced Math Formulas and Functions *Part III. Formatting and Viewing Options: Font, Alignment, Number, Style, Borders, Column Titles, Working with Rows and Columns, Header and Footers, Freezing Panes, Split Screen *Part IV. Managing Sheet Tabs: Inserting, Deleting, Renaming and Navigating Sheets *Part V. Getting Creative With Charts: Pie Charts, Bar Graphs, Line Graphs, Customizing Your Chart Style, Format and Elements *Part VI. Extras: AutoFill, Flash Fill, Absolute Cell Referencing, and Filters *Part VII. BONUS Tricks! Secret Tricks to Make You an Excel Expert