Microsoft Excel Training
Microsoft Excel is a powerful spreadsheet program used to create, edit and format professional reports. From simple lists to complex linked spreadsheets with formulas, functions and macros, Excel helps users organise, analyse and present data with confidence.
Choose Your Excel Course
Click a course below to view the full details
Spreadsheets Made Easy
Introduction Microsoft Excel Course
Duration: 1 Day
Delivery: Face To Face & Live Online
This course covers mastering percentages and spreadsheet techniques. Delegates will learn how to handle percentages confidently, link spreadsheets and use formulas such as Today, Median, Mode and Absolute Cell Referencing. The course also develops filtering and subtotal skills.
Who Should Attend?
- Data Analysts
- Finance Professionals
- Operations Managers
- Accountants
Course Requirements
No previous experience of Microsoft Excel is required. Delegates should have basic computer skills, including how to use a mouse and keyboard.
Course Content
- Keyboard: Function keys and shortcuts.
- Screen Layout: Terminology, toolbars and navigation.
- Formatting: Opening, closing, saving, text, columns and rows.
- Editing: Planning, Autofill, copy, cut, paste and Paste Special.
- Printing: Selection, entire workbook, worksheet and page setup.
- Data: Sort, filter and subtotals.
- Basic Graphs: Bar, area and pie charts.
- Basic Formulas: Arithmetic, percentages, absolute references, averages and dates.
- BODMAS: Understand calculation order using examples such as 2+2*2=6.
- Formulas: Average, Median, Mode, Count, CountA, CountBlank, CountIF, Min and Max.
Combined & Complex Formulas
Intermediate Microsoft Excel Course
Duration: 1 Day
Delivery: Face To Face & Live Online
This course introduces more complex Excel features, including IF, SUMIF, COUNTIF, AND, OR, VLOOKUP and HLOOKUP, along with an introduction to combining formulas. It also explores advanced data analysis techniques, including Pivot Tables.
Who Should Attend?
- Data Analysts
- Finance Professionals
- Operations Managers
- Accountants
Course Requirements
Delegates should have attended the previous stage of the Excel course at Pringle PCS or have equivalent working knowledge.
Course Content
- Editing: Custom fills and conditional formatting.
- Advanced Linking Spreadsheets: Formula linking.
- Data: Pivot Tables, custom filtering, subtotals, validation, lists and protection.
- Formulas: IF statements, CountIF, SumIF, VLOOKUP and HLOOKUP.
- Nested IFs: Build nested IF statements for multi-condition logic.
- More Formulas: Use AND and OR.
- What IF Analysis: Goal Seek and Scenario Manager.
- PMT: Calculate repayment of a loan.
- Further Formulas: Introduction to combined formulas.
- Text Formulas: Len, Left, Right, Mid, Find, Proper, Upper and Lower.
- Combined Text Formulas: Combine text functions for advanced data cleanup.
Pivot Tables & Data Reports
Intermediate Microsoft Excel Reporting Course
Duration: 1 Day
Delivery: Face To Face & Live Online
This course helps delegates master essential tools for organising, analysing and presenting data. It is ideal for anyone looking to enhance reporting skills or improve decision-making through better data management.
Who Should Attend?
- Data Analysts
- Finance Professionals
- Operations Managers
- Accountants
Course Requirements
Delegates should have attended the previous stage of the Excel course at Pringle PCS or have equivalent working knowledge.
Course Content
- Pivot Tables: Organise and analyse large datasets efficiently with interactive Pivot Tables.
- Data Sorting and Filtering: Quickly sort and filter data to focus on relevant information.
- Graphs and Charts: Create visual representations of data.
- Creating Reports: Design comprehensive and professional reports.
- Using the Slicer: Use slicers to filter data dynamically.
Excel Master
Advanced Microsoft Excel Course
Duration: 1 Day
Delivery: Face To Face & Live Online
The advanced Excel course focuses on combining features, functions and tools to solve complex problems. New functions such as financial, text and date formulas are introduced, along with Macros and VBA to enhance mastery of Excel.
Who Should Attend?
- Data Analysts
- Finance Professionals
- Operations Managers
- Accountants
Course Requirements
Delegates should have attended the previous stage of the Excel course at Pringle PCS or have equivalent working knowledge.
Course Content
- Date Formulas: Day, Month, Year, WeekDay and WeekNum.
- Combined Advanced Formulas: IF, AND, OR, VLOOKUP and HLOOKUP.
- Problem Solving: Apply advanced problem-solving techniques to optimise complex formulas.
- Macros VBA: Record, edit and run Macros, and understand VBA including REM statements.
- Advanced Customising: Customise Excel through toolbars and menus.
- Advanced Formatting: Manage and consolidate data using templates, Track Changes and auditing.
- Forms: Create and manage dropdown lists, tick boxes and spinners.
- Combined Text Formulas: Use Len, Left, Right, Mid, Find, Proper, Upper and Lower.
