Andrei Mares
Pentru a afla mai multe despre echipa stelara, vizitati starteam.

3 Excel functions, 1 cell: how to build a “pro” dashboard engine

  • Posted 02 July 2026
  • By Andrei Mares
  • 10
  • 110

Stop wasting hours manually sorting, deduplicating, and filtering your data in Excel. Instead, combine FILTER, UNIQUE, and SORTBY to create a self-cleaning data engine that does all the work from a single cell and never needs updating.

To create a list in Excel that is filtered, deduplicated, and alphabetized all at once, you need to stack these three functions together:

=SORTBY(
UNIQUE(FILTER(array,include,[if_empty])),
UNIQUE(FILTER(array,include,[if_empty])),
[sort_order]
)

Nested formulas can quickly become a wall of text. To create the line break shown above, press Alt+Enter in the formula bar. This doesn’t change how the formula works, but it makes it much easier to type and audit. At first glance, you might notice that part of the formula repeats itself. This isn’t a mistake. To make this engine work without errors, you have to mirror the logic. I’ll explain exactly why we need to do this in Step 4 below.

[mai mult...]

Cum ștergi în siguranță fișierele sensibile pe Windows 11

  • Posted 26 May 2026
  • By Andrei Mares
  • 1
  • 70

Când solicitați Windows-ului să șteargă un fișier, de obicei o faceți cu speranța că fișierul va dispărea pentru totdeauna. Cu toate acestea, un serviciu bun de recuperare a datelor poate adesea readuce acele fișiere la viață.
Așadar, este important să știți cum să păstrați informațiile sensibile neschimbate.

[mai mult...]

BIOS Updates are no longer optional

  • Posted 28 August 2025
  • By Andrei Mares
  • 1
  • 486
  • BIOS updates can improve performance and compatibility while also adding important new features.
  • An old BIOS version poses a serious security risk that can compromise your entire system.
  • Updating your BIOS is now safer and easier than ever, so there’s little reason not to do it regularly.

If you own a Windows PC or laptop, you’ve probably been told to avoid BIOS updates unless something is wrong, likely to prevent a catastrophic issue like bricking your motherboard. However, with security, performance, and compatibility all at stake, I think they’re essential for all machines.

[mai mult...]

Creating Running Totals in Excel

  • Posted 13 August 2025
  • By Andrei Mares
  • 5
  • 491

Running totals show how figures build over an extended period, one entry at a time, allowing you to see trends and patterns that raw data alone might not reveal. Creating running totals in Excel is straightforward, but you must be careful to use the correct method depending on how your data is structured.

[mai mult...]

Microsoft is making major changes to Windows Security

  • Posted 02 July 2025
  • By Andrei Mares
  • -1
  • 471
[mai mult...]

Cum folosești TalkBack pe Google Chrome

  • Posted 02 July 2025
  • By Andrei Mares
  • 3
  • 693

With this accessibility feature on, the phone “talks back” to you, reading aloud whatever is on your screen. You just tap the screen, and it’ll read whatever’s currently in focus. That way, you can read web pages or click on buttons and links without ever looking at your screen. It can even describe images to you.

Since you’re using single taps to hear the screen out loud, you can’t use the usual touch gestures to interact with the phone. The Talkback feature comes with its own set of gestures to navigate the phone.Launching the Talkback welcome screen.

They’re pretty straightforward, but you have to learn them and practice getting them down. I hope to help you fast-track that process. We’ll start from the basics and build up from there.

[mai mult...]

5 Things to consider before picking your first linux distro

  • Posted 23 May 2025
  • By Andrei Mares
  • 10
  • 605

The Linux desktop environments (DEs) determine how the OS looks and feels and how you interact with it. The DE includes windows, icons, panels, menus, and any GUI you interact with when using the OS. Naturally, choosing the wrong DE will lead to a poor overall experience.

Not all Linux distros come with a DE preinstalled. Arch Linux and Debian lack both a DE and a GUI. You’ll need to set them up yourself. That’s why beginners should avoid these distros. Want to get to know some of the popular Linux DEs? Starting off, we have GNOME. It’s very popular but a huge departure from the conventional desktop experience seen on Windows or macOS. GNOME is super minimalistic with a heavy focus on virtual desktops for app management.

You can try Fedora for the vanilla GNOME experience.

Fedora Linux Activies Overview showing a the desktop switcher and dock.

Alternatively, you can use Ubuntu, where you get a customized GNOME experience supporting a dock and desktop icons to make it more user-friendly.

The Ubuntu Desktop With Dock and Icons

However, if you want something more familiar yet powerful, go with KDE Plasma. It’s highly customizable with tons of advanced settings and options.

KDE Neon Overview

By default, it looks like Windows. However, you can tweak it to resemble macOS—which is what Garuda Linux does.

That said, having so many options can be overwhelming—especially for those looking for a simpler OS. Cinnamon can be a great option here with its traditional Windows 7-ish layout and favorable balance between features and usability. It has a gentle learning curve to ensure you focus on using the OS instead of learning the OS. Linux Mint is the definitive way to experience Cinnamon.

Linux Mint Desktop Overview.

Now, there are dozens of other DEs, but I recommend starting with either GNOME, KDE Plasma, or Cinnamon. One of these will likely meet your needs. As you get comfortable, you can explore other DEs.

[mai mult...]

How to create shortcuts to frequently accessed Files on Google Drive for Android

  • Posted 23 May 2025
  • By Andrei Mares
  • 24
  • 285

Creating Google Drive shortcuts not only increases efficiency but also saves you time and streamlines your workflow. Instead of navigating through multiple layers of folders, a shortcut takes you directly to the file or folder you need.

As a writer, I regularly manage most of my project files in Google Drive. I often find myself repeatedly opening the same file or folder, and creating a shortcut is a quick and painless way to get back to it.

Furthermore, you can share shortcuts with colleagues or friends to enhance teamwork. Also, if you have a file in a shared team folder but want easy access from your personal folder, you can create a shortcut instead of duplicating the file. This way, you avoid cluttering your Drive with copies, and any updates made to the file are reflected everywhere.

[mai mult...]

Tips to improve your Search Experience on Windows

  • Posted 23 May 2025
  • By Andrei Mares
  • -5
  • 361
  • Use categories to filter search results by typing the category followed by a colon and search query for more precise results.
  • Utilize web search for specific information: search for time, weather, definitions, statistics, or currency conversions.
  • Enable cloud search for comprehensive results by turning on cloud search to include results from Bing, OneDrive, Outlook, and SharePoint.

Sometimes, it can be hard to quickly find the information you need using Search on Windows 11. But with a few tips and tricks, you can make it a breeze.

[mai mult...]

How to view all user Accounts on Windows 11

  • Posted 17 April 2025
  • By Andrei Mares
  • 4
  • 723
  • To view all user accounts on Windows 11, go to Settings > Accounts > Other Users. View family accounts at Settings > Accounts > Family.
  • To retrieve the account list using a command-line method, open Command Prompt, type the “net user” command, and press Enter.
  • To view more details about user accounts, in Command Prompt, type the “wmic useraccount get” command and press Enter.

Do you want to find out all the user accounts that exist on your Windows 11 PC? If so, you have both graphical and command-line methods to list existing accounts. I’ll show you the various ways to do that.

[mai mult...]
  • 1
  • 2
  • 3
  • 4
  • …
  • 7
  • Next

Statistici Autor

70 Solutii Create

45796 Vizualizari solutii

-8 Like-uri solutii

© Askit.ro, 2014 - 2026. All rights reserved. Done by Class IT