Learn how to use Microsoft Excel step by step in this beginner-friendly tutorial. If you're new to Excel or want to understand the basics, this video shows you how to get started using Excel right ...

If you work with a large dataset or usually query the same data in an Excel table, then you should use the VLOOKUP function to make your life easier – here's how.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY formula. Alternatively, to extract, filter, and sort columns from a dataset ...

If you want to learn how to use Microsoft 365 Copilot in Excel, here's a detailed guide that will demonstrate to how to enable the feature and use it to your advantage.

I’m using Excel on Office 365 on a Windows 10 64-bit system, but you can apply these sorting techniques to earlier versions. Custom sorts aren’t supported in the browser edition.

Concatenate merges the data you have inserted into columns into its own cell or column in Excel. Let’s take a look at how to use concatenate in Excel.

Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel.

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

This guide shows how to create progress bars in Excel using Bar Charts and Conditional Formatting on a Windows 11/10 PC. Take a look.

Excel offers several built-in conditional formatting rules you can apply to your data. (Click image to enlarge it.) We’ll demonstrate using Excel for Windows under a Microsoft 365 subscription.