First boss defeated 😎

Looks like it's time to step off our path in Excel and switch to SQL.

Since the beginning of the year, we've covered a ton of topics and analyzed Excel inside and out. Essentially, it turned into a mini-course, although I initially thought it would be "a couple of posts and that's it."

Here's the trail so you don't get lost:
- Why EXCEL = BASICS
- Basic functions for an easy start
- How to color tables automatically: formatting
- How and with what to link tables: VLOOKUP, XLOOKUP, INDEX+MATCH
- What is data filtering and what is it eaten with
- Data Quality: how to avoid junk in Excel
- Hotkeys for work
- Install fresh Office without VPN
- Settings to turn Excel into a working analytical system
- The pinnacle of automation: macros in Excel

While putting together the collection, I was surprised at how much we've accumulated 😨

To wrap up the topic and not leave you without a bonus, I've compiled a large article with charts and tables - go check it out: [link to article].

And another bonus. I've put together a "mini" guide... well, mini, 17 pages 😂
It includes:
- what to learn in Excel and in what order;
- why and why exactly that way;
- where to get datasets and what exercises to do to get the hang of it.

You can easily go through it and bring your Excel up to a "ready for employment" level. I'll put the file in the comments.

It turned out to be a good journey. I even grew fond of Excel - it's a shame to leave it. But over the weekend we'll reboot and start with SQL.

Thank you for enduring this entire route and leveling up your Excel. The full route is still available on the map here .

I'd be glad if you share the post with your friends. The information is extremely useful and gathered in one pot 😎

@data_dzen 🙂