Tips & Tricks

Tips & tricks For Microsoft Excel, Power BI, SQL and more

Read a selection of tips & tricks that make using Microsoft Excel, Power BI, SQL and more way easier!

We’ve got loads of handy user guides for Microsoft Excel, Power BI, SQL, SharePoint and more that’ll make your life way easier. Want to learn how to get the best out of your Microsoft 365 and Microsoft Power Platform applications in your organisation? Contact us today about training courses for business.

Articles
  • How to Fix Common Issues Preventing Copilot Access in M365 Apps
    Troubleshooting Guide: How to Fix Common Issues Preventing Copilot Access in M365 Apps

    Microsoft Copilot can boost productivity in M365 apps, but access often fails due to connectivity, outdated software, or misaligned settings. Start with basics - verify internet, update apps/Copilot, and reboot - then tackle advanced fixes like confirming licenses, moving to supported update channels, adjusting admin/privacy policies, or repairing Office. For reliability, keep Windows and M365 updated, maintain a stable connection, monitor the Service Health dashboard, follow IT policy, and clear caches regularly.

  • How to Create a Radar Chart in Excel
    How to Create a Radar Chart in Excel

    A radar chart in Excel displays multiple variables on radial axes to compare them at a glance, forming a polygon that highlights patterns and differences. The article explains key benefits and business uses - like evaluating suppliers, employees, products, and campaigns - because the charts are compact, clear, and visually engaging. It then walks through creating one in Excel (select data → Insert → Radar → customise) and shares best practices: limit variables, label clearly, and use consistent scaling.

  • CAGR Growth in Excel Office
    How to Calculate CAGR Growth in Excel

    In this article, we look at how compound annual growth rate (CAGR) as the “average speed” at which an investment or business metric grows over time, smoothing out year-to-year volatility. It walks through the manual CAGR formula— (Ending Value / Beginning Value)^(1/Years) − 1 —then demonstrates four Excel-based methods to automate the calculation: the direct formula, RRI, POWER, and RATE functions.

  • calculating compound interest in excel
    How to Calculate Compound Interest in Excel

    Build a simple Excel calculator to forecast investment growth with compound interest.

  • Copilot vs. ChatGPT vs. Gemini
    Copilot vs. ChatGPT vs. Gemini: How to Choose the Right AI Assistant for Your Task

    Microsoft Copilot, OpenAI’s ChatGPT, and Google’s Gemini are leading AI assistants, each excelling in different environments. Copilot integrates deeply with Microsoft 365 to automate documents, data analysis, and email, while ChatGPT shines in open-ended conversation, creative writing, and flexible plugin-driven workflows. Gemini prioritises speed and factual accuracy within Google Workspace, offering powerful research and summarisation capabilities. Choosing the right tool depends on your ecosystem, need for customisation, and whether productivity, creativity, or precision is the top priority.

  • Choosing the Right IT Course - Quick Guide
    Choosing the Right IT Course - Quick Guide

    This quick guide helps teams choose the right IT course with confidence. It highlights the top 10 evaluation criteria - covering accreditation, instructor quality, curriculum freshness, hands-on labs, credentials, outcomes, flexibility, support, community, and level fit - and includes a printable side-by-side comparison checklist. Use it to align training with real-world tools and career ROI.

  • excel-lookup-multiple-criteria-team
    How to Use Excel Lookup with Multiple Criteria

    This blog explains how Excel’s LOOKUP functions—particularly XLOOKUP and VLOOKUP—can retrieve data based on multiple criteria. It walks through a step-by-step example of finding an employee’s sales in a specific region, showing both an XLOOKUP formula and a VLOOKUP alternative that uses a helper column.

  • Calculate Variance Using Excel
    Can you Calculate Variance Using Excel?

    In this guide, we explain variance as a measure of how widely data points deviate from the mean and shows why understanding this spread is useful for deeper insight and risk assessment. It walks readers through calculating variance in Excel, distinguishing between the VAR.S function for a sample and VAR.P for an entire population, then demonstrates each with a car-sales case study.

  • Formula for VAT on Excel
    Comprehensive Guide on the Formula for VAT in Excel

    The article explains how businesses can quickly calculate value-added tax in Microsoft Excel using the formula =Net*(1+VAT), where the VAT rate is set with an absolute cell reference for accuracy. It walks through setting up columns for net sales, VAT rate, and gross sales; entering the formula; copying it down multiple rows; and double-checking results. Automating VAT this way streamlines invoicing, enhances financial reporting, and minimizes manual errors.

Next
image

Registered England and Wales: 11477692 VAT Number: GB 3123317 52All trademarks are owned by their respective owners. Click here for details.

  • image
  • iamge
  • image