Microsoft Excel – Beginner to Intermediate
Duration: 1 DayInvestment: $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.