Excel Introduction: Spreadsheets Made Easy

Course Code: ITEE01 | Duration: 1 Day | Level: Introduction

One of the hardest problems users face in Excel is Percentages (Finding, Adding and Deducting). This course shows some simple steps of how to conquer this problem allowing users to create more complicated spreadsheets that they can trust and use effectively. In addition, linking spreadsheets is one of the easiest ways to improve your readable data with the introduction of some new formulas i.e. Today, Median, Mode and Absolute Cell Referencing. Delegates confidence will quickly grow allowing them to start learning filtering and subtotal functions.

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 Code: ITEE02 | Duration: 1 Day | Level: Intermediate

This course introduces more complex features. By the end of this course delegates will be in a position to use some of Excel’s most beneficial functions such as If, Sumif, Countif, And, Or, Vlookup, and Hlookup and is an introduction to using combined formulas. In addition, PCS will also look at more advanced data analysis techniques with combined formulas such as Pivot tables.

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 Intermediate Part 2: Pivot Tables & Data Reports

Course Code: ITEE03 | Duration: 1 Day | Level: Intermediate / Advanced

This 1-day hands-on training course is designed to help participants master the essential tools for organizing, analyzing, and presenting data in Excel. Whether you’re looking to enhance your reporting skills or improve decision-making through better data management, this course provides practical knowledge to elevate your Excel expertise.

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

• Pivot Tables
• Data Sorting & Filtering
• Graphs & Charts
• Creating Reports
• Using the Slicer

Microsoft Excel Advanced: Excel Masterclass

Course Code: ITEE04 | Duration: 1 Day | Level: Advanced

The previous levels of Excel introduce several very useful functions and tools, as introduced in the previous level; one single function cannot always provide you with a solution. The advanced course focuses on how to combine the features, functions and tools of Excel together. This course is not just about integration, but several new functions will also be introduced such as Financial, Text & Date formulas. This will give the user confidence to master any formula. In addition this course also introduces Macros VBA.

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)
• 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

Bespoke IT Training

For a truly exclusive and personalized training experience, Pringle PCS offers Bespoke IT Training Days, designed to align perfectly with your company's unique needs. This means that every element of the training—from topics covered to scenarios used—is tailored to directly address the challenges your team encounters in their day-to-day roles.

Flexible Location and Timing:
Our Bespoke Training Days can be held at our fully equipped offices or on-site at your company’s premises, creating a familiar learning environment. We also offer flexibility with evening and weekend sessions upon request, which is ideal if your team has specific availability constraints. Customised to Your Company’s Data and Scenarios:
We can integrate your company’s data and real-life scenarios into the training. This allows staff to learn within the exact context they work in, making the training highly relevant and immediately applicable. Whether it’s your CRM system, specific data sets, or common operational situations, the course material will reflect the actual tools and situations your employees use.

Mix and Match Course Topics:
Courses are fully customisable—you can combine topics from various skill levels or even blend subjects from different courses. For instance, if your team needs advanced Excel functions alongside project management techniques, we can create a unique curriculum that addresses both. This tailored approach ensures you maximize the training day, covering exactly what your team needs without unnecessary or unrelated content.

Enhanced Practicality and Focused Solutions:
By addressing the precise needs of your organization, these sessions provide focused solutions to real-world problems, making your team more effective and confident in their roles. Whether it’s troubleshooting, improving workflow efficiency, or upskilling, your staff will leave with the tools they need to make an immediate impact.