MICROSOFT EXCEL BASIC

  • PURPOSE

  • COURSE CONTENT

  • DELIVERY

  • ACCREDITATION

The online basic Microsoft Excel course is designed for those who are unfamiliar with basic formulas and formatting, such as the ‘plus and minus’ functions. This course helps if the Excel screen is still a scary environment in general.

Unit 1: Getting started

  1. Identifying the elements of the Excel interface
  2. Customising the Excel interface
  3. Creating a basic worksheet
  4. Opening and saving

Unit 2: Performing calculations in an Excel worksheet

  1. Creating formulas in a worksheet
  2. Inserting functions in a worksheet
  3. Copying and pasting formulas
  4. Calculating formulas over multiple sheets

Unit 3: Modifying an Excel worksheet

  1. Editing worksheet data
  2. Finding and replacing data
  3. Copy, cut, paste and BODMAS
  4. Automatic fill

Unit 4: Modifying the appearance of a worksheet

  1. Applying font properties
  2. Adding borders and colours to cells
  3. Aligning content in a cell
  4. Applying number formatting
  5. Applying cell styles
  6. Adjusting the row height and column width
  7. Inserting and deleting rows and columns

Duration: 1 Day

Delivery: Classroom/Online

 

5 Day Courses: Participants will receive a SpecCon Holdings certificate upon completion of all courses.

1 Day Courses: Participants will receive a SpecCon Holdings certificate upon completion of this course.