I don't mean someone who knows Excel well; I mean an actual expert-level user who can diagnose and troubleshoot formatting issues.

Thanks

Wouldn't say expert, you know that is a former spurt. But post this issue and I or someone more experienced can take a crack at it.

I'm an Excel wizard. Formulas and VBA programming are my forte. But formatting stuff should also be easy for me.

So let me know what I can do for you, boss. I'd be glad to help.

Outside of vba & macros, I'd put myself near, or just under, expert level as well.

^^^^^^^^^^^^^^

My experience with excel is completely opposite.

I'm a certified novice at using the actual Excel application.
I did do a lot of Microsoft office automation. It wasn't done using Office interface however. I used visual studio to write C# and VB applications that would populate existing Excel templates provided by the accounting departments with queries from SQL or Oracle.
I even wrote applications that would recursively navigate sub-folders and change/replace/delete VBA code inside existing Excel or Word documents. I would break into password protected Excel/Word documents at the request of management after employees left the company.

I rate myself a 4/10 in Excel, because I know what it’s capable of.

Most people think I’m an 11/10 in Excel. Formulas, formatting, pivot tables I am pretty amazing at. VBA I’m mediocre.

Para, I’m sure Rey and 250 have you covered, but feel free to reach out if you like.

By the way, expert… An Ex is a has been, and a spurt is just a drip under pressure.

My thanks to all of you.

Happy to help as well if needed. My Excel ability has gone through the roof the past 7 years in my current job.

quote:

Originally posted by Beancooker:
I rate myself a 4/10 in Excel, because I know what it’s capable of.

Most people think I’m an 11/10 in Excel. Formulas, formatting, pivot tables I am pretty amazing at. VBA I’m mediocre.

Para, I’m sure Rey and 250 have you covered, but feel free to reach out if you like.

By the way, expert… An Ex is a has been, and a spurt is just a drip under pressure.

It always amuses me when I'm on an interview panel and one of the questions is to rate your skills in Excel on a scale of one to ten. If anyone says 10, I pretty much know in advance the rest of the answer is going to be a shitshow. "I'm an expert because I use it every day as a grocery list." -Sure you are.

I also hate getting that question- because I know what excel can do, and I know my skills probably put me at about a 4 too, but some of the other candidates will be answering 10 for the reason given above. And I've been on interview panels where the the scoring is set up so the 10 is what counted, even if the person is clearly an ignorant idiot.

I doubt it will help, but Format Painter is your friend!

quote:

Originally posted by Perception:

It always amuses me when I'm on an interview panel and one of the questions is to rate your skills in Excel on a scale of one to ten. If anyone says 10, I pretty much know in advance the rest of the answer is going to be a shitshow. "I'm an expert because I use it every day as a grocery list." -Sure you are.

I also hate getting that question- because I know what excel can do, and I know my skills probably put me at about a 4 too, but some of the other candidates will be answering 10 for the reason given above. And I've been on interview panels where the the scoring is set up so the 10 is what counted, even if the person is clearly an ignorant idiot.

The way I explain when I get asked that question is that out of a thousand Excel users, I’m in the top 2 or 3. I started with Quattro pro in early 90s. And while I am advanced in formulas, VBA to open of looking for files and extracting data like discussed above, I can look at big data sets, see the relationships between fields, and come up with a process to get the desired information. Some of my projects included building an Materials Requirement Planning file where the file issued recommended build schedules for several finished goods based on minimum inventory requirements, allowed overriding the recommended schedules, then drive those requirements down to shared subassemblies and finally to how many of which raw parts had to be ordered when based on what’s in inventory, order lead times, and when they needed to be received and inspected. I had a working model in 6 weeks because the SAP system they had wasn’t working with no estimate of a fix.

I also did a stock allocation program that allocated newly produced goods across several countries’ warehouses so that each warehouse had the same days in hand based on the forecast against each warehouse and its safety stock requirement. The logistics department said they couldn’t find a software to do that for the three areas outside the US. I offered to create an Excel solution and everyone was skeptical except one colleague. He knew what I was capable of. I did that in 3 weeks.

But yes, I met people who think they know Excel because they can enter numbers in the correct cell. I suppose it’s similar to people who know how to drive versus the bodyguards who drive cars or NASCAR drivers.

^ With that sentiment, I'd say I'm more top 10-20% out of a thousand users, in raw Excel use.

In my company of around 400, I'd say I'm easily top 3.

I'm finally learning VLOOKUP....what took me so long

quote:

Originally posted by parabellum:
I don't mean someone who knows Excel well; I mean an actual expert-level user who can diagnose and troubleshoot formatting issues.

Thanks

I use data from a host of sources, including .pdfs and Word files, and that always requires some degree of reformatting.

If I can help, please let me know.