Filtering and Searching – Filtering emails, Searching for emails using And, Or and Not operators, Creating a search folder

Managing Email using Rules – Creating a new rule, Using And, Or and Not operators in rules, Deleting a rule, Using the Rules Wizard

Archiving Email – Archiving individual messages, Archiving multiple messages, Using Auto Archive, Controlling Auto Archive settings, Specifying or changing the Auto Archive folder

Mastering Key Excel Concepts – Creating formulas using absolute, relative and mixed referencing, Naming cells and cell ranges, Using names in formulas, Editing named cells and ranges using the Name Manager

Tips and Techniques for Entering Core Excel Functions – Using different strategies to quickly enter core Excel functions including SUM, AVERAGE, MIN and MAX, counting cells containing numeric or text values, and more

Using IF and VLOOKUP Functions to Display Conditional Results – Using the powerful IF function to output conditional results, creating nested IF statements, creating formulas using SUMIF and COUNTIF, Using the VLOOKUP function to look up data vertically in a list or database, Dealing with VLOOKUP errors

Applying Conditional Formatting – Highlighting cells using built-in conditional formats, Clearing conditional formatting

Protecting and Formatting Worksheets and Workbooks – Protecting worksheets and workbooks, using cell styles and themes to speed up formatting in multiple worksheets

Linking Worksheets and Workbooks – Using link cells in formulas to link worksheets and workbooks, Managing, and updating links between workbooks, Importing linked and unlinked Excel data into Microsoft Word

Summarizing Cells or Ranges from Multiple Sheets – Understanding 3D references, inserting formulas that extract totals from multiple sheets using 3D references, Considerations when inserting, moving and deleting sheets

Manipulating and Extracting List or Database Data – Identifying the parts of an Excel list or database, Best practices for setting up lists or databases correctly in Excel, inserting records on a worksheet or adding records using a data form, Sorting records using the Sort feature with multiple sort keys

Converting Data Sets to Tables – Why you should be using Excel tables, converting lists to tables in 3 different, ways, Creating formulas in tables

Creating Drop-Down Lists Using Validations – Applying validations, creating drop-down lists to make data entry easier and more accurate

Visualizing Data using Charts and Sparklines – Inserting charts on a spreadsheet or on a new Excel sheet, applying chart formats to improve the appearance of your charts, Changing the chart type

Summarizing Data using Pivot Tables – Creating pivot tables to summarize Excel list or database data, Rearranging fields in a pivot table, applying formatting to pivot tables and fields, filtering a pivot table, Creating a pivot chart