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

      Description

       

      Course Content

       

      Formatting

      Text formatting

      Row and column formatting

      Number formatting

      Conditional formatting 

      Additional formatting options  

       

      Charts  

      Chart basics 

      Formatting charts  

       

      Graphics 

      Working with pictures  

      Conditional formatting with graphics 

      SmartArt graphics  

       

      Printing 

      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

       

      Prerequisites 

      You should be comfortable with the Windows environment.

      Bring your own device.