Microsoft Excel – Intermediate: Complex Formulas

Loading Events

« All Events

Microsoft Excel – Intermediate: Complex Formulas

December 12 @ 9:30 am - 4:30 pm

|Recurring Event (See all)

One event on 7th August 2019 at 9:30am

One event on 10th September 2019 at 9:30am

One event on 8th October 2019 at 9:30am

One event on 7th November 2019 at 9:30am

One event on 12th December 2019 at 9:30am

One event on 17th January 2020 at 9:30am

One event on 11th February 2020 at 9:30am

One event on 11th March 2020 at 9:30am

Member price – £120.00 + VAT
Non-member price – £160.00 + VAT

Duration – 1 Day

 

This course introduces more complex features. By the end of this course delegates will be in a position to use some of Excel’s most beneficial functions such as If, Sumif, Countif, And, Or, Vlookup, and Hlookup and is an introduction to using combined formulas. In addition, the trainer will also look at more advanced data analysis techniques with combined formulas such as Pivot tables.

  • Refresher Workshop
  • Editing – Custom Fills / Conditional Formatting
  • Advanced Linking Spreadsheets – Formula Linking
  • Data – Pivot Tables / Custom Filtering / Subtotals / Validation / Lists / Protection
  • Formulas – IF Statements / CountIF & SumIF / Vlookup / Hlookup
  • Nested IFs: =IF(A1=1,”Yes”,IF(A1=2,”No”,IF(A1=3,”Good”,IF(A1=4,”Bad”,”Naughty”))))
  • AND / OR Formulas
  • What IF Analysis – Goal Seek / Scenario Manager
  • PMT – Repayment of a Loan
  • Introduction to Combined Formulas
  • Text Formulas – Len / Left / Right / Mid / Find / Proper / Upper / Lower
  • Introduction to Combined Text Formulas: =Proper(Left(D1,1)&” “&Right(D1,Len(D1)-Find(” “,d1,1)))
  • Problem Solving Workshops
  • Question and Answers

Details

Date:
December 12
Time:
9:30 am - 4:30 pm
Event Categories:
, , ,

Venue

Sheffield
South YorkshireUnited Kingdom

Organiser

Chamber Skills Solutions
Phone:
01709 386200
Email:
training@brchamber.co.uk
Website:
www.brchamber.co.uk/training

Other

Enquiry Only
Is Inquirable

Book this training course