The Microsoft Excel Advanced training course is available at the Edinburgh, Glasgow, Aberdeen and Inverness Pitman Training Centres.
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 data. These tools are extremely useful for auditing and streamlining your workflow.
Course Duration: 1 Day
The Adobe Acrobat training course is available at the Edinburgh, Glasgow, Aberdeen and Inverness Pitman Training Centres.
In this course you will learn how to create, convert and share documents through the universal Acrobat PDF format to produce interactive, media rich and secure publications for Print or Web.
This course is designed for people who are collating documents with multiple contributors or publishing to a variety of mediums.
Course Duration: 1 Day
Streamlining Workflow: Create & edit macros, Visual Basic for Applications, Visual Basic Editor Window, customising Access to Excel commands, applying conditional formatting, adding data validation criteria, update workbook’s properties, modifying excel’s default settings
Collaborating with Others: Protecting files, sharing workbooks, setting revision tracking, review tracked revisions, merge workbooks, adjust macro settings, digital signatures, digital certificates
Auditing Worksheets: Trace cell Precedents, trace cell dependants, locate errors in formulas, invalid data, error checking, watch and evaluate formulas, group and outline data
Analysing Data: Trend lines, scenarios, goal seek, solver, PivotTable reports, PivotChart reports, Analysis ToolPak
Working with Multiple Workbooks: Workspaces, data consolidation, link cells in different workbook, edit links
Importing and Exporting Data: Export to Microsoft Word, import Word table, import text files
Structuring XML Workbooks: Develop XML maps, import/add/export XML data, manage XML workbooks, apply XML view options
On successful completion of this workshop you will be able to support other users and analyse your data in greater detail.
Flexible Workforce Development Fund (FWDF)
Claim up to £15,000 for Training your employees
This fund provides Levy Paying Companies an opportunity to up-skill or re-skill Employees and in turn, support economic growth.
Eligibility Criteria:
For more information on applying for this funding, contact our Course Advisors by clicking below:
———–
A funded training opportunity is now available to those facing redundancy or those who have been made redundant from March 2020 onward.
The National Transition Training Fund aims to tackle the rise in unemployment caused by Covid-19 by offering short sharp training opportunities for people to learn in-demand skills.
If you are currently under threat of redundancy, or have been made redundant at any time from the 1st March 2020 and are aged 25 or over, you can access an industry recognised qualification to help you gain employment.
For further information on how to proceed then contact us referencing the course(s) you are interested in.
