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. #MSExcel #Microsoft365 #Office365

https://www.kunal-chowdhury.com/2023/09/time-saving-excel-tips.html

There is #OnlyOne tool I have used continuously from #CollegeThroughToday

#MSExcel

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

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

Lost two hours of work on an #msexcel 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? 😅

On programming for excel using only formulae and data ranges. #msexcel

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

LMAO @ this #comedian acting like an #IndianGuru going on about #Powerpoint

https://yewtu.be/watch?v=fQdAHqOrM2w

#Comedy #FuckMicrosoft #FuckPowerpoint #FuckExcel #MSExcel #MS #MSPowerpoint

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

For #ICAEW members, my tips on the tricks needed to get some #Excel functions to handle arrays and ranges and return arrays, is live on the #ICAEW_Excel page. Requires member login.
https://www.icaew.com/technical/technology/excel-community/excel-community-articles/2023/excel-tips-and-tricks-467

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.

#msexcel #functions #tips #tricks #workarounds #dynamic #arrays

When a dozen people attempt to edit (separate cells) on an #MSExcel 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. #IT

@miriamjones well, #kanban has been around for decades. At least as a method for industrial production control. But even for #office and #admin 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. #Trello or even #libreoffice #calc (#msexcel).

Hi, I"m James and this is my #introduction.

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

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

What I'm into: #Photography, #Cooking, #Grilling, #StarWars, #StarTrek, #80sMovies, #JurassicPark, #Marvel, #dinosaurs, #computers, #gadgets, #VBA, #Python, #MSExcel, #art, #archaeology, #history, #3DPrinting, #philosophy, #news, 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.

Global #Excel 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 https://lnkd.in/djEzkn3. And get ready to Excel Beyond Expectation. #excel #microsoftexcel #globalexcelsummit #msexcel

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

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...)

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

What's the correct hashtag for microsoft products ?
#excel
#msexcel
#MicrosoftExcel

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 #excel or #msexcel stuff here.

#introduction

Hi all. I’m Cee.

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

Ex-pat Brit living in #NewZealand #Aotearoa. proud new kiwi.
12 alpacas, 4 sheep, 2 dogs & one human (grumpy).
Into #writing, #art, #bridgecardgame, #worldnews, #fandoms, #fanart, #fanfic, #reading, #games, #Supernatural, #TheBoys, #DoctorWho, #msexcel … I could go on but even I’m getting bored.
Ex IT developer, tester, & Project Manager.
Often sarcastic. Occasionally annoyed.

Do you know MS Excel? This is how

#msexcel #fmwc #excelgod

https://youtu.be/3kMaLZna07s