Search Our Content Library

• Working with Flash Fill
• Outlining with Subtotals and Grouping
• Displaying Data Graphically
• Understanding Pivot Tables and Pivot Charts and Filtering with Slicers
• Working with Date and Time Functions
• Working with Common Text Functions
• Customizing Excel
• Linking Workbooks and Worksheets
• Working with Range Names
• Analyzing Data with Common Logical Functions
• Analyzing Data with Common Lookup Functions
• Sorting and Filtering Range Data
• Analyzing and Organizing with Tables
• Using Conditional Formatting

• Using Advanced IF Statements
• Using Advanced Lookup Functions
• Using Complex Logical and Text Functions
• Formula Auditing
• What-If Analysis Tools
• Worksheet and Workbook Protection
• Advanced Use of PivotTables and PowerPivot
• Working with Form Controls
• Ensuring Data Integrity
• Automating with Macros
• Collaborating in Excel
• Importing and Exporting Data to a Text File

• Getting Started With Excel
• Creating Workbooks and Using Templates
• Entering Data
• Excel Formula Basics
• Adjusting a Worksheet
• Formatting and Aligning Worksheet Data
• Using Cell Styles and Themes
• Inserting Objects and Graphics
• Proofing a Workbook
• Printing an Excel File
• Managing Worksheets
• Navigating and Viewing Excel Files

• Overview of Common Changes
• New Features in Word
• New Features in Excel
• New Features in PowerPoint
• New Features in Outlook
• New Features in Access