Topics covered include: How the Table feature allows you to transform filtering tasks; Avoid repetitive work by creating a keyboard shortcut for Excel's Freeze Panes feature; Embed frequently used lists, such as employees, departments, or key customers, into Excel's interface for use with any spreadsheet; Add the hidden Form Command back to Excel 2007 and later; Double-checking manual inputs easily by having Excel read numbers aloud to you; Dispatch the Compatibility Checker to avoid wasting time when saving workbooks as .XLS files by dispatching the Compatibility Checker; Jump-start data visualization with the Quick Analysis feature; Strike through list items with a custom shortcut; Discover how to use Excel's; Personal Macro Workbook; Use the Text Box feature for paragraphs of text to avoid merging cells; Keepan eye on how much your text is being reduced as you try to squeeze more on a page. Upon completing this course, you should be able to: Identify the feature that helps you transform filtering tasks; Implement Excel's Personal Macro Workbook; Define how to avoid merging cells; Recall how to embed frequently used lists; Recognize when the Flash Fill function was first introduced to Excel; Identify what to select when using Text to Columns for names; Recognize the command shortcut to use for clearing borders in a cell; Identify the shortcut command to apply for strikethrough formatting; Describe which shortcut key is used to toggle between Enter/Edit modes; Identify a new function in Excel 2007 that tries to identify patterns based on your data entry; Differentiate types of delimiters; Recognize which menu can be accessed using the Remove Duplicates feature; Differentiate Excel versions and how they function.