Format: One hour in person on York Campus
Audience: All YSJ 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.
We have the same courses Excel Video Courses on YouTube.
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. There is an additional MOS Excel course to cover further MOS skills.
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
