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.