Pankaj Shah web agency director in London with over 20 years of experience in web design and project management
Do you want an awesome website for your business?
Yes I want an awesome website

Business Video Tutorials, Useful Articles & Infographics

Find lots of useful tips to help your business grow. Learn about user engagement, business bookkeeping, marketing, business software tools and much more.

Learn how to use the SUM function in Microsoft Excel with step-by-step examples, AutoSum tips and simple addition formulas.
Learn how to use the COUNTIF function in Excel to count specific data entries, analyse datasets and compare COUNT and COUNTA functions.
Learn how to use the COUNTA function in Excel, understand the difference between COUNT and COUNTA, and improve data analysis skills.
Learn how to use the COUNT function in Microsoft Excel to count numeric entries and combine it with SUM and AVERAGE formulas.
Learn how to calculate averages in Microsoft Excel using the AVERAGE function, manual formulas and practical examples in this tutorial.
Learn how to use the IF function in Excel with practical examples for invoices, commissions, logical tests and conditional formulas.
Learn how to use the VLOOKUP function in Excel to retrieve data, create dropdown lists and improve spreadsheet data analysis skills.
Learn how to use the CONCATENATE function in Excel 2021 to combine names, addresses and text values with easy step-by-step examples.
Master LibreOffice Calc with our free beginner tutorial: formulas, formatting, charts, printing, and exporting spreadsheets to PDF, step by step.
In this video tutorial, I will show you how to create a PayPal donation button.
In this video tutorial, I will show you how to Cancel Subscription Payments on PayPal. You can follow this tutorial to stop an automatic payment on PayPal. This is also known as a PayPal subscription payment.
Learn how to remove duplicates in Excel, highlight duplicate values and clean large datasets with this step-by-step tutorial.
In this video tutorial, I will show you how to install and use the Grammarly Chrome Extension. If you want to improve your website written content then the Grammarly Chrome Extension is a perfect and FREE tool.
So you want to start your own business? It can seem like a big decision to make, planning can take valuable time and sometimes you will have days where you begin to question why you started in the first place. To help put things into perspective for you, here is a step by step guide that will help you through the process.
Learn how to wrap text around images in Microsoft Word, align pictures, create clean layouts and export professional documents as PDF.
Learn how to create a custom calendar in Microsoft Word with images, tables, formatted dates and PDF export for personal or business use.
Learn how to insert images into a table in Microsoft Word, format layouts, remove borders and export professional image documents as PDF.
Learn how to create colorful WordArt in LibreOffice Writer using Fontwork. Step-by-step guide to design a festive flyer with custom text effects.
Master LibreOffice Calc array formulas & SUMPRODUCT with step-by-step examples: percentages, profit totals, and averages for faster spreadsheets.
Learn how to save a LibreOffice Calc spreadsheet as CSV, keep formatting safe with ODS, and pick the right encoding for clean data exports today.
Learn to add borders and gridlines to a LibreOffice Calc spreadsheet for cleaner, more readable printed reports in this easy, step-by-step guide.
Learn how to calculate VAT in LibreOffice Calc with formulas to find VAT amounts, prices including VAT, and reverse VAT quickly and easily today.
Learn how to calculate averages in LibreOffice Calc using SUM and division formulas, with real examples for budgeting monthly costs and expenses.
Learn how to format cells in LibreOffice Calc: set currency, dates, percentages, numbers vs. text, and time formats with this step-by-step guide.
In this video tutorial, I will show you how to use Google Forms start to finish. Google Forms can be embedded on your website, sent as an email link or posted as a link on social media. At DCP we use Google Forms to get feedback once we complete a website design project. It is always good to understand what your customers think about your business and processes, you can then make improvements and have even more happy customers.
A beginner's guide to 6 basic LibreOffice Calc formulas: SUM, AutoSum, currency formatting, custom totals, and VAT percentage calculations today.
Learn how to quickly create a bar chart in LibreOffice Calc 6 with this step-by-step tutorial covering data entry, formatting, and chart styling.
Learn how to create a pie chart in LibreOffice Calc: enter data, pick a chart style, add a title, and place the legend exactly where you want it.
Learn how to change the background on your Google Chrome browser with this easy step-by-step tutorial. Customise Chrome with themes, colours and images.
Learn how to convert Apple Mac Pages files into Microsoft Word DOCX documents using CloudConvert with this simple step-by-step guide.
Founding father and revolutionary scientist followed a strict thirteen-week plan to allow self-improvement, he made sure to concentrate on one virtue a week. He would wake up at 5 AM and ask himself ‘What good shall I do this day?’ before three hours of work starting at 8 and then after lunch another three hours dedicated to work. He only dedicated four hours of his schedule to sleep and kept his food breaks to a strict timetabled routine.
Learn how to convert uppercase text to lowercase in Microsoft Word using the Change Case feature and quick formatting tools.
Learn how to convert Microsoft Word documents to PDF files using Microsoft Word, LibreOffice Writer and online PDF conversion tools.
Learn how to create pivot tables in LibreOffice Calc using this step-by-step tutorial, covering sales data analysis, filtering, and pivot charts.
Learn how to split data in Excel using Text to Columns to separate first names, last names and other data with this step-by-step tutorial.
Learn how to save an Excel spreadsheet as a CSV file for importing data into MailChimp, Hootsuite and other applications with this step-by-step tutorial.
Learn how to add a custom background image to your LibreOffice Impress slides, plus resolution settings and logo placement tips for cleaner decks
Learn how to create and format tables in LibreOffice Writer in this step-by-step tutorial covering rows, columns, borders, and design tips today.
Learn how to create blog posts and documents faster using Dragon NaturallySpeaking speech recognition software without typing manually.
Learn to build column, pie and line charts in LibreOffice Calc with this step-by-step DCP tutorial covering setup, formatting, and chart styling.
In this video tutorial, I will show my Top 5 awesome and free software applications! So you're looking for free applications which you can install on your computer to enhance your business productivity and your creative skills. In this video, I have compiled a top 5 free software applications which you can download today. I use these applications in my business every day.
A beginner's guide to LibreOffice Writer: set up headers, footers, styles, logos, images, tables and lists, then exporting polished docs to PDFs.
Learn conditional formatting in LibreOffice Calc: use color scales, data bars, icon sets, and date rules to visualize your spreadsheet data fast.
Learn how to create a clear, professional e-commerce flow chart in LibreOffice Draw, mapping the full customer journey from browsing to checkout.
Learn Microsoft Excel basics including data entry, formatting, formulas, filters and invoice tracking in this beginner-friendly tutorial.

This website (dcpweb.co.uk) uses cookies to improve your browsing experience and help us understand how our site is used. By continuing to browse this website, you agree to our use of cookies.

To learn more about how we collect, use, and protect your data, please read our Privacy Policy.

DCP Web Designers is one of London’s most established web design companies.

Since 2004, we have designed and developed websites for companies across a wide range of industries, from local service businesses to ecommerce brands and professional organisations.

Our focus is on creating websites that not only look professional, but also perform well in search engines, attract the right audience and support long-term business growth.

If you are looking for experienced web designers who understand how to build websites that deliver real results, our team is here to help.

Privacy Policy

Last Updated: 01/07/2024

Different Colour Productions Ltd (“we,” “us,” or “our”) is committed to protecting your privacy. This Privacy Policy outlines our practices concerning the collection, use, and disclosure of personal information when you visit our website or engage with our services. By using our website and services, you consent to the terms outlined in this Privacy Policy.

1. Information We Collect

We collect various types of information to provide and improve our services. The types of information we may collect include:

1.1. Personal Information: This may include your name, email address, phone number, and any other information you provide when you contact us, request information, or subscribe to our newsletter.

1.2. Log Data: When you visit our website, we automatically collect information, such as your IP address, browser type, pages visited, and the time and date of your visit.

1.3. Cookies and Similar Technologies: We use cookies and other tracking technologies to improve your experience on our website. You can adjust your browser settings to reject cookies or be alerted when cookies are being used.

2. How We Use Your Information

We use the collected information for various purposes, including:

2.1. Providing Services: To provide web design and related services you have requested from us.

2.2. Communication: To respond to your inquiries, send updates, and provide customer support.

2.3. Analytics: To analyse and improve our website and services, as well as monitor usage patterns.

3. Information Sharing and Disclosure

We do not sell or rent your personal information to third parties. However, we may share your information with third parties under the following circumstances:

3.1. Service Providers: We may share your information with trusted service providers who help us deliver our services, such as hosting providers, analytics providers, and marketing services.

3.2. Legal Obligations: We may disclose your information when required by law, to comply with legal processes, or to protect our rights, privacy, safety, or property.

4. Your Choices

You have choices regarding your personal information:

4.1. Access and Update: You can access and update your personal information by contacting us.

4.2. Marketing Communications: You can opt out of receiving marketing communications from us by following the unsubscribe instructions in our emails or emailing [email protected]

5. Security

We take appropriate measures to protect your personal information from unauthorised access, disclosure, alteration, or destruction.

6. Links to Other Websites

Our website may contain links to third-party websites. We are not responsible for the privacy practices of these websites. We recommend reviewing their respective privacy policies.

7. Changes to this Privacy Policy

We may update this Privacy Policy from time to time to reflect changes in our practices. Any changes will be posted on this page, and the date at the top will indicate the latest update.

8. Contact Us

If you have any questions or concerns about this Privacy Policy or our practices, please contact us at: [email protected]

By using our website and services, you acknowledge that you have read and agree to this Privacy Policy. Different Colour Productions Ltd is committed to safeguarding your personal information and respecting your privacy rights.

ThreeBestRated Top 3 Website Designers in London 2026 award for DCP Web Designers Certificate