Excel Tips, Tricks and Timesavers

Working with Workbooks and Files Using Keyboard Shortcuts Customizing Excel Understanding Protected View and AutoRecover Saving to a Read-Only Format Using Document Themes Changing Printer Settings Using Formatting Options Working with Merged Cells Using Styles Creating and Using Custom Number Formats Shading Alternate Rows Using Conditional Formatting Using the Format Painter Showing Text and a Value in a Cell Working with Formulas Learning Some AutoSum Tricks Knowing When to Use Absolute and Mixed References Avoiding Error Displays in Formulas Creating Worksheet-Level Names Using Named Constants Performing Lookups Rounding Numbers Working with Data Selecting Cells Efficiently Automatically Filling a Range with a Series Transforming Data with and Without Using Formulas Creating a Drop-Down List in a Cell Using Conditional Formatting Identifying Excess Spaces Transposing a Range Using Flash Fill Filling the Gaps in a Report Getting Data from a PDF File Using Tables and Pivot Tables Understanding Tables Using Formulas with a Table Identifying Data Appropriate for a Pivot Table Using a Pivot Table Instead of Formulas Controlling References to Cells Within a Pivot Table Grouping Items by Date in a Pivot Table Creating Pivot Tables with Multiple Groupings Using Pivot Table Slicers and Timelines Configuring Charts and Graphics Understanding Recommended Charts Customizing Charts Creating a Chart Template Linking Chart Text to Cells Applying Chart Data Labels from a Range Grouping Charts and Other Objects Taking Pictures of Ranges Working with Images