Microsoft Excel


Microsoft Excel
After completing our full day Excel courses, take your knowledge to the next level; we offer 2 half day (3 hour) long courses. These courses will take you from our previous levels, onto mastering Pivot Tables & Advanced Formulas.

Both our Pivot Tables and Advanced Formulas courses have been specifically designed so that you can attend both courses, or just one, or sit both on the same day creating a full day length course, or you can sit them on consecutive/ non consecutive days, as we know sometimes it can be difficult to be out of the office for a full working day.

Excel Half Day Course: Expert Pivot Tables


Course Code: ITS07A | Duration: Half Day (3 Hours) | Level: Expert

Pivot tables are one of the most powerful features in Excel; this powerful feature cuts the time you spend on formulas in half by easily calculating, summarizing, and analysing data. This 3-hour session is the next step after our Stage 2 Intermediate or Stage 3 Advanced full day Excel courses.

In this course you will learn how to import data into Excel to be able to create a Pivot Table or Pivot Chart. Also, the course helps and shows you techniques of how to prepare the data by using combined text and date formulas, allowing the data to be grouped and summarized in a Pivot Table or Pivot Chart.


    Course Requirements

  • Knowledge in basic computer skills i.e. how to use a mouse and keyboard.
  • Idealy attendees will have sat on our Introduction, Intermediate and Advanced levels before attending either of the half day courses, however this is not a requirement.
  • An in depth knowledge of how to use Excel

  • Course Content

  • Drag & Drop Fields
  • Refreshing Data
  • Formatting Error Values and Empty Cells
  • Show Pages: Automatically splitting up data to individual sheets
  • Grouping fields by month and year
  • Calculating data as a percentage of the total
  • Using Slicers
  • Applying Conditional Formatting to PivotTable data
  • Creating calculated fields
  • Using Combined Text and Date formulas to group Data
  • Dashboard; Formatting Multiple Pivot tables on One Sheet
  • Show Values As: Percentage, Min, Max, Average & Count
  • Tips & Tricks Mastering Pivot Tables
  • Problem Solving Workshops
  • Question and Answers

Excel Half Day Course: Expert Advanced Formulas


Course Code: ITS07B | Duration: Half Day (3 Hours) | Level: Expert

There are so many useful and unused formals in excel that can solve many of your spreadsheet problems.

This 3-hour session is the next step after our Stage 3 advanced full day Excel course. This course will teach and show you how to use and create combined formulas allowing you to master this amazing program. Creating Validating lists is a brilliant and very easy solution to use within Excel, the problem can be how to show a list a different set, i.e. if you choose from list1 “Make”, the second list “Model” should only show models relating to the list 1 selection. Make; Porsche - Model: 911, 718, Taycan.

Combined H & V Lookup is a great formula that is covered in the full day Advanced course, however in this course we show other formulas i.e. Index Transpose, Match, Xlookup that might work better especially if the first column or row does not hold the unique reference you’re trying to match. When you need question or group data, mastering the range of IF Statements is one of the great benefits of this course. Using Advanced Form Rippon and creating Dropdown Lists, Spinners and with assigned tick boxes can take your spreadsheet to the database level, all whilst staying within Excel.

    Course Requirements

  • Knowledge in basic computer skills i.e. how to use a mouse and keyboard.
  • Idealy attendees will have sat on our Introduction, Intermediate and Advanced levels before attending either of the half day courses, however this is not a requirement.
  • An in depth knowledge of how to use Excel

  • Course Content

  • Mastering Combined Formulas
  • Lookup & Reference: INDEX | INDIRECT | MATCH | TRANSPOSE | LOOKUP | VLOOKUP | HLOOKUP | XLOOKUP | XMATCH
  • Date Formulas: DATE, TODAY| WEEKNUM | DAY |MONTH| YEAR | WORKDAY
  • Time: HOUR | MINUTE | SECOND ||TIME VALUE
  • Mastering Forms: SPINNERS | TWISTER | DROPDOWN
  • Logical Formulas: IF | NESTED IF STATEMENTS| IF ERROR | IFNA | IFS SWITCH
  • Text Formulas: LEN | LEFT | RIGHT | FIND | EXACT | SEARCH | SUBSTITUTE |VALUE
  • VBA: Introduction to VBA Formulas and creating Loops
  • Problem Solving Workshops
  • Question and Answers

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

BESPOKE IT TRAINING DAY AT OUR OFFICES OR CLIENT’S SITE


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)

All training courses can be tailored using own company data or reslove specific probelms which staff may have to face. With all besopke training topics can be taken and combined from differnt stages or combine more than one course together

BESPOKE IT SURGERY DAY – ON-SITE AT CLIENT’S PREMISES:

As you know, losing a whole day to training can prove to be an expensive investment. An individual may not need a full day's training if there are only a few elements of a program they really need to know or simply that they need refreshing on basic skills and are too embarrassed to say - we have a solution to the problem – Our IT Surgery!

We have IT Masters who can teach and consult to the highest level and provide solutions for any IT working problem. With these skills and experience to draw on, we have created a unique service whereby your employees can receive specific, individual training without the loss of a full working day.

We can turn one of your rooms into an ‘IT surgery' where employees can turn-up for scheduled appointments or we can move round Desk to Desk to help teach and solve problems with in your organisation

BOOKING & EVALUATING APPOINTMENTS

Our experienced IT Training team will circulate amongst your employees and identify from each member of staff what their particular IT problems and needs are. Our team will quickly evaluate the time needed for the IT Master to show and teach the appropriate tasks on the surgery day

IT BESPOKE SURGERY DAY

Our IT Master will be based on-site in any available room awaiting IT problems or training requirements. On-site Training hours can be structured to fit your business operation, Our training surgery day is a 6 hour day but the start time can be flexible to suite your company working hours i.e. Surgery Day can start at 7.30am or stay open to 7.30pm if required. This unique service is the most efficient way for your company to train and increase productivity whilst keeping your training costs and lost time to an absolute minimum.

Online Live Training


All Of PCS Training Course can now be taught remotely from your office or even from home. Pringle PCS will give you Log in details which will allow you or your team to join the Live Training Session.

Training Requirments

With all live online training PCS will give a free 30 minutes setup and test to show how the remote learning will work. We test Internet speed, connection and show how easliy it is to join the live trainig.
Every delegate would need to have a working Camera and Micpohone to be able to interacte with the class. With Live Online Training Pringle PCS stronlgy recommed having Duel Screens or access to Tablet.

Company Classroom and 1-1

Live Online Training can be taught 1-1 or upto a classroom of 8 and all courses can be tailored to own company requirments

Duration

A Live Online Training schedule session is in total upto 6 hours of Training with added Breaks.

Prices


IT Scheduled Courses



Scheduled courses are held at PCS Training & Conference Centre and open to any learners from any organisation or company.

IT Course Price Grade
Standard
Single Booking
Online Only
£75
Per Person
Multiple Booking
Online Only
£90
Per Person
One To One
£395

IT 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
Individual Days: Online (Max 8 Delegates: Additional £50 Per Person)
£445
Individual Days: PCS Or Client Site (Max 8 Delegates: Additional £50 Per Person)
£595
IT Client Site Contracted Rates
Standard & Premium
Bespoke IT Surgery Day On-site at Client’s Premises
£695
Computer Hire and Setup
£10
Per PC
Database Development
Standard & Premium
Bespoke Development Day On-site at Client’s Premises
£695

Excel Online Quizzes

<

Copyright © 2020 | All Rights Reserved Pringle Computer Systems Limited