What are some awesome, lesser-known Excel blogs or channels? I need to freshen up my knowledge.

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

Try https://www.myonlinetraininghub.com/, you should be able to find some interesting stuffs there. Perhaps look at the excel-webinars form the drop down menu. The excel keyboard shortcuts attached below might also be useful, see the link therein if you encounter a resolution problem.

Post Photo
like

This has to be the most creative, yet one of the worst, ways to show excel shortcuts I've ever seen

smartfunny

The best ones are lesser known for a reason. Sort of a DYOR will likely net you a niche specialist in the field of work your searching for, brilliant excel models and for free- if you do conduct just the right searches.

Related Posts

Any bank account recommendations for a sub40k salary?

like

Would you marry a man with ED if he was perfect otherwise?

likefunnyuplifting

Looking for folks who can refer for Energy and Utilities space for Consultant/Senior Analyst designation. For BCG, McK, Bain for India location. Any leads are appreciated

like

FJ12 band is which level??

I’ve only slept with one person, my wife. I have not openly shared this with anyone because there’s a stigma that I “settled” or I don’t have numbers on the board like a man should. I’m not overly religious, so that was never a driver in the equation. I admit, I do think about the “what if” every once in awhile but I’m honestly getting to the age where I feel I’m beyond my prime anyhow.

like

Accenture India Deloitte India Larsen & Toubro Infotech

Hi All, My joining is next Tuesday and these are the offers i hold : LTI (P3 position -30 LPA including 10% variable) Ltd. Deloitte India (Manager - 32 LPA including 12% performance bonus) Accenture ACN (L9 in Business & Technology integration - 33 LPA including 27% )

Skillset - GCP cloud Architect/ GCP Devops & Infra
YOE - 8.7

PLease suggest what I should join wrt to the overall WLB, JOB SECURITY, ANNUAL HIKE and SKILL GROWTH

I work through a contractor, and was hired 2yrs ago to be a Systems Test Engineer II. They decided last minute to make me a Software Content Manager, but kept my title as is since it was supposed to be a 6mo rotation. I’m still an SCM, and am taking on leadership roles in the group. How do I ask for a title change and pay increase to reflect what I actually do? Do I ask my contract house, or my NASA mgmt? Should I ask to make the pay retroactive since I was hired to do one thing, but do another?

like

Hi Everyone. Has anyone received any update/mail for the 8th aug joining batch?

Pros and cons to doing CDDs? I’m joining a firm that primarily does cdd projects and would love to hear some pros/cons.

like

Completely off topic
I don't have any friends.. sometimes i feel very lonely.. i don't have anyone to share my thoughts or feeling.. there is this void.. trying to pickup things to distract myself but it's not helping much... Seeking your inputs!! Sorry for this off topic question.

like

Facebook Ads after iOS 14 changes.

I'll share my experience and urge you to share yours:

Since iOS 14 changes, Facebook ads isn't the same anymore. Why?

A. >75% iOS users denied tracking. They are no longer tracked across websites/apps. Facebook lost its edge.
B. Targeting and conversion tracking aren't as effective anymore.
C. Many advertisers have been migrating their budgets from Facebook to Apple and Amazon ads.

What's your experience? Let's all learn.

#FacebookAds

like

Hello Fishes,

I urgently need a suggestion, yesterday I have joined a company, but I haven't submitted all the documents yet.
I'm yet to complete the on boarding process.
Can I abscond them today i.e. after 1 day?
If yes, what reason I should tell them?

Yesterday night, I have got a better opportunity.

like

Anyone thought of applying for the campaign in florida with Pascale?

Best tips for studying/prepping for case interviews? I am overwhelmed.

like

What is the salary range for MDM joining at Associate -BIM?
Yoe-5+ years

What are the perks of joining Oracle ? Like Broadband reimbursement, monitor , mobile, wfh set up etc ?

like

I woke up today tired.

My work cell was buzzing and then I remembered something.

I forgot to thank the bus driver that dropped me off a few days ago.

I got up and rushed downstairs to find the bus driver.

It was raining outside but I was already running barefoot to the bus stop.

I stood there soaked in my pajamas as the bus approached.

Then, the door opened. The driver got up and shook my hand.

I sat down and started my shift.

I’m the bus driver. Reminder to love and thank yourself.

funnylike

Do any attorneys here also have side gigs? Besides clearing conflicts and having professional liability insurance, is there anything else I need to consider?

like

Best men’s skin care products / brand? Face wash, in particular. I use Kiehl’s but looking to explore other brands. Thanks!

like

Roth vs Traditional 401k, thoughts?

like

Additional Posts in Excel Genius

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

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

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Anyone know what these badges are?

Post Photo
likefunny

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

How do I compare two sheets to make sure they are identical?

like

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Would anyone be willing to teach me vlookup?

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

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

Scan your QR code to download
Fishbowl app on your mobile

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