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