Microsoft Excel

Microsoft Excel is a complex and powerful spreadsheet program that you can use to create, edit and format professional tabled reports. It uses grid sheets that can easily create simple lists of organised data which can be made into complex linked spreadsheets utilising formulas, functions and macros.

Excel is designed to make life easier and save you huge amounts of time. The user does not need to be a mathematical genius to create powerful statistics or advanced graphs from your data, but instead letting Excel be the calculator. As with any IT application, it will only save the delegate’s time if they know how to use it. Our Excel courses take you through the most essential commonly used features and help build up their confidence to master this fundamental office program.

Excel Introduction: Spreadsheets Made Easy


Course Code: ITS12 | Duration: 1 Day | Level: Introduction | Price Grade: Standard

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: ITS13 | 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: ITS13B | 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 Master Class


Course Code: ITS14 | 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

Microsoft excel Training Videos


Prices


IT & Business Skills Scheduled Courses


All Scheduled courses are held at Pringle PCS Training & Conference Centre.

IT & Business Skills Scheduled Courses
Price
Online Single Booking
£120
Per Person
Online Additional / Subsequent Delegate Booking On The Same Day Scheduled Online Course
£75
Per Person
Single Booking Scheduled Course at Skywalker House
£150
Per Person
At Skywalker House Additional / Subsequent Delegate Booking On The Same Day Scheduled at Skywalker House
£90
Person
Online One To One
£345
One To One: Client Site or Skywalker House
£395

IT & Business Skills Company Classroom


This training is given exclusively for your company only, either here at PCS or at your own premises. (Evening and weekend dates are also available on request).


Company Classroom Standard & Premium
Individual Days: Online (Max 8 Delegates:)
£495
Individual Days: PCS Or Client Site (Max 8 Delegates)
£595
Individual Days: PCS Or Client Site (Max 12 Delegates)
£695
Bespoke IT & Business Skills Course |Team Building | Surgery On-site at Client’s Premises
£795
Computer Hire and Setup
£10
Per PC
Bespoke Database Development On-site at Client’s Premises
£695

Course Dates


Red = Fully Booked | Yellow = Limited Spaces Left | Green = One To One Or Company Classroom Booking Only, Dates Available At Request
If our set dates are not suitable for you, please contact us to discuss alternative dates for you.

Training Courses Scheduled 365 2019 2016 Office IT Word Excel PowerPoint Presentation Outlook Email Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
Microsoft Excel | Introduction
ITS04Scheduled 365 IT 2019 2016 Office live 		4 4 4 6 4 4 4 5 4 4 5 4
Microsoft Excel | Intermediate
ITS05 Scheduled 365 IT 2019 2016 Office live 		7 5 5 7 5 5 7 6 5 - 6 5
Microsoft Excel | Pivot Table Reports
ITS07 Scheduled 365 IT 2019 2016 Office live 		9 7 9 9 7 7 9 8 9 9 8 9
Microsoft Excel | Advanced
ITS06 Scheduled 365 IT 2019 2016 Office live 		8 6 6 8 6 6 8 7 6 8 7 -
Microsoft Excel | Introduction
ITS04Scheduled 365 IT 2019 2016 Office live 		One To One Or Company Classroom Booking Only
Microsoft Excel | Intermediate
ITS05 Scheduled 365 IT 2019 2016 Office live 		One To One Or Company Classroom Booking Only
Microsoft Excel | Pivot Table Reports
ITS07 Scheduled 365 IT 2019 2016 Office live 		One To One Or Company Classroom Booking Only
Microsoft Excel | Advanced
ITS06 Scheduled 365 IT 2019 2016 Office live 		One To One Or Company Classroom Booking Only


Copyright © 2020 | All Rights Reserved Pringle Computer Systems Limited