11-07-17 Excel 2010 Intermediate (Any) Full Day - School ICT Services
  • Latest News

    11/09/2017

    Fileset 703 is now available in the downloads section of our website.


    Read more

  • Request a call back

    • Name
    • Email
    • Telephone
    • Message

  • Join our mailing list

    Enter your email address below to receive regular news updates from School ICT Services Ltd

    11-07-17 Excel 2010 Intermediate (Any) Full Day

    Places:

    Places Available

    Price:

    SLA £105 / None SLA £135

    Course Title:

    Excel 2010 Intermediate

    Duration:

    1 Day

    Times:

    9.30am – 4.00pm

    Course Aims:

    n/a

    Course Objectives:

    Setup & Printing Issues

    • Worksheet Margins
    • Worksheet Orientation
    • Worksheet Page Size
    • Headers and Footers
    • Header and Footer Fields
    • Scaling Your Worksheet to Fit a Page(s)
    • Printing Titles On Every Page
    • Printing the Row and Column Headings
    • Spell Checking
    • Previewing a Worksheet
    • Viewing Workbooks Side By Side
    • Printing Options

    Functions and Formulas

    • Getting Help With Functions
    • Nested Functions
    • Consolidating Data using a 3-D Reference Sum Function
    • Mixed References within Formulas

    Time & Date Functions

    • TODAY
    • NOW
    • DAY
    • MONTH
    • YEAR

    Mathematical Functions

    • ROUND
    • ROUNDDOWN
    • ROUNDUP

    Logical Functions

    • IF
    • AND
    • OR

    Mathematical Functions

    • SUMIF

    Statistical Functions

    • COUNT
    • COUNTA
    • COUNTIF
    • COUNTBLANK
    • RANK
    • TEXT FUNCTIONS
    • LEFT
    • RIGHT
    • MID
    • TRIM
    • CONCATENATE

    Financial Functions

    • FV
    • PV
    • NPV
    • RATE
    • PMT

    Lookup Functions

    • VLOOKUP
    • HLOOKUP

    Database Functions

    • DSUM
    • DMIN
    • DMAX
    • DCOUNT
    • DAVERAGE

    Named Ranges

    • Naming Cell Ranges
    • Removing a Named Range
    • Named Cell Ranges and Functions

    Cell Formatting

    • Applying Styles to a Range
    • Conditional Formatting
    • Custom Number Formats

    Manipulating Worksheets

    • Copying or Moving Worksheets
    • Splitting a Window
    • Hiding Rows, Columns & Worksheets

    Templates

    • Creating Excel Templates
    • Editing Excel Templates

    Paste Special Options

    • Using Paste Special to Add, Subtract, Multiply & Divide
    • Using Paste Special ‘Values’
    • Using Paste Special Transpose Option

    Target Audience:

    n/a

    Pre-requisites:

    • None

    Venue Details:

    School ICT Services Ltd
    The Courtyard
    Swillington Lane
    Swillington
    Leeds
    LS26 8BZ

     

    Skip to toolbar