Call: 0330 32 100 58

Excel Level 2

Course Content

COURSE OBJECTIVES

Use Logic Functions
Use Lookup Functions
Importing  Data
Understand and use Nested Functions
Using Dates and Times

About

1: Who is the Course for?
This course is designed for users who wish to increase their skills and knowledge of spreadsheets and Microsoft Excel. This level will help the delegate to produce more productive spreadsheets using formulas and function techniques.

2: The Course
Courses delivered by InIT Learning are tutor led. The tutor will use demonstration and discussion along with hands-on practical tasks and assignments to ensure each user has gained an understanding of each topic. Questions are encouraged throughout the session. During each task and assignment the tutor will give one to one support as required.

3: Certificates
Each delegate will receive a manual and a certificate of attendance

Excel Level 2
In-house Course

Logic Functions
TRUE – FALSE
SumIF
AverageIF
IF
Nested IF
IFERROR
AND OR NOT
Naming Cells & Ranges
Managing Names
Using Names
Lookup Functions
Import CSV or Txt
Custom Fill
Static Dates and Times
Custom Date Formats
Custom Time Formats
Dynamic Dates and Times
Basic Date Calculations
Date Functions
Times
Handy Shortcuts
Enquiry
Excel 1Excel 2Excel 3Word 1Word 2PowerPointOutlook
On Course for Success with InIT Learning
On Course to Develop - On Course to Progress - On Course to Achieve
InIT Learning One day Computer Courses
Copyright © InIT Learning
Areas Covered - Milton Keynes, Buckinghamshire - Northampton, Northamptonshire - Rugby, Warwickshire - Oxford, Oxfordshire - Bedford, Bedfordshire - All surrounding towns and counties
usersscreenlist linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close