Table of Contents – BPB Online
Skip to content
- Introduction
- Introducing the Ribbon
- Customizing the Ribbon and Quick Access Toolbar
- Protected Mode
- Backstage View and the File Menu
- Unlocking the Big Grid
- A Faster Way to Paste Special
- Page Layout view
- Keyboard Shortcuts
- Formula Bar Tricks
- Quick Zoom
- See Totals in the Status Bar
- New and improved Functions in Excel 2010
- Table Make Excel a Bit More Like a Database
- Smarter Fill Handle Double Click
- Sort by Color
- Improved Filter Tricks
- Remove Duplicates
- Add Subtotals Automatically
- Using the Easy XL program
- Pivot Tables
- Power pivot
- Charting
- Create Tiny Charts with Sparklines
- Data Visualizations
- Cell Styles
- Document themes Across MS Office
- Using Picture Tools and Background Removal
- Create Business Diagrams with SmartArt
- Using WordArt
- Handling Large Blocks Of Text
- Equation Editor
- Quick Translations
- Excel In a Web Browser
- Get Excel Answers from the MrExcel.com Board