Advanced Excel
Take your Excel skills further with custom format codes, sorting and querying tables, and advanced practice files. Learn through hands-on workbooks, video tutorials and a test at the end of each module.
Introductory Video
Textbook
SC_EX_5-1.xlsx
SC_EX_5-2.xlsx
SC_EX_5-3.xlsx
Custom Format Codes — Video Tutorials
Module 1 Test
SC_EX_6-1.xlsx
SC_EX_6-2.xlsx
SC_EX_6-3.xlsx
Sorting and Querying a Table
Creating, Sorting and Querying a Table
Module 2 Test
SC_EX_7-6.xlsx
SC_EX_7-7.xlsx
Support_EX_7_AirlineA.xlsx
Support_EX_7_AirlineC.docx
Support_EX_7_AirlineD.docx
Support_EX_7_Branch18624.docx
Support_EX_7_Branch70635.docx
Support_EX_7_Branch82410.xlsx
Support_EX_7_InsuranceLogo.gif.pdf
Module 3 Test