MS Excel (Intermediate) Part 1

by Pringle PCS Claim Listing

Microsoft Excel is a powerful spreadsheet program used to create, edit, and format professional tabled reports. With its grid-based structure, Excel allows users to organize data into simple lists or complex, linked spreadsheets with formulas, functions, and macros.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Pringle PCS Logo

img Duration

1 Day

Course Details

Microsoft Excel is a powerful spreadsheet program used to create, edit, and format professional tabled reports. With its grid-based structure, Excel allows users to organize data into simple lists or complex, linked spreadsheets with formulas, functions, and macros.

This course introduces more complex features, including key functions like If, Sumif, Countif, And, Or, Vlookup, and Hlookup, along with an introduction to combining formulas. It also explores advanced data analysis techniques, such as Pivot Tables.

 

Course Contents:

  • 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"))))
  • More Formulas: AND / OR
  • What IF Analysis: Goal Seek / Scenario Manager
  • PMT: Repayment of a Loan
  • Further Formulas: Introduction to Combined Formulas
  • Text Formulas: Len / Left / Right / Mid / Find / Proper / Upper / Lower
  • Combined Text Formulas: =Proper(Left(D1,1)&" "&Right(D1,Len(D1)-Find(" ",D1,1)))
  • Sheffield Branch

    Skywalker House 18A Darnall Road, Sheffield

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy