Configurare program

How to Create a Dependent Drop-Down List in Microsoft Excel

Does using a drop-down list in Microsoft Excel make data entry easier for you or your co-workers? If you said yes and want to go a step further, you can create a dependent drop-down list just as easily.

With a dependent drop-down list, you select the item that you want in the first list, and that determines the items that display as choices in the second one. For example, you might select a product, like a shirt, and then pick a size, a food item, like ice cream, and then pick a flavor, or an album, and then pick a song.

[mai mult...]

What Is a Slack “Huddle” and How Do I Start One?

Slack Logo.

Clubhouse splashed onto the scene with “drop-in” voice-only group chats. Several services have introduced their own versions of this, including Slack. Here’s how you can use Slack for quick “huddles” with your team when you need more than text.

What Is a Huddle in Slack?

A Slack Huddle is a similar concept to Clubhouse and Twitter Spaces in that there’s really not a formal meeting time or invitation. The whole idea is that people can simply “drop-in” to a Huddle whenever. And what actually is a Huddle when you join one? It’s pretty much just an audio-only chat room. There is no option to show yourself with a webcam, but on the desktop, you can share your screen. Huddles are meant for quick, casual discussions.

A Huddle can be started in any Slack channel, including direct messaging if you want to Huddle with one other person. Huddles can have up to 50 participants. You can use Huddles on Slack for desktop, iPhone, iPad, and Android.

[mai mult...]

How to Use Alexa’s Live Translate Mode

Echo Dot sitting on table.

Amazon’s Alexa language recognition capabilities extend beyond listening to simple voice commands asking for weather updates and turn-by-turn directions. Now, Alexa’s neural machine translation and speech recognition technology can translate conversations in real-time.

Alexa’s Live Translation service performs well. During testing sessions, we spit rapid-fire phrases in English, Spanish, French, and Brazilian Portuguese, which Alexa was accurately able to translate within seconds of hearing them. Live Translation feels smooth and free of choppiness and unintended phrases. This is especially true with end-of-sentence breaks, which Alexa has become better at addressing over time.

[mai mult...]

How to Highlight Top- or Bottom-Ranked Values in Microsoft Excel

Microsoft Excel Logo

Automatically highlighting data in your spreadsheets makes reviewing your most useful data points a cinch. So if you want to view your top- or bottom-ranked values, conditional formatting in Microsoft Excel can make that data pop.

Maybe you use Excel to track your sales team’s numbers, your students’ grades, your store location sales, or your family of website’s traffic. You can make informed decisions by seeing which rank at the top of the group or which fall to the bottom. These are ideal cases in which to use conditional formatting to call out those rankings automatically.

[mai mult...]