This easy beginners Excel tutorial covers the basics of the SWTICH function, which can be used as an alternative to nested IF statements or the IFS function.

If you’d like to follow along, you can download a copy of the file from my Google Drive. You can also use it for reference in your own time.
Download the file here: https://drive.google.com/file/d/1JSZLXjq7VRT9JViOSfgOQXbf03hLIHwv/view?usp=sharing

Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!

What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I’ll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! 🙂

Check out our playlist on INDEX, MATCH and variations on the IF function here: https://www.youtube.com/watch?v=M-0jEVhYkVw&list=PLJWCoDBpUWeM_8pBriBOVDVhB1to3A-Z2

And here are the links to my videos on nested IF statements and the IFS function !
Nested IF statements: https://www.youtube.com/watch?v=VgnUbiqliHI
IFS function : https://www.youtube.com/watch?v=c7AoYBjnXDk

Please take the opportunity to connect and share this video with your friends and family if you find it useful.