Loading Events

« All Events

  • This event has passed.
Event Series Event Series: Excel Intermediate

Excel Intermediate

January 12 @ 9:30 am - 4:30 pm

For individuals who are already using Excel, this course will streamline and perfect their Excel skills by teaching the more intermediate features available in the application.

What you will learn:

  • Formula – Vlookups, IF Statements, SumIf, CountIf, Text formula, Concatenate, linking spreadsheets.
  • Utilities – Protecting data, hide and unhide data, named ranges, working with dates, comments, data validation, headers and footers.
  • Linking Data – linking spreadsheets, identifying links, linking separate workbooks.
  • Data Analysis – Updating Pivot Tables, filters, subtotals, icons and data bars in conditional formatting, filter and sort using colour.
  • Pivot Tables – creating Pivot Tables, Pivot Charts, Slicers, refreshing data, updating ranges.

Details

Date:
January 12
Time:
9:30 am - 4:30 pm
Series:
Event Categories:
, ,

Organiser

Pitman Training Centre – Glasgow
Phone
0141 223 0090
Email
glasgow@pitman-training.net

Venue

Glasgow
First Floor 82 Union Street
Glasgow, G1 3QS United Kingdom
+ Google Map
Phone
0141 223 0090