374 Spreadsheet courses delivered Online

Course Objectives At the end of this course you will be able to: Identify the components of the PowerPoint interface Create slides Format text on slides Add and modify graphical objects to a presentation Work with tables in a presentation Add charts to a presentation Prepare the SlideShow '1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Very patient Trainer. Happy to adapt course + help with problems on existing presentations. Andrea Lethbridge - CNN ' 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. Getting Started with PowerPoint Identify the Components of the PowerPoint Interface Create a PowerPoint Presentation Accessing Help Choose the right view for the task in PowerPoint Normal view Slide Sorter view Notes Page view Outline view Add, rearrange, and delete slides in PowerPoint Working with Themes Add colour and design to my slides with themes Remove the current slide design (theme) Slide Layout What is a slide layout? Apply or change a slide layout Working with text Add text to a slide Create a new text box Format text Tables Add a table to a slide Format a Table Copy and paste a table from Word Insert an Excel spreadsheet within PowerPoint Edit Cells, Rows and Columns Delete a table Graphics Working with Clipart, and Shapes Selecting objects, shapes, pictures or text boxes Arrange a picture, shape or other object Adding Charts to Your Presentation Create a Chart Format a Chart Insert a Chart from Microsoft Excel Inserting date and slide numbers Add slide numbers to your presentation Hide slide numbers on the title slide Change where the page numbers appear on your slides Start your slide numbering with a specific number Print slides, notes, or handouts Create the Slide Show Record your slide show Preview the recorded slide show Turn slide timings off Set the slide timings manually Add or remove transitions between slides Add Animations to Text and Objects Deliver the Presentation Speakers notes Add speaker notes to your slides View your speaker notes as you deliver your slide show Who is this course for? Who is this course for? This course is designed for end users who are interested in learning the fundamentals needed to create and modify engaging presentations. Requirements Requirements General knowledge of the Windows OS 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

The 'Level 1 - IT Support Help Desk Technician' course offers a comprehensive diploma in IT skills and technology, covering various essential aspects of information technology. Participants will gain insights into transforming technologies, the significance of IT, communication and networking, future IT skills, word processing, presentation software, spreadsheet creation and editing, database management, and information technology project management. Learning Outcomes: Understand the significance of information technology and its role in transforming various industries. Acquire essential communication and networking skills required in the field of IT support. Identify future IT skills and technologies to stay relevant in the ever-evolving IT landscape. Gain proficiency in word processing software and use it effectively for various tasks. Develop presentation skills and utilize presentation software to create impactful presentations. Master spreadsheet creation, navigation, and editing to handle data efficiently. Learn the basics of storing and managing databases for organized data handling. Acquire knowledge of information technology project management to effectively plan and execute IT projects. Why buy this Diploma in IT Skills and Technology? 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 Diploma in IT Skills and Technology you will be able to take the MCQ test that will assess your knowledge. 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 Diploma in IT Skills and Technology does not require you to have any prior qualifications or experience. You can just enrol and start learning. Prerequisites This Diploma in IT Skills and Technology 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 Diploma in IT Skills and Technology is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Level 1 - IT Support Help Desk Technician 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 Mock Exam Mock Exam - Level 1 - IT Support Help Desk Technician 00:20:00 Final Exam Final Exam - Level 1 - IT Support Help Desk Technician 00:20:00

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.