More Than 250
Developed through years of expertise, CPS HR teaches up-to-date skills applicable on the job.

Excel Level 2


Excel Level 2 is a one-day instructor-led course that provides more advanced tools for analysis and presentation of complex, realistic data in Microsoft Excel: how to manage complex workbooks, build more complex functions, use data analysis tools, make an impact with powerful chart and presentation features, and collaborate with other users.

Appropriate for all levels
  • Chapter 1: Managing workbooks, Managing worksheets, Customizing Excel
  • Chapter 2: Named ranges, Using names in formulas
  • Chapter 3: Tables, Sorting, Filtering tables, Structured references, Validation Transposing data
  • Chapter 4: Summarizing data, Consolidation Subtotals
  • Chapter 5: PivotTables Creating and formatting PivotTables, Manipulating PivotTables PivotCharts
  • Chapter 6: Presentation features, Conditional formats, Custom Formats Graphics
  • Chapter 7: Advanced charts, Special chart types, Sparklines Quick Analysis
  • Chapter 8: Collaboration Permissions Shared workbooks