Microsoft Excel – Beginner to Intermediate

Duration: 1 Day
Investment: $605 incl GST
Delivery: Face 2 Face

 

Target Audience

Council staff who would like to advance their basic Microsoft Excel skills

 

Key Learnings

Basic skills Covered:
  • Creating a new workbook
  • Formulas and functions
  • Cell referencing
  • Using the Autofill tool
  • Formatting cells and using borders and margins
  • Sorting and filtering data lists
  • Creating and editing charts
  • Inserting shapes, pictures, clip art, SmartArt Graphics, WordArt, screen shots and signature lines
  • Printing – worksheets/workbooks/formulas and functions/row and column headers.
 
Intermediate Skills Covered:
  • Editing worksheets
  • Adding headers, footers, and hyperlinks
  • Formatting and editing cells
  • Conditional formatting
  • Analysing data lists
  • Using What-If analysis, performing calculations
  • Creating, editing, and formatting pivot tables
  • Creating and editing charts
  • Linking and embedding objects
  • Sharing workbooks.

 

Additional Information

For further information about the content of this program or to enquire about having this program brought ‘In-House’ to your council or to a ‘Council Hub’ near you please contact LGA Training on 8224 2000 or at training@lga.sa.gov.au.
 
Please understand that by registering you are accepting our policy conditions. For a copy of our policies, please click here.

 

Upcoming Short Courses

There are currently no openings available for this course.