Excel Genius

14906 members
Discussions, Useful Tips, Resources, Macros, More

Excel Geniuses- I need a macro the will convert a model with all USD to show it in British Pounds, and then back easily. Anyone have experience with this?

like
Reaction Icon Like
Arrow Icon

Looking for some good templates for venture planning (start-up financials). Any you would recommend?

like
Reaction Icon Like
Arrow Icon

Trying to make a stickie note macro in PowerPoint. Anyone know how to select the textbox and move cursor to the end using a PowerPoint macro?

like
Reaction Icon Like
Arrow Icon

Each country has multiple txns. Some complete, some not. What formula should I use to say if Indonesia has ANY “not complete” then show me the term “not done”. Tried IF(Index Match) but only (cont.)

Post Photo
like
Reaction Icon Like
Arrow Icon

Updated my VBE to have a black background and highlighter colour text - so satisfying!

like
Reaction Icon Like
Arrow Icon

Having an issue in a pivot table. I had an export pulled from Salesforce and when I add the “modified date” column the format is changing from 3/31/20 to: Year and Quarter (neither are fields in...

like
Reaction Icon Like
Arrow Icon

If a client uses a xlookup or match formula, will it work on my not updated version of excel?

like
Reaction Icon Like
Arrow Icon

Hi All! I would like to learn macros in excel. Does anyone have best YouTube or LinkedIn learning suggestions? Or any other free platforms?

like
Reaction Icon Like
Arrow Icon

I’m building an account mapping model and want to prevent the user from inserting a value into different tagging columns. I.e. an account shouldn’t be tagged in column E and columns G/H. Anyone know..

like
Reaction Icon Like
Arrow Icon

I may be late to the party but i absolutely LOVE that Excel now has a “Yes to all” option when you get that annoying notification of a tab already having the name of the tab you’re trying to copy.

like
Reaction Icon Like
Arrow Icon

Favorite online learning platform? Related to programming, Excel, web dev, or other technology

like
Reaction Icon Like
Arrow Icon

If a cell in Column F equals Y, I want the entire row to be deleted and moved to sheet titled Paid Invoices. What’s the macro I should use? Googled and still don’t understand. Thanks!

like
Reaction Icon Like
Arrow Icon

What are the most typical models you all build

likehelpful
Reaction Icon Like
Arrow Icon

Noob here:( Lead wants me to limit values in 5 columns - achieved Now she wants me to implement - If 1st column is filled and others' are empty, raise an error. Tried ISBLANK but it removes drop-down

like
Reaction Icon Like
Arrow Icon

So I built model that uses some VBA functions, but my boss insists on using a Mac and some of the functionality breaks when he tries to use the file. Does literally anyone else in finance use a Mac?

likefunny
Reaction Icon Like
Arrow Icon

Does anyone else have this issue that popped up? When I hit Alt + N it switches to the insert tab but doesn't allow me to continue the shortcut

like
Reaction Icon Like
Arrow Icon

Why when I refresh a query, the table where the query is loaded to just gets duplicate rows? Same with the pivot table that feeds off of that query?

like
Reaction Icon Like
Arrow Icon

I took up a new job at a tech company based out of Silicon Valley and my boss has been pushing hard for me to use Smartsheets but I hate it. I switch to excel whenever I can. Smartsheet vs Excel?

like
Reaction Icon Like
Arrow Icon

Best excel courses?

like
Reaction Icon Like
Arrow Icon

Has anyone ever installed / used kutools? Every time I google excel questions the kutools help articles whisper sweet nothings to me..

likefunny
Reaction Icon Like
Arrow Icon

Download the Fishbowl app

That was just a preview…
Sign Up to see all discussions
  • Discover what’s 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 with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.
Share

Embed this post

Copy and paste embed code on your site

Preview