Microsoft Excel: Intro | Inter | Adv

EXCEL INTRODUCTION: SPREADSHEETS MADE EASY

COURSE REQUIREMENTS

No previous experience of Microsoft Excel is required however the delegate should have knowledge in basic computer skills i.e. how to use a mouse and keyboard.

COURSE CONTENT

  •  Keyboard (Function Keys / Shortcuts)
  •  Screen Layout (Terminology / Toolbars / Navigation)
  •  Formatting (Opening – Closing – Saving / Text / Columns & Rows)
  • Editing (Planning / Autofill / Copy / Cut / Paste / Paste Special)
  •  Printing (Selection / Entire Workbook / Worksheet / Page Setup)
  •  Data (Sort / Filter / Subtotals)
  •  Basic Graphs (Bar / Area / Pie)
  •  Basic Formulas (+ – ÷ × / Basic Percentages / Absolute References / Averages / Dates)
  •  Data (Sort / Filter / Subtotals)
  •  BODMAS & BIDMAS: (2+2*2=6)
  • Average / Median / Mode Formulas
  • Count / CountA / CountBlank / Countif Formulas
  • Min / Max Formulas
  • Problem Solving Workshops
  • Min / Max Formulas
  • Question and Answers

MICROSOFT EXCEL INTERMEDIATE: COMBINED & COMPLEX FORMULAS

COURSE REQUIREMENTS

 The delegate needs to have attended the previous level of the Excel course at Pringle PCS or at least, have the equivalent working knowledge.

COURSE CONTENT

  • 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

MICROSOFT EXCEL ADVANCED: EXCEL MASTER CLASS

COURSE REQUIREMENTS

The delegate needs to have attended the previous level of the Excel course at Pringle PCS or at least, have the equivalent working knowledge.

COURSE CONTENT

  • Refresher Workshop
  • Date Formulas (Day / Month / Year / WeekDay / WeekNum)
  • Combined Advanced Formulas (IF / AND / OR / V & H Lookup Combined)
  • Problem Solving Exercises (The Solver / Utilising / Complex Formulas)
  • Introduction to Macros VBA (Recording, Editing, Running Macros / Understanding VBA / Rem Statements)/li>
  • Advanced Customising Of Excel (Toolbars / Menus)
  • Advanced Formatting (Templates / Consolidating Data / Track Changes / Auditing)
  • Forms / Dropdown Lists / Tick Boxes / Spinners
  • Combined Date Formulas: =IF(WeekDay(A1,2)<=5,”Work”,”Play”)
  • Advanced Combined Text Formulas (Len / Left / Right / Mid / Find / Proper / Upper / Lower)
  • Problem Solving Workshops
  • Question and Answers
Delivery

Cohort Minimum

Cohort Maximum

Number of Training Sessions

Contact Hours

Price per learner 1 to 1

120

Price per Learner

(Minimum Cohort)

£595.00

Training PringlePCS's Offer

Pringle PCS have been established since 1996 and have become one of the UK Leading Training Providers. PCS Training offer extensive IT & Business Skills training courses designed to improve and enhance learners’ skills. All courses are taught by highly experienced professional trainers Skywallker House The main Headquarters of PCS are in Sheffield at Skywalker House, S9 5AB and have three dedicated IT training rooms and two conference rooms. This facility enables PCS to provide Business Skills (People Skills) and IT training that ranges from scheduled courses to bespoke IT and company development solutions. All PCS services are offered across the entire United Kingdom to provide any company, in any industry the full solution UK Training PCS train throughout the UK at customer premises or assigned conference facilities. PCS can even bring full IT equipment that makes a standard office into a fully functional training room. PCS can also train in-house designed company programs or company procedures that would need rolling out throughout the organisation UK Training PCS train throughout the UK at customer premises or assigned conference facilities. PCS can even bring full IT equipment that makes a standard office into a fully functional training room. PCS can also train in-house designed company programs or company procedures that would need rolling out throughout the organisation

View Website

Reviews

There are no reviews yet.

Be the first to review “Microsoft Excel: Intro | Inter | Adv”

Your email address will not be published. Required fields are marked *

9 − one =