Microsoft
SoftwareHow to create a drop-down list in Excel
Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.
-
Image: PixieMe/Adobe Stock -
Image: PixieMe/Shutterstock Microsoft
SoftwareHow to calculate conditional rank in Excel
A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.
-
Image: monticello/Shutterstock Microsoft
SoftwareHow to create a churning circle using only a gradient fill in PowerPoint
A spinning hollow circle is a great way to suggest the passing of time in a PowerPoint show. Susan Harkins shows you how to make this simple animation.
-
Image: prima91/Adobe Stock Microsoft
SoftwareHow to reverse the order of a list and maintain the original order in Word
Reversing a Word list requires a few unexpected steps, but it’s all about the formatting. Susan Harkins will show you how it’s done.
-
Image: iStock/Igor Kutyaev Microsoft
SoftwareHow to use advanced options to work more productively in Outlook
It’s true that there are a few things you can’t change about Outlook, but the reality is, you can customize a lot. Susan Harkins shows you how.
-
Image: monticello/Shutterstock Microsoft
SoftwareHow to use triggers to control what happens next in PowerPoint
Microsoft PowerPoint triggers give you a lot of power because they allow you to choose when animations are implemented during the show.
-
Image: monticellllo/Adobe Stock Microsoft
SoftwareHow to add a conditional format that highlights groups in Excel
Learn how to add a highlight to expose groups in your Microsoft Excel data using a helper column and Excel’s conditional formatting feature.
-
Image: Ahmad/Adobe Stock Microsoft
SoftwareHow to calculate a conditional running total using a PivotTable in Excel
At the sheet level, conditional running totals require focused expressions, but an Excel PivotTable requires only a few field swaps. Susan Harkins shows you how.
-
Image: flukyfluky/ iStockphoto Microsoft
SoftwareHow to create a floating bar chart in Excel
Making a floating bar chart in Microsoft Excel is a great way to visually represent distribution between entities. Susan Harkins will show you how.
-
Image: Menara Grafis/Adobe Stock Microsoft
SoftwareHow to enter and display fractions in Excel
Entering fractions in Microsoft Excel isn’t exactly intuitive, but it is easy. Learn how to enter and display fractions as either fractions or as decimal values.