98 Excel tips every user should master
Whether you are a Microsoft Excel beginner or an advanced user, you'll benefit from these step-by-step tutorials.
Microsoft
Learn more about the products coming out of the multinational software giant.
Latest Articles for Microsoft
-
Image: Bumblee_Dee, iStock/Getty Images Software -
Image: PixieMe/Adobe Stock Software How to add a single vertical bar to a Microsoft Excel line chart
In Microsoft Excel, to draw attention to a specific marker in a line chart, drop in a thin line, think of it as a marker.
-
Image: mrmohock/Adobe Stock Cloud How to take advantage of Azure Hybrid Benefits
Use your on-premises licenses in the cloud to save money.
-
Image: Fotoproff/Adobe Stock Security Critical Microsoft vulnerabilities decreased 47% in 2021
Only 104 critical vulnerabilities were reported in 2021, an all-time low for the world’s largest software company.
-
Natee Meepian Software How to enter mathematical equations into a Microsoft Word document
Word seems like an odd choice to use with mathematical equations, but the reality is Microsoft Word is a great choice. Word has a gallery of built-in equations, and you can enter your own equations or even modify equations.
-
Image: Viktor Pazemin/Adobe Stock Software How to use conditional formatting to highlight rank in Microsoft Excel
Microsoft Excel’s RANK.EQ() function ranks a set of values, but in a busy sheet, the top-ranking items might get lost. You can combine RANK.EQ() with a conditional formatting rule to highlight the top-ranking items so they’re easy to find.
-
Image: Adobe Stock/ArtemisDiana Security Microsoft Defender vs Trellix: EDR software comparison
Looking to secure your network? Microsoft Defender and Trellix are two of the most popular endpoint detection and response software options. Compare the features of these EDR tools.
-
Image: gguy/Adobe Stock Software You can now combine Power Virtual Agents and the Azure Bot Framework Composer
New tools make it easy for low code users and pro code developers to work together on a project and take the Power Platform to the next level.
-
Image: Postmodern Studio/Adobe Stock Software How to create a custom picture placeholder in Microsoft PowerPoint
If you don’t want the same rectangular pictures for your Microsoft PowerPoint slide show, create a custom-shaped picture placeholder and make it available to the presentation via a layout slide.
-
Image: Pexels Software How to create routine file backups in Windows 11 using xcopy
Backing up specific important folders, files and documents in Windows 11 does not require expensive third-party software when you know how to use the command line.
-
Image: PixieMe/Adobe Stock Software How to convert a Microsoft Excel slicer into a series of filtering buttons on a PivotChart
Slicers are a good way to filter data in a Microsoft Excel PivotTable or PivotChart, but they take up a bit of room. By moving the buttons to the chart, you free room for more visuals.
-
Image: Adobe Stock Software How to use the new Font Picker in Microsoft Word for the web
Microsoft Word for the web has improved its Font interface—it has more font options and they’re easier to find now.
-
Image: Aleksei/Adobe Stock Software How to convert a birth date to an age without an expression using Microsoft Excel Power Query
In Microsoft Excel, you don’t need an expression to calculate someone’s age – use Power Query to simplify the process.
-
Image: PhotoGranary/Adobe Stock Software How to use aliases in Exchange Online so customers don’t know your real email address
Exchange Online now makes it easy to manage and use aliases with Outlook.
-
Image: Tada Images/Adobe Stock Software Visio: From a simple IT tool to the universal business diagram app it was always meant to be
Everyone using Microsoft 365 now gets access to Visio, but what can you do with it – and which diagramming features do you still have to pay more for?