Course Code: WKSH 121
Academic Year: 2024-2025
Analyze, summarize and explore spreadsheet data through the use of Pivot Tables. You will use Lookup formulas to quickly locate data in large spreadsheets and will write, edit and combine advanced formulas and functions to evaluate data and quickly answer questions. Topics include comparing and contrasting spreadsheet data through the use of advanced charts. You will learn to combine text strings, change lines of text to columns and effectively manage text using Excels Text functions along with using Macros to automate and streamline repetitive tasks.