• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

6290 Courses

Safeguarding Children: Internet Safety Course

5.0(10)

By Apex Learning

Overview This comprehensive course on Safeguarding Children: Internet Safety Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Safeguarding Children: Internet Safety Course comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Safeguarding Children: Internet Safety Course. It is available to all students, of all academic backgrounds. Requirements Our Safeguarding Children: Internet Safety Course is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 10 sections • 10 lectures • 04:25:00 total length •The Concept of Internet Safety for the Children: 00:46:00 •The Concept of Privacy and Appropriate Online Content: 00:33:00 •Cyberbullying: 00:39:00 •Internet Grooming: 00:41:00 •Appropriate Measures for Safeguarding Your Child: 00:34:00 •Safe Use of Social Media: 00:16:00 •Mobile Device Safety: 00:19:00 •Tools and Tips for Monitoring Child's Internet Use: 00:18:00 •Identifying, Preventing and Overcoming Internet Addiction: 00:19:00 •Assignment - Safeguarding Children: Internet Safety Course: 00:00:00

Safeguarding Children: Internet Safety Course
Delivered Online On Demand4 hours 25 minutes
£12

Control and Administration of Medicines Online Training Course

5.0(10)

By Apex Learning

Overview This comprehensive course on Control and Administration of Medicines Online Training Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Control and Administration of Medicines Online Training Course comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Control and Administration of Medicines Online Training Course. It is available to all students, of all academic backgrounds. Requirements Our Control and Administration of Medicines Online Training Course is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc.   Course Curriculum 10 sections • 10 lectures • 04:33:00 total length •Medicine Management Fundamentals: 00:37:00 •Importance of Medicine Management: 00:24:00 •Prescribing Medication Effectively: 00:27:00 •Common Problems - Pharmacological Management: 01:05:00 •Common Medicines to Use: 00:18:00 •Palliative Care: 00:24:00 •The Four Principles of Medicine Optimisation: 00:24:00 •Managing Medication in Residential Aged Care Facilities (RACFs): 00:35:00 •Law and Legislation: 00:19:00 •Assignment - Control and Administration of Medicines Online Training Course: 00:00:00

Control and Administration of Medicines Online Training Course
Delivered Online On Demand4 hours 33 minutes
£12

Substance Misuse Awareness Online Certification Course

5.0(10)

By Apex Learning

Overview This comprehensive course on Substance Misuse Awareness Online Certification Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Substance Misuse Awareness Online Certification Course comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Substance Misuse Awareness Online Certification Course. It is available to all students, of all academic backgrounds. Requirements Our Substance Misuse Awareness Online Certification Course is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 9 sections • 9 lectures • 03:09:00 total length •Introduction to Substance Misuse: 00:22:00 •Overview of Substance: 00:39:00 •Prevention and Awareness: 00:22:00 •Substance Misuse at Workplace: 00:20:00 •Substance Misuse Policy at Workplace: 00:20:00 •Treatment of Substance Addiction: 00:23:00 •Laws and Acts on Substances: 00:29:00 •Substance Misuse and Youth: 00:14:00 •Assignment - Substance Misuse Awareness Online Certification Course: 00:00:00

Substance Misuse Awareness Online Certification Course
Delivered Online On Demand3 hours 9 minutes
£12

Property Management

5.0(10)

By Apex Learning

Overview This comprehensive course on Property Management will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Property Management comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Property Management. It is available to all students, of all academic backgrounds. Requirements Our Property Management is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 11 sections • 10 lectures • 02:26:00 total length •Module 1 - Introduction to Property Management: 00:12:00 •Module 2 - The Role and Responsibilities of a Property Manager: 00:11:00 •Module 3 - Listing Properties and Marketing: 00:25:00 •Module 4 - The Letting Process and Tenancy Agreement: 00:32:00 •Module 5 - The Property Management Process: 00:32:00 •Module 6 - Keeping Tenants Long Term: 00:10:00 •Module 7 - Regulations of Property Management: 00:11:00 •Module 8 - Changes in the UK Property Market: An Opportunity: 00:13:00 •Recommended Readings - Property Management: 00:00:00 •Assignment - Property Management: 3 days

Property Management
Delivered Online On Demand2 hours 26 minutes
£12

Online Course - A Perfect Guide to Home Business

5.0(10)

By Apex Learning

Overview This comprehensive course on Online Course - A Perfect Guide to Home Business will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Online Course - A Perfect Guide to Home Business comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Online Course - A Perfect Guide to Home Business. It is available to all students, of all academic backgrounds. Requirements Our Online Course - A Perfect Guide to Home Business is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 10 sections • 10 lectures • 04:53:00 total length •Introduction to Business: 00:36:00 •Understanding Entrepreneurship: 00:22:00 •What Is a Home-Based Business?: 00:33:00 •Introduction to Online Business: 00:36:00 •Introduction to Digital Marketing: 00:37:00 •E-Commerce Business Model: Dropshipping: 00:18:00 •E-Commerce Business Model: Affiliate Marketing: 00:30:00 •Opportunities for Home-Based Income: 00:26:00 •At-Home Professional Service Provider Business: 00:27:00 •Introduction to Freelancing: 00:28:00

Online Course - A Perfect Guide to Home Business
Delivered Online On Demand4 hours 53 minutes
£12

Ultimate Guide to Paint Mountains in Watercolours

5.0(10)

By Apex Learning

Overview This comprehensive course on Ultimate Guide to Paint Mountains in Watercolours will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Ultimate Guide to Paint Mountains in Watercolours comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Ultimate Guide to Paint Mountains in Watercolours. It is available to all students, of all academic backgrounds. Requirements Our Ultimate Guide to Paint Mountains in Watercolours is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 15 lectures • 02:39:00 total length •Introduction: 00:01:00 •Materials Required: 00:03:00 •Mountains and Lake: 00:11:00 •Snowy Mountains: 00:09:00 •Sunlight on Mountains: 00:11:00 •Mountains and Rivers: 00:12:00 •Layered Mountains and Trees: 00:13:00 •Mountains and Snow: 00:10:00 •Church on Hill: 00:16:00 •House on Hill: 00:10:00 •Houses on Hill: 00:15:00 •Trees and Lake: 00:14:00 •Mountain and Lake: 00:18:00 •Snowy Mountains and Lake: 00:15:00 •Class Project: 00:01:00

Ultimate Guide to Paint Mountains in Watercolours
Delivered Online On Demand2 hours 39 minutes
£12

Level 5 Diploma in Business Studies - QLS Endorsed

4.7(26)

By Academy for Health and Fitness

24-Hour Flash Sale! Prices Reduced Like Never Before!! In today's highly competitive business landscape, the UK is home to over 5.9 million private sector businesses, each striving for success. Are you equipped with the necessary skills and knowledge to navigate the intricacies of this dynamic environment? Do you possess the acumen to drive growth and stay ahead of the curve? This comprehensive Business Studies bundle covers the key areas of business, from strategic planning and marketing to financial management and legal considerations. You'll gain a strong foundation in Strategic Planning, Business Analytics, and Management principles. Craft compelling business proposals and gain a solid understanding of Business Law and Tax Accounting. Develop your Sales and Marketing Strategies, master Financial Management, and learn the fundamentals of Accounting. Finally, put your knowledge into action by crafting a comprehensive Business Plan for your entrepreneurial dreams. With a single payment, you will gain access to the Business Studies Bundle, including 10 premium courses, a QLS Endorsed Hardcopy certificate (for the title course) and 11 PDF certificates for Absolutely free. This business studies Bundle Package includes: Main Course: Diploma in Business Studies at QLS Level 5 10 Premium Additional CPD QS Accredited Courses - Course 01: Strategic Planning Process Course 02: Business Analytics Course 03: Business Management Course 04: Business Proposal Writing Course 05: Business Law Course 06: Advanced Tax Accounting Course 07: Diploma in Sales and Marketing Strategies Course 08: Financial Management Course 09: Introduction to Accounting Course 10: Business Plan for Entrepreneurs This Business Studies Bundle is your one-stop shop for launching a fulfilling career in business. Whether you aspire to be an entrepreneur, manager, marketer, or financial expert, this programme provides the skills and knowledge you need to achieve your goals. Don't let this opportunity pass you by - enrol in our Business Studies course and start your journey to success! Learning Outcomes of Business Studies Apply strategic planning frameworks to real-world business scenarios. Analyse data and translate insights into actionable business strategies. Develop and implement effective management practices to optimise business operations. Craft compelling business proposals that win over investors and clients. Gain a comprehensive understanding of business law to navigate legal complexities. Master the fundamentals of accounting and financial management for sound decision-making. Why Prefer this Course? Get a Free QLS Endorsed Certificate upon completion of the course Get a Free Student ID Card with this training program (£10 postal charge will be applicable for international delivery) The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Start your learning journey straight away! Course Curriculum Course 01: Diploma in Business Studies at QLS Level 5 Module 01: Introduction To Business Management Module 02: Operations Management Module 03: Introduction To Business Analysis Module 04: Project Management Module 05: Business Process Management Module 06: Planning & Forecasting Operations Module 07: Performance Management Module 08: Management Of Cash And Credit Module 09: Managing Risk And Recovery Module 10: Business Environment Module 11: Human Resource Management Module 12: Customer Service Course 02: Strategic Planning Process Module 01: Preparing For The Strategic Planning Process Module 02: Establish a Committee Module 03: Gather Operational Data Module 04: Initiating The Strategic Planning Process Module 05: Develop a Mission Statement Module 06: Develop a Vision Statement Module 07: Assess Internal and External Environments Module 08: Performing SWOT Analysis Module 09: Developing The Strategic Plan Module 10: Prioritise What the Strategic Plan Will Address Module 11: Set Goals and Objectives Module 12: Develop Strategy for Achieving Goals Module 13: Draft the Strategic Plan Module 14: Executing The Plan Module 15: Assign Responsibility and Authority Module 16: Establish a Monitoring System Course 03: Business Analytics Module 01: Introduction to Business Analysis Module 02: Business Environment Module 03: Business Processes Module 04: Business Analysis Planning and Monitoring Module 05: Strategic Analysis and Product Scope Module 06: Solution Evaluation Module 07: Investigation Techniques Module 08: Ratio Analysis Module 09: Stakeholder Analysis and Management Module 10: Process Improvement with Gap Analysis =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) CPD Hard Copy Certificate: Free (For The First Course: Previously it was £29.99) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £119) CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Entrepreneurs Business Managers Marketing Professionals Finance Professionals Career Changers Anyone in Business Requirements You will not need any prior background or expertise to enrol in this Business Studies bundle. Career path After completing this Business Studies bundle, you are to start your career or begin the next phase of your career. Business Administrator: £30,000 - £60,000 Project Manager: £35,000 - £70,000 Business Consultant: £40,000 - £100,000 Operations Manager: £30,000 - £70,000 Senior Executive: £50,000 - £120,000 Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. Diploma in Business Studies at QLS Level 5 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Level 5 Diploma in Business Studies - QLS Endorsed
Delivered Online On Demand3 days
£119

Microsoft Excel Introduction - In-company

By Microsoft Office Training

Course Objectives This course aims to provide delegates with a foundation for Excel knowledge and skills. ' Customer Feedback Very professional and well mannered, fun and pleasant at the same time. I learnt a lot Carolina Foster - CNN 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 Great course and excellent trainer. Thanks Tracy Preston - Western Power Distribution 1 year email support service Take a look at the consistent excellent feedback from our corporate clients 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. Our competitive rates start from £550.00 per day of training Tailored 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. 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? All users who want to master the main features of Microsoft Excel Requirements Requirements General knowledge of the Windows OS Certificates Certificates Certificate of completion Digital certificate - Included

Microsoft Excel Introduction - In-company
Delivered in London or UK Wide or OnlineFlexible Dates
£650

Microsoft Excel Advanced - In-company

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients 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. Our competitive rates start from £550.00 per day of training Tailored 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. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. 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

Microsoft Excel Advanced - In-company
Delivered in London or UK Wide or OnlineFlexible Dates
£650

Microsoft Excel Advanced (now with live online classes) One-to-One Training

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback 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 classrom, one to one, tailored and bespoke courses. Tailored In Company training: 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. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. 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

Microsoft Excel Advanced (now with live online classes) One-to-One Training
Delivered In-Person in LondonFlexible Dates
£650