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!
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?
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.
Is there a way to consolidate non numerical data from multiple excel sheets into one master sheet?
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
Power bi- how do I compile reports with different report header names and different number of column names?
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?
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 ...
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
Looking to set up conditional formatting to indent a cell if another cell has a certain number of characters. Please see comments for details.
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.
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.
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
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?