50 Courses

Course Objectives This course aims to provide delegates with a foundation for Excel knowledge and skills. ' Customer Feedback Great course and excellent trainer. Thanks Tracy Preston - Western Power Distribution Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all. Laura Smith - James Grant Very professional and well mannered, fun and pleasant at the same time. I learnt a lot Carolina Foster - CNN 1 year email support service Take a look at the consistent excellent feedback from trainees visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Tailored in company training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. What is Excel? The Excel Interface Ribbon, Tabs and Groups Microsoft Office Backstage view Working with Workbooks Create a blank Workbook Create a Workbook using a Template Opening and saving Files Working with worksheets Worksheet navigation Select one or multiple Worksheets Insert, Move, Copy or Delete a Worksheet Working with Cells, Rows & Columns Cell References How to select cells or ranges Different types of data Move, Copy and Delete cells Pasting Options Find and Replace Working with Rows and Columns Overview of formulas in Excel Autocalculation The parts of an Excel formula Using calculation operators in Excel formulas The difference between Absolute, Relative and Mixed references Using Excel functions; Sum, Average, Max and Min Cell Formatting Font Format options Number Format options Change the Fill and Borders Cell Alignment An Introduction to Charts Create a simple Chart Format your chart Page Layout and Print Page Layout and Page Break View Change the Page Orientation Set Page Margins Headers and Footers in a worksheet Print a worksheet or workbook Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements General knowledge of the Windows OS Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Construction Project Manager 2 Days Training in Preston

Communication Strategies 1 Day Workshop in Preston

Managing Performance 1 Day Workshop in Preston

Recruitment Skills 1 Day Workshop in Preston

Effective Change Management 1 Day Workshop in Preston

Negotiation Skills - Professional 1 Day Workshop in Preston

Leading Effective Teams 1 Day Workshop in Preston

Train-The-Trainer 1 Day Training in Preston

IPAF training is the most widely recognised standard for Mobile Elevated Work Platform operators. These are commonly known as MEWP’s or Scissor Lifts and Cherry Pickers. MHA Training is a fully approved and registered IPAF member and we can deliver a wide range of courses. This can be done at our training centre in Warrington or On-Site at customer premises Nationwide. The International Powered Access Federation (IPAF) promotes the safe and effective use of powered access worldwide. Set up in 1983, IPAF is a non-profit organisation that represents the interests of member training companies. Over the years, IPAF has played a key role in promoting many of the design safety and testing procedures that are now established in the powered access industry. Companies such as MHA Training in Warrington are responsible for training for over 90,000 operators each year. Those who successfully complete their training at our centre in Warrington, or out On-Site nationwide are awarded the PAL Smart card. The (Powered Access Licence) is the most widely held and recognised qualification for mobile platform operators. The PAL Smart card is valid for five years and shows the machine categories that an operator has been trained on. It also features the holders photo and signature, and can be verified on their website. IPAF itself does not provide any training, it is provided by approved quality training centres like MHA Training. Approved training centres are regularly audited by IPAF, which ensures the highest standards are consistently met. Class sizes are kept small and courses generally last 1-2 days and are a mixture of theory and practical. To ensure success candidates must then undergo a 30 question multiple choice paper and a practical test. Course material is available in many languages and training centre’s receive regular updates. MHA Training was established in 2008 based at our training centre in Warrington, Cheshire. We provide an array of services On-Site also for clients around the North West in areas such as Manchester, Liverpool, Widnes, St. Helens, Runcorn, Wigan, Preston and Leeds. Over the years we have expanded and have instructors available Nationwide. IPAF E-Learning. IPAF’s new E-learning module is part of its full training programme for mobile elevating work platforms (MEWPs). The E-learning module delivers flexibility and interactive tools, with the same emphasis on practical training. Together with supervised written and practical testing of operator skills. E-learning can lead to a PAL Card (Powered Access Licence) which proves that the operator has successfully completed the training and is able to operate MEWP’s safely. Benefits: Flexible. Trainees complete the theory part anytime, anywhere, on any device, at their own pace. Interactive. Engages trainees with games, quizzes, videos and simulations. Operator E-learning does not replace practical training. Trainees who complete the online session must still pass a supervised theory test with an IPAF centre like MHA training. Also must successfully complete a minimum half-day of practical training and testing before being issued a PAL Card as proof of successfully completed operator training. Training Courses Available: Operators. Demonstrators. Static Boom (1b). Mobile Vertical (3a). Mobile Boom (3b). Push Around Vertical (PAV). Other courses: Harness Use and Inspection (H).