4309 Courses in Sheffield delivered Online

Learning Objectives Introduction , Getting Started with Excel , Creating Workbooks and Using Templates , Entering Data , Excel Formula Basics , Adjusting a Worksheet , Formatting and Aligning Data , Using Cell Styles and Themes , Inserting Objects and Graphics , Proofing a Workbook , Printing an Excel File , Managing Worksheets , Navigating and Viewing Excel Files , Conclusion   Pre-Requisites Basic Computer Skills   Description Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks. Section 01 Lesson 01: What is Excel 00:03:00 Lesson 02: Opening Excel 00:04:00 Lesson 03: Navigating the Excel User Interface-v2 00:06:00 Lesson 04: Navigating the Excel User Interface 00:04:00 Lesson 05: Using the Excel Ribbon 00:07:00 Lesson 06: Understanding Excel Worksheet Components 00:07:00 Lesson 07: Using the Backstage View 00:06:00 Section 02 Lesson 01: Creating a New Workbook 00:06:00 Lesson 02: Saving an Excel Workbook 00:05:00 Lesson 03: Using the Accessibility Checker 00:04:00 Lesson 04: Using the Accessibility Checker-v3 00:04:00 Section 03 Lesson 01: Navigating a Worksheet by Mouse or Keyboard 00:05:00 Lesson 02: Understanding Excel Data Types 00:04:00 Lesson 03: Using the Inking Tools 00:05:00 Lesson 04: Using the Inking Tools-v3 00:03:00 Lesson 05: Working with Cell and Range Addressing 00:05:00 Lesson 06: Using Various Data Selection Techniques 00:05:00 Lesson 07: Working with Common Excel Commands 00:06:00 Lesson 08: Using Flash Fill and Autofill 00:06:00 Section 04 Lesson 01: What are Formulas and Functions 00:05:00 Lesson 02: Understanding the Components of a Formula 00:05:00 Lesson 03: Understanding Calculation Hierarchy and the Order of Operations 00:03:00 Lesson 04: Creating Basic Formulas 00:05:00 Lesson 05: Working with Basic Functions and AutoSum 00:06:00 Lesson 06: Using Cell References 00:05:00 Lesson 07: Using the Quick Analysis Tool 00:03:00 Section 05 Lesson 01: Modifying Columns and Rows 00:06:00 Lesson 02: Hiding and Unhiding Columns and Rows 00:06:00 Section 06 Lesson 01: Formatting and Aligning Data 00:07:00 Lesson 02: Merging Data 00:07:00 Lesson 03: Wrapping Text and Adjusting Orientation 00:06:00 Lesson 04: Formatting Numbers 00:05:00 Lesson 05: Using the Format Painter 00:04:00 Section 07 Lesson 01: Using Cell Styles 00:06:00 Lesson 02: Applying Themes 00:05:00 Section 08 Lesson 01: Inserting and Formatting Images and Shapes 00:08:00 Lesson 02: Inserting and Formatting SmartArt 00:05:00 Lesson 03: Working with Icons 00:04:00 Lesson 04: Inserting Hyperlinks 00:06:00 Lesson 05: Inserting Symbols and Equations 00:05:00 Lesson 06: Inserting WordArt and Text Boxes 00:05:00 Lesson 07: Inserting 3-D Models 00:04:00 Lesson 08: Arranging Objects 00:06:00 Section 09 Lesson 01: Using Find and Replace 00:05:00 Lesson 02: Using Go To and Go To Special 00:03:00 Lesson 03: Using the Spell Checker 00:05:00 Lesson 04: Using the Thesaurus and Translation Features 00:05:00 Lesson 05: Using the resolve Feature-v3 00:02:00 Section 10 Lesson 01: Printing and Previewing Excel Files 00:06:00 Lesson 02: Creating Custom Margins and Scaling 00:05:00 Lesson 03: Adding Headers and Footers 00:04:00 Lesson 04: Formatting a Page with the Page Layout Tab 00:06:00 Lesson 05: Printing Titles and Specific Worksheet Areas 00:03:00 Lesson 06: Exporting to PDF-v3 00:02:00 Lesson 07: Exporting to PDF and XPS 00:04:00 Section 11 Lesson 01: Renaming and Coloring Worksheet Tabs 00:03:00 Lesson 02: Adding, Deleting and Navigating Worksheets 00:03:00 Lesson 03: Hiding and Unhiding Worksheets 00:03:00 Section 12 Lesson 01: Viewing Workbooks 00:03:00 Lesson 02: Using Zoom Tools 00:03:00 Lesson 03: Configuring Sheet Options 00:05:00 Lesson 04: Using the Freeze Panes and Split Commands 00:04:00 Lesson 05: Adjusting Worksheet Properties 00:04:00 Lesson 06: Viewing Workbook Statistics-v3 00:02:00 Course Recap Recap 00:02:00 Final Exam Final Exam - Excel 365 Beginner 00:20:00

Enroll in our Dental Nurse Training course to gain comprehensive skills and knowledge essential for a successful career in dental nursing. Perfect for aspiring dental nurses, current assistants, and those seeking to enter the dental field.

Dive into the digital world safely with our Cyber Security course! In today's fast-paced world, staying safe online is more important than ever.

Step into the world of small business success with our captivating online course, tailored for the dreamers and doers of today's entrepreneurial landscape.

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support

Cyber security is of paramount importance in the digital age, serving as a vital shield against ever-evolving Cyber security threats. In the UK, its significance is underscored by a burgeoning demand fueled by a surge in Cyber security attacks and digital vulnerabilities. With a projected increase of 25% in cyber incidents annually, the need for skilled cyber security professionals is escalating rapidly. This demand translates into abundant job opportunities across various sectors, ranging from government agencies to private enterprises. Moreover, cyber security roles offer competitive salaries, with entry-level positions starting at around £30,000 per year and experienced professionals commanding salaries well over £60,000 annually. Embracing a career in cyber security not only presents a chance to contribute to safeguarding digital infrastructure but also offers the prospect of a lucrative and rewarding profession in a field that is continually expanding and evolving. Key Features This Level 2 Diploma in Cyber Security Course Includes: This Level 2 Diploma in Cyber Security Course is CPD Certified Free Certificate Level 2 Diploma Developed by Specialist Lifetime Access From our Cyber security course, you will learn about cyber security, cyber attacks types, cybercrimes overview & password management . So, stand out in the job market by completing the Cyber Security course. Get an certificate and add it to your resume to impress your employers. Course Curriculum Level 2 Diploma in Cyber Security Course: Module 01: Fundamentals of Cyber Security Module 02: Types of Cyber Attacks Module 03: Cybercrimes Overview Module 04: Cyber Security and Data Breach Incidents Module 05: Best Practices in Password Management Learning Outcomes Diploma in Cyber Security Level 2 & 3 Course : Understanding Cyber Threats: Recognize various cyber threats and their implications on Cyber security. Cybercrime Awareness: Grasp the concepts and types of cybercrimes prevalent today. Data Breach Management: Acquire skills to respond to and prevent data breaches. Effective Password Practices: Implement secure password management techniques proficiently. Safe Internet Navigation: Demonstrate safe internet browsing practices for personal and professional use. Security in Remote Work: Apply Cyber security measures for office and remote work environments effectively. Certification After completing this Diploma in Cyber Security Level 2 & 3course, you will get a free certificate. 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? Level 2 Diploma in Cyber Security Course Individuals aspiring to enter the cyber security field. Employees seeking to enhance their cyber security awareness. IT professionals aiming to specialise in cyber security. Students pursuing a career in information technology or cyber security. Anyone concerned about personal and professional cyber security. NB: This Course doesn't provide any professional qualifications. For professional qualifications, you may like to choose: Level 2 Diploma in Business Beginners in Cyber Security Level 4 Diploma in Cyber Security Level 5 Diploma in Cyber Security NCFE Level 2 Certificate in the Principles of Cyber Security Level 3 Diploma in Cyber Security Management and Operations Career path Level 2 Diploma in Cyber Security Course Cyber Security Analyst IT Security Consultant Network Security Engineer Incident Response Specialist Data Security Administrator Security Compliance Officer Certificates Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Cyber security is of paramount importance in the digital age, serving as a vital shield against ever-evolving Cyber security threats. In the UK, its significance is underscored by a burgeoning demand fueled by a surge in Cyber security attacks and digital vulnerabilities. With a projected increase of 25% in cyber incidents annually, the need for skilled cyber security professionals is escalating rapidly. This demand translates into abundant job opportunities across various sectors, ranging from government agencies to private enterprises. Moreover, cyber security roles offer competitive salaries, with entry-level positions starting at around £30,000 per year and experienced professionals commanding salaries well over £60,000 annually. Embracing a career in cyber security not only presents a chance to contribute to safeguarding digital infrastructure but also offers the prospect of a lucrative and rewarding profession in a field that is continually expanding and evolving. Key Features This Level 2 Diploma in Cyber Security Course Includes: This Level 2 Diploma in Cyber Security Course is CPD Certified Free Certificate Level 2 Diploma Developed by Specialist Lifetime Access From our Cyber security course, you will learn about cyber security, cyber attacks types, cybercrimes overview & password management . So, stand out in the job market by completing the Cyber Security course. Get an certificate and add it to your resume to impress your employers. Course Curriculum Level 2 Diploma in Cyber Security Course: Module 01: Fundamentals of Cyber Security Module 02: Types of Cyber Attacks Module 03: Cybercrimes Overview Module 04: Cyber Security and Data Breach Incidents Module 05: Best Practices in Password Management Learning Outcomes Diploma in Cyber Security Level 2 & 3 Course : Understanding Cyber Threats: Recognize various cyber threats and their implications on Cyber security. Cybercrime Awareness: Grasp the concepts and types of cybercrimes prevalent today. Data Breach Management: Acquire skills to respond to and prevent data breaches. Effective Password Practices: Implement secure password management techniques proficiently. Safe Internet Navigation: Demonstrate safe internet browsing practices for personal and professional use. Security in Remote Work: Apply Cyber security measures for office and remote work environments effectively. Certification After completing this Diploma in Cyber Security Level 2 & 3 course, you will get a free certificate. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? Level 2 Diploma in Cyber Security Course Individuals aspiring to enter the cyber security field. Employees seeking to enhance their cyber security awareness. IT professionals aiming to specialise in cyber security. Students pursuing a career in information technology or cyber security. Anyone concerned about personal and professional cyber security. NB: This Course doesn't provide any professional qualifications. For professional qualifications, you may like to choose: Level 2 Diploma in Business Beginners in Cyber Security Level 4 Diploma in Cyber Security Level 5 Diploma in Cyber Security NCFE Level 2 Certificate in the Principles of Cyber Security Level 3 Diploma in Cyber Security Management and Operations Career path Level 2 Diploma in Cyber Security Course Cyber Security Analyst IT Security Consultant Network Security Engineer Incident Response Specialist Data Security Administrator Security Compliance Officer Certificates Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Diploma in Administrative Management equips you with the essential skills and knowledge to excel in today's dynamic office environment. This course goes beyond the basics, transforming you into a highly organized and efficient administrative professional.

Unlock your potential in Python programming with our Complete Python Course - Beginner to Expert! From mastering syntax to advanced data analysis, machine learning, and web development, this comprehensive course equips you with essential programming skills. Start your journey today and become a proficient Python developer!

Overview   With the ever-increasing demand for Lean Six Sigma in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Lean Six Sigma may be.   Learning about Lean Six Sigma or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Lean Six Sigma. That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Lean Six Sigma is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates.   The self-paced online learning methodology by Compete High in this Diploma in Lean Six Sigma course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course!   Instead of searching for hours, enrol right away on this Diploma in Lean Six Sigma course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run.   Who is this course for?   While we refrain from discouraging anyone wanting to do this Diploma in Lean Six Sigma course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Lean Six Sigma, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Lean Six Sigma, Anyone looking for a certificate of completion on doing an online training on this topic, Students of Lean Six Sigma, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity   Career Path   This Diploma in Lean Six Sigma course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.    Course Curriculum Module 1 - Introduction to Six Sigma Introduction to Six Sigma 00:00 Module 2 - Basic Six Sigma Concepts Basic Six Sigma Concepts 00:00 Module 3 - The Define Phase The Define Phase 00:00 Module 4 - The Measure Phase The Measure Phase 00:00 Module 5 - Analyse Phase Analyse Phase 00:00 Module 6 - Improve Phase Improve Phase 00:00 Module 7 - Control Phase Control Phase 00:00 Module 8 - Beginner Statistics Beginner Statistics 00:00 Module 9 - Six Sigma in Professional Field Six Sigma in Professional Field 00:00 Module 10 - Project Management Project Management 00:00