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

Excel Level 1

1-DAY COURSE

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.

WHO SHOULD ATTEND:
Appropriate for all levels
LEARNING OBJECTIVES
  • 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