Microsoft Excel – Intermediate: Complex Formulas

Loading Events

« All Events

  • This event has passed.

Microsoft Excel – Intermediate: Complex Formulas

6th December 2023 at 9:30 am - 4:30 pm

|Recurring Event (See all)

One event on 6th December 2023 at 9:30 am

One event on 5th January 2024 at 9:30 am

One event on 7th March 2024 at 9:30 am

One event on 5th April 2024 at 9:30 am

One event on 7th May 2024 at 9:30 am

One event on 5th July 2024 at 9:30 am

Member price – £150.00 + VAT
Non-member price – £170.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

 

Now available as a virtual course – ring 01709 386200 for further details

Details

Date:
6th December 2023
Time:
9:30 am - 4:30 pm
Event Categories:
, , , ,

Venue

Sheffield
Sheffield, United Kingdom

Organiser

Chamber Skills Solutions
Phone
01709 386200
Email
training@brchamber.co.uk

Other

Enquiry Only
Is Inquirable

Book this training course