Alright fellas how do I become an excel genius easy answers only

like
Posting as :
works at
You are currently posting as works at

Udemy courses.. look for discounts and you can get the beginner to expert courses spending may be $30-$50 and your time in going over them.

This will get you through most used formulas.

Easy way - Learn vlookup, xlookup, sumif/s, countif/s, multiple and nested if conditions and date related formulas. These paired with good control on Pivots is pretty much widely used ones.

Related Posts

Hey so like - newfound reason for my procrastination since I got on Ritalin - a tendency towards "putting things off so I can enjoy the hyperfocus later". When I just started taking the meds I was super effective for a few weeks but now my brain seems to be figuring out ways around the drugs 🤦🏻‍♀️ any ideas on how to not fall back into procrastination behaviours?

like

Some book recommendations for software engineers. You're welcome. :)

Post Photo
likefunny

7-10 hashtags ✅, 15-20 people tagged ✅, delloited ✅

Post Photo
funnylike

What's the ECTC of a 3-year QA automation engg who wants to apply for an SDET? What is the package we can expect.

like

How much is the average salary for a healthcare advocate for an insurance company?

like

What are the biggests costs involved in starting a veterinary office?

like

Hello Community, has any of you appeared for a L3 DevOps Engineer at Walmart, just wanted a general idea about what kind of questions to expect. Thanks in advance

like

Hello All, I recently joined Nagarro. I have few queries. 1. If parents are included in HIS, by default at Nagarro? 2. How good is premium HIS at Nagarro? 3. How percentage of basic salary is pf deduction at Nagarro? Please answer my queries if you know. This will help me.
Nagarro

like

Anyone else turn all the watches in their watch box to 10:09 after they’ve stopped?

like

Capgemini campus offer holder.
Got a mail recently from superset platform asking for language certifications if available.
Can anyone give any insights on it? What if we don't have any foreign language certifications?

like

I'm about to graduate from uni and have sadly just realised that the creative industries I like aren't going to pay enough, so I want to get into consulting. Ideally in areas like marketing/branding/digital rather than MBB

I have no consulting experience and I have accepted an internship offer at an advertising firm for this summer. What steps would you advise me to take to get into consulting? Also, I get to pick between strategy and accounts for the internship - would either be more useful?

like

Hello. What is the average salary for a remote corporate recruiter? I have 4 years of experience in agency recruiting. Thank you!

like

155k with 7 YOE as a valuation manager in a HCOL, 30 years old, how am I doing so far?

like

Is the Chloé Nile now an outdated style? I feel like I never see it anymore (only the Tess and the faye) and some Chloe styles just don’t age well to me personally, like the Marcie. Not a huge fan of a lot of their newer released bags either.

like

Just saw that DWT in LA has an opening for a junior commercial lit associate position. Anyone know salary for a 2nd year? I had a good call with them before they had any junior positions open. Following up now. Tips/recs/advice welcome. Big move coming from ID

like

B4 peeps, had anyone heard about % salary increases this year? We are always told they benchmark against other B4s, but that’s surely BS.

like

My partner lateraled as a senior associate (now a 7th year) and hasn't yet received clear direction on ascension to partnership. Curious what your firms have told you about pathways to partnership? Are you eligible to be made partner as a 9th year? What factors go into consideration? Are you expected to generate business before you achieve partner? How much?

like

Urgent need of REFERRAL.

I am having 3 years of experience in JAVA DEVELOPMENT. Currently serving Notice Period and my LWD is 20th January.
Tech stack: JAVA, SPRING BOOT, SPRING MVC, HIBERNATE, MICROSERVICES.

Kindly refer me in your respective organisations.

like

Hi All - I have a final round case presentation coming up. I have to chose a company and create a 5-6 slide deck on how the company I’m interviewing for could implement its’ solutions to improve revs/profits at the company I chose. For people who have done this with success, do you have any tips? What was your approach with the deck? Did you use their branding/colors? Did you keep it simple or try to impress with your PowerPoint skills?

Any help is appreciated! TIA!

like

In which hikes are given in Accenture??

like

Additional Posts in Excel Genius

Tips on adjusting to Mac? I’ve figured lots of keyboard shortcuts but it’s just not the same 😪

like

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

What is y'all's preferred clipping tool? One of my former companies had a great simple program that was only like $50 and worth every penny.
Snipping Tool just ain't cuttin' it (lol pun intended).

like

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

What are the most annoying things for you in old-school excel users?
I’ll start:
1) vlookup 2) concatenate 3) inability to work with file versions, therefor constantly locking file from changes

like

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

What are your top Excel ninja tricks? Ones that few people know...

like

I am having difficulties getting my (Return on ad spend) column displaying correctly. The source data is shown in currency but on the pivot table I am only seeing count and percentage options. Any help would be greatly appreciated.

Post Photo
like

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

I really need some help.
What shortcut inverses my
Ctrl + [ aka Ctrl + {
which jumps through a cell to the source? How do I jump back? Manually isn't practical for a 50+ tab sheet

like

Hey, tips for where to look for good excel cheat sheets online? :)

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

like

Is there a way to consolidate non numerical data from multiple excel sheets into one master sheet?

like

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

What's the F4 analogy in Office 365?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal