In this course, students will use Microsoft Excel to create spreadsheets and workbooks that you can use to store, manipulate, and share your data. This course is intended for students who wish to gain the foundational understanding of Microsoft Excel.

    No events to show



      Course Content



      Text formatting

      Row and column formatting

      Number formatting

      Conditional formatting 

      Additional formatting options  



      Chart basics 

      Formatting charts  



      Working with pictures  

      Conditional formatting with graphics 

      SmartArt graphics  



      Preparing to print 

      Page Setup options 

      Printing worksheets


      At Course Completion


      After completing this course, students will be able to:


      Format text, cells, rows, and columns; merge cells; apply colour and borders; format numbers; create conditional formats; use the Format Painter; and use Find and Replace to update the formatting for specific content.


      Create, format, modify, and print charts based on worksheet data; work with various chart elements; and apply chart types and chart styles.


      Insert and modify a picture; represent data graphically within cells by applying three forms of conditional formatting (data bars, colour scales, and icon sets); and insert and modify SmartArt graphics.


      Check spelling; find and replace text and data; preview and print a worksheet; set page orientation and margins; create and format headers and footers; and print gridlines.


      Presented By

      Additional information

      When:  Tuesday 1st October, 2019, 1pm-4pm
      Where:  Level 3, 15 Daly Street, Lower Hutt
      Fee:  $300 +GST (those wanting to attend the 2nd workshop on the same day can attend courses for $450+GST)

      Who Should Attend



      You should be comfortable with the Windows environment.

      Bring your own device.