catraining

 

Microsoft Partner
Microsoft Excel Functions

Audience: Excel functions are the backbone of most Excel worksheets but with nearly 500 worksheet functions in Excel how can you possibly learn them all? The answer is to learn the important ones. The Excel functions course is devised to give you a broad skill set covering the primary categories of Excel functions

Course Duration: 1 day(1)

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and Saturday club.

Course Location: This Microsoft Excel Functions training course is delivered at our training centre in London situated close to Liverpool Street station; training can also be delivered at your offices. Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

 

MOS Excel Specialist / Expert Exam Costs ( optional )

 

All Vouchers now include a Retake Voucher
Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs

 

View Scheduled Public Courses

reaining course

 

After completing this course, students will be able to:
    • Text formulas and functions such as TRIM
    • Aggregation functions such as SUMIFS
    • Decision making functions such as IF and IFERROR
    • Date and Time such as TODAY and NETWORKDAYS
    • Lookup and Reference functions such as VLOOKUP
    • Magnitude functions such as MAX, LARGE and RANK
    • Information functions such as CELL and ISNA

  • Course Outline
    print this page
    Module 1: Text formulas and functions
    • Concatenation operator or CONCATENATE function?
    • Extraction; LEFT, RIGHT, MID
    • Manipulation: LEN, TRIM, FIND, SEARCH, REPLACE, SUBSTITUTE
    • Conversion: TEXT, VALUE, UPPER, LOWER, PROPER
    Module 2: Aggregation functions
    • SUMIFS, COUNTIFS, AVERAGEIFS
    • Database functions: DSUM, DCOUNT, DCOUNTA, DAVERAGE
    Module 3: Decision making functions
    • IF, AND, OR, NOT
    • Constructing and evaluating nested IFs
    • IFERROR, IFNA
    • CHOOSE
    • Module 4: Date and Time
      • NOW, TODAY
      • NETWORKDAYS
     
    Module 5: Lookup and Reference functions
    • VLOOKUP and HLOOKUP
    • COLUMN and ROW
    • MATCH
    • INDEX
    • OFFSET
    • TRANSPOSE
    • INDIRECT
    • Intersection formulas
    Module 6: Magnitude
    • MAX and MIN
    • LARGE and SMALL
    • RANK
    Module 7: Information
    • CELL
    • ISERR, ISERROR, ISNA
    • ISBLANK, ISNUMBER
     
      Microsoft

Call us now for further information Tel:08001601666