Soluții

How to Calculate the Sum of Cells in Excel

Microsoft Excel may be known for complex calculations and formulas, but it’s no slouch at simple arithmetic. There are a number of ways to find solutions to simple math problems, like finding the sum of numbers in multiple cells.

Finding the Sum of Numbers in Adjacent Columns or Cells

The quickest way to calculate the sum of squares in Excel is to simply highlight the list of numbers, and check the bottom right of the screen. Here, you’ll find the sum of any selected cell as well as their average and the number of cells you’re adding.

sum at bottom of excel

But, we’ll assume you want to add the sum to the workbook itself. In that case, highlight the numbers you want to add.

highlight cells

From the “Formulas” tab, click “Autosum” to find the sum of the list of numbers. Once you click, Excel will automatically add the sum to the bottom of this list.

formulas autosum

Alternatively, you can type the formula =SUM(D1:D7) in the formula bar and then press “Enter” on the keyboard or click the checkmark in the formula bar to execute the formula. Change the letters and numbers in parenthesis to fit your workbook.

sum formula

Finding the Sum of Numbers in Non-Adjacent Columns or Cells

Click any empty cell in the workbook. This should be the cell where you want to display the sum of these non-adjacent columns.

empty cell

From the “Formulas” tab, click the arrow icon at the right of “Autosum.”

formulas autosum

Choose “Sum.”

autosum and sum

Click the first number in the series.

first cell in column

Hold the “Shift” button and then click the last number in that column to select all of the numbers in between.

shift and click to select

To add the second column of numbers, hold Ctrl and scroll down from the first to the last number in the column. Alternatively, you can add the formula =SUM(D1:D7,F1:F7) to the formula bar. Swap the cells inside the parenthesis to fit your needs.

ctrl and click to select

Press the “Enter” button on the keyboard, or the checkmark in the formula bar to execute the formula.

2 column sum formula

[mai mult...]

How to Change Your Team Logo in Microsoft Teams

Microsoft Teams Logo

Creating and joining a team in Microsoft Teams is easy. Visually identifying a team from a long list of teams, on the other hand, can be more difficult. Give your teams a visual identity by adding a unique logo to each one. It’s quite normal to have a list of teams in Microsoft Teams, each of which is represented by an icon with the initials of the team name in it.

A list of teams in Microsoft Teams.

The more teams you’re a member of, the more difficult it is to identify a team at a glance, especially if you’re a member of multiple teams that have the same initials. The best way to easily identify a team is to give it a unique logo. This image will show up in the list of teams and in the team itself.

Before we begin, know that you’ll need to be the owner of the team before you can change its icon. To change your team logo, open Microsoft Teams, click the three-dot menu button next to the team name, then select “Manage Team.”

The team menu with "Manage team" highlighted.

Navigate to the “Settings” tab, expand the “Team Picture” section, and click the “Change Picture” button.

The "Settings" tab with "Team picture" highlighted.

In the panel that opens, select the “Upload Picture” button.

The "Upload picture" option.

A file dialogue will appear for you to locate the image you want to use for your team. Select the photo you want, then click the “Save” button.

The "Save" button.

Close the panel. Your image will now be visible in the sidebar and in the team itself.

The new logo displayed in the team.

If you want to change the image again in the future, just repeat the process.

[mai mult...]

How to Automatically Change iPhone and iPad Wallpaper in Dark Mode

A Section of Apple iPhone Dark and Light Mode Wallpaper

If you’d like your iPhone or iPad wallpaper to change when you switch between light and dark mode, you can use special wallpapers provided by Apple that include both light and dark versions. Here’s how to set it up. First, open the “Settings” app on your iPhone or iPad.

Tap the "Settings" icon on iPhone

In Settings, tap “Wallpaper.”

In Settings, tap "Wallpaper."

In Wallpaper settings, tap “Choose a New Wallpaper.”

Tap "Choose a New Wallpaper."

On the “Choose” screen, select the “Stills” category at the top of the page.

On the wallpaper select screen, tap "Stills."

In the “Stills” category, select a wallpaper that includes the dark mode icon, which looks like several concentric circles with halves cut out of them. The wallpapers with the dark and light mode icon will change automatically between dark and light versions when dark mode or light mode is activated.

On the wallpaper select screen, choose a wallpaper with the dark mode logo.

On the next screen, tap “Set,” then decide whether you want to see the wallpaper on your Lock screen, Home screen, or both.

Choose if you want your wallpaper to appear on your Lock screen, Home screen, or both.

After that, close Settings and switch from light mode to dark mode (or vice versa) by opening Control Center, holding down the brightness slider, and tapping the dark or light mode button. After you switch, you’ll notice that the wallpaper you set changes automatically to match.

[mai mult...]

Cum sa instalezi Wireguard in docker

Wireguard este o tehnologie VPN relativa noua, simpla, sigura si foarte rapida. Puteti avea acasa propriul server vpn pentru a va conecta remote la echipamentele personale. Pentru a instala Wireguard avem nevoie de o masina fizica sau virtuala cu Ubuntu server si instalate docker si docker-compose.

[mai mult...]