293 Spreadsheet courses in Bradford delivered On Demand

Course Overview Take your spreadsheet skills to the next level and become a Pivot Table pro, with this step-by-step instructor-guided training course. The Excel Pivot Tables Crash Course course will equip you with the practical skills to analyse large sets of information quickly and efficiently using Excel Pivot Tables. It will teach you how to perform a diverse range of tasks such as creating reports, using Pivot Table data for market analytics, identifying trends, and calculating profit. This course is open to learners of all levels. It is ideal for financial and market analysts, administrative assistants, project managers, and anyone whose role involves working with spreadsheet data. Gain in-demand analytical skills and learn up-to-date best practices by learning from the experts. This best selling Excel Pivot Tables Crash Course has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Excel Pivot Tables Crash Course is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Excel Pivot Tables Crash Course is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Excel Pivot Tables Crash Course is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Excel Pivot Tables Crash Course, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Excel Pivot Tables Crash Course will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Excel Pivot Tables Crash Course to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Course Overview Enjoy better spreadsheet management and learn how to carry out everyday data-based tasks in Excel with expertise, with this complete Excel functions masterclass.  Through video guidance, the Simple but Powerful Functions in Microsoft Excel course will take you through the basic functions and features of Excel step-by-step. You will learn how to create pivot tables, use text formulas, search a value in a column, and carry out other typical spreadsheet tasks, gaining valuable office skills that will help you gain a competitive edge in your field. Are you looking to build your efficiency in Excel? Go from beginner to expert and build full proficiency in no time, by mastering Excel's core functions today. No previous experience is needed to take this course. Enrol as a full-time or part-time learner and add new skills to your CV. This best selling Simple but Powerful Functions in Microsoft Excel has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Simple but Powerful Functions in Microsoft Excel is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Simple but Powerful Functions in Microsoft Excel is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Simple but Powerful Functions in Microsoft Excel is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Simple but Powerful Functions in Microsoft Excel, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Simple but Powerful Functions in Microsoft Excel will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Simple but Powerful Functions in Microsoft Excel to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

A comprehensive and detailed course containing premium beginner, intermediate, and advanced level content. Start with the fundamentals and build a strong foundation before gradually studying Excel 2021's advanced features, formulae, and functions that will help you become a master.

Learn about AutoCAD to Excel - VBA Programming Hands-On! from industry experts and boost your professional skill. This AutoCAD to Excel - VBA Programming Hands-On! course will enhance your skill and make you ready for the job market. You'll get expert opinions about the best practices and problems of AutoCAD to Excel - VBA Programming Hands-On!. You'll also gain the skills of AutoCAD to Excel - VBA Programming Hands-On! to excel in your job and tips to master professional skills in no time.  You'll be connected with the community of AutoCAD to Excel - VBA Programming Hands-On! professionals and gain first-hand experience of AutoCAD to Excel - VBA Programming Hands-On! problem-solving. The AutoCAD to Excel - VBA Programming Hands-On! is self-paced. You can complete your course and submit the written assignment in your suitable schedule. After completing the AutoCAD to Excel - VBA Programming Hands-On!, you'll be provided with a CPD accredited certificate which will boost your CV and help you get your dream job.  This AutoCAD to Excel - VBA Programming Hands-On! will provide you with the latest information and updates of AutoCAD to Excel - VBA Programming Hands-On!. It will keep you one step ahead of others and increase your chances of growth. Why buy this AutoCAD to Excel - VBA Programming Hands-On!? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the AutoCAD to Excel - VBA Programming Hands-On! there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This AutoCAD to Excel - VBA Programming Hands-On! does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Prerequisites This AutoCAD to Excel - VBA Programming Hands-On! was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This AutoCAD to Excel - VBA Programming Hands-On! is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum 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 Assignment Assignment - AutoCAD to Excel - VBA Programming Hands-On! 00:00:00

FREE Level 5 QLS Endorsed Certificate | 11 CPD Courses+11 PDF Certificates| 145 CPD Points | Installment Payment

Description:  This Microsoft Office 2010 Excel Beginners - Complete Video Course will teach you the basic functions and features of Excel 2010. After an introduction to spreadsheet terminology and Excel's window components, you will learn how to use the Help system and navigate worksheets and workbooks. Then you will enter and edit text, values, formulas, and pictures, and you will save workbooks in various formats. You will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course is designed to introduce you to using Microsoft Excel if you're unfamiliar with any major aspect of it. The series will lead you through the fundamentals of creating and working with Excel spreadsheets. Today's Excel spreadsheet isn't just for financial professionals. Microsoft Excel offers intuitive tools that make it easy to access, connect, and analyze critical data-regardless of your profession. 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? Microsoft Office 2010 Excel Beginners - 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 Microsoft Office 2010 Excel Beginners - 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. Getting Started Spreadsheet Terminology FREE 00:02:00 The Excel Environment 00:05:00 Getting Help 00:03:00 Navigating a Worksheet 00:06:00 Entering and Editing Data Entering and Editing Text and Values 00:09:00 Entering and Editing Formulas 00:09:00 Working with Pictures 00:03:00 Saving and Updating Workbooks 00:07:00 Modifying a Worksheet Moving and Copying Data 00:13:00 Moving and Copying Formulas 00:07:00 Absolute and Relative References 00:06:00 Inserting and Deleting Ranges, Rows, and Columns 00:07:00 Functions Entering Functions 00:15:00 AutoSum 00:04:00 Other Common Functions 00:11:00 Formatting Text Formatting 00:06:00 Column Formatting 00:12:00 Number Formatting 00:06:00 Conditional Formatting 00:10:00 Additional Formatting Options 00:12:00 Printing Preparing to Print 00:09:00 Page Setup Options 00:14:00 Printing Worksheets 00:04:00 Charts Chart Basics 00:11:00 Formatting Charts 00:05:00 Managing Large Workbooks Viewing Large Worksheets 00:14:00 Working with Multiple Worksheets 00:12:00 Printing Large Worksheets 00:08:00 Graphics and Screenshots Conditional Formatting with Graphics 00:09:00 SmartArt Graphics 00:05:00 Screenshots 00:05:00 Mock Exam Mock Exam- Microsoft Office 2010 Excel Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Excel Beginners - Complete Video Course 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview Boost your career opportunities within the IT industry and learn new abilities with the latest technology and software. Today's businesses rely on IT systems to support them, so this course will quickly upgrade your skills and allow you to apply for the latest roles. The Essential IT Skills Level 3 course provides you with all the knowledge needed to master every primary IT process. You will be explicitly taught how to produce professional spreadsheets and presentations with the standard Microsoft software. All this will be accompanied by varied tips and recommendations on approaching IT assignments and how to make the best impressions at work. 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 Essential IT Skills Level 3. It is available to all students, of all academic backgrounds. Requirements Our Essential IT Skills Level 3 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 12 lectures • 04:00:00 total length •Module 01: Introduction: A Transforming Technology: 00:30:00 •Module 02: Importance of Information Technology: 00:10:00 •Module 03: Communication and Network: 00:30:00 •Module 04: Future Skills Required in Information Technology: 00:15:00 •Module 05: Technology as a Foundation Skill Area: 00:10:00 •Module 06: Word Processing Software: 00:30:00 •Module 07: Presentation Software: 00:30:00 •Module 08: Creating and Editing Spreadsheet (Part 1: The Basics of Spreadsheets): 00:15:00 •Module 09: Creating and Editing Spreadsheet (Part 2: Navigation and Edit): 00:25:00 •Module 10: Storing Database: 00:25:00 •Module 11: Information Technology Project Management: 00:20:00 •Assignment - Essential IT Skills Level 3: 00:00:00

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