The amazing Excel hacks will make you realize that most of what you do manually can be done automatically.

This post covers these techniques to help you execute tasks quickly and become more productive.

kunal-chowdhury.com/2023/09/ti

#msexcel #Microsoft365 #office365

Last updated 1 year ago

usbs-usa · @usbs_usa
34 followers · 380 posts · Server glasgow.social

There is tool I have used continuously from

#msexcel #collegethroughtoday #onlyone

Last updated 1 year ago

Jon R · @saibeaks
22 followers · 57 posts · Server fosstodon.org

Learning some stuff about cash flow, upfront vs deferred charges, and bending to help with commercial reviews.

#msexcel

Last updated 1 year ago

Jon Rocrym · @rocrym
60 followers · 209 posts · Server masto.ai

Work re-done after dinner (and double checked it has saved correctly now).
I leveraged functions that greatly improve usability of this pricing sheet:

FILTER (filters array based on a condition, returns an array)
SORT (sorts array)
UNIQUE (self explanatory)
(array = cell range)

#msexcel

Last updated 2 years ago

Jon Rocrym · @rocrym
60 followers · 208 posts · Server masto.ai

Lost two hours of work on an spreadsheet due to (I believe) some onedrive/sharepoint interaction.

On the other hand, the thought process has taken place, hence the fix will be hopefully shorter.

How's your Saturday evening going? 😅

#msexcel

Last updated 2 years ago

Jon R · @saibeaks
22 followers · 52 posts · Server fosstodon.org

On programming for excel using only formulae and data ranges.

#msexcel

Last updated 2 years ago

Jon R · @saibeaks
22 followers · 51 posts · Server fosstodon.org

VLOOKUP is like static routing: configure it, it works, but watch out if you change stuff in the vicinity. (Note: use XLOOKUP whenever possible)

#excel #msexcel #networking

Last updated 2 years ago

one2seven · @one2seven
22 followers · 121 posts · Server kolektiva.social
Blue · @blue
348 followers · 95 posts · Server blimps.xyz

Still baffles me that Excel can randomly lock up and peg my processor to 100% for 5 minutes while undoing "insert blank row".

#msexcel

Last updated 2 years ago

ExcelAnalytics · @ExcelAnalytics
108 followers · 149 posts · Server mastodon.world

For members, my tips on the tricks needed to get some functions to handle arrays and ranges and return arrays, is live on the page. Requires member login.
icaew.com/technical/technology

Excel Tips & Tricks #467 - Excel functions that are harder to get to return arrays or ranges
Such as AND, OR, and date functions like EOMONTH.

#icaew #excel #icaew_excel #msexcel #functions #tips #tricks #workarounds #dynamic #arrays

Last updated 2 years ago

Jon Rocrym · @rocrym
46 followers · 100 posts · Server masto.ai

When a dozen people attempt to edit (separate cells) on an sheet at the same time, the scrolling back and forth is a bit dizzying.

Better if using the Web browser, and not the desktop app. Still, this multi-author feature looks like magic to me.

#msexcel #it

Last updated 2 years ago

@miriamjones well, has been around for decades. At least as a method for industrial production control. But even for and stuff, kanban has been around for ~15 years. A good book to get started is Mike Burrows's "Kanban from the inside". You can use any kind of software you like, e.g. or even ().

#kanban #office #admin #trello #libreoffice #calc #msexcel

Last updated 2 years ago

Real_JamesCain · @real_jamescain
457 followers · 2350 posts · Server techhub.social

Hi, I"m James and this is my .

I'm originally from a rural town in middle Missouri but now call my home. I have a love for the American southwest (my Mom is from New Mexico) and for the coastal city of .

I'm single, live alone with two () named Amelia and Penelope. I'm a , can't stand money in , and yearn for a day when the improve their messaging and start fighting back.

What I'm into: , , , , , , , , , , , , , , , , , , , , and you'll find I'm a bit of an all-around nerd.

I'm sarcastic as all get out but I have a big heart, that's easily broken when I see people (or animals) hurting.

I also have a bad habit of hating how I sound, so don't be surprised if this post doesn't last.

#introduction #saintlouis #savannah #Georgia #Dachshunds #dogs #progressive #liberal #Politics #democrats #photography #cooking #grilling #StarWars #startrek #80smovies #jurassicpark #marvel #dinosaurs #computers #gadgets #vba #python #msexcel #art #archaeology #history #3dprinting #philosophy #News

Last updated 2 years ago

ExcelAnalytics · @ExcelAnalytics
83 followers · 69 posts · Server mastodon.world

Global Summit
FREE tickets to day 1 are also available, but HURRY! There is a limited number. Now is the time to take advantage and register your place. Get your Early Bird Ticket at lnkd.in/djEzkn3. And get ready to Excel Beyond Expectation.

#excel #MicrosoftExcel #globalexcelsummit #msexcel

Last updated 2 years ago

Rob R · @Haggisnwhisky
79 followers · 59 posts · Server infosec.exchange

Let's face it, the world runs on , from the smallest to the biggest companies. This is across all functions from finance to

One of the lesser known functions I've been using this week is =INDIRECT(). This lets you put a file/worksheet/cell reference as text into one of your cells, I guess as a text-based pointer, and then use it to call up the value you're referring to. This is a bit like creating a pointer (as text) and then dereferencing it to obtain its value (if you're into that kind of programming)

So if you have the following structure, then A3 will display the value from A1 (1337)
- A1 = "1337"
- A2 = "A1"
- A3 = "=INDIRECT(A2)"

(cont...)

#msexcel #infosec

Last updated 2 years ago

ExcelAnalytics · @ExcelAnalytics
59 followers · 34 posts · Server mastodon.world

@gaspart @ruud Heh, you use what you've got!
Throw in INDEX/MATCH and LIKE too 😀

#msexcel #excel #sql #datacleansing

Last updated 2 years ago

Baudouin El Khoury · @bek
1 followers · 33 posts · Server ioc.exchange

What's the correct hashtag for microsoft products ?


#excel #msexcel #MicrosoftExcel

Last updated 2 years ago

Patrick O'Beirne · @PatrickOBeirne
5 followers · 14 posts · Server mastodon.ie

For those followers who were dragged over from my test account while I'm learning how this works .... I intend this to be personal fun. I'll leave @excelanalytics on Twitter as the work account until I see some or stuff here.

#excel #msexcel

Last updated 2 years ago

Randomlycee · @randomlycee
36 followers · 245 posts · Server mas.to

Hi all. I’m Cee.

Things I love so far about Mastodon? Hashtags! They’re actually useful here!

Ex-pat Brit living in . proud new kiwi.
12 alpacas, 4 sheep, 2 dogs & one human (grumpy).
Into , , , , , , , , , , , , … I could go on but even I’m getting bored.
Ex IT developer, tester, & Project Manager.
Often sarcastic. Occasionally annoyed.

#msexcel #doctorwho #theboys #supernatural #games #reading #fanfic #fanart #fandoms #worldnews #bridgecardgame #art #writing #aotearoa #newzealand #introduction

Last updated 2 years ago

AiRolG · @airolgloria
15 followers · 406 posts · Server mastodon.online

Do you know MS Excel? This is how

youtu.be/3kMaLZna07s

#excelgod #fmwc #msexcel

Last updated 4 years ago