paypaldonate

enbgdeidgalvltplptro

Monday 10th January 2022  -  12.30pm - 2.30pm  -  6 Weeks

This course is aimed at existing Excel users who feel they are not making the best use of its facilities and who want to explore other features. The course will introduce many shortcuts that the user may not have discovered for themselves.

It is assumed the user has a basic knowledge of Excel or has already attended the Foundation course.


EDITING - DATA - Naming cells, Conditional formatting, paste special tools

DISPLAY – Freeze row/columns, use sub-totalling featured

PROTECTION

DATA – sorting, querying, filtering

LINKING – data/charts

FUNCTIONS
Date and Time Functions
Mathematical Functions
Statistical Functions
Text Functions
Lookup and Reference Functions
Index & Match Functions
Logical Function (Nested)

FLASH FILL

For more information or to apply for this course, please contact Ingrid This email address is being protected from spambots. You need JavaScript enabled to view it. or telephone (028) 8772 7648.

Apply online



ANALYSIS – pivot tables, scenarios

SLICERS

Successful Benefits Checker claims
Since September 2012 £331,745.16

Revised ESF Logo

 Dept of CommunitiesDept of Communities FR Fundraising Badge LR LOGO T buc Colour Logo

Lottery Funded Mid Ulster Council  Executive office with web address
This Project is part-funded by the European Union and the Department of Employment and Learning