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

1644 Courses

Switchgears and Transformers: Selection, Maintenance & Testing

By EnergyEdge - Training for a Sustainable Energy Future

Gain expertise in switchgears and transformers through EnergyEdge's classroom training. Enroll now for a comprehensive learning experience.

Switchgears and Transformers: Selection, Maintenance & Testing
Delivered In-PersonFlexible Dates
£2,899 to £2,999

Construction Management, Architectural Studies & Cost Estimation -QLS Endorsed Diploma

4.7(26)

By Academy for Health and Fitness

***24 Hour Limited Time Flash Sale*** Construction Management, Architectural Studies & Cost Estimation -QLS Endorsed Diploma Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Elevate your understanding of the built environment with our enriching bundle of courses on "Construction Management, Architectural Studies & Cost Estimation." Immerse yourself in three QLS-endorsed courses designed to provide an intricate understanding of Construction Management, Architectural Studies, and Construction Cost Estimation. Upon successful completion, you will receive hardcopy certificates as an acknowledgment of your mastery. Our "Construction Management, Architectural Studies & Cost Estimation" bundle brings together a suite of topics to fortify your knowledge and prepare you for the challenges of the construction industry. Key Features of the Construction Management, Architectural Studies & Cost Estimation Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Construction Management, Architectural Studies & Cost Estimation bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Construction Management QLS Course 02: Architectural Studies QLS Course 03: Construction Cost Estimation Diploma 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Construction Site ManagementCourse 02: Construction Industry Scheme (CIS)Course 03: Construction Cost Estimation DiplomaCourse 04: Construction SafetyCourse 05: LEED V4.1 - Building Design and Construction In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV WritingCourse 02: Job Search SkillsCourse 03: Self Esteem & Confidence BuildingCourse 04: Professional Diploma in Stress ManagementCourse 05: Complete Communication Skills Master Class Convenient Online Learning: Our Construction Management, Architectural Studies & Cost Estimation courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Understand the nuances of Construction Management. Develop an appreciation for Architectural Studies. Gain proficiency in Construction Cost Estimation. Acquire knowledge of Construction Site Management. Learn about the Construction Industry Scheme (CIS). Understand principles of Construction Safety. Comprehend LEED V4.1 - Building Design and Construction. Step into the vast world of construction and architecture with our carefully curated bundle. The courses introduce you to the multifaceted sphere of Construction Management, and the aesthetic and functional dimensions of Architectural Studies. The Construction Cost Estimation Diploma will enable you to gain insights into the economic aspects of construction projects. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals interested in Construction Management, Architectural Studies, and Cost Estimation. Aspiring architects and project managers. Individuals interested in sustainable building practices and safety protocols. Career path Architect - average salary in the UK: £27,000 - £45,000 Cost Estimator - average salary in the UK: £35,000 -£55,000 LEED Accredited Professional - average salary in the UK: £30,000 -£50,000 Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Construction Management, Architectural Studies & Cost Estimation -QLS Endorsed Diploma
Delivered Online On Demand45 hours
£300

Electrical Substation: Design, Construction & Commissioning

By EnergyEdge - Training for a Sustainable Energy Future

Enhance your knowledge with EnergyEdge course on electrical substation design, construction, and commissioning. Join us today!

Electrical Substation: Design, Construction & Commissioning
Delivered In-PersonFlexible Dates
£2,899 to £2,999

Construction Management, Cost Estimation and Safety Training

4.7(26)

By Academy for Health and Fitness

***24 Hour Limited Time Flash Sale*** Construction Management, Cost Estimation and Safety Training Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Set the cornerstone for your career in construction with our "Construction Management, Cost Estimation and Safety Training" eight-course bundle. Consisting of three Quality Licence Scheme-endorsed courses in Construction Management, Construction Cost Estimation, and Construction Safety, you will receive a hardcopy certificate for each to showcase your theoretical knowledge and dedication. This bundle is also fortified with five CPD QS accredited courses. Key Features of the Construction Management, Cost Estimation and Safety Training Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Construction Management, Cost Estimation and Safety Training bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Construction Management QLS Course 02: Construction Cost Estimation QLS Course 03: Construction Safety 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Construction Industry Scheme (CIS) Course 02: LEED V4 - Building Design and Construction Course 03: WELL Building Standard Course 04: Construction Estimation using RSMeans Course Course 05: AutoCAD VBA Programming - Beginner course In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Construction Management, Cost Estimation and Safety Training courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Understand the theoretical principles of Construction Management. Learn the essentials of Construction Cost Estimation. Gain knowledge about Construction Safety protocols. Get familiar with the Construction Industry Scheme (CIS). Understand LEED V4 Building Design and WELL Building Standard. Learn to estimate construction costs using RSMeans. Get introduced to AutoCAD VBA Programming. Discover the world of construction with our expertly designed eight-course bundle, tailored to provide a comprehensive theoretical understanding of construction management, cost estimation, and safety. From getting acquainted with CIS, LEED V4 and WELL standards to using RSMeans for estimation and introduction to AutoCAD VBA programming, this bundle is your gateway to the construction industry. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals aiming for a theoretical understanding of Construction Management. Aspiring professionals looking for comprehensive knowledge in Cost Estimation and Construction Safety. Anyone keen to understand the Construction Industry Scheme (CIS) and LEED V4 & WELL Building Standards. Career path Construction Manager - Avg. salary: £44,000 per year. Cost Estimator in construction - Avg. salary: £38,000 per year. LEED Consultant - Avg. salary: £42,000 per year. WELL Building Standard Consultant - Avg. salary: £45,000 per year. AutoCAD Programmer - Avg. salary: £39,000 per year. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Construction Management, Cost Estimation and Safety Training
Delivered Online On Demand43 hours
£309

SEO, Digital Marketing & Facebook Marketing

4.7(26)

By Academy for Health and Fitness

***24 Hour Limited Time Flash Sale*** SEO, Digital Marketing & Facebook Marketing Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you looking forward to expanding your market-reaching capability? Or looking for ways to boost your audience and drive sales? Master the art of online visibility and growth! Propel your business to new heights with our comprehensive bundle of 8 top-notch courses - "SEO, Digital Marketing & Facebook Marketing." The roadmap to success in the digital landscape has never been so well-defined! Our bundle comprises three exceptional QLS-endorsed courses in SEO, Digital Marketing, and Facebook Marketing. Your mastery in these subjects will be recognised with hardcopy certificates, enhancing your professional credibility. Understanding SEO principles, digital marketing strategies, and Facebook marketing techniques can exponentially amplify your brand's reach and engagement. Five additional CPD QS-accredited courses complement the QLS-endorsed trio, diving deeper into the world of online growth. Explore the exciting world of growth hacking, transform from a beginner to an advanced digital marketer, master social media marketing, harness the power of SEO analytics and content marketing tools, and learn to optimise results with Facebook analytics. These theoretical-based courses offer a thorough understanding of these dynamic disciplines, giving you a competitive edge in the ever-evolving digital marketplace. Key Features of the SEO, Digital Marketing & Facebook Marketing Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our SEO, Digital Marketing & Facebook Marketing bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: SEO - Search Engine Optimisation QLS Course 02: Digital Marketing QLS Course 03: Facebook Marketing 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Digital Marketing - Growth Hacking Techniques - Online Course Course 02: Digital Marketing for Beginners to Advanced Course 03: Social Media Marketing and Digital Marketing Masterclass Course 04: Strategies on SEO Analytics - Content Marketing Tools Course 05: Learn to Optimize Results With Facebook Analytics In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Unleash the full potential of digital marketing with our 8-course bundle: "SEO, Digital Marketing & Facebook Marketing." This exclusive bundle delivers a deep theoretical understanding of SEO, digital marketing, and Facebook marketing, with additional insights into growth hacking, SEO analytics, and social media marketing. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring digital marketers seeking to broaden their theoretical knowledge. Entrepreneurs looking to boost their brand's online visibility and growth. Content creators and writers aiming to improve their SEO understanding. Social media managers seeking a comprehensive understanding of Facebook analytics. Career path SEO Specialist: £25,000 - £35,000 Digital Marketing Manager: £30,000 - £50,000 Growth Hacker: £40,000 - £60,000 Social Media Manager: £25,000 - £40,000 Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

SEO, Digital Marketing & Facebook Marketing
Delivered Online On Demand3 days
£309

Merchandising, Logistic Management & Product Management

4.7(26)

By Academy for Health and Fitness

***24 Hour Limited Time Flash Sale*** Merchandising, Logistic Management & Product Management Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Unleash your potential with our extensive bundle of 8 courses titled: Merchandising, Logistic Management & Product Management. This bundle includes 3 QLS endorsed courses: Merchandising, Logistic Management, and Product Management Foundations, each offering a hardcopy certificate upon completion. In addition, we also provide 5 relevant CPD QS accredited courses: Quality Management, Basics of Process Planning, Resourcing and Managing Talent Course, Risk Assessment & Management Diploma, and Commercial Management. Dive deep into the theory behind Merchandising, Logistic Management, and Product Management and transform your understanding of these domains. Propel your career to new heights with this intricate blend of theoretical courses. Key Features of the Merchandising, Logistic Management & Product Management Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Merchandising, Logistic Management & Product Management bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Merchandising QLS Course 02: Logistic Management QLS Course 03: Product Management Foundations 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Quality Management Course 02: Basics of Process Planning Course 03: Resourcing and Managing Talent Course Course 04: Risk Assessment & Management Diploma CPD Accredited Course 05: Commercial Management In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Merchandising, Logistic Management & Product Management courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Develop an understanding of Merchandising strategies and techniques. Gain insight into the key concepts of Logistic Management. Understand the foundation of Product Management. Learn the principles and processes of Quality Management. Acquire knowledge of Process Planning basics. Understand the techniques of Resourcing and Managing Talent. Learn about Risk Assessment & Management and Commercial Management. This bundle covers an extensive array of topics, starting from Merchandising to Logistic Management, and culminating in Product Management. These topics are intertwined and form the backbone of effective business operations. By diving deep into these subjects, you will gain a comprehensive theoretical understanding that can be applied across various industries and roles. The benefits of learning these courses extend beyond the immediate job prospects, empowering you to make strategic decisions and effectively manage resources. CPD 260 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Professionals in the business sector aiming to enhance their knowledge. Aspiring product managers looking to build a solid foundation. Individuals interested in careers related to quality and process planning. Career path Merchandising Manager: £40,000 - £60,000 per annum Logistic Management Specialist: £30,000 - £50,000 per annum Product Manager: £45,000 - £70,000 per annum Quality Management Officer: £25,000 - £40,000 per annum Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Merchandising, Logistic Management & Product Management
Delivered Online On Demand48 hours
£309

Data Entry Administrator & Data Entry Clerk Diploma - CPD Certified

4.7(26)

By Academy for Health and Fitness

24-Hour Flash Sale! Prices Reduced Like Never Before!! Businesses usually plan ahead for their future moves and plans, basing their decisions on prior data. Making dynamic judgements becomes difficult if data is not adequately organised and maintained. In the UK, businesses lose an estimated £12 billion annually due to poor data quality; highlighting the critical role of proficient data administrators. Our comprehensive bundle is designed to enhance your proficiency with the latest tools and compliance practices to make you an asset in any office setting. This bundle covers everything from basic data entry skills to advanced data analysis with Google Data Studio, ensuring a well-rounded skill set. Courses like the Data Entry Administrator Diploma and Data Entry Clerk & Office Admin Assistant provide foundational knowledge, while General Data Protection Regulation (GDPR) & Cyber Security Management addresses crucial security practices. Additionally, practical skills in Microsoft Excel, Business and Data Analytics, and Financial Analysis are taught, equipping you to handle complex data environments effectively. Courses Are Included in this Data Entry Administrator & Clerk Bundle: Course 01: Data Entry Administrator & Clerk - CPD Certified Course 02: Google Data Studio: Data Analytics Course 03: General Data Protection Regulation (GDPR) & Cyber Security Management Course 04: Business and Data Analytics for Beginners Course 05: Business Administration Course 06: Office Admin Assistant Course 07: Office Administration & Skills Diploma Course 08: Business Improvement Course 09: Financial Analysis Course Course 10: Ultimate Microsoft Excel For Business Bootcamp Course 11: Diploma in Business Proposal Writing Course 12: Business Etiquette and Professional Behaviour Course 13: Negotiation Skills Certificate Course 14: Diploma in Performance Management Course 15: Workplace Confidentiality Course 16: Project Management Course Course 17: Product Management Course 18: Strategic Marketing & Planning Course 19: Visual Merchandising Diploma Course 20: Customer Service Training Embrace the opportunity to become a cornerstone of workplace efficiency and data management by enroling in our Data Entry Administrator course. Enrol now and join us to advance your career and become part of the future of business operations. Learning Outcomes of this Bundle: Master efficient data entry techniques and office administration skills. Analyse data effectively using Google Data Studio and Excel. Understand GDPR compliance and cyber security essentials. Develop business and financial analysis skills for workplace application. Enhance communication, negotiation, and project management capabilities. Apply strategic planning and performance management in business settings. This Diploma in Data Entry Administrator at QLS Level 3 course is endorsed by The Quality Licence Scheme and accredited by CPD QS (with 120 CPD points) to make your skill development & career progression more accessible than ever! Why Prefer this Course? Get a Free CPD Accredited 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! Moreover, this diploma offers learners the opportunity to acquire skills that are highly valued in the field of Data Entry. With this Certification, graduates are better positioned to pursue career advancement and higher responsibilities within the Data Entry setting. The skills and knowledge gained from this course will enable learners to make meaningful contributions to Data Entry-related fields, impacting their Data Entry experiences and long-term development. Course Curriculum Course 01: Data Entry Administrator & Clerk - CPD Certified Module 01: Introduction Module 02: Using the Computer Module 03: Common Rules and Guidelines Module 04: Using Excel for Efficient Data Entry Module 05: Using Excel's Flash Fill and Autofill to Automate Data Entry Module 06: How to Create a Form in Excel? Module 07: Using Statistics Packages Course 02: Google Data Studio: Data Analytics Module 01: Introduction to GDS Module 02: Data Visualisation Module 03: Geo-visualisation Module 04: A Socio-Economic Case Study Course 03: General Data Protection Regulation (GDPR) & Cyber Security Management Module 01: The Purpose and Principles of the UK GDPR Module 02: The Legal Foundations of GDPR Module 03: The Governance of GDPR Module 04: Protecting Personal Data Module 05: Exemptions to GDPR Module 06: International Transactions and National Security Module 07: Introduction to Cyber Security Module 08: Cyber Attacks Module 09: Cybercrimes Module 10: Cyber Security and Data Breaches Module 11: Password Management Module 12: Internet Browsing Module 13: Office and Remote Work Security Module 14: Device Management Module 15: Preventative Measures =========>>>>> And 17 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*20 = £390) 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 £89) CPD 200 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: Aspiring data entry clerks Office administrators Career changers Business professionals Administrative staff Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Data Entry Administrator: £18,000 - £25,000 Office Manager: £24,000 - £35,000 Business Analyst: £35,000 - £60,000 Financial Analyst: £30,000 - £50,000 Project Manager: £30,000 - £70,000 Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Bundle, you need to order to receive a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD . 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 Data Entry Administrator at QLS Level 3 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Data Entry Administrator & Data Entry Clerk Diploma - CPD Certified
Delivered Online On Demand4 days
£109

Level 4 Diploma in Youth Work - QLS Endorsed

4.7(26)

By Academy for Health and Fitness

24-Hour Flash Sale! Enjoy incredible discounts on our entire product range. Limited time only. Shop now and save big.

Level 4 Diploma in Youth Work - QLS Endorsed
Delivered Online On Demand10 hours
£100

Microsoft Excel Intermediate - Online classroom

By Microsoft Office Training

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 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 classroom, 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. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data 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 Preferably, delegates would have attended the Excel Introduction 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 Intermediate - Online classroom
Delivered OnlineFlexible Dates
£275

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

By Microsoft Office Training

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 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 classroom, 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. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data 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 Preferably, delegates would have attended the Excel Introduction 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 Intermediate (now with live online classes) One-to-One Training
Delivered In-Person in LondonFlexible Dates
£275