This course will introduce the concepts and basic tools of Excel providing a sound basis to begin making and using Excel sheets.

Course Details

Format: One hour in person on York Campus

Audience: All YSJ alumni, students and staff

Prior knowledge: None

Excel1 is the first in a 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:

• What is a spreadsheet
• Storing data and formatting numbers
• Changing the appearance of cells and copying formats
• Copying, auto-filling and moving cells
• Performing calculations and copying formulae
• Using range formulae, SUM and AVERAGE
• Managing columns, rows and cells. Adjusting, inserting and deleting
• Working with large sheets of data, freezing titles, defining a print area for paper and PDFs
• Creating basic tables. Sorting and filtering data.
• Saving work, OneDrive benefits and Excel online

Other Digital Training Courses

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

Accessibility courses    Adobe courses    Apprentice courses    Audio, video and image courses    Bookings app ccourses    Excel and data courses    Excel courses    Getting started courses    Microsoft 365 other apps Courses    MOS Courses and tests    Portfolio and website courses    Poster and leaflet courses    PowerPoint Courses    Research courses    Word Courses    Work skills 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