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
Be the first to review “Microsoft Excel: Intro | Inter | Adv” Cancel reply
Reviews
There are no reviews yet.