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

Excel Level 1


Our Excel Level 1 is a one-day instructor-led course that provides the basic concepts and skills students need to start being productive with Microsoft Excel: how to create, save, share, and print worksheets that contain various kinds of calculations and formatting. This course, and the two that come after, map to the objectives of the Microsoft Office Specialist and Expert exams for Excel.

Appropriate for all levels
  • Chapter 1: Fundamentals, Getting around Workbook basics
  • Chapter 2: Creating worksheets, Entering data, Formulas, Functions, Moving and copying data, Reference types
  • Chapter 3: Formatting text, Formatting number, Formatting alignment borders, highlightings, and themes
  • Chapter 4: Manipulating data, Data entry shortcuts, Paste options, Inserting, deleting, and hiding
  • Chapter 5: Charts, Creating charts, Chart types and elements
  • Chapter 6: Output, Managing worksheet windows, Sharing workbooks
  • Chapter 7: Settings and templates, Workbook options and properties, Printing worksheets Templates