40551 Courses delivered Online

Learn to Drive Traffic into Sales through Digital Marketing Course Overview This course on "Learn to Drive Traffic into Sales through Digital Marketing" provides learners with the essential skills to effectively use digital marketing strategies to attract, engage, and convert online traffic into sales. Covering key areas such as SEO, social media marketing, content creation, and email marketing, the course equips learners with the knowledge to optimise digital campaigns and enhance business visibility. The course is designed for individuals seeking to master digital marketing techniques to increase online sales and drive business growth. By the end of the course, learners will have a comprehensive understanding of traffic generation strategies and how to convert them into tangible business results. Course Description In this course, learners will explore various digital marketing techniques aimed at driving traffic to websites and converting that traffic into sales. Topics include SEO fundamentals, social media marketing strategies, email marketing campaigns, and creating compelling content. The course provides a structured approach to understanding how to leverage these strategies effectively, using data analytics to track and improve performance. Learners will gain the ability to create digital marketing plans, monitor campaign success, and optimise strategies to enhance online sales. The course is designed for those who want to advance their digital marketing skills and improve conversion rates, whether for personal projects or within their professional roles. Learn to Drive Traffic into Sales through Digital Marketing Curriculum Module 01: Introduction to Digital Marketing Module 02: SEO Strategies for Traffic Growth Module 03: Social Media Marketing for Engagement Module 04: Email Marketing to Convert Leads Module 05: Creating Content that Converts Module 06: Analytics and Campaign Optimisation (See full curriculum) Who is this course for? Individuals seeking to increase their online sales through digital marketing. Professionals aiming to enhance their digital marketing knowledge and career prospects. Beginners with an interest in driving business growth via online channels. Entrepreneurs wanting to optimise their digital marketing efforts. Career Path Digital Marketing Specialist SEO Manager Social Media Manager Content Marketing Strategist Email Marketing Coordinator E-commerce Manager

Certificate in Lash and Brow Treatments Course Overview The "Certificate in Lash and Brow Treatments" offers an in-depth exploration into the techniques and skills required to perform high-quality lash and brow services. This course provides learners with comprehensive knowledge of brow lamination, tinting, and waxing, empowering them to build a solid foundation in the beauty industry. By the end of the course, learners will be equipped with the expertise to enhance their clients' lash and brow aesthetics with precision and care. Whether aiming to start a new career or add specialised skills to an existing beauty practice, this course is designed to offer a valuable skill set that meets the growing demand in the beauty market. Course Description This course covers a wide range of essential topics, including the tools and materials needed for lash and brow treatments, client consultations, and understanding contraindications to ensure safety. Learners will explore techniques such as tinting, brow lamination, and waxing, with video demonstrations of each process to provide detailed, step-by-step guidance. Additionally, bonus training on lash tinting will deepen learners' knowledge of the full range of lash and brow treatments. Throughout the course, learners will gain essential skills to perform these services with confidence and professionalism, ensuring a high standard of client satisfaction and safety. On completion, learners will receive a certificate recognising their new expertise in the beauty industry. Certificate in Lash and Brow Treatments Curriculum Module 01: Introduction Module 02: Things You Will Need for Your Treatment Module 03: Consultation and Patch Test Module 04: Contra-Indications Module 05: Tinting Module 06: Brow Lamination Video Module 07: Waxing Demo Videos Module 08: Bonus Lash Tint Training Module 09: Certificate Time (See full curriculum) Who is this course for? Individuals seeking to enhance their beauty therapy skills. Professionals aiming to specialise in lash and brow treatments. Beginners with an interest in the beauty industry. Beauty enthusiasts looking to expand their expertise. Career Path Brow Artist Lash Technician Beauty Therapist Salon Owner Beauty Consultant

Thai Massage Therapy for Pain Management - Online Diploma Course Overview The "Thai Massage Therapy for Pain Management - Online Diploma" offers an in-depth exploration of Thai massage techniques tailored for pain relief. This course is designed for those who wish to understand the therapeutic potential of Thai massage, equipping learners with the necessary knowledge and skills to apply these techniques effectively. The course covers foundational theories, essential practices, and full massage sequences that can be implemented in pain management treatments. By the end of the course, learners will be able to confidently offer Thai massage sessions focused on alleviating various pain-related conditions, enhancing overall wellbeing, and contributing to improved physical health. Course Description This comprehensive online diploma takes learners through an in-depth study of Thai massage, focusing on its effectiveness in pain management. The course starts with an introduction to the fundamentals of Thai massage therapy, before progressing to specific techniques aimed at relieving muscular and joint pain. It covers a full sequence of massage steps, ensuring learners gain a solid understanding of how each move contributes to pain relief. The content is designed to be easily followed, with clear explanations and structured learning. Throughout, students will develop the skills needed to carry out Thai massage therapy to support clients in managing pain and improving flexibility, ensuring their approach is both effective and holistic. Thai Massage Therapy for Pain Management - Online Diploma Curriculum Module 01: Thai Massage Introduction Module 02: Thai Massage Techniques Step By Step Module 03: The Full Massage Sequence (See full curriculum) Who is this course for? Individuals seeking to improve their knowledge of pain management techniques Professionals aiming to enhance their skill set in therapeutic massage Beginners with an interest in Thai massage or alternative therapies Health and wellness enthusiasts looking to diversify their expertise Career Path Thai Massage Therapist Alternative Medicine Practitioner Pain Management Specialist Holistic Health Consultant Wellness Centre Practitioner

Styling & Staging in Interior Design Course Overview This course offers a comprehensive exploration of styling and staging techniques used in interior design. Learners will gain valuable insights into how to creatively arrange and display furniture, accessories, and decor elements to enhance a space's aesthetic appeal. From styling coffee tables to creating inviting seating areas, this course will equip learners with the knowledge to transform any room. With a focus on practical skills, learners will understand how to approach each space with a strategic eye, elevating their design capabilities for both personal projects and professional use. Course Description Styling & Staging in Interior Design covers a range of key topics to help learners master the art of styling various spaces within a home or commercial property. The course delves into styling techniques for furniture and accessories, including coffee tables, side tables, dining areas, and walls. Learners will also explore how to utilise items like scatter cushions, throw pillows, and art to create balanced and visually appealing designs. The course is structured to provide an enriching learning experience, where learners will develop skills to approach interior styling with confidence, ensuring that each space reflects contemporary trends while maintaining functionality. Styling & Staging in Interior Design Curriculum Module 01: Introduction To Chapters Module 02: Introduction To Styling and Staging In Interior Design Module 03: Styling Coffee Tables Module 04: Styling Side Tables Module 05: Styling Servers and Consoles Module 06: Styling Dining Room Tables Module 07: Styling Book Cases and Display Cases Module 08: Styling with Scatter Cushions and Throw Pillows Module 09: Styling Seating and Sleeping Areas Module 10: Styling Walls with Art and Framing Module 11: Conclusion (See full curriculum) Who is this course for? Individuals seeking to enhance their interior design knowledge. Professionals aiming to broaden their design skill set. Beginners with an interest in styling and staging for interior design projects. Homeowners wanting to improve their living spaces. Career Path Interior Stylist Home Staging Professional Visual Merchandiser Property Stylist Interior Designer

Manual Handling Training Course Overview: This Manual Handling Training course is designed to equip learners with the essential skills and knowledge required to safely handle materials and equipment in various work environments. The course covers key aspects such as identifying manual handling risks, performing risk assessments, and adopting safe techniques for lifting and moving objects. Learners will gain a comprehensive understanding of the importance of safety in manual handling and will be able to implement best practices to prevent accidents and injuries at work. On completion, participants will have a strong foundation in manual handling safety, enhancing both their personal confidence and their ability to contribute to a safer workplace. Course Description: The Manual Handling Training course delves into the core aspects of manual handling safety, focusing on risk identification and mitigation strategies. It covers topics such as the principles of safe lifting, risk assessments, and specific techniques to ensure the safe movement of goods. Learners will be introduced to industry standards for manual handling operations and how to assess potential risks. Throughout the course, participants will gain a solid understanding of how to prevent injuries and accidents caused by improper manual handling, ensuring they are well-prepared to manage and address manual handling concerns in any work setting. The course is designed to provide learners with the necessary knowledge to improve safety standards and reduce the risk of injury in their workplace. Manual Handling Training Curriculum: Module 01: Manual Handling and Work-related Accidents Module 02: Identifying the Manual Handling Risks Module 03: Manual Handling Risk Assessments Module 04: How to Prepare a Manual Handling Operation Module 05: Manual Handling Techniques (See full curriculum) Who is this course for? Individuals seeking to improve workplace safety. Professionals aiming to enhance their health and safety qualifications. Beginners with an interest in workplace safety or health and safety roles. Those looking to comply with safety regulations in manual handling environments. Career Path: Health and Safety Officer Warehouse Supervisor Logistics and Operations Manager Risk Assessor Warehouse Operative

Hotel Cleaner Course Overview: This Hotel Cleaner course is designed to equip learners with the knowledge and skills needed to excel in the hospitality cleaning industry. Covering a broad range of topics, it includes essential cleaning techniques, health and safety practices, and customer service skills tailored for hotel environments. Learners will gain an understanding of the importance of cleanliness and organisation in guest satisfaction. Upon completing the course, learners will be able to confidently perform cleaning duties in various hotel areas, ensuring a safe and welcoming environment for guests. Course Description: The Hotel Cleaner course delves into a variety of topics crucial to maintaining cleanliness and hygiene in hotels. Learners will explore techniques for cleaning guest rooms, public spaces, and facilities while adhering to industry standards. Topics include understanding cleaning equipment, handling chemicals safely, time management, and effective communication with hotel staff and guests. Learners will gain knowledge of the importance of attention to detail, a strong work ethic, and maintaining high cleanliness standards to enhance the guest experience. The course offers a comprehensive overview of the expectations and requirements within the hotel cleaning industry, preparing learners for roles in this sector. Hotel Cleaner Curriculum: Module 01: Introduction to Hotel Cleaning Module 02: Cleaning Techniques for Guest Rooms Module 03: Cleaning Public Spaces and Facilities Module 04: Health and Safety in Hotel Cleaning Module 05: Chemical Handling and Equipment Use Module 06: Time Management and Efficiency Module 07: Customer Service and Communication in Hotel Cleaning Module 08: Maintaining Cleanliness Standards and Best Practices (See full curriculum) Who is this course for? Individuals seeking to work in the hotel cleaning industry. Professionals aiming to improve cleaning and organisational skills. Beginners with an interest in hospitality services. Those looking to develop a career in hotel management or facilities maintenance. Career Path: Hotel Cleaner Housekeeping Assistant Facilities Maintenance Worker Hotel Housekeeping Supervisor Hospitality Industry Cleaner

Block Management Course Overview: This Block Management course provides an in-depth understanding of property management, offering a comprehensive approach to the key responsibilities and skills required for managing residential blocks effectively. Learners will explore the intricacies of managing apartment complexes, dealing with tenant relations, and ensuring regulatory compliance. The course covers essential aspects such as leasing, marketing properties, tenant retention, and property valuation. Upon completion, learners will be equipped to pursue a career in property management with a strong foundation in both theoretical knowledge and practical application. Course Description: The Block Management course is designed to equip learners with the essential knowledge and skills required to manage residential properties efficiently. This course covers a wide array of topics, including property listing and marketing, the letting process, tenant relations, and the management of communal areas. Learners will explore the regulatory framework surrounding property management, including laws and regulations related to tenancy agreements and building compliance. The course is structured to provide both theoretical understanding and practical insights, preparing learners for a successful career in property management. By the end of the course, learners will possess the tools to manage residential properties effectively, ensuring both operational success and tenant satisfaction. Block Management Course Curriculum : Module 01: Introduction to Property Management Module 02: The Role and Responsibilities of a Property Manager Module 03: Listing Properties and Marketing Module 04: The Letting Process and Tenancy Agreement Module 05: The Property Management Process Module 06: Valuation Process Module 07: Selling Property Finding the Buyers Module 08: Keeping Tenants Long Term Module 09: Regulations of Property Management Module 10: Changes in the UK Property Market An Opportunity (See full curriculum) Who is this course for? Individuals seeking to enter property management. Professionals aiming to enhance their property management skills. Beginners with an interest in real estate or property management. Anyone looking to understand the legalities and regulations of property management. Career Path: Property Manager Block Manager Property Administrator Real Estate Consultant Lettings Manager Property Portfolio Manager Facilities Manager

Sourdough Cooking Essentials: Discover Artisan Cooking Course Overview: "Sourdough Cooking Essentials: Discover Artisan Cooking" offers a comprehensive introduction to the art of crafting sourdough-based dishes. This course covers a variety of essential recipes, including sourdough pizza, tortillas, hot dogs, burgers, sandwich bread, and even pasta. Designed for both novices and food enthusiasts, this course provides you with the foundational knowledge and skills needed to incorporate sourdough into everyday meals. By the end, learners will have a deep understanding of sourdough preparation techniques, enabling them to create delicious and authentic artisan dishes at home. Course Description: In this engaging course, you will explore the versatility of sourdough as an ingredient in various meals. The course delves into the intricacies of making sourdough-based pizza, tortillas for burritos, sourdough burgers, and even pasta dishes like chicken Alfredo. Learners will gain skills in fermenting dough, shaping, baking, and pairing sourdough with different fillings for unique and flavourful dishes. Each module will guide you step-by-step through the processes, empowering you to confidently recreate these dishes at home. Whether you are looking to elevate your culinary expertise or try something new, this course provides valuable skills and knowledge to enhance your cooking repertoire. Sourdough Cooking Essentials: Discover Artisan Cooking Curriculum: Module 01: Course Introduction Module 02: Sourdough Pizza Module 03: Sourdough Tortillas Burritos Module 04: Sourdough Hot Dogs Module 05: Sourdough Burgers Module 06: Sourdough Sandwich Bread & BLT Module 07: Sourdough Pasta & Chicken Alfredo Module 08: Bonus Section (See full curriculum) Who is this course for? Individuals seeking to expand their cooking repertoire. Professionals aiming to enhance their baking and culinary skills. Beginners with an interest in artisan baking. Food lovers eager to discover new and creative sourdough-based recipes. Career Path Artisan baker Chef in restaurants or bakeries Caterer specialising in artisan breads Culinary consultant Food entrepreneur in the sourdough or bread-making sector

***Level 5: Accounting & Finance*** Accounting and finance assist businesses in measuring, monitoring, and planning their operations. This Level 5: Accounting & Finance course has been designed to provide a thorough introduction to business Accounting and Finance as both an idea and a profession. This course will equip you with in-demand accounting and finance skills as well as the ability to complete practicable processes while working in an organisation. This could be tricky, especially if this is your first consignment in the accounting and finance sector. Our Level 5: Accounting & Finance course provides a solid understanding of accounting and financial methods, concepts, and duties to properly prepare you for a career in the accounting and finance sector. Learning Outcomes After completing this Level 5: Accounting & Finance course, learner will be able to: Understand the essentials of accounting and finance Understand the types of cost data and cost analysis Gain a thorough understanding of contribution analysis Understand break-even and cost-volume-profit analysis Understand relevant cost and know to make short-term decisions Know how to manage financial assets Understand forecasting cash needs and budgeting Cost control and variance analysis Know how to manage accounts receivable and credit Know how to manage inventory Understand the time value of money Know how to improve managerial performance Understand capital budgeting decisions Understand improve managerial performance Understand sources of short-term financing Know how to consider term loans and leasing Understand long-term debt and equity financing Understand accounting conventions and recording financial data Why Choose Level 5 Accounting & Finance Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Others Benefits of this Course Free One PDF Certificate Lifetime Access Unlimited Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the course ] ***Level 5: Accounting & Finance*** Detailed Course Curriculum Module 1: Essentials of Accounting and Finance Identify the Non-Financial Manager's Concern with Finance The Importance of Finance Financial and Operating Environment Module 2: Types of Cost Data and Cost Analysis The Importance of Cost Data Types of Costs How Do Your Costs Behave? Segregating Fixed Cost and Variable Cost Cost Allocation Cost Analysis What You Can Learn from the Japanese? Module 3: Contribution Analysis Should You Accept a Special Order? How Do You Determine a Bid Price? Determining Profit from Year to Year Are You Utilising Capacity? Module 4: Break-Even and Cost-Volume-Profit Analysis What is Cost-Volume-Profit Analysis? What and Why of Break-Even Sales? What is the Margin of Safety? Cash Break-Even Point What is Operating Leverage? Sales Mix Analysis Module 5: Relevant Cost and Making Short-Term Decisions What Costs Are Relevant to You? Accepting or Rejecting a Special Order Pricing Standard Products Determining Whether to Sell or Process Further Adding or Dropping a Product Line Utilising Scarce Resources Don't Forget the Qualitative Factors Module 6: Forecasting Cash Needs and Budgeting Forecasts Using Forecasts Preparing Financial Forecasts Budgets The Sales Budget The Production Budget The Direct Material Budget The Direct Labour Budget The Factory Overhead Budget The Ending Inventory The Selling and Administrative Expense Budget The Cash Budget The Budgeted Income Statement The Budgeted Balance Sheet A Shortcut Approach to Formulating the Budget Module 7: Cost Control and Variance Analysis Defining a Standard The Usefulness of Variance Analysis Setting Standards Determining and Evaluating Sales Variances Cost Variances Labour Variances Overhead Variances The Use of Flexible Budgets in Performance Reports Standards and Variances in Marketing Sales Standards Variances in Warehousing Costs Module 8: Managing Financial Assets Working Capital Financing Assets Managing Cash Properly Getting Money Faster Delaying Cash Payments Opportunity Cost of Foregoing a Cash Discount Volume Discounts Module 9: Managing Accounts Receivable and Credit Credit References Credit Policy Analysing Accounts Receivable Module 10: Managing Inventory Inventory Management Considerations Inventory Analysis Determining the Carrying and Ordering Costs The Economic Order Quantity (EOQ) Avoiding Stock Outs Determining the Reorder Point or Economic Order Point (EOP) The ABC Inventory Control Method Supply Chain Management Module 11: The Time Value of Money Future Values - How Money Grows Future Value of an Annuity Present Value - How Much Money is Worth Now? Present Value of Mixed Streams of Cash Flows Present Value of an Annuity Perpetuities Applications of Future Values and Present Values Module 12: Capital Budgeting Decisions Types of Investment Projects What Are the Features of Investment Projects? Selecting the Best Mix of Projects With a Limited Budget Income Taxes and Investment Decisions Types of Depreciation Methods How Does MACRS Affect Investment Decisions? The Cost of Capital Module 13: Improving Managerial Performance What is Return on Investment (ROI)? What Does ROI Consist of? - Du Pont Formula ROI and Profit Objective ROI and Profit Planning ROI and Return on Equity (ROE) Module 14: Sources of Short-Term Financing Trade Credit Cash Discount When are Bank Loans Advisable? Working with a Bank Issuing Commercial Paper Using Receivables for Financing Using Inventories for Financing Module 15: Considering Term Loans and Leasing Intermediate-Term Bank Loans Using Revolving Credit Insurance Company Term Loans Financing with Equipment Leasing Module 16: Long-Term Debt and Equity Financing Types of Long-Term Debt Equity Securities How Should You Finance? Module 17: Accounting Conventions and Recording Financial Data Double Entry and the Accounting Equation Assessment Method After completing each module of the Level 5: Accounting & Finance course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this Level 5: Accounting & Finance course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? Level 5: Accounting & Finance This Level 5: Accounting & Finance course is ideal for: Candidates interested to start a career in accountancy Business owners seeking to look after their own accounts Existing accountancy workers in seeking higher positions or promotion Accountancy workers with no formal qualifications Anyone wishing to boost their career prospects. Requirements Level 5: Accounting & Finance There are no specific requirements for Level 5: Accounting & Finance course because it does not require any advanced knowledge or skills. Career path Level 5: Accounting & Finance This Level 5: Accounting & Finance course may lead you to a variety of career opportunities. Accounts Assistant Accounts Payable & Expenses Supervisor Accounts Payable Clerk Audit Trainee Payroll Administrator / Supervisor Tax Assistant / Accountant. Accounting Clerk Auditing Clerk Accounts Receivable Clerk Certificates Certificate of completion Digital certificate - Included

Dive into the intricate world of numbers and data with our comprehensive 'Microsoft Excel & Accounting Training' course. Begin your journey by mastering the foundational elements of Microsoft Office Excel 2016, from the basics of worksheet modifications to the art of data visualisation using charts. As you progress, pivot your attention towards the meticulous realm of accounting. Here, you'll unravel the secrets of the accounting equation, immerse yourself in transaction analyses, and culminate your learning by understanding the complete accounting cycle. Whether you're looking to enhance your data management skills or embark on a career in accounting, this course is your stepping stone to success. Learning Outcomes: Acquire proficiency in utilising Microsoft Excel 2016 for data analysis, visualisation, and workbook management. Understand the core principles of accounting, including the accounting equation and transaction analysis. Demonstrate the ability to prepare financial statements and complete the accounting cycle. Implement advanced Excel features such as PivotTables, PivotCharts, and Lookup Functions. Apply knowledge in real-world scenarios, including fiscal year evaluations and spreadsheet exercises. Why buy this Microsoft Excel & Accounting Training? 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 Microsoft Excel & Accounting Training 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 Microsoft Excel & Accounting Training course for? Individuals aiming to bolster their data analysis and management capabilities. Aspiring accountants keen on understanding the fundamentals of the profession. Business owners desiring a deeper grasp of financial statements and accounting cycles. Students pursuing a career in finance or data management. Professionals looking to integrate Excel functionalities into their daily tasks. Career path Data Analyst: Average salary range: £25,000 - £40,000 Annually Accountant: Average salary range: £28,000 - £52,000 Annually Financial Controller: Average salary range: £40,000 - £70,000 Annually Management Accountant: Average salary range: £30,000 - £55,000 Annually Excel Specialist: Average salary range: £22,000 - £35,000 Annually Bookkeeper: Average salary range: £18,000 - £30,000 Annually Prerequisites This Microsoft Excel & Accounting Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Excel & 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 **Microsoft Excel** Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interfact 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:16:00 Apply Number Format 00:07: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:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09: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:06:00 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Create and Modify Tables 00:16:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 **Accounting Training** 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: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 Account 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