Excel Genius

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

Are the betas pulled straight from CapIQ levered or unlevered?

Reaction Icon Like
Arrow Icon

At KPMG we had an audit toolbar that let you re-number multiple spreadsheets at once. Now I’m at a new firm and would love to have something similar for tying out spreadsheets with tons of tabs.

Reaction Icon Like
Arrow Icon

I have a pivot with a connected pivot chart. Rows: matter of expenses, columns: months. I filter the departments by a slicer, which works fine but do I have to make a new pivot for every year (cont)

Reaction Icon Like
Arrow Icon

Anyone have a good reason to use the nested choose function with vlookup versus using index/match?

Reaction Icon Like
Arrow Icon

My company wants to put everyone onto Microsoft Office 365 - the free, open version, and uninstall the standard Microsoft applications from our computers. How will this effect Excel functionality?

Reaction Icon Like
Arrow Icon

Best way to visually display trending data on sales when looking at how a few factors influence volume and price? Also any tips for including both in the same chart?

Reaction Icon Like
Arrow Icon

I did this manually but would there be a way to pivot the dates (day/month) in the rows years in columns with raw data being (date/month/year) needed a visual of same day different year

Post Photo
Reaction Icon Like
Arrow Icon

I’m a Junior accountant, recent MBA grad in Finance, located in NYC, just got laid off due to a merger. Anybody hiring or know any opening positions?

smart
Reaction Icon Like
Arrow Icon

Hello! Is there any VBA coding to clear all column filters in a pivot table? I see how to remove all fields... But I want to keep all the fields and just clear all the filters. Thanks!

like
Reaction Icon Like
Arrow Icon

Is there an absolute moron’s guide to Index Match? I have two tables of users, some exist on table A that don’t on B, and vice versa. I need to merge them based on their email as the unique identifier

like
Reaction Icon Like
Arrow Icon

Can you share the most useful formulae and built in automation features you have used with the latest version of excel?

like
Reaction Icon Like
Arrow Icon

Is Tableau it Power BI better for dashboards? You cannot really do true dashboards in Excel.

like
Reaction Icon Like
Arrow Icon

3 unconventional but useful formulas a consulting newbie should master?

like
Reaction Icon Like
Arrow Icon

What are your top 3 productivity hacks in excel O365?

like
Reaction Icon Like
Arrow Icon

I’ve used Excel for over 15 years. Functions and VBA were my go-tos. But today I just learned about power query (now known as “Get and Transform Data”). Total game changer. That’s all I have to say!

likeupliftingsmart
Reaction Icon Like
Arrow Icon

I have an excel workbook that is protected, I’D like to get the information/formate into a separate file so I can edit some of the cells. Is there a way to do so without knowing the password ?

Reaction Icon Like
Arrow Icon

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.

Reaction Icon Like
Arrow Icon

Help with unexpected results using round function (cont)

Reaction Icon Like
Arrow Icon

Formula to convert the date on the left to the date on the right? I’ve been using text to columns then concatenation but I feel there must be a better way...thoughts? Thanks!

Post Photo
likehelpful
Reaction Icon Like
Arrow Icon

I want to create a heat map of when people are unavailable with day of week as the columns and hour of day as the rows. I have start times and end times, how can I use this data to create the map?

like
Reaction Icon Like
Arrow Icon