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.