Excel Tips, Tricks and Timesavers

Excel is our most popular class series and these classes can fill weeks ahead. Green flag dates have the MINIMUM enrollment to run as scheduled. Dates with "Class is Full" are at capacity without availability. To get a class date you prefer, it's best to register as far in advance as possible. View More Dates Excel is our most popular class series and these classes can fill weeks in advance. Green flag dates have the MINIMUM enrollment to run as scheduled. Dates with "Class is Full" are at capacity without availability. To get the class date you prefer, it's best to register as far in advance as possible. 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) 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.

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