Microsoft Office Training – Advanced Excel

Course Topics

  • Look-up Functions
  • Using the Solver
  • Applying Conditional Formats
  • Using Data Validation
  • Protecting a Workbook
  • Tracking Changes
  • Query a Database
  • Retrieving Data from a Database
  • Filtering the Data using Microsoft
  • Query
  • Working with Lists
  • Formatting the Spreadsheet
  • Text, Numbers, Conditional Formatting
  • Using Charts
  • If Functions
  • Goal Seek, Data Tables, Scenarios
  • Pivot Tables
  • Apply Styles to PivotTables
  • Chart and Graph Tutorial
  • Chart Controlled With List Box