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