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...
I am currently working in the city in London as a PA. It is lots of fun, however very hard work!
L P – Personal Assistant
I came to Pitmans after leaving my job as a Customer Service Team Leader as I wanted to better myself & change careers. I studied the Executive PA Diploma, the course was very informative & could be done at my own pace. After completing the course I temped for 3 months & then I managed to get a job as an administrator through Office Angels. I am now working for an Interior Design company as PA to the Managing Director.
I would recommend Pitman to anyone who wants to improve themselves, I also made some new friends who I am still in contact with, as my circle of friends was very limited as I knew no-one when I moved to Edinburgh 3 years ago…
Many thanks again, I will be back!
LB – Executive PA Diploma
The trainer was capable of explaining things so they were easily understood and answered all questions I had during the Intermediate Course.
Amy – Admin Assistant – Access
Marion was very clear about the topic covered in the course. I found I actually enjoyed it more than I was expecting.
Jamie – Customer Service/Security – Receptionist Seminar
” I would like to thank you for giving me this unique opportunity to change my life and get a good job as a bookkeeper.
To be honest, as a foreigner I was scared at hat the course would be too hard to study and understand but I decided to take this challenging opportunity and improve my skills.
The training materials were amazing. They were very well presented and easy to learn. However the greatest advantage was the Training Supervisors. At any point when you are stuck with the subject or do not understand the questions then all you have to do is ask and all the help you need is there for you.
After I completed just three of the modules I decided to look of a job as a part time bookkeeper and I was in seventh heaven when I was offered a job before I had even finished my course.
The knowledge I have received from Pitman has helped me to develop my skills and improve my financial situation.
I strongly believe that anyone with a bit of discipline, patience and effort can change their lives for the best with the help of Pitman Training.”
AKS – Accounting Technician Diploma
“When I came to see Fran she recommended Microsoft Excel, HTML, Dreamweaver 8 and Book-Keeping Level 2 Module 1 courses as the most suitable for preparing me to set up my own online business. Â
The staff were all very helpful and polite and the environment was professional but friendly.  I have since set up a website with a friend as an information site for parents and carers of children with autism. Â
The courses at Pitman increased my confidence with technology and made me believe that after 15 years as a music teacher, and 2 years as a full time carer for my children who have support needs, I can now change direction and transform my life.”
JM – Various Courses
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...