MS Excel Logo Image

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

Date

09 Dec 2021
Expired!

Time

10:00 - 12:00

Location

Online

Organizer

CPD
Email
cspower@wit.ie