North Lindsey College
University Campus

Call

01724 294030

Email

info@northlindsey.ac.uk

Visit
North Lindsey College
Kingsway
Scunthorpe
DN17 1AJ

Excel Intermediate

Apply Online

Excel Intermediate

Customised programme

Excel 2003 v 2007 v 2010 (and later);
Quick Access Toolbar;
Named Ranges;
Data Validation (using Named Ranges);
Absolute Values (‘Locking’ the cell reference);
Data Transfer between worksheets and spreadsheets;
Conditional Formatting;
Formula Auditing;
IF Statements and Formulas;
VLOOKUPS;
Inserting Charts;
Sub-totals;
Pivot Tables;
Paste Options;
Date and Time Functions;
Placing Existing Data into a ‘Table’;
Themes;
Adapting the view of the Spreadsheet;
Inserting ‘Screen-Shots’;
SmartArt Graphics;
What-If Analysis;
Macros

Apply Online Call 01724 294030 Email info@northlindsey.ac.uk
    • Course Title

      Excel Intermediate

    • Start Dates

      Mon 14th Jan 2019; Fri 8th Feb 2019; Fri 15th Mar 2019; ; Fri 12th Apr 2019; Fri 17th May 2019; Fri 14th Jun 2019; Fri 12th Jul 2019

    • Part Time – Course dates decided on demand

    • Duration

      1 day

    • Apply Now