Excel 2019 Intermediate - Northern Beaches Community College

Thanks for adding:

Proceed to Checkout

Continue browsing

X

Excel 2019 Intermediate

Course Outline

Intermediate Microsoft Office Excel one day course focusing on more advanced features of Excel. This is a great follow on course from the Excel 2019 Introduction. Learn data setup, formula techniques, functions, formatting and linking, sorting and filtering data. This course would suit those who have basic day to day excel skills but want to learn more advanced techniques and functions of the software.

Topics include

  • Page Setup
  • Filling Data
  • Worksheet Techniques
  • Page Setup
  • Formula Referencing
  • Formula Techniques
  • Number Formatting Techniques
  • Conditional Formatting
  • Chart elements

Prerequisites

  • Confident keyboarding skills and Excel Introduction course or equivalent skills and knowledge
  • Students must have Excel 2016/2019 or Office 365 installed on their computer.

The students attending this course are expected to already have the following Excel skills/knowledge:

• Creating a new Workbook
• Working with workbooks
• Editing workbooks
• Using/Understanding Formulas and Functions
• Selecting Ranges
• How to copy Excel Data, including basic filling
• Formatting in Excel
• Cell Alignment
• Formatting Rows and Columns
• Formatting Numbers
• Applying Borders
• Working with a Worksheet
• Printing
• Creating Charts

This course has no current classes. Please the waiting list.

Course testimonials:

  • Great session. Great Teacher. Nicky was lovely and very helpful and thorough in her teaching.
  • Who thought that an Excel course could have you focused for a full day without a dull moment. Excellent trainer, learnt a lot with very practical applications. Highly recommended.
  • The whole day was great, I learnt so much. Thanks Nicky for a great course.
  • I really enjoyed the course and learnt a lot. Nikki is a very knowledgeable and engaging trainer. Highly recommended.