Audience: All YSJ students and staff
Format: One hour in person on York Campus
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.
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:
- 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
