This course covers more formulae and looks at approaches to building more complex solutions.

Course Details

Format: One hour in person on York Campus

Alternative: This course is also available as a self-paced video course with exactly the same content and sample files to practice along. For the video and resources see Excel Training Courses and notes (internal) or Excel Video Courses from YSJ Digital Training direct on YouTube.

Audience: All YSJ students and staff

Prior knowledge: Completion of Excel 3 Course (Using Formulae)

Excel5 is in our series of five Excel courses designed to cover all the key aspects of Excel. The other individual sessions can be booked according to your interests and do not have to be taken in order although we do recommend Excel1 before the others.

If you are interested in a MOS (Microsoft Office Specialist) qualification, then the five courses cover most of the MOS objectives in an introductory manner.

This course includes:

• Generate numeric data using RANDBETWEEN() and SEQUENCE()
• Sort data by using the SORT() function
• Get unique values by using the UNIQUE() function
• Format text by using RIGHT(), LEFT(), MID(), UPPER(), LOWER(), and LEN() functions
• Format text by using the CONCAT() and TEXTJOIN() functions
• Use the formulae above to solve real world data handling issues

Other Digital Training Courses

All Digital Training Courses    In person (York) courses    Online Courses

York St John Graduate attributes

As well as other skills, knowledge and competencies gained from your  time at York St John, these attributes are designed to enable graduates to thrive in life and work.

These courses contribute particularly to the following Graduate Attributes:

Confident

• Communicate, in a range of formats and for different audiences
• Confident in your skills and aspirational in setting goals for the future

Authentic

• Engaged with relevant technology and using it in a socially responsible way

Resilient

• Able to adapt to technological change and agile in approach to learning

Enterprising

• Aware of resources and able to utilise these to support personal and professional development

Professional

• Knowledgeable, evidence led and intellectually curious