acca-cbe-centre-banner

acca-cbe-centre-banner

acca-cbe-centre-banner

Excel Advanced Formulas
 

Our Microsoft Excel Formulas course is suitable for those with an advanced working knowledge of Excel who want a greater understanding of more sophisticated formulas & functions within Excel. Familiarity with creating functions including IF, VLOOKUPs and HLOOKUPs or our Excel Advanced course.

 

Benefits

  • At the end of this course you will have a greater understanding of building complex formulas using nested functions (such as IF statements). 
  • You will find quicker ways to customise formulas by taking advantage of the built-in functions available in Excel. Save time by learning more sophisticated search & auditing techniques when working with data-heavy spreadsheets.

 

Duration & Cost

Hours per Week 3 Months 6 Months 9 Months 11 Months 12 Months
 15 £1,800 £3,000 £4,000 £4,720 £4,900
 9 £1,500  £2,500  £3,300  £3,900  £4,050 
 6 £1,190  £2,030  £2,750 £3,350  £3,500
 4 £860  £1,460  £1,940 £2,360  £2,465 

 

Course Syllabus

  • Building complex formulas

- Using nested IF statements
- Creating compound logical tests using AND, OR, NOT functions with IF statements
- Nesting LOOKUP functions
- Source table structure information using CHOOSE function
- Using MATCH function to locate data
- The INDEX function for retrieving information by location
- Using a nested formula containing INDEX, MATCH and MATCH (two-way lookup)

    • Advanced functions in formulas

- Using COUNTIFS,SUMIFS, & AVERAGEIFS for tabulating data based on single/multiple criteria
- Statistical functions; MEDIAN, MODE, RANK, LARGE, SMALL, ROUND, MOD
- AGGREGATE function to sum data in ranges with errors
- Use a variety of Financial functions such PMT, FV, IRR

        • Data & Text Functions

- Smarter ways to calculate date & time; TODAY
- NETWORKDAYS, WORKDAY, DATEDIF 
- Use TYPE to identify data type of existing cell contents
- Text functions; UPPER, PROPER, FIND, MID, SEARCH, LEFT, RIGHT, LEN
- TRIM excess space in cells

        • Auditing formulas

- Tracing formula precedents, dependents, and errors
- Correcting errors in formulas
- Combining IF with VLOOKUP to suppress error messages
- Using the IS information function
- Error checking functions; ISERR, ISERROR, IFERROR

Refer A Friend Banner

Accountancy Course Info Request

Form by ChronoForms - ChronoEngine.com

Save 30% on Student Oyster Card

Student Oyster Discount Offer


Website security

NUS NY 728x90 2016 12 15 V1 NC

Opening Hours

Monday
09:00 - 21:00
Tuesday
09:00 - 21:00
Wednesday
09:00 - 21:00
Thursday
09:00 - 21:00
Friday
09:00 - 21:00
Saturday
09:00 - 21:00
Sunday
09:00 - 21:00

Logo Bar

Go to top
Join us at Amity College Ltd.