Working with Microsoft Excel Spreadsheets
This session will be facilitated by Geraldine Meskill again this semester.
The course content includes:
- Efficient Spreadsheet Design
- Review Basic Spreadsheet Development
- Splitting and Freezing Windows
- Reviewing 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
Speaker
-
Geraldine Meskill