Copilot in Excel is an AI assistant built into Excel that can draft formulas from plain English, analyse a table of data for trends and outliers, create charts and PivotTables, and clean up data. It can’t handle messy, unstructured data, it needs a Microsoft 365 Copilot licence, and its output always needs checking. Used well, it’s a genuine time-saver.
Category: Microsoft Excel
Excel keyboard shortcuts let you perform common tasks instantly instead of hunting through menus. The most useful include Ctrl+C and Ctrl+V to copy and paste, Ctrl+Z to undo, Ctrl+Arrow to jump across data, and Alt+= to AutoSum. Learning even ten of them can save you several hours a week.
Download our free Excel shortcuts cheat sheet: a one-page PDF listing the high-value Windows and Mac keyboard shortcuts worth using every day, grouped by task and shown as keys you press in sequence. It deliberately skips the basics everyone already knows, so it stays to a single printable page you can pin by your desk. No sign-up required.
Microsoft Excel is the world’s most widely used spreadsheet program. It stores data in a grid of rows and columns, and lets you calculate, analyse and chart that data using formulas and functions. People use it for everything from budgets and invoices to reporting and data analysis. This guide covers the essentials, from cells to PivotTables.
A pivot table is an Excel tool that summarises a large table of data into a compact, interactive report. In a few clicks it groups your data and calculates totals, counts or averages, so you can answer questions like “total sales by region” without writing a single formula. To create one, select your data and choose Insert > PivotTable.