For individuals who have never used the Excel spreadsheet package before or have only used Excel for limited tasks. At the end of the day you will be able to create professional looking spreadsheets.What you will learn:Excel Introduction Formulas Viewing Screen Layout – Ribbon Bar Introduction Enter, Move & Clear Data Order of Operations Selecting Excel Data Areas Add, Subtract, Multiply, Divide Saving Excel Auto Sum & Auto Average Creating New Workbooks Percentages Cut, Copy & Paste Absolute Cell ReferencingNaming, Deleting & Working with Sheets Data Manipulation Printing Widen Rows & Columns Print Preview Inserting Rows & Columns Page Layout...

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:Formula Utilities VLookups Protecting Data IF Statements Hide & Unhide Data SumIf Named Ranges CountIf(s) Working With Dates Text Formula - Concatenate Working With Comments Linking Spreadsheets Data Validation Separating Text Data Headers & Footers Data Analysis Linking Data Advanced Sort Options Linking Spreadsheets Filters Identifying Links Subtotals Linking Separate Workbooks Updating Pivots Icons & Data Bars in Conditional Formatting Filter & Sort Using Colour Pivot Tables...

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. What you will learn:Macros Additional Items Editing & Deleting Macros IfAnd/IfOr Formula Record Macros IfNa Formula Customising Ribbon Convert to Table Screenshots Removing Duplicates Review Data Filter Timeline Track Changes IfError Auditing Tools HLookups Watch Window Sparklines Review Changes Pivot Tables Restricting Data Area Flash Fill Utilities Goal Seek Data Consolidation Power View Reports Create Scenarios What – If Analysis Drawing Diagrams Recommended...

The objective of this qualification is to support a role in the workplace and give learners personal growth and engagement in learning. The qualification is designed for learners who wish to progress to higher or supervisory level within a food manufacturing business.Topics include ensuring compliance with food safety legislation, the application and monitoring of food hygiene practice, how to implement food safety management procedures and the application and monitoring of good practice regarding contamination, microbiology and temperature control.WHAT DOES THIS COURSE COVER?Understand the requirements for ensuring compliance with food safety legislationUnderstand the application and monitoring of good personal hygiene practice,...

Successful completion of this course constitutes 14 hours of periodic training towards the Driver CPC qualification. 35 hours of periodic training must be completed within a rolling 5 year period.The course will cover two of the following:Drivers Hours and TachographRealities of TransportFire Fighting and Emergency First AidSafety in Transport and Manual HandlingThe Law and YouTutor support is available throughout the duration of the courseWho should attend this course?Operators and drivers working in the Logistics industry.Learning OutcomesGTG Certificate issued and this course accounts for 14 hours towards their 35 hours DCPC which is recorded with JAUPT.

Successful completion of this course constitutes 28 hours of periodic training towards the Driver CPC qualification. 35 hours of periodic training must be completed within a rolling 5 year period.The course will cover two of the following:Drivers Hours and TachographRealities of TransportFire Fighting and Emergency First AidSafety in Transport and Manual HandlingThe Law and YouTutor support is available throughout the duration of the courseWho should attend this course?Operators and drivers working in the Logistics industry.Learning OutcomesGTG Certificate issued and this course accounts for 28 hours towards their 35 hours DCPC which is recorded with JAUPT.

Successful completion of this course constitutes 21 hours of periodic training towards the Driver CPC qualification. 35 hours of periodic training must be completed within a rolling 5 year period.The course will cover three of the following:Drivers Hours and TachographRealities of TransportFire Fighting and Emergency First AidSafety in Transport and Manual HandlingThe Law and YouTutor support is available throughout the duration of the courseWho should attend this course?Operators and drivers working in the Logistics industry.Learning OutcomesGTG Certificate issued and this course accounts for 21 hours towards their 35 hours DCPC which is recorded with JAUPT.

Successful completion of this course constitutes 7 hours of periodic training towards the Driver CPC qualification. 35 hours of periodic training must be completed within a rolling 5 year period.The course will cover one of the following:Drivers Hours and TachographFire Fighting and Emergency First AidSafety in Transport and Manual HandlingThe Law and YouRealities of TransportTutor support is available throughout the duration of the courseWho should attend this course?Operators and drivers working in the Logistics industry.Learning OutcomesGTG Certificate issued and this course accounts for 7 hours towards their 35 hours DCPC which is recorded with JAUPT.

A hands-on instructor-led Microsoft Excel training course allowing students with an existing knowledge of Excel fundamentals to improve their skills and create better spreadsheets. A useful capability with analysing and presenting data with Excel is achieved through learning, discussion and practice with an expert trainer in a professional classroom environment. Course Content includes, consolidate data in different workbooks, Advanced List Management, Subtotals, Data Validation, Database Functions Analysing Data, Goal Seek, Solver, Scenarios, Trendlines Pivot Tables, Creating a PivotTable, Rearranging PivotTables, Formatting PivotTables, PivotCharts, Create Slicers Collaborating with Other Users, Protect a Worksheet, Protect Workbooks, Set a Workbook...

A hands-on instructor-led Microsoft Excel training course helping students who would like to learn how to create spreadsheets and gain a fundamental ability with Excel via learning and guided practice from an open and friendly trainer within a professional classroom environment. After training students may expect to produce straight forward spreadsheets to handle data, use simple formulas to calculate values, format any spreadsheet for clarity and emphasis and set up the spreadsheet for sharing, printing and perhaps creating charts to easily demonstrate values.The primary objective of all Excel training courses is to increase each students overall ability and confidence in...