Excel Tips, Tricks and Timesavers

Class Format Fully interactive live, hands-on training presented and supported by a professional online instructor. Attend from ` your own location or an ONLC center . Class Times Based on local time zone... 10:00a - 4:45p (ET)   |   9:00a - 3:45p (CT)   |   8:00a - 2:45p (MT)   |   7:00a - 1:45p (PT) Overview This one-day class offers tips, tricks and timesavers that will help you get the most from Excel. It is an easy quick-paced class that will touch on most of the popular Excel features and how to access them efficiently. Target Student You already know Excel and have been working with it regularly. Some of your skills are self-taught and you might have taken formal training. Individuals who have taken one or more Excel Core Skills classes will be excellent candidates for this class. Who Should NOT Take This Class If you are a novice Excel user, this class is not for you. It is best to have some practical Excel work experience before taking this class. Prerequisites This class is not for beginning Excel users. The typical candidate for this class will be either self-taught or will have had some formal training in Excel. This class can be taken after our ` Excel Introduction . _ Attending other ` Excel Core Skills classes in our curriculum can be helpful but not necessary. COURSE OUTLINE 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