We can deliver training onsite at your workplace or via virtual classrooms if preferred.
For individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow.
CITB Members can receive a special discounted rate on our training courses – Click to find out more
For individuals who are already using Excel to an advanced level.
What you will learn:
What you will learn:
| Macros | Additional Items |
| Editing & Deleting Macros | IfAnd/ IfOr Formula |
| Recording Macros | IfNa Formula |
| Custom Ribbon | Convert to Table |
| Screenshots | |
| Review Data | Removing Duplicates |
| Tracking Changes | Filter Timeline |
| Auditing Tools | IfError |
| Watch Window | HLookups |
| Restricting Data Area | Sparklines |
| Pivot Tables | |
| Utilities | Flash Fill |
| Goal Seek | |
| Data Consolidation | |
| Power View Reports | |
| Create Senarios | |
| What – If Analysis | |
| Drawing Diagrams | |
| Recommended Pivot Tables | |
This course will teach you how to use Excel to analyse, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow.
None
Duration: 1 Day We can deliver onsite at your workplace of via virtual classrooms if preferred. For individuals who are already using Excel to an advanced level. This course will...
Duration: 1 Day We can deliver onsite at your workplace of via virtual classrooms if preferred. For individuals who are already using Excel to an advanced level. This course will...
Duration: 1 Day We can deliver onsite at your workplace of via virtual classrooms if preferred. For individuals who are already using Excel to an advanced level. This course will...
Duration: 1 Day We can deliver onsite at your workplace of via virtual classrooms if preferred. For individuals who are already using Excel to an advanced level. This course will...
If it wasn’t for my training at Pitman Training I would not have been qualified for the job, but because of the Legal Secretarial course, I now have all the skills to be able to carry out my duties. I had been out of work for some time and the course also gave me a the confidence to go out there and find a job that I enjoy and have the hours that fit in with my daughter’s schooling.
N G – Legal Secretary
I was recently promoted to secretary to the Clinical Director at the Princess Royal Maternity in Glasgow. The job is varied, interesting and very well paid. I still have fond memories of my days at Pitman Training.
E L – Medical Secretary to the Clinical Director
Julie related ‘real life’ situations which I could relate to.
Paul – Problem Manager – Communication Skills
E W – PA
“I studied the Microsoft Fast Track Diploma. I had been working in a beauty salon for 5 years – I was a therapist and in January I gave up treatments and became the full time receptionist. I really wanted a Monday – Friday receptionist role in an office but because I didn’t have much IT experience I knew that I would find the job search difficult.
The Microsoft training gave me the skills that employers were looking for and I found that once I had the qualification on my CV I started getting selected for interviews. As well as learning new skills the course also helped to just refresh my memory on some things that I could already do.
I am now working in a new job which is the Monday – Friday role I wanted. My job title is Customer Service Assistant. This is a Front of House role which involves a lot of meeting and greeting and looking after all of the tenants in the building who we provide serviced offices for.
I enjoyed the training as it felt very relaxed and I liked that I could go at my own pace. I am so happy that I got this qualification for myself. I really believe that without my qualification I would be stuck in a job that I really wasn’t happy in for many more years!
Thank you Pitman training!”
JS – Fast Track Diploma
Very useful, customised experience, highly recommended.
Sam – Programme Officer – Project Management Principles
Duration: 1 Day We can deliver onsite at your workplace of via virtual classrooms if preferred. For individuals who are already using Excel to an advanced level. This course will...