402 Spreadsheet courses

Automate your Excel workflow, accelerate your productivity, and master the fundamentals of programming with VBA!

Learn how to find broken links, bad tags and many more uses of SEO audit tool through our SEO Audit with Screaming Frog course. The lucid contents of the course teach you how an audit tool exponents your whole site and create a spreadsheet of all your pages. Teaching you the basic function of SEO tools, it enables you how to recognize duplicate content, issue a report, create XML sitemaps, scrutinize broken backlinks, and fix site errors. It also guides you to learn a webpage crawling, and Frog SEO Spider using system to create a list of your internal pages. Frog SEO tracks the crawl level, keyword elements, export your data to spreadsheet, measure file size, justify page depth, find replica pages with duplicate content and organize outlinks and inlinks to any given URL. What you'll learn You'll learn the basics to SEO (Search Engine Optimization) You'll learn how to how to use Screaming Frog SEO Spider You'll learn how to perform an SEO Audit You'll learn how to analyze broken backlinks You'll learn how to identify duplicate content You'll learn how to fix site errors You'll learn how to issue a report You'll learn how to crawl a website You'll learn how to examine the .htaccess for issues & compatability You'll learn how to analyse page data like titles, meta & descriptions You'll learn how to generate XML sitemaps You'll learn how to meta robots text You'll learn how to audit hreflang attributes Requirements You should know how to use a PC at a beginner level Screaming Frog SEO Spider (FREE Version at least) Who is the target audience? Online Marketers Everyone with a Website SEO Marketers & Engineers Brick & Mortar Businesses Everyone with a Product Video Producers who want to rank their videos higher in Google Link Builders Bloggers Content Creators who want to get more traffic from their work Module: 01 Starting Your SEO Audit 00:47:00 SEO Audit Software Walkthrough 01:02:00 Keyword Planner 00:08:00 Free Keyword Research Tool 00:06:00 Paid Keyword Research Tool 00:07:00 Module: 02 WordPress Fastest Cache Settings 00:05:00 Yoast Real-Time Analysis for Any Site 00:02:00 WordPress Cache Speed Test 00:01:00 Real-Time Ranking Case Study 00:08:00 All In One SEO Plugin 00:03:00 Course Certification

Description: Business Accounting refers to the systematic recording, analysing, interpreting and presenting financial information. An Introduction to Business Accounting - Complete Video Course course provides you with the basic knowledge of Business Accounting for the betterment of your business. In the course, you will learn the accounting equation and different types of financial statements and the ways of analysing transactions using the double-entry system, and by journalizing transactions. The course will also teach you how to post entries, the trial balance, and find errors using horizontal analysis. The Business Accounting course will also teach you the ways of adjusting process, adjusting entries, preparing a worksheet, and creating financial statements. Areas of concentration also include accounting cycles, temporary vs permanent accounting basics, the accounting cycle illustrated steps, the fiscal year, and working capital and current ratio. To sum up, the course will help you to know the basic usage of Business Accounting. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? An Introduction to Business Accounting - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our An Introduction to Business Accounting - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Professional Bookkeeper Introduction Professional Bookkeeper FREE 00:09:00 Introduction to Accounting and Business Defining a Business 00:07:00 Ethics in Accounting 00:05:00 Generally Accepted Accounting Principles (GAAP) 00:10:00 The Accounting Equation The Accounting Equation 00:07:00 Transactions 00:11:00 Financial Statements 00:13:00 Analyzing Transactions The Accounting Equation and Transactions 00:16:00 Double-Entry System 00:11:00 Transactions - Journalizing 00:17:00 Journal Entries 00:38:00 Entering Information - Posting Entries Posting Entries 00:10:00 The Trial Balance 00:10:00 Finding Errors Using Horizontal Analysis 00:09:00 Horizontal Trend : Balance Sheet 00:21:00 Horizontal Trend: Income Statement 00:36:00 Adjusting Process The Purpose of the Adjusting Process 00:15:00 Adjusting Entries Adjusting Entries - Prepaid Expenses 00:13:00 Adjusting Entries - Accrued Revenues 00:10:00 Adjusting Entries - Depreciation Expense 00:09:00 Adjustment Summary Adjustment Summary - Review 00:13:00 Vertical Analysis 00:33:00 Preparing a Worksheet Preparing a Worksheet 00:06:00 Financial Statements The Income Statement 00:11:00 Financial Statements - Definitions 00:12:00 Completing the Accounting Cycle Temporary vs. Permanent Accounts 00:19:00 The Accounting Cycle Illustrated Accounting Cycle Illustrated - Steps 1-5 00:11:00 Accounting Cycle Illustrated - Steps 6-10 00:12:00 Fiscal Year Fiscal Year 00:09:00 Spreadsheet Exercise Spreadsheet Exercise - Steps 1-4 00:11:00 Spreadsheet Exercise - Steps 5-7 00:37:00 Mock Exam Mock Exam- An Introduction to Business Accounting - Complete Video Course 00:20:00 Final Exam Final Exam- An Introduction to Business Accounting - Complete Video Course 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Register on the AutoCAD to Excel - VBA Programming Hands-On! today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The AutoCAD to Excel - VBA Programming Hands-On! is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The AutoCAD to Excel - VBA Programming Hands-On! Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the AutoCAD to Excel - VBA Programming Hands-On!, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Unit 01: Introduction Module 01: Introduction 00:01:00 Module 02: Course Content 00:04:00 Module 03: Who is this Course for? 00:01:00 Module 04: What Will I Learn from this Course? 00:02:00 Unit 02: Exporting AutoCAD Objects to Excel Module 01: Exporting Line Object to Excel Introduction 00:01:00 Module 02: Exporting Line Objects to Excel - Hands-on Demo 00:13:00 Module 03: Exporting MText Objects to Excel Introduction 00:01:00 Module 04: Exporting MText Objects to Excel - Hands-on Demo 00:08:00 Module 05: Exporting Attribute Blocks to Excel Introduction 00:01:00 Module 06: Exporting Attribute Block Objects to Excel - Hands-on Demo 00:15:00 Unit 03: AutoCAD to Excel Extractor Project Module 01: Developing the Extractor Program 00:09:00 Unit 04: Exporting AutoCAD Objects to Delimited Files Module 01: Exporting LWPolyline to CSV File Introduction 00:02:00 Module 02: Exporting LWPolyline Objects to a CSV File - Hands-on Demo (Part 1) 00:04:00 Module 03: Exporting LWPolyline Objects to a CSV File - Hands-on Demo (Part 2) 00:19:00 Module 04: Exporting LWPolyline to a Pipe Delimited File Introduction 00:01:00 Module 05: Exporting LWPolyline to a Pipe Delimited File - Hands-On Demo 00:02:00 Unit 05: Importing Excel File Into AutoCAD Module 01: Importing Line Objects into AutoCAD Introduction 00:01:00 Module 02: Clear Line Objects for Importing Excel Spreadsheet - Hands-On Demo 00:01:00 Module 03: Importing Line Objects Spreadsheet File into AutoCAD - Hands-On Demo 00:14:00 Module 04: Importing MText Objects Excel Spreadsheet File into AutoCAD Introduction 00:01:00 Module 05: Importing MText Objects Excel Spreadsheet File into AutoCAD - Hands - On Demo 00:09:00 Unit 06: Importing CSV and Pipe Delimited Files into AutoCAD Module 01: Importing CSV File into AutoCAD Introduction 00:01:00 Module 02: Importing CSV File into AutoCAD - Hands-On (Part 1) 00:03:00 Module 03: Importing CSV File into AutoCAD - Hands-On (Part 2) 00:18:00 Module 04: Importing Pipe Delimited File into AutoCAD - Hands-On 00:04:00 Unit 07: Conclusion Module 01: Conclusion and Thank you 00:01:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Duration 1 Days 6 CPD hours This course is intended for This course is for individuals who are new to Adobe Acrobat Pro, but need to create and share PDF files and PDF portfolios. Students should have some experience using office productivity applications, such as word processor, a multimedia presentation application, or a spreadsheet application. Overview In this course, you will create and work with PDF documents. You will: Access information in a PDF document Create and save PDF documents Navigate content in a PDF document Modify PDF documents Review PDF documents Convert PDF documents Adobe Acrobat Pro DC puts the power of the Portable Document Format, literally, at your fingertips. By taking advantage of the functionality & features available in Acrobat, you will ensure the integrity of your documents regardless of who views them. Prerequisites To ensure your success in this course, you should have basic experience with computers and exposure to Windows 8, as well as common productivity tools such as Microsoft Office Word & Microsoft Office PowerPoint. You can obtain this level of skill & knowledge by taking the following courses: Using Microsoft Windows 8 Microsoft Windows 8 Transition from Windows 7 Microsoft Office Word 2013: Part 1 Microsoft Office PowerPoint 2013: Part 1 1 - Accessing PDF Documents Topic A: Open a PDF Document Topic B: Browse a PDF Document 2 - Creating and Saving PDF Documents Topic A: Create and Save a PDF Document from an Existing Document Topic B: Create a PDF Document from a Web Page Topic C: Combine Multiple PDF Documents 3 - Navigating Content in a PDF Document Topic A: Perform a Search in a PDF Document Topic B: Search Multiple PDF Documents Topic C: Work with Bookmarks Topic D: Create Links and Buttons 4 - Modifying PDF Documents Topic A: Manipulate PDF Document Pages Topic B: Edit Content in a PDF Document Topic C: Add Page Elements 5 - Reviewing PDF Documents Topic A: Add Comments and Markup Topic B: Compare PDF Documents Topic C: Initiate and Manage a Review Topic D: Digitally Sign PDF Documents 6 - Converting PDF Files Topic A: Reduce the File Size of a PDF Document Topic B: Optimize PDF Files Topic C: Convert and Reuse PDF Document Content

***HGV, Transport and Logistics Management Training - CPD Accredited*** HGV driving is a valuable, rewarding and secure career in the UK, and the demand for HGV drivers through HGV, Transport and Logistics Management Training has also increased over the years. Getting a job as a driver with HGV training isn't very difficult compared to other jobs. Through HGV training and experience, you can eventually become an HGV instructor and even move into management. The starting salary as an HGV driver often starts at £19,000, and with time & experience, you can earn up to £36,000 to £40,000. As an instructor or manager, you will approximately earn more than £40,000. Our HGV training bundle course will introduce you to transport management, driver safety, car mechanic and repair, vehicle routing problems, driving instructor, logistic management, and so much more. Along with this HGV, Transport and Logistics Management Trainingcourse, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. This HGV, Transport and Logistics Management Training Bundle Consists of the following Premium courses: Course 01: Large Goods Vehicle (LGV) Course 02: Transport Management Diploma Course 03: Freight Consultant Training Course 04: Vehicle Routing Problem with Spreadsheet Course 05: Driving Instructor Course 06: Driver Safety Awareness Certificate - CPD Certified Course 07: Car Mechanic and Repair Training Course 08: Engine Lubricant System Training - Level 4 Course 09: Import/Export Processing Course 10: Logistic Management Course 11: Manual Handling Level 2 Learning Outcomes Obtain the Large Goods Vehicle (LGV) qualification. Earn the Transport Management Diploma. Become a certified Freight Consultant. Solve the Vehicle Routing Problem using spreadsheet software. Obtain the Driving Instructor qualification (optional). Earn the Driver Safety Awareness Certificate. Understand and apply mechanic and repair techniques. Gain knowledge and apply engine lubrication systems. Describe and apply import/export processing principles. Learn and apply logistics management concepts. So, enrol now in this HGV, Transport and Logistics Management Training to advance your career! Curriculum of HGV, Transport and Logistics Management Training Bundle Course 01: Heavy Goods Vehicle (HGV) Module 01: Knowing Your LGV Module 02: Characteristics of Vehicle Module 03: Vehicle Limit Module 04: Loads and Load Restraint Module 05: Drivers' Hours and Records Module 06: Vehicles and Driving Module 07: Health and Conduct Module 08: Your LGV Module 09: Qualified LGV Driver Module 10: Provisional LGV Licence Module 11: CPC Test Part 01 and 02 Module 12: CPC Test Part 03 and 04 CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this HGV, Transport and Logistics Management Training. Requirements Our HGV, Transport and Logistics Management Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. Career path HGV, Transport and Logistics Management Training HGV Driver (£26,000 - £35,000 per year) Transport Manager (£30,000 - £45,000 per year) Freight Consultant (£30,000 - £40,000 per year) Driving Instructor (£30,000 - £40,000 per year) Vehicle Mechanic (£25,000 - £35,000 per year) Logistics Manager (£30,000 - £50,000 per year) Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Transport Management Diploma) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Introduction: Unlock the power of Microsoft Excel with this comprehensive four-course bundle. Gaining mastery of Macros, you'll move through beginner, intermediate, and advanced levels. Solidify your knowledge and refine your skills with each step, and become an Excel expert. This Microsoft Excel course caters to beginner, intermediate, and advanced levels. It aims to provide students with a comprehensive understanding of Excel, a powerful spreadsheet software that is widely used in business and other industries. For Beginners, the course covers the basics of Excel, including creating and formatting worksheets, entering data, and performing calculations using formulas and functions. Students will also learn how to create charts and graphs to display data visually. For Intermediate learners, the course delves deeper into Excel's functionalities, including sorting and filtering data, conditional formatting, and basic data analysis using PivotTable and PivotChart. They will also learn how to use macros to automate repetitive tasks and increase productivity. For Advanced learners, the course covers advanced Excel features such as complex formulas, array functions, and advanced charting techniques. Students will also learn how to use Excel's VBA (Visual Basic for Applications) programming language to create custom macros and automate complex tasks. Overall, this course is designed to provide students with a solid foundation in using Microsoft Excel at all levels. Whether a beginner, intermediate or advanced user, the course will equip them with the necessary skills to manage and analyze data effectively, increasing their productivity and efficiency.

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 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. Tailored in company training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. Career path Career path Microsoft Office 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

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 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. Tailored in company training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. Career path Career path Microsoft Office 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

Course Objectives At the end of this course you will be able to: Collaborate on documents Add reference marks and notes Make long documents easier to use Secure a document Work with forms '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. Collaborating on Documents Modify User Information Share a Document Compare Document Changes Review a Document Merge Document Changes Review Tracked Changes Coauthor Documents Adding Reference Marks and Notes Add Captions Add Cross-References Add Bookmarks Add Hyperlinks Insert Footnotes and Endnotes Add Citations and a Bibliography Simplifying and Managing Long Documents Insert Blank and Cover Pages Insert an Index Insert a Table of Contents Insert an Ancillary Table Manage Outlines Create a Master Document Securing a Document Suppress Information Set Formatting and Editing Restrictions Add a Digital Signature to a Document Restrict Document Access Forms Create Forms Manipulate Forms Who is this course for? Who is this course for? This course is designed for users who would like to create and work with lengthy and well structured documents, collaborate with others on documents, and create forms in Microsoft Word Requirements Requirements Preferably, delegates should have attended the Word Intermediate course. Career path Career path Microsoft Office 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