Collaborate Disseminate
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.
The post How to add a single vertical bar to a Microsoft Excel line chart appeared first on TechRepublic.
Continue reading How to add a single vertical bar to a Microsoft Excel line chart
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.
The post How to enter mathe… Continue reading How to enter mathematical equations into a Microsoft Word document
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.
The post Ho… Continue reading How to use conditional formatting to highlight rank in Microsoft Excel
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.
The post How to create a custom picture placeholder in M… Continue reading How to create a custom picture placeholder in Microsoft PowerPoint
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.
The post How to convert a Microsoft Excel slicer into a series of … Continue reading How to convert a Microsoft Excel slicer into a series of filtering buttons on a PivotChart in Excel
Microsoft Word for the web has improved its Font interface—it has more font options and they’re easier to find now.
The post How to use the new Font Picker in Microsoft Word for the web appeared first on TechRepublic.
Continue reading How to use the new Font Picker in Microsoft Word for the web
In Microsoft Excel, you don’t need an expression to calculate someone’s age – use Power Query to simplify the process.
The post How to convert a birth date to an age without an expression using Microsoft Excel Power Query appeared first on TechRepublic… Continue reading How to convert a birth date to an age without an expression using Microsoft Excel Power Query
Learn how to use either of these methods in Microsoft Excel to display negative values in red.
The post 2 ways to display negative numbers in red in Microsoft Excel appeared first on TechRepublic.
Continue reading 2 ways to display negative numbers in red in Microsoft Excel
Navigating a Microsoft Word document using VBA requires very little code, but it’s not intuitive.
The post How to use VBA to reach the beginning and end of a Microsoft Word document appeared first on TechRepublic.
Continue reading How to use VBA to reach the beginning and end of a Microsoft Word document
Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.
The post How to use UNIQUE() to populate a dropdown in Microsoft Excel appeared first on TechRepublic.
Continue reading How to use UNIQUE() to populate a dropdown in Microsoft Excel