Microsoft Excel is a powerful spreadsheet program used to create, edit, and format professional tabled reports. With its grid-based structure, Excel allows users to organize data into simple lists or complex, linked spreadsheets with formulas, functions, and macros. Our Excel courses cover essential features to build your confidence in mastering this essential office tool.

Course Code: ITEE01 | Course Title: Spreadsheets Made Easy | Duration: 1 Day
Delivery: Face To Face & Live Online

This course covers mastering percentages and spreadsheet techniques. You will learn how to handle percentages confidently, link spreadsheets, and utilise formulas like Today, Median, Mode and Absolute Cell Referencing. You will also gain skills in filtering and subtotal functions.

Who Should Attend Microsoft Excel Training?

• Data Analysts
• Finance Professionals
• Operations Managers
• Accountants

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
• BODMAS: 2+2*2=6
• Formulas: Average / Median / Mode, Count / CountA / CountBlank / CountIF, Min / Max

Course Code: ITEE02 | Course Title: Combined & Complex Formulas | Duration: 1 Day
Delivery: Face To Face & Live Online

This course introduces more complex features, including key functions like If, Sumif, Countif, And, Or, Vlookup, and Hlookup, along with an introduction to combining formulas. It also explores advanced data analysis techniques, such as Pivot Tables.

Who Should Attend Microsoft Excel Training?

• Data Analysts
• Finance Professionals
• Operations Managers
• Accountants

Course Requirements:

The delegate needs to have attended the previous stage of the Word course at Pringle PCS or at least, have the equivalent working knowledge.

Course Content

• 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"))))
• More Formulas: AND / OR
• What IF Analysis: Goal Seek / Scenario Manager
• PMT: Repayment of a Loan
• Further Formulas: Introduction to Combined Formulas
• Text Formulas: Len / Left / Right / Mid / Find / Proper / Upper / Lower
• Combined Text Formulas: =Proper(Left(D1,1)&" "&Right(D1,Len(D1)-Find(" ",D1,1)))

Course Code: ITEE03 | Course Title: Pivot Tables & Data Reports | Duration: 1 Day
Delivery: Face To Face & Live Online

This course is designed to help participants master the essential tools for organizing, analysing, and presenting data. If you’re looking to enhance your reporting skills or improve decision-making through better data management, this course provides practical knowledge to elevate your expertise.

Who Should Attend Microsoft Excel Training?

• Data Analysts
• Finance Professionals
• Operations Managers
• Accountants

Course Requirements:

The delegate needs to have attended the previous stage of the Word course at Pringle PCS or at least, have the equivalent working knowledge.

Course Content

• Pivot Tables: Organize and analyse large datasets efficiently with interactive pivot tables
• Data Sorting & Filtering: Quickly sort and filter data to focus on relevant information
• Graphs & Charts: Create visual representations of data
• Creating Reports: Design comprehensive and professional reports
• Using the Slicer: Utilize slicers to filter data dynamically

Course Code: ITEE04 | Course Title: Excel Master | 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 VBA, to enhance mastery of Excel.

Who Should Attend Microsoft Excel Training?

• Data Analysts
• Finance Professionals
• Operations Managers
• Accountants

Course Requirements:

The delegate needs to have attended the previous stage of the Word course at Pringle PCS or at least, have the equivalent working knowledge.

Course Content

• Date Formulas: Essential date functions such as Day, Month, Year, WeekDay, and WeekNum
• Combined Advanced Formulas: IF, AND, OR, VLOOKUP, and HLOOKUP
• Problem Solving: Apply advanced problem-solving techniques to optimize complex formulas
• Macros VBA: Record, edit, run Macros & understand VBA including REM statements for automation
• Advanced Customising: Customize Excel through toolbars and menus
• Advanced Formatting: Manage & consolidate data using Templates, Track Changes, & Auditing
• Forms / Dropdown Lists / Tick Boxes / Spinners: Create and manage interactive forms
• Combined Text Formulas: Functions like Len, Left, Right, Mid, Find, Proper, Upper, & Lower

No Problems, Just Solutions...