MS Excel Level 1 (Beginner Plus)

MS Excel for course is offered by Act Training and Testing for beginners. Students will learn basic worksheets skills and how to work with data in worksheets. Act Training has been offering high quality, reasonably priced training courses to individuals and organisations since 1993.

Course Content:

• Lesson 1:Getting Started
  • Spreadsheet terminology
  • The Excel window
  • Getting help
  • Navigating workbooks
• Lesson 2: Entering and editing text
  • Entering and editing text and values
  • Entering and editing formulas
  • Working with pictures
  • Saving and updating workbooks
• Lesson 3: Modifying a worksheet
  • Moving and copying data
  • Moving and copying formulas
  • Absolute and relative references
  • Inserting and deleting ranges, rows and columns
• Lesson 4: Using functions
  • Entering functions
  • AutoSum
  • Other functions
• Lesson 5: Formatting worksheets
  • Formatting text
  • Formatting rows and columns
  • Formatting numbers
  • Conditional formatting
  • Additional formatting options
• Lesson 6: Printing
  • Preparing to print
  • Page Setup options
  • Printing worksheets
• Lesson 7: Creating Charts
  • Chart basics
  • Formatting charts