374 Spreadsheet courses delivered Online

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classroom, one to one, tailored and bespoke courses. Tailored In company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Gain the solid skills and knowledge to kickstart a successful career and learn from the experts with this

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Embark on a captivating journey into the world of numbers and ledgers with our Business Accounting Training course. From unraveling the mysteries of the accounting equation to mastering the art of financial statement preparation, this course is your gateway to becoming a financial maestro. The adventure begins with a comprehensive introduction to accounting and business principles, ensuring a solid foundation for the intricate dance of transactions and adjustments. Guided by seasoned professionals, dive into the adjusting process, worksheet preparation, and the completion of the accounting cycle. Immerse yourself in a spreadsheet exercise that brings theory to life. This course isn't just about numbers; it's about unlocking the secrets to financial acumen and becoming the architect of your financial success. Learning Outcomes Gain a profound understanding of the accounting equation and its role in financial transactions. Analyze and interpret complex financial transactions with confidence. Master the art of posting entries and the adjustment process for accurate financial reporting. Acquire skills in preparing comprehensive financial statements. Navigate the accounting cycle seamlessly, illustrating fiscal year concepts with ease. Why choose this Business Accounting Training course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Business Accounting Training course for? Aspiring accountants eager to kickstart their career in finance. Small business owners looking to manage their own accounts effectively. Students pursuing studies in accounting or finance. Entrepreneurs seeking a comprehensive understanding of business accounting. Professionals aiming to enhance their financial literacy. Career path Junior Accountant: £22,000 - £30,000 Bookkeeper: £20,000 - £28,000 Financial Analyst: £28,000 - £40,000 Accounting Manager: £35,000 - £50,000 Finance Controller: £40,000 - £60,000 Chief Financial Officer (CFO): £60,000 and above Prerequisites This Business Accounting Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Business Accounting Training 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Professional Bookkeeper Introduction Professional Bookkeeper 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:12: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

Course Overview Discover the fastest and most effective way to master Microsoft Excel online. The Upgrade Excel Skill: 50 Tips course will take you from beginner to pro in Excel in no time, with 50 expert tips that are guaranteed to boost your productivity.  Microsoft Excel is the leading spreadsheet software across the globe. Through this complete masterclass, you will build your proficiency in Excel in just one week, equipping you with transferable skills that can be applied to a wide range of office roles. It will teach you how to apply advanced filters, navigate between worksheets seamlessly, conduct quick data analysis, and much more. Maximise your spreadsheet management skills, add value to your CV, and boost your productivity in the office by learning Excel's key tips and shortcuts! This best selling Upgrade Excel Skill: 50 Tips has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Upgrade Excel Skill: 50 Tips is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Upgrade Excel Skill: 50 Tips 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 Upgrade Excel Skill: 50 Tips 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 Upgrade Excel Skill: 50 Tips, 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 Upgrade Excel Skill: 50 Tips 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 Upgrade Excel Skill: 50 Tips 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 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