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...
Excellent. Very approachable and knowledgeable. Made the subject interesting.
Angela – Assistant Facilities Manager – Excel
“I had worked in Lettings Management for over six years and decided to have a complete career change. Pitman Training offered a legal secretarial course which I was able to complete in two and a half months full time and in less than two weeks of completion of the course, I found work.
I registered with a few recruitment agencies but also sent my CV to law firms directly. I am now working as a PA for the main partner of a law firm and training as a paralegal.
Thanks to Pitman and the team at the Edinburgh office, who have been very helpful, I am thankful and happy embarking on my new career.”
RA – Legal Secretarial Diploma
The small group allowed for personal interaction and focus on specific examples from the group.
Donald – Client service manager – Assertiveness
“The training and facilities were both excellent.Callum was both patient and understanding to my level of knowledge.The course has certainly benefited me and in turn, my work.”
Excel Level 2 Lesley Allan——Sales Coordinator—–George Wimpey
I have now come to the end of my courses in finance, and I should like to say how impressed I was with the quality of training I received through them all.
The knowledge I have gained has consolidated and enhanced my previous experience in a number of accounts jobs over the years, and given me new confidence in my skills and abilities to truly pursue bookkeeping as a specialist career. There are certainly many businesses out there that really need competent “accounting technicians”.
As soon as I had completed my Sageline 50 Accounts course, I got a second job using both this training and the previous course I completed, Excel Proficient. My training in Manual PAYE and Sage Payroll has enabled me to take over the wages responsibility in my other part-time bookkeeping job, and I have also set up a stock control system on the laptop using Excel spread sheets.There is also a possibility of taking on a further job working from home a couple of afternoons / evenings a week, doing the accounts for another local business using Sage on a laptop.
I am delighted with the “instant” results my training with yourselves have produced – the investment of time, money and effort was definitely worthwhile, now that I am reaping rewards well beyond my original expectations…. even at my time of life (over 50), retraining to specialist level in accounts has been an excellent decision.
THANK YOU!
DG – Accounting Technician 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
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...