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
#msexcel #Microsoft365 #office365
There is #OnlyOne tool I have used continuously from #CollegeThroughToday
#msexcel #collegethroughtoday #onlyone
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? 😅
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
#Comedian #indianguru #powerpoint #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
#icaew #excel #icaew_excel #msexcel #functions #tips #tricks #workarounds #dynamic #arrays
@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).
#kanban #office #admin #trello #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.
#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
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
#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
#msexcel #excel #sql #datacleansing
What's the correct hashtag for microsoft products ?
#excel
#msexcel
#MicrosoftExcel
#excel #msexcel #MicrosoftExcel
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.
#msexcel #doctorwho #theboys #supernatural #games #reading #fanfic #fanart #fandoms #worldnews #bridgecardgame #art #writing #aotearoa #newzealand #introduction