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.
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)
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?
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?
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
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?
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!
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
Can you share the most useful formulae and built in automation features you have used with the latest version of excel?
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!
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 ?
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.
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?