3371 Courses

Become an expert in Microsoft Excel with our comprehensive online training program. Learn formulas, charts, pivot tables, data analysis, macros, and more. Develop in-demand Excel skills through hands-on exercises and project work. Gain proficiency in this powerful software to advance your career or improve productivity.

Picture this: You're seated in a bustling café, sipping your favourite tea while effortlessly managing and guiding clients through the complex maze of the UK tax system. How did you acquire this expertise? Welcome to 'Tax Accounting and Administration in the UK'.  In the heart of the bustling financial industry lies the intricate tapestry of taxation. The United Kingdom, with its myriad tax regulations, beckons those brave enough to navigate its depths. Enter the realm of personal tax accounts and the HMRC personal tax account system. This course, 'Tax Accounting and Administration in the UK', offers an explorative journey through the UK's dynamic tax landscape. Harnessing the power of tax and accounting, this curriculum doesn't just deliver facts, but it paints a vibrant picture of the complex, ever-changing financial framework of the nation. Whether you're a novice or a seasoned professional, the world of UK taxation is vast, and this course is your guiding star. Learning Outcomes: Understanding the structure and functions of the UK's tax system and administration. Comprehending the taxation protocols affecting individuals. Gaining insights into the role and importance of National Insurance. Mastering the process of submitting a self-assessment tax return. Diving deep into the core concepts of income tax. Acquiring knowledge about Payee, Payroll, Wages, and their interrelation. Becoming proficient in the various tax categories such as Value Added Tax and Corporation Tax. Video Playerhttps://studyhub.org.uk/wp-content/uploads/2021/04/Tax-Accounting-and-Administration-in-the-UK.mp400:0000:0000:00Use Up/Down Arrow keys to increase or decrease volume. Why buy this Tax Accounting and Administration in the UK course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Level 5 Diploma in Tax Accounting and Administration in the UK at QLS 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. Who is this Tax Accounting and Administration in the UK course for? Aspiring accountants keen to specialise in the taxation field. Business owners aiming to comprehend the UK tax implications for their enterprise. Finance students desiring a comprehensive grasp on UK taxation. Professionals in the financial sector looking to enhance their portfolio with tax expertise. Consultants aiming to provide informed tax advice to their clientele. Career path Tax Accountant: Average Salary: £35,000-£55,000 Per Annum Management Accountant: Average Salary: £30,000-£50,000 Per Annum Financial Analyst: Average Salary: £32,000-£60,000 Per Annum Payroll Manager: Average Salary: £25,000-£45,000 Per Annum VAT Specialist: Average Salary: £40,000-£60,000 Per Annum Corporate Tax Manager: Average Salary: £50,000-£75,000 Per Annum Prerequisites This Level 5 Diploma in Tax Accounting and Administration in the UK at QLS does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Level 5 Diploma in Tax Accounting and Administration in the UK at QLS 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. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £115 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Tax Accounting and Administration in the UK Tax System and Administration in the UK 00:27:00 Tax on Individuals 00:25:00 National Insurance 00:15:00 How to Submit a Self-Assessment Tax Return 00:15:00 Fundamentals of Income Tax 00:25:00 Payee, Payroll and Wages 00:21:00 Value Added Tax 00:21:00 Corporation Tax 00:20:00 Double Entry Accounting 00:14:00 Management Accounting and Financial Analysis 00:17:00 Career as a Tax Accountant in the UK 00:19:00 Assignment Assignment - Level 5 Diploma in Tax Accounting and Administration in the UK at QLS 00:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Overview Learn about Mastering Accountancy and Xero from industry experts and boost your professional skill. This Mastering Accountancy and Xero 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 Mastering Accountancy and Xero. You'll also gain the skills of Mastering Accountancy and Xero to excel in your job and tips to master professional skills in no time.  You'll be connected with the community of Mastering Accountancy and Xero professionals and gain first-hand experience of Mastering Accountancy and Xero problem-solving. The Mastering Accountancy and Xero  is self-paced. You can complete your course and attend the examination in your suitable schedule. After completing the Mastering Accountancy and Xero, you'll be provided with a CPD accredited certificate which will boost your CV and help you get your dream job.  This Mastering Accountancy and Xero will provide you with the latest information and updates of Mastering Accountancy and Xero. It will keep you one step ahead of others and increase your chances of growth. Why buy this Mastering Accountancy and Xero? 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 Mastering Accountancy and Xero 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 Mastering Accountancy and Xero does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Prerequisites This Mastering Accountancy and Xero 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 Mastering Accountancy and Xero is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Mastering Accountancy and Xero Module : 01 Chris Moore - Accounting 00:01:00 Chris Moore - 1. Introduction 00:03:00 Chris Moore - 2. First Transactions 00:05:00 Chris Moore - 3. T Accounts introduction 00:03:00 Chris Moore - 4. T-Accounts conclusion 00:03:00 Chris Moore - 5. Trial Balance 00:02:00 Chris Moore - 6. Income Statement 00:03:00 Chris Moore - 7. Balance Sheet 00:03:00 Module : 02 Chris Moore - 8. Balance Sheet Variations 00:03:00 Chris Moore - 9. Accounts in practise 00:05:00 Chris Moore - 10. Balance Sheets what are they 00:05:00 Chris Moore - 11. Balance Sheet Level 2 00:03:00 Chris Moore - 12. Income Statement Introduction 00:06:00 Chris Moore - 13. Are they Expenses, or Assets 00:03:00 Chris Moore - 14. Accounting Jargon 00:02:00 Module : 03 Chris Moore - 15. Accruals Accounting is Fundamental 00:03:00 Chris Moore - 16. Trial Balance 3 days ago More 00:04:00 Chris Moore - 17. Fixed Assets and how it is shown in the Income Statement 00:03:00 Chris Moore - 18. Stock movements and how this affects the financials 00:03:00 Chris Moore - 19. Accounts Receivable 00:03:00 Chris Moore - 20. How to calculate the Return on Capital Employed 00:05:00 Chris Moore - 21. Transfer Pricing - International Rules 00:02:00

Businesses will always require sharp minds to navigate the intricate maze of regulations and predict potential threats. Acting as the watchdogs of an organisation,Compliance and Risk Management professionals ensure all procedures align with legislative standards and anticipate risks that could threaten business stability. According to UK statistics, there's a soaring 15% demand for experts in Compliance and Risk Management. In fact, the salary range lies between £40,000 to £100,000 per annum, depending on experience and roles. Our Compliance and Risk Management course dives deep into the fundamental topics of this discipline: from understanding the basics of compliance to the intricacies of compliance and risk management. With a Compliance and Risk Management comprehensive curriculum covering eight vital modules, including Compliance Audit, Ethics, and the Risk Management Process, our course offers a thorough theoretical grounding. By the end of your journey with us, you'll have a robust understanding, preparing you for a prosperous career in Compliance and Risk Management. Compliance and Risk Management Course Learning Outcomes: Master key concepts in Compliance and Risk Management. Comprehend Compliance's Five Essential Elements. Explore the intricacies of Compliance Management System (CMS). Decode the Compliance Audit methodology. Emphasise Ethics within Compliance and Risk Management frameworks. Identify diverse Risk categories in Compliance and Risk Management. Understand the Compliance and Risk Management procedural flow. Join today, be skilled, learn Compliance and Risk Management with positive energy and enthusiasm, create an excellent career using your full potential! Become the best in the Compliance and Risk Management business. Get Started Now. Upon completing this comprehensive Compliance and Risk Management course, you will be able to: Gain in-depth knowledge on what compliance is and the importance of compliance Get familiar with the five basic elements of compliance and processes Get introduced to Compliance Management System along with the elements of CMS Know the compliance audit in detail and acquire the skills to conduct a audit Explore the differences between ethics and compliance Be aware of what risk is and all the different types of risks Have a deep understanding of risk management, its objectives and concepts Gain intensive knowledge and skills to carry out a risk management process Diploma in Compliance and Risk Management Course Curriculum Course Curriculum : Module 1: Introduction to Compliance Module 2: Five Basic Elements of Compliance Module 3: Compliance Management System (CMS) Module 4: Compliance Audit Module 5: Compliance and Ethics Module 6: Risk and Types of Risk Module 7: Introduction to Risk Management Module 8: Risk Management Process CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Compliance Central aims to prepare efficient human resources for the industry and make it more productive than ever. This helpful course is suitable for any person who is interested in Compliance and Risk Management. There are no pre-requirements to take it. You can attend the course if you are a student, an enthusiast or a Employee Employer Manager Supervisor Entrepreneur Business Professional Company Leader HR Professional Requirements This Compliance and Risk Management course has no requirements. Career path This Compliance and Risk Management course will help you with the fundamentals of compliance and risk management. This course will provide all the essential competencies to explore a plethora of exciting work opportunities, such as - Consultant Officer Risk Manager Risk & Compliance Investigator These opportunities pay an average of £20,000 to £65,000 a year in the UK. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Turn Your Dreams into Reality with the Excel Analyst - Excel Data Analysis and Visualisation Course Training course. This comprehensive Excel Analyst - Excel Data Analysis and Visualisation Course online course will equip you with the knowledge and skills you need to succeed in your chosen field. Whether you're a beginner or looking to take your career to the next level, this course has covered you. Key Learning Outcomes: Understanding the core concepts and theories in your field Building your knowledge and skills through practical, hands-on learning Developing the ability to think critically and solve problems effectively Enhancing your communication skills and the ability to work effectively with others Gaining a competitive edge in your career and reaching your full potential With a flexible online format that allows you to learn at your own pace, Excel Analyst - Excel Data Analysis and Visualisation Course training course offers a convenient and accessible way to boost your career prospects. So why wait? Enrol today and take the first step towards success! Vital Component of the Excel Analyst - Excel Data Analysis and Visualisation Course course: CPD Accredited Course Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials 100% Learning Satisfaction Guarantee Lifetime Access & 24/7 Support Self-paced online course Modules Covers to Explore Multiple Job Positions Transform your career with the Excel Analyst - Excel Data Analysis and Visualisation Course Bundle! Perfect your skills and stand out in the employment market with our comprehensive training program. Impress potential employers and add valuable expertise to your resume. Don't wait-enrol in the Excel Analyst - Excel Data Analysis and Visualisation Course Bundle now and take the first step towards a successful and fulfilling career! Course Outline: Modifying a Worksheet Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and PivotCharts Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is the perfect fit for anyone seeking to start or advance in the Excel Analyst - Excel Data Analysis and Visualisation Course industry. Whether you're a beginner or looking to expand your knowledge, this comprehensive training will provide you with the essential skills and expertise to succeed. Requirements Join the Excitement-With this Excel Analyst - Excel Data Analysis and Visualisation Course course, there's no limit to what you can achieve. From day one, you'll be on your way to building a fulfilling career in this thriving field. No prior experience is required to enrol in this course. Career path Upon completion, you'll have the opportunity to pursue a variety of in-demand Excel Analyst - Excel Data Analysis and Visualisation Course jobs, with endless possibilities for growth and success. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Secure workplace health with our COSHH Training. Master regulatory compliance, identify hazardous substances, conduct risk assessments, and implement safety measures. This course is essential for anyone managing or working with hazardous materials.

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Diploma in Data Entry & Management will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Diploma in Data Entry & Management will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Diploma in Data Entry & Management and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Diploma in Data Entry & Management is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Diploma in Data Entry & Management. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Diploma in Data Entry & Management will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum **Data Entry And Management** Introduction to Data Entry 00:20:00 Data Management 00:20:00 Using the Computer for Data Entry 00:15:00 Common Rules and Guidelines for Data Entry 00:30:00 Using Excel for Efficient Data Entry 00:30:00 Using Excel's Flash Fill and Autofill to Automate Data Entry 00:30:00 How to Create a Data Entry Form in Excel? 00:45:00 Using Statistics Packages in Data Entry 00:45:00 **Basics Of MS Excel** Getting Started With Microsoft Office Excel 2016 Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying A Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting A Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Microsoft Excel assists you to perform with different programs such as calculation, macro program language, pivot tablets, graphics tools, and various applications within time. Learn much more precise use of these functions with the easiest and effective method thorough Microsoft Office 2016 Excel Beginners course. The course teaches you the basic functions of Excel. It instructs you how to open Excel files, make a simple calculation, and save it. It also teaches you how to put data, extract data, analyze actionable information, and perform in different ways. The purpose of the course is to enhance your ability to kick-start your career in a sound bite. Who is this Course for? Microsoft Office 2016 Excel Beginners is 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. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Mock Exam Mock Exam- Microsoft Office 2016 Excel Beginners 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Beginners 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

This Microsoft Office 2007 Excel Intermediate will provide you with experience at creating more elaborate worksheet and workbooks n Microsoft Office Excel 2007 to display data in more effective ways. In this series you will work with multiple worksheets and workbooks, you will learn how to switch between workbooks and even copy worksheets, you will also get 3D formulas: 3D formulas will allow you to link the worksheets, and also add something call the Watch-Window. You will learn to create and manage all these linked workbooks as well as creating workspaces which will allow you to manage the workbook as well. Before getting this course you must have the basic skills of Microsoft Excel 2007. This level will give you an advanced knowledge you need to know about Microsoft Excel. Who is this Course for? Microsoft Office 2007 Excel Intermediate is 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. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Course Curriculum Using Multiple Worksheets and Workbooks Using Multiple Workbooks 00:04:00 Linking Worksheets with 3-D Formulas 00:06:00 Linking Workbooks 00:11:00 Managing Workbooks 00:04:00 Advanced Formatting Using Special Number Formats 00:17:00 Using Functions to Format Text 00:13:00 Working with Styles 00:07:00 Working with Themes 00:11:00 Other Advanced Formatting 00:13:00 Outlining and Subtotals Outlining and Consolidating Data 00:11:00 Creating Subtotals 00:06:00 Cell and Range Names Creating and Using Names 00:12:00 Managing Names 00:04:00 Lists and Tables Examining Lists 00:03:00 Sorting and Filtering Lists 00:07:00 Advanced Filtering 00:12:00 Working with Tables 00:22:00 Web and Internet Features Saving Workbooks as Web Pages 00:11:00 Using Hyperlinks 00:04:00 Distributing Workbooks 00:03:00 Advanced Charting Chart Formatting Options 00:08:00 Combination Charts 00:05:00 Graphic Elements 00:09:00 Documenting and Auditing Auditing Features 00:05:00 Creating A Body Of Work 00:03:00 Protection 00:05:00 Workgroup Collaboration 00:13:00 Templates and Settings Application Settings 00:05:00 Built-in Templates 00:07:00 Creating and Managing Templates 00:10:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

In the Microsoft Excel for Beginners course, learners will be given a full introduction to the features and functions of Excel, taking their proficiency from beginner to advanced level in no time. We offer step-by-step guidance for managing everyday tasks, such as modifying a worksheet, managing workbooks, performing calculations and entering financial data. The principles and practices of SEN teaching and supporting children with learning difficulties is also covered in this comprehensive course. Learning Objectives: Master day-to-day office tasks and manage important work data with Microsoft Excel Learn how to modify and format worksheets in Excel Get step-by-step guidance on how to print and manage workbooks Be able to perform basic calculations and data-inputting tasks Who is this Course for? Microsoft Excel For Beginners is 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 Excel For Beginners 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. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Microsoft Excel Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00