Microsoft Excel Spreadsheets

This course will be delivered over two sessions- Thursday 9th December & Thursday 16th December.

The course content includes:

• Efficient Spreadsheet Design
• Review Basic Spreadsheet Development
• Splitting and Freezing Windows
• Review Basic Functions- Time/Date, Text, Nesting, Conditional Formatting, The IF Function, Cell Comments, Copy, Paste and Paste Special, Sorting, Multiple Column Sorts (Custom Sort)
• Lists, Advanced Filtering, Lookup Functions, Pivot Tables Review
• Review Multiple Sheets, Linking Sheets, Importing, Hiding Rows & Columns, Worksheet & Workbook Protection
• Creating Scenarios, Using, Editing and Deleting Scenarios
• Review of Creating a Chart, Advanced Chart Options
• Tracking Precedent and Dependent Cells
• Creating a Macro, Running a Macro