Excel Genius

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

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

What is going to be the best way for me to get really good at excel? And I don’t really use it often in my day to day work so will have to learn outside of work.

like
Reaction Icon Like
Arrow Icon

What tools do you guys use for PDF conversion to Excel?

like
Reaction Icon Like
Arrow Icon

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

like
Reaction Icon Like
Arrow Icon

What is the most useful macro for my tax accounting professionals?

like
Reaction Icon Like
Arrow Icon

Anyone have any ideas on how to clean up an exported excel sheet that has the pound signs and random numbers? I tried some simple things like find and replace, can’t find an easier way

like
Reaction Icon Like
Arrow Icon

What’s an xlookup?

like
Reaction Icon Like
Arrow Icon

Power bi- how do I compile reports with different report header names and different number of column names?

like
Reaction Icon Like
Arrow Icon

PowerBI/Excel- have payroll data for full year and would like to calculate average pay per employee and extract records +\- 10% of average for each employee. Any ideas on how to go about this?

like
Reaction Icon Like
Arrow Icon

Anyone know how to delete multiple custom cell styles at once without running a macro?

Reaction Icon Like
Arrow Icon

Leaving this here for those who haven’t learned yet, as I just did.... You can create custom chart templates in excel, if you always reformat charts to the same style, you can ... continued ...

likesmart
Reaction Icon Like
Arrow Icon

There wasn’t a bowl for PowerPoint but posting it here. What are your top keyboard shortcuts you use for formatting slides in ppt. Tables, boxes, objects etc

like
Reaction Icon Like
Arrow Icon

Looking to set up conditional formatting to indent a cell if another cell has a certain number of characters. Please see comments for details.

Post Photo
like
Reaction Icon Like
Arrow Icon

Is there a way for Excel to scan through a row of rankings (high, medium, low) and assign an overall ranking? Eg: If high appears 4 out of 6 times, the ranking will automatically calculate as high.

Post Photo
like
Reaction Icon Like
Arrow Icon

Does anyone’s firm use Office 365? My firm is saying they don’t want to move 365 because it poses a security issue being in the web and we don’t have a big enough security team to monitor it.

funny
Reaction Icon Like
Arrow Icon

I rarely have to use formulas in Excel, so please be kind to me. Apart from conditional formatting cells, what formula can be used to display a word whenever a cell contains a range of numbers? Contd

like
Reaction Icon Like
Arrow Icon

What’s the best resource to learn how to do a complete DCF valuation?

like
Reaction Icon Like
Arrow Icon

Excel for Mac - Cannot access any of the buttons in the ribbon. When I click them they’ll depress but won’t present any of the options. Any ideas on how to fix?

Reaction Icon Like
Arrow Icon