882 Courses

Learn how to use Macros in Excel to automate your work and start to see the power these can give you. Course overview Duration: 1 day (6.5 hours) Our Excel – Working with Macros course aims to show how macros can be used to automate commonly used commands and processes. This course is designed for existing experienced users of Excel. You should be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course. Objectives By the end of the course you will be able to: Record and run macros Navigate within the Visual Basic Environment Edit pre-recorded macros Create your own functions Content Recording macros Accessing the Developer Tab Naming conventions and storage locations Recording macros Absolute and relative cell addressing Running macros Assigning macros to the Quick Access Toolbar Assigning macros to objects Creating new tabs Workbook macros Recording macros in a specific workbook Saving the workbook as an Excel Macro-Enabled Workbook Creating quick access items specific to workbooks Importing and manipulating data Importing Delimited Text Files Importing Fixed Width Text Files The Visual Basic environment Project explorer Code window Properties window Renaming modules Deleting modules Working with code Code structure Adding comments Navigating within your code Editing macro code Getting help with syntax Debugging Errors Using debug Function procedures Creating function macros

An in depth look at Pivot Tables and their powerful features to summarise and visualize your data. Course overview Duration: 1 day (6.5 hours) Our Excel – Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who need to learn more about the use of Pivot Tables to summarise and analyse information. This course is designed for existing experienced users of Excel. You should be a confident Excel user and be able to create and edit worksheets and write basic formulas. Objectives By the end of the course you will be able to: Build and customise Pivot Tables Group and sort information Filter information Use slicers and the timeline filter Add different summary calculations Create Pivot Charts Add calculated fields and items Content The anatomy of a Pivot Table Using a Pivot Cache Building a Pivot Table The Pivot Table interface Refreshing the Pivot Table Adding column, row, page and data fields Changing data orientation Showing data fields in columns or rows Drilling down to underlying data Setting Pivot Table options Format options Totals and filters options Display and printing options Data options Customising Pivot Tables Modifying field names Data formatting Changing field layout options Changing summary calculations Working with subtotals Filtering and sorting Filtering items Sorting data Value and label filters Creating top 10 reports Using the Search filter Using the Slicer tool Use the Timeline filter Grouping Grouping date fields Grouping numeric fields Adding your own groups Summary calculations Running totals Differences year on year, month on month % Differences year on year, month on month % of Row, Column, Total and other fields Pivot charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Adding calculated fields Adding calculated items

Level 7 QLS Endorsed Diploma | 180 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support

Register on the Leadership and Management today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a certificate as proof of your course completion. The Leadership and Management is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablets, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Leadership and Management Receive a digital certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are aspiring professionals. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Leadership and Management, all you need is a passion for learning, A good understanding of English, numeracy, and IT skills. You must also be over the age of 16.  Course Content Introduction to The Course Introduction to the Course 00:03:00 Module 01: Understanding Management and Leadership Understanding Management and Leadership 00:42:00 Module 02: Leadership Theories Leadership Theories 00:27:00 Module 03: Improving Management and Leadership Performance Improving Management and Leadership Performance 00:17:00 Module 04: High Performance Teams High Performance Teams 00:34:00 Module 05: Motivating Employees Motivating Employees 00:28:00 Module 06: Organisational Skills Organisational Skills 00:28:00 Module 07: Talent Management Talent Management 00:39:00 Module 08: Succession Planning Succession Planning 00:26:00 Module 09: Business Process Management Business Process Management 00:30:00 Module 10: Communication Skills Communication Skills 00:29:00 Module 11: Negotiation Techniques Negotiation Techniques 00:17:00 Module 12: Managing Meetings and Giving Feedback Managing Meetings and Giving Feedback 00:24:00 Module 13: Managing Change Managing Change 00:24:00 Module 14: Time Management Time Management 00:39:00 Module 15: Stress Management Stress Management 00:17:00 Module 16: Emotional Intelligence in Leadership Emotional Intelligence in Leadership 00:34:00 Module 17: Managing Conflict Managing Conflict 00:24:00 Module 18: Dealing with Office Politics Dealing with Office Politics 00:36:00 Module 19: Risk Management Risk Management 00:37:00 Module 20: Corporate Responsibility and Ethics Corporate Responsibility and Ethics 00:16:00 Module 21:Microsoft Word, Excel, PowerPoint Microsoft Word 08:06:00 Microsoft Excel 03:59:00 Microsoft PowerPoint 08:24:00 A Recap to the Course Recap - Leadership and Management 00:00:00 Assessment Assignment - Leadership and Management 00:00:00 Recommended Materials Workbook - Leadership and Management 06:55:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Embark on a transformative journey with the 'Level 5 Diploma in Leadership and Management for Adult Care,' designed to sculpt the next generation of influential leaders and astute managers in the adult care sector. This comprehensive course, meticulously crafted, offers an in-depth exploration of both theoretical and practical aspects of leadership and management. Through its 24 diverse modules, learners will delve into the realms of management theories, high-performance team building, and effective communication skills. The course not only covers the foundational elements like understanding management principles and leadership theories but also ventures into specialised areas such as talent management, succession planning, and the intricacies of dealing with office politics. Additionally, it addresses the critical skills of time and stress management, crucial for thriving in fast-paced professional environments. The curriculum's unique blend of modules like 'Safeguarding in Adult Care' and 'Overcoming Barriers in Adult Care Settings' tailors specifically to the adult care industry, ensuring that graduates emerge as well-rounded, industry-ready professionals. Learning Outcomes Acquire a thorough understanding of both classical and contemporary leadership theories and their application in adult care settings. Develop the ability to build and sustain high-performing teams, along with mastering motivational strategies for employees. Gain proficiency in essential organisational skills, including managing change, negotiating effectively, and mastering time management. Enhance emotional intelligence and conflict management skills, pivotal for navigating complex interpersonal dynamics in a professional setting. Learn to strategically manage risks and uphold corporate responsibility and ethics in adult care leadership Why choose this Level 5 Diploma in Leadership and Management for Adult Care 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 Level 5 Diploma in Leadership and Management for Adult Care course for? Individuals aiming to ascend to leadership positions in the adult care sector. Managers seeking to enhance their leadership capabilities and organisational effectiveness. Professionals in adult care who wish to refine their skills in managing teams and conflict. Aspiring leaders focused on developing robust communication and negotiation skills. Career-changers looking to enter the adult care industry with a solid foundation in management and leadership. Career path Care Home Manager: £30,000 - £45,000 Adult Care Services Coordinator: £25,000 - £35,000 Healthcare Administrator: £20,000 - £30,000 Senior Care Supervisor: £22,000 - £32,000 Clinical Services Manager: £35,000 - £50,000 Policy Advisor in Adult Care: £28,000 - £40,000 Prerequisites This Level 5 Diploma in Leadership and Management for Adult Care does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Level 5 Diploma in Leadership and Management for Adult Care 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 Module 1: Understanding Management and Leadership Understanding Management and Leadership 00:42:00 Module 02: Supporting Education in Adult Care Supporting Education in Adult Care 00:13:00 Module 03: Safeguarding in Adult Care Safeguarding in Adult Care 00:07:00 Module 04: Overcoming Barriers in Adult Care Settings Overcoming Barriers in Adult Care Settings 00:11:00 Module 05: Leadership Theories Leadership Theories 00:27:00 Module 06: Improving Management and Leadership Performance Improving Management and Leadership Performance 00:17:00 Module 07 High Performance Teams High Performance Teams 00:34:00 Module 08: Motivating Employees Motivating Employees 00:28:00 Module 09: Organisational Skills Organisational Skills 00:28:00 Module 10: Talent Management Talent Management 00:39:00 Module 11: Succession Planning Succession Planning 00:26:00 Module 12: Business Process Management Business Process Management 00:30:00 Module 13: Communication Skills Communication Skills 00:29:00 Module 14: Negotiation Techniques Negotiation Techniques 00:17:00 Module 15 Managing Meetings and Giving Feedback Managing Meetings and Giving Feedback 00:24:00 Module 16: Managing Change Managing Change 00:24:00 Module 17: Time Management Time Management 00:39:00 Module 18: Stress Management Stress Management 00:17:00 Module 19: Emotional Intelligence in Leadership Emotional Intelligence in Leadership 00:34:00 Module 20: Managing Conflict Managing Conflict 00:24:00 Module 21: Dealing with Office Politics Dealing with Office Politics 00:36:00 Module 22: Risk Management Risk Management 00:37:00 Module 23: Corporate Responsibility and Ethics Corporate Responsibility and Ethics 00:16:00 Module 24:Microsoft Word, Excel, PowerPoint Microsoft Word 08:06:00 Microsoft Excel 03:59:00 Microsoft PowerPoint 08:24:00 Assignment Assignment - Level 5 Diploma in Leadership and Management for Adult Care 00:00:00

Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time. Course overview Duration: 1 day (6.5 hours) Our Excel Module 4 – Advanced Formulas and Functions course looks at some of the more advanced functions of Excel that can be used to manipulate and extract data. This is an intensive one-day course and designed for experienced users of Excel. Participants should be confident in creating and using Excel and be able to build simple formula before attending. Objectives By the end of the course you will be able to: Use a range of Text functions to manage text data Create and use different types of date and time functions Work with rounding functions Use logical statements Build nested formula Use SUMIF, COUNTIF and AVERAGEIF Cross reference data from other worksheets using LOOKUP, INDEX and MATCH functions Use IS functions and IFERROR to test cell values Content Working with text Splitting text into multiple cells Merging data into one cell Extracting data using text functions Tidying data Working with dates and times Formatting dates and times Date and time functions Calculating date and time differences Using functions to round numbers up and down ROUND ROUNDUP ROUNDDOWN CEILING FLOOR Use lookup functions Lookup functions Creating a lookup table Range naming Using VLOOKUP Using HLOOKUP Using INDEX and MATCH Working with logical statements Creating an IF statement Using the AND plus OR functions Nesting functions Calculating values based on given criteria SUMIF(S) COUNTIF(S) AVERAGEIF(S) Using IS and IFERROR and test cell values ISBLANK ISNUMBER ISTEXT ISERROR IFERROR

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Getting Data Ready for Regression Model Transportation Problem in Excel using Goal Seek 00:12:00 Gathering Business Knowledge 00:03:00 Data Exploration 00:03:00 The Data and the Data Dictionary 00:07:00 Univariate analysis and EDD 00:03:00 Discriptive Data Analytics in Excel 00:10:00 Outlier Treatment 00:04:00 Identifying and Treating Outliers in Excel 00:04:00 Missing Value Imputation 00:03:00 Identifying and Treating missing values in Excel 00:04:00 Variable Transformation in Excel 00:03:00 Dummy variable creation: Handling qualitative data 00:04:00 Dummy Variable Creation in Excel 00:07:00 Correlation Analysis 00:09:00 Creating Correlation Matrix in Excel 00:08:00 Creating Regression Model The Problem Statement 00:01:00 Basic Equations and Ordinary Least Squares (OLS) method 00:08:00 Assessing accuracy of predicted coefficients 00:14:00 Assessing Model Accuracy: RSE and R squared 00:07:00 Creating Simple Linear Regression model 00:02:00 Multiple Linear Regression 00:05:00 The F - statistic 00:08:00 Interpreting results of Categorical variables 00:05:00 Creating Multiple Linear Regression model 00:07:00 What-if analysis Excel: Running Linear Regression using Solver 00:08:00 Assessment Assessment - Linear Regression Analysis In MS Excel 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Learn Excel tricks of the trade and some quick easy wins, to make time spent on spreadsheets efficient, effective and painless!

Register on the Learn Microsoft Word, PowerPoint & Outlook In 90 Minutes! today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Learn Microsoft Word, PowerPoint & Outlook In 90 Minutes! is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Learn Microsoft Word, PowerPoint & Outlook In 90 Minutes! Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Learn Microsoft Word, PowerPoint & Outlook In 90 Minutes!, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Introduction INTRO FINAL 00:01:00 Microsoft Word Essentials New Word Document and Templates 00:02:00 Tabs, Ribbons and Groups 00:03:00 Zoom and Rulers in Word 00:02:00 Editing the Word Document 00:03:00 Insert Pictures with Word 00:05:00 Insert Shape and Text Box in Word 00:02:00 Review Tab in Word 00:03:00 Layout in Word 00:02:00 File Options in Word 00:02:00 Closing and Reopening in Word 00:01:00 Microsoft PowerPoint Essentials New PowerPoint Presentation and Templates 00:02:00 Tabs Ribbons and Groups in PowerPoint 00:02:00 First Slide and Designing the Slide 00:02:00 Home Tab and Updates in PowerPoint 00:02:00 Buttons in PowerPoint 00:01:00 Inserting Pictures in PowerPoint 00:04:00 Presentation Mode 00:01:00 Animations Tab 00:05:00 File Options in PowerPoint 00:02:00 Closing and Reopening in PowerPoint 00:01:00 Microsoft Outlook Essentials Setting Up Outlook with Accounts 00:03:00 Tabs, Ribbons and Groups in Outlook 00:03:00 Navigation Bar in Outlook 00:01:00 Organizing Outlook with Favorites and Folders 00:03:00 Additional Options inside Outlook Tabs 00:01:00 Reading, Writing and Receiving Emails 00:08:00 Attaching Items in Outlook Mails 00:03:00 The View Tab in Outlook 00:02:00 Create a Rule to move emails to a folder 00:04:00 Insert a screen shot from Excel 00:02:00 Microsoft Excel Keyboard Shortcuts Formatting Excel Keyboard Shortcuts 00:02:00 Table Excel Keyboard Shortcuts 00:02:00 Editing Excel Keyboard Shortcuts 00:05:00 Formula Excel Keyboard Shortcuts 00:03:00 Workbook Excel Keyboard Shortcuts 00:02:00 Handy Excel Shortcuts Keyboard Shortcuts 00:05:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Duration 2 Days 12 CPD hours Overview What's New in This Guide? Automatic Payment Reminders for open customer invoices Ability to automatically include the PO# (purchase order number) to Invoice Emails Able to combine multiple emails which allows you to attach multiple sales or purchasing documents to a single email Quickly locate a company file using the new company file search feature Smart Help is an improved search experience that includes access to live experts through messaging and call back options This course covers all features that are in QuickBooks Pro and Premier 2020 and prepares you for the QuickBooks Certified User exam. This course combines all topics in the two 1 day courses ?Get Started with QuickBooks 2020 for Windows? and ?Keep Going with QuickBooks 2020 for Windows?. First-time QuickBooks users will learn the basic features of the software. Experienced QuickBooks users will quickly learn the new features and functionality of QuickBooks 2020. Getting Started Starting QuickBooks Setting QuickBooks Preferences Components of the QuickBooks Operating Environment Using QuickBooks Help Identifying Common Business Terms Exiting QuickBooks Setting Up a Company Creating a QuickBooks Company Using the Chart of Accounts Working with Lists Creating Company Lists Working with the Customers & Jobs List Working with the Employees List Working with the Vendors List Working with the Item List Working with Other Lists Managing Lists Setting Up Inventory Entering Inventory Ordering Inventory Receiving Inventory Paying for Inventory Manually Adjusting Inventory Selling Your Product Creating Product Invoices Applying Credit to Invoices Emailing Invoices Setting Price Levels Creating Sales Receipts Invoicing for Services Setting Up a Service Item Changing the Invoice Format Creating a Service Invoice Editing an Invoice Voiding an Invoice Deleting an Invoice Entering Statement Charges Creating Billing Statements Processing Payments Displaying the Open Invoices Report Using the Income Tracker Receiving Payments for Invoices Making Deposits Handling Bounced Checks Working with Bank Accounts Writing a QuickBooks Check Voiding a QuickBooks Check Using Bank Account Registers Entering a Handwritten Check Transferring Funds Between Accounts Reconciling Checking Accounts Entering and Paying Bills Handling Expenses Using QuickBooks for Accounts Payable Using the Bill Tracker Entering Bills Paying Bills Entering Vendor Credit Memorizing Transactions Entering a New Memorized Transaction Editing a Memorized Transaction Deleting a Memorized Transaction Grouping Memorized Transactions Using a Memorized Transaction Printing the Memorized Transaction List Customizing Forms Creating a Custom Template Modifying a Template Printing Forms Using Other QuickBooks Accounts Other QuickBooks Account Types Working with Credit Card Transactions Working with Fixed Assets Working with Long-Term Liability Accounts Using the Loan Manager Creating Reports Working with QuickReports Working with Preset Reports Sharing Reports Exporting Reports to Microsoft Excel Printing Reports Creating Graphs Creating QuickInsight Graphs Using QuickZoom with Graphs Working with the Sales Graph Customizing Graphs Printing Graphs Tracking and Paying Sales Tax Using Sales Tax in QuickBooks Setting Up Tax Rates and Agencies Indicating Who and What Gets Taxed Applying Tax to Each Sale Determining What You Owe Paying Your Tax Agencies Preparing Payroll with QuickBooks Using Payroll Tracking Setting Up for Payroll Setting Up Employee Payroll Information Setting Up a Payroll Schedule Writing a Payroll Check Printing Paycheck Stubs Tracking Your Tax Liabilities Paying Payroll Taxes Preparing Payroll Tax Forms Using the EasyStep Interview Using the EasyStep Interview Using Online Banking Setting Up an Internet Connection Setting Up Bank Feeds for Accounts Viewing, Downloading, and Adding Online Transactions Creating Online Payments Transferring Funds Online Canceling Online Payments Managing Company Files Using QuickBooks in Multi-user Mode Setting Up Users and Passwords Setting a Closing Date Sharing Files with an Accountant Updating QuickBooks Backing Up and Restoring a Company File Condensing a Company File Estimating, Time Tracking, and Job Costing Creating Job Estimates Creating an Invoice from an Estimate Displaying Reports for Estimates Updating the Job Status Tracking Time Displaying Reports for Time Tracking Tracking Vehicle Mileage Displaying Vehicle Mileage Reports Displaying Other Job Reports Writing Letters Using the Letters and Envelopes Wizard Customizing Letter Templates