We can deliver training onsite at your workplace or via virtual classrooms if preferred.
For individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package.
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 intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package.
What you will learn:
| Managing Multiple Spreadsheets | Using Charts |
| ·     Using Multiple Worksheets | ·     Chart Objects |
| ·     Creating Multiple Views | ·     Creating a Chart |
| ·     Managing Multiple Worksheets and Workbooks | ·     Change the Location of a Chart
·     Changing Chart Type, Style and Sub Type |
| ·     Linking Data Between Worksheets | ·     Changes to Chart Source Data |
| ·     Viewing Multiple Applications | ·     Chart Quick Menus
·     Creating a Chart Template |
| Protection | Data Validation |
| ·     Workbook protection | ·     Adding Data Validation |
| ·     Worksheet protection | ·     Data Validation Messages |
| ·     Restrict Data Entry
·     Data Validation Calculations |
|
| Â Conditional Formatting | |
| ·     Adding Conditional Formatting
·     Remove Conditional Formatting ·     Colour Scales ·     Highlight Blank Scales ·     Icon Sets ·     Data Bars ·     Conditional Formatting Formulas |
Filter and Sort
·     Sorting a List ·     Filtering a List ·     AutoFilters ·     Customer Auto Filters ·     Using Subtotals in a List
|
| Creating and Using Functions
·     Using Built in Functions ·     Using Nested Functions ·     AUTOSUM ·     COUNT Functions ·     IF Functions ·     Using Date and Time Functions ·     Combine and Separating Text ·     Tracing and Correcting Worksheet Errors |
LookUps
·     VLookUp ·     HLookUp ·     XLookUp  Pivot Tables ·     Creating a Pivot Table ·     Conditional Formatting within Pivot Tables ·     Pivot Table Slicers ·     Creating a Pivot Chart |
This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package.
None
Duration: 1 Day We can deliver training onsite at your workplace or via virtual classrooms if preferred. For individuals who are already using Excel to an intermediate level. This course...
Duration: 1 Day We can deliver training onsite at your workplace or via virtual classrooms if preferred. For individuals who are already using Excel to an intermediate level. This course...
Duration: 1 Day We can deliver training onsite at your workplace or via virtual classrooms if preferred. For individuals who are already using Excel to an intermediate level. This course...
Duration: 1 Day We can deliver training onsite at your workplace or via virtual classrooms if preferred. For individuals who are already using Excel to an intermediate level. This course...
Duration: 1 Day We can deliver training onsite at your workplace or via virtual classrooms if preferred. For individuals who are already using Excel to an intermediate level. This course...
Duration: 1 Day We can deliver training onsite at your workplace or via virtual classrooms if preferred. For individuals who are already using Excel to an intermediate level. This course...
Duration: 1 Day We can deliver training onsite at your workplace or via virtual classrooms if preferred. For individuals who are already using Excel to an intermediate level. This course...
Duration: 1 Day We can deliver training onsite at your workplace or via virtual classrooms if preferred. For individuals who are already using Excel to an intermediate level. This course...
“I started doing a Secretarial Diploma at Pitman because I had been working in retail since graduating from university in 2008. I had pretty good admin skills but no qualifications and felt like I was stuck in a rut. Pitman was a perfect fit for me because I was working shifts at my job at Glasgow Science Centre and could come in whenever I was free.
At first I thought I was just going to be getting a qualification for skills I already had but I actually learned a lot more than I expected. Modules like Effective Business Communication were helpful and I did electives in Access and Introduction to Medical Secretary which was extremely helpful in getting my new job.
In May 2013, before I had even completed my diploma, I started my job as an Audio Typist for the NHS. I had been searching the NHS pages before I started my diploma and it took the help of Pitman to actually help me find a job. My typing and audio typing skills along with the medical terminology learned in Pitman have been essential in my progress within my job with my manager telling me she feels I have a career in the NHS ahead of me.
I just discovered today that I received a distinction for my diploma and am now thinking of where to move up within my new sector. Without Pitman, I don’t think I would have been able to get out of retail so I’m very happy to have chosen to take this course!”
EJ – Secretarial Diploma
I finished a Pitman Secretarial Diploma in 2008 and after one month working as a temp. I was lucky enough to be offered a permanent job as Clerical/Admin Assistant which is where I am still working now.
Learning to touch type at Pitman definitely helped to secure the job, and also having a certificate from all the units of the secretarial diploma which showed that I could use Microsoft Office programs competently.
I took the option to study from home as living in Perth , it meant I could fit in work around the kids school hours. Though I did enjoy going into Edinburgh occasionally to do Outlook, and Audio. The course was really straightforward, and the tests were an enjoyable challenge.
I love being able to touch type, and it will be useful for the rest of my life, in whatever job I do. I have even got my children started on the BBC’s cool typing lessons for kids, where singing animals encourage you, and I hope that they will be able to type by the time they are teenagers.
All the trainers at Pitman were really helpful, and always ready to explain things, when I phoned or emailed with questions.
GA – Secretarial Diploma
What I liked about training at Pitman Training, was the flexible nature of the courses which enabled me to progress at my own pace and fit my studies around other commitments.
K C – Administrator
Very good training and very good facilities. The trainer was very competent, friendly, engaging and welcoming, very patient and good manner.
Andrea – Trainee Administrator – Excel
Enjoyed the Supervisory Skills course, picked up useful tips and methods on how to handle difficult situations.
Deborah – Finance Team Leader – Supervisory Skills
Overall excellent trainer with good psychological inferences too.
Blair – Managing Director – Presentation Skills
Duration: 1 Day We can deliver training onsite at your workplace or via virtual classrooms if preferred. For individuals who are already using Excel to an intermediate level. This course...
Duration: 1 Day We can deliver training onsite at your workplace or via virtual classrooms if preferred. For individuals who are already using Excel to an intermediate level. This course...