15082 Courses

Learn Excel for Business Accounting with our comprehensive course. From basic worksheet creation to advanced functions like pivot tables, charts, and data analysis, master Excel's features for efficient accounting tasks. Ideal for business professionals and students looking to enhance their Excel skills for financial management.

Master the art of project planning with our Dynamic Excel Gantt Chart and Timelines course. Learn to create and manage dynamic Gantt charts and timelines. Ideal for project managers, data analysts, and business professionals. Enrol today!

Overview This comprehensive course on Intermediate Solidworks will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Intermediate Solidworks  comes with accredited certification from CPD, 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 Intermediate Solidworks. It is available to all students, of all academic backgrounds. Requirements Our Intermediate Solidworks 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 6 sections • 37 lectures • 02:45:00 total length •1.1 Extruded Boss Advanced: 00:03:00 •1.2 Extruded Boss Additional: 00:04:00 •1.3 Extruded Cut Advanced: 00:03:00 •1.4 Swept Boss: 00:02:00 •1.5 Lofted Boss: 00:03:00 •1.6 Draft: 00:03:00 •1.7 Shell: 00:02:00 •1.8 Rib: 00:04:00 •1.9 Example #1: 00:08:00 •1.10 Example #2: 00:07:00 •2.1 Linked dimensions: 00:04:00 •2.2 Equations: 00:05:00 •2.3 Coordinate System: 00:03:00 •2.4 Hole wizard: 00:03:00 •2.5 Feature scope: 00:02:00 •2.6 Mirror: 00:03:00 •2.7 Example #1: 00:09:00 •2.8 Example #2: 00:09:00 •3.1 Creating a Design Table: 00:06:00 •3.2 Configurations: 00:05:00 •3.3 Example #1: 00:07:00 •3.4 Example #2: 00:04:00 •4.1 Distance and Angle: 00:04:00 •4.2 Profile Center: 00:04:00 •4.3 Symmetric and Width: 00:05:00 •4.4 Path Mate: 00:05:00 •4.5 Linear Coupler: 00:06:00 •4.6 Example #1: 00:08:00 •4.7 Example #2: 00:13:00 •5.1 Collision Detection: 00:02:00 •5.2 Interference Detection: 00:03:00 •5.3 Assembly Feature: 00:02:00 •5.4 Replacing Part: 00:01:00 •5.5 Sub-assembly: 00:03:00 •5.6 Example #1: 00:05:00 •5.7 Example #2: 00:05:00 •Assignment - Intermediate Solidworks Course: 00:00:00

Overview This comprehensive course on Learn Ethical Hacking From A-Z: Beginner To Expert will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Learn Ethical Hacking From A-Z: Beginner To Expert comes with accredited certification from CPD, 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 Learn Ethical Hacking From A-Z: Beginner To Expert. It is available to all students, of all academic backgrounds. Requirements Our Learn Ethical Hacking From A-Z: Beginner To Expert 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 17 sections • 105 lectures • 11:51:00 total length •Course Overview: 00:08:00 •About Your Instructors: 00:03:00 •Section Overview: 00:03:00 •Current Cybersecurity Market: 00:09:00 •The 3 Types of Hackers: 00:05:00 •The 4 Elements of Security: 00:04:00 •Ethical Hacker Terminology: 00:04:00 •Common Methods of Hacking: 00:08:00 •Cybersecurity & Ethical Hacking Overview: 00:03:00 •Ethical Hacking vs Penetration Testing: 00:06:00 •Job Opportunities in Cybersecurity: 00:01:00 •Who is This Course is For?: 00:01:00 •Networking Section Overview: 00:12:00 •How Data Travels Across The Internet: 00:02:00 •Understanding Ports and Protocols: 00:08:00 •Understanding IP Addresses: Public & Private: 00:02:00 •What Are Subnets?: 00:03:00 •The Average Network vs Remote Based: 00:06:00 •Hacking Lab Section Overview: 00:09:00 •Understanding Virtual Machines: 00:03:00 •Setup Your Kali Linux Machine: 00:10:00 •VN Setup & Testing Vulnerable Systems: 00:23:00 •Linux+Python+Bash+Powershell Section Overview: 00:06:00 •Linux Basics: 00:11:00 •Working With Directories & Moving Files: 00:03:00 •Installing & Updating Application Files: 00:02:00 •Linux Text Editors: 00:04:00 •Searching For Files: 00:02:00 •Bash Scripting Basics: 00:09:00 •Python Basics: 00:11:00 •Remaining Anonymous Section Overview: 00:06:00 •TOR Browser Overview: 00:06:00 •Anonsurf Overview: 00:03:00 •Changing Mac Addresses: 00:03:00 •Using a Virtual Private Network/Server (VPN, VPS): 00:04:00 •WiFi Hacking Section Overview: 00:06:00 •WiFi Hacking System Setup: 00:09:00 •WEP Hacking Attack #1: 00:09:00 •WEP Hacking Attack #2: 00:04:00 •WPA/WPA2 Hacking: 00:10:00 •Reconnaissance Section Overview: 00:04:00 •Passive Recon vs Active Recon: 00:01:00 •Recon-ng Overview: 00:15:00 •Whois Enumeration: 00:02:00 •DNS Enumeration Overview: 00:02:00 •Netcraft.com DNS Information: 00:03:00 •Google Hacking: 00:05:00 •Shodan.io Overview: 00:02:00 •Securityheaders.com (Analyze HTTPS Headers of website): 00:02:00 •Ssllabs.com/ssltest (Look for SSL issues on website): 00:02:00 •Pastebin.com (Sensitive Information): 00:01:00 •NMAP Port Scanning (Discover open ports, OS, Services, Vulnerabilities, etc.): 00:15:00 •Netcat Overview + SMB/NFSEnumeration: 00:14:00 •Nikto & Sparta Web Application Scanner: 00:06:00 •SMPT Enumeration + Nessus/Openvas Scanners: 00:05:00 •Launching Attacks Overview: 00:10:00 •Analyzing Information Gathered: 00:04:00 •Taking Advantage of Telenet: 00:06:00 •Searching & Understanding Exploits: 00:06:00 •Copy Exploits From Searchsploit: 00:03:00 •Understanding Exploits: 00:04:00 •Launching Exploits: 00:24:00 •Brute Force Attacks: 00:07:00 •How To Crack Passwords: 00:04:00 •ARP Spoofing Overview: 00:21:00 •Introduction To Cryptography: 00:14:00 •Post Exploitation Section Overview: 00:03:00 •Privilege Escalation: 00:29:00 •Transferring Files in/out of Victim, Creating Custom Malware + Evading Antivirus: 00:27:00 •Installing a Keylogger: 00:03:00 •Installing a Backdoor: 00:07:00 •Website & Web Application Hacking Overview: 00:06:00 •Web Application Scanning: 00:08:00 •Directory Buster Hacking Tool: 00:03:00 •Nikto Web App Hacking Tool: 00:03:00 •SQLmap and SQL Ninja Overview: 00:01:00 •How To Execute Brute Force Attacks: 00:13:00 •Using Command Injection: 00:03:00 •Malicious File Upload: 00:10:00 •Local & Remote File Inclusion: 00:10:00 •SQL Injection Overview: 00:19:00 •Using Cross Site Request Forgery: 00:11:00 •Cross Site Scripting Overview: 00:12:00 •Mobile Phone Hacking Section Overview: 00:11:00 •Mobile Attack Vectors: 00:02:00 •Mobile Hacking Using URLs: 00:02:00 •Jail Breaking and Rooting Considerations: 00:01:00 •Privacy Issues (Geo Location): 00:01:00 •Mobile Phone Data Security: 00:02:00 •Getting Your Name Out There Section Overview: 00:02:00 •Building A Brand: 00:09:00 •Personal Branding: 00:13:00 •Setup Your Website and Blog: 00:11:00 •Writing a Book: 00:10:00 •Starting a Podcast: 00:08:00 •Networking Overview: 00:06:00 •Making Money Section Overview: 00:02:00 •Bug Bounty Programs: 00:04:00 •How To Start Freelancing: 00:11:00 •How To Start Client Consulting: 00:09:00 •Potential Salary & Cybersecurity Roadmap: 00:10:00 •Books Recommendations: 00:03:00 •Places to Practice Hacking for Free: 00:03:00 •Resources - Learn Ethical Hacking From A-Z: Beginner To Expert: 00:00:00 •Assignment - Learn Ethical Hacking From A-Z: Beginner To Expert: 00:00:00

Overview This comprehensive course on Learn Linux in 5 Days will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Learn Linux in 5 Days comes with accredited certification from CPD, 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 Learn Linux in 5 Days. It is available to all students, of all academic backgrounds. Requirements Our Learn Linux in 5 Days 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 10 sections • 45 lectures • 05:58:00 total length •Course Overview: 00:03:00 •Background and Introduction: 00:07:00 •Linux Distributions: 00:05:00 •Installing VirtualBox on Windows: 00:03:00 •Installing VirtualBox on Mac: 00:03:00 •Installing Linux Using an Image for VirtualBox: 00:05:00 •VirtualBox Troubleshooting Tips: 00:02:00 •When to Install Linux from Scratch: 00:15:00 •Installing CentOS from Scratch / CentOS Manual Installation Process: 00:23:00 •Getting Connected: 00:11:00 •Connect Directly: 00:02:00 •The Linux Directory Structure: 00:10:00 •The Shell: 00:08:00 •Basic Linux Commands: 00:05:00 •Teach Yourself to Fish: 00:06:00 •Working with Directories: 00:09:00 •Listing Files and Understanding LS Output: 00:12:00 •File and Directory Permissions Explained - Part One: 00:11:00 •File and Directory Permissions Explained - Part Two: 00:09:00 •View Files and the Nano Editor: 00:05:00 •Editing Files in Vi: 00:10:00 •Editing Files with Emacs: 00:06:00 •Finding Files and Directories: 00:07:00 •Graphical Editors: 00:04:00 •Deleting, Copying, Moving, and Renaming Files: 00:11:00 •Wildcards - Part One: 00:05:00 •Wildcards - Part Two: 00:07:00 •Input, Output, and Redirection: 00:08:00 •Comparing Files: 00:04:00 •Searching in Files and Using Pipes: 00:10:00 •Transferring and Copying Files over the Network: 00:07:00 •Customizing the Shell Prompt: 00:05:00 •Shell Aliases: 00:04:00 •Environment Variables: 00:08:00 •Processes and Job Control: 00:12:00 •Scheduling Repeated Jobs with Cron: 00:06:00 •Switching Users and Running Commands as Others: 00:08:00 •Shell History and Tab Completion: 00:13:00 •Installing Software on RPM Based Linux Distros: RedHat, CentOS, AlmaLinux, Rocky: 00:21:00 •Installing Software on Debian Based Linux Distros: Debian, Ubuntu, Kali Linux: 00:12:00 •Conclusion - Congratulations and Thank You!: 00:01:00 •Connecting to a Linux Virtual Machine over the Network: 00:11:00 •Bonus - Installing NGINX, MySQL, PHP, and WordPress on Ubuntu: 00:09:00 •Resources: 00:15:00 •Assignment - Learn Linux in 5 Days: 00:00:00

Overview This comprehensive course on Advanced Digital Painting Course will deepen your understanding on this topic .After successful completion of this course you can acquire the required skills in this sector. This Advanced Digital Painting Course comes with accredited certification from CPD, 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 Advanced Digital Painting Course. It is available to all students, of all academic backgrounds. Requirements Our Advanced Digital Painting 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 5 sections • 23 lectures • 02:51:00 total length •Set up a new document: 00:02:00 •Studying Dutch Masters: 00:07:00 •Creating a Composition with reference photos: 00:05:00 •Basic sketch for Background Painting: 00:06:00 •Underpainting in Grey tones: 00:13:00 •Foreground Sketch: 00:08:00 •Painting the Clouds in the sky: 00:07:00 •Background Mountains Part 1: 00:09:00 •Placing the Planet: 00:03:00 •Background Mountains Part 2: 00:05:00 •Background Mountains Right: 00:11:00 •Painting the Sea: 00:08:00 •Balanced Rock: 00:10:00 •Arch Ready: 00:14:00 •The River: 00:08:00 •The Arch Completed: 00:07:00 •Pentool Part 1: 00:06:00 •Pentool Part 2: 00:03:00 •Pentool Part 3: 00:05:00 •Building a Spaceship: 00:14:00 •The Spaceship: 00:11:00 •Placing the Spaceship and Astronauts: 00:09:00 •Assignment - Advanced Digital Painting Course: 00:00:00

Overview Did you know a pleasant classroom environment can amplify student engagement by over 65%? The classroom Behaviour Management' course is meticulously designed to guide teaching assistants and educators towards creating a balanced classroom.  Explore the art of communication, with segments like 'Experienced TAs Maintain Strong Communications with the Students' and 'Communication and Interaction'. Delve deep into the specifics of 'Cognition and Learning' and address 'Social, Emotional and Mental Health Difficulties'.  This course also offers a penetrating look into 'SEN Support' and the tenets of 'High Quality Teaching for Pupils with SEN', ultimately guiding participants towards 'Providing the Best Learning Environment'. 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 Classroom Behaviour Management . It is available to all students, of all academic backgrounds. Requirements There is no experience or previous qualifications required for enrolment on this Classroom Behaviour Management . It is available to all students, of all academic backgrounds. 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 • 02:24:00 total length •Understanding Behaviour & Relationships as a TA: 00:20:00 •Experienced TAs Maintain Strong Communications with the Students: 00:14:00 •Communication and Interaction: 00:17:00 •Cognition and Learning: 00:21:00 •Social, Emotional and Mental Health Difficulties: 00:13:00 •Children Having Special Education Needs or Disabilities: 00:17:00 •SEN Support: 00:14:00 •High Quality Teaching for Pupils with SEN: 00:10:00 •Providing the Best Learning Environment: 00:18:00

Overview This comprehensive course on Property Negotiator Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Property Negotiator Training 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 Negotiator Training. It is available to all students, of all academic backgrounds. Requirements Our Property Negotiator Training 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 5 sections • 43 lectures • 18:48:00 total length •Introduction to Estate Agents: 00:20:00 •Different Types of Estate Agents: 00:15:00 •Getting Started on the Job: 00:15:00 •Listing Property Finding the Sellers: 00:22:00 •Valuation Process: 00:20:00 •Negotiating as an Estate Agent: 00:13:00 •Selling Property - Finding the Buyers: 00:22:00 •Letting Property: 00:31:00 •Technology for Estate Agents: 00:22:00 •Regulation of Estate Agents: 00:13:00 •Module 1: Who is an Estate Agent?: 00:15:00 •Module 2: Requirements for the Job: 00:20:00 •Module 3: History of the Estate Agent: 00:20:00 •Module 4: The Real Estate Industry: 00:15:00 •Module 5: Different Types of Estate Agents: 00:15:00 •Module 6: Online Estate Agents: 00:20:00 •Module 7: Estate agent Fees and Contracts: 00:30:00 •Module 8: Pros and Cons of Hiring an Estate Agent: 00:20:00 •Module 9: Getting to Know Your Clients: 00:20:00 •Module 10: A Day in the Life of an Estate Agent: 00:15:00 •Module 11: Selling Property with an Estate Agent: 00:15:00 •Module 12: Property Marketing: 00:15:00 •Module 13: The Regulations for Estate Agent Boards and Why It is Important: 00:10:00 •Module 14: Valuation: 00:20:00 •Module 15: Performing Viewings: 00:15:00 •Module 16: Negotiating: 00:30:00 •Module 17: Buying with an Estate Agent: 00:20:00 •Module 18: Sales Progression: 00:30:00 •Module 19: Technology: 00:25:00 •Module 20: Investment Property: 00:40:00 •Module 21: About Letting Agents: 00:25:00 •Module 22: Property Management: 00:15:00 •Module 23: Laws and Regulations: 00:30:00 •Module 24: How to Set Up an Estate Agency: 00:15:00 •Module 25: Property Development and the Process: 00:35:00 •Module 26: Main Actors and Economic Context: 01:20:00 •Module 27: Land for Development: 02:00:00 •Module 28: Making Decisions: 00:20:00 •Module 29: Sorting Out Your Finances: 00:30:00 •Module 30: Establishing Your Business: 00:20:00 •Module 31: Market Research: 01:15:00 •Module 32: Promotion and Selling: 01:00:00 •Assignment - Property Negotiator Training: 00:00:00

Overview This comprehensive course on Speed Reading will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Speed Reading comes with accredited certification from CPD, 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 Speed Reading. It is available to all students, of all academic backgrounds. Requirements Our Speed Reading 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 6 sections • 6 lectures • 01:56:00 total length •Introduction to Speed Reading: 00:22:00 •Module 02: Preparing Yourself for Effective Speed Reading: 00:12:00 •Speed Reading: Benefits and Obstacles: 00:21:00 •Relationship Between Reading and the Brain: 00:21:00 •Skills and Techniques for Speed Reading: 00:18:00 •How to Improve Your Memory?: 00:22:00

Are you looking to improve your current abilities or make a career move? Our unique Complete Microsoft Excel Course might help you get there! Expand your expertise with high-quality training - study the Complete Microsoft Excel and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the online training course. This Complete Microsoft Excel online training course is accredited by CPD with 15 CPD points for professional development. Students can expect to complete this training course in around 11 hours. You'll also get dedicated expert assistance from us to answer any queries you may have while studying our course. The course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Complete Microsoft Excel course, you will receive an instant e-certificate as proof of the comprehensive skill development and competency. Add these amazing new skills to your resume and boost your employability by simply enroling on this course. With this comprehensive course, you can achieve your dreams and train for your ideal career. The Complete Microsoft Excel course provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development. You'll get a Free Student ID card by enroling in this course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. Enroling on the Complete Microsoft Excel course will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with the program. Why Prefer this Complete Microsoft Excel Course? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standard-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support Experts created the Complete Microsoft Excel course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this course and take a step toward a brighter future! *** Course Curriculum *** Here are the topics you will cover on the Course: >> Complete Microsoft Excel << Module 01: Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features CONCAT IFS MAXIFS MINIFS SWITCH TEXTJOIN Map Chart Funnel Chart Better Visuals Pivot Table Enhancements Power Pivot Updates Module 02: Getting Started with Microsoft Office Excel Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter Cell Data Use Excel Help Module 03: Performing Calculations Create Worksheet Formulas Insert Functions Reuse Formulas and Functions Module 04: Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Search for and Replace Data Use Proofing and Research Tools Module 05: Formatting a Worksheet Apply Text Formats Apply Number Format Align Cell Contents Apply Styles and Themes Apply Basic Conditional Formatting Create and Use Templates Module 06: Printing Workbooks Preview and Print a Workbook Set Up the Page Layout Configure Headers and Footers Module 07: Managing Workbooks Manage Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties Module 08: Working with Functions Work with Ranges Use Specialized Functions Work with Logical Functions Work with Date & Time Functions Work with Text Functions Module 09: Working with Lists Sort Data Filter Data Query Data with Database Functions Outline and Subtotal Data Module 10: Analyzing Data Apply Intermediate Conditional Formatting Apply Advanced Conditional Formatting Module 11: Visualizing Data with Charts Create Charts Modify and Format Charts Use Advanced Chart Features Module 12: Using PivotTables and PivotCharts Create a PivotTable Analyze PivotTable Data Present Data with PivotCharts Filter Data by Using Timelines and Slicers Module 13: Working with Multiple Worksheets and Workbooks Use Links and External References Use 3-D References Consolidate Data Module 14: Using Lookup Functions and Formula Auditing Use Lookup Functions Trace Cells Watch and Evaluate Formulas Module 15: Sharing and Protecting Workbooks Collaborate on a Workbook Protect Worksheets and Workbooks Module 16: Automating Workbook Functionality Apply Data Validation Search for Invalid Data and Formulas with Errors Work with Macros Module 17: Creating Sparklines and Mapping Data Create Sparklines MapData Module 18: Forecasting Data Determine Potential Outcomes Using Data Tables Determine Potential Outcomes Using Scenarios Use the Goal Seek Feature Forecasting Data Trends Module 19: Excel Templates Excel Templates Assessment Process Once you have completed all the modules in the Complete Microsoft Excel course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 15 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 course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career. Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.