The course taught learners to manage large Excel worksheets, use multiple sheets and workbooks, link data, apply advanced formatting, and create outlines and subtotals. They also learned to sort, filter, remove duplicates, format tables, and protect and share workbooks.