Skip to content
 
If you can read this, either the style sheet didn't load or you have an older browser that doesn't support style sheets. Try clearing your browser cache and refreshing the page.

(Some Guy)   This test will determine how skilled you are at Microsoft Excel. Difficulty: No Clippy help popups   (ratemyexcel.com) divider line
    More: Interesting  
•       •       •

1352 clicks; posted to STEM » on 22 Oct 2020 at 11:12 PM (5 weeks ago)   |   Favorite    |   share:  Share on Twitter share via Email Share on Facebook



52 Comments     (+0 »)
 
View Voting Results: Smartest and Funniest


Oldest | « | 1 | 2 | » | Newest | Show all

 
2020-10-22 10:03:23 PM  
Fark user imageView Full Size


Fark user imageView Full Size

Fark user imageView Full Size
 
2020-10-22 10:28:24 PM  
I'm skeered, I haven't used Exel for 20 years.
 
2020-10-22 11:21:09 PM  
Easy.

Search for "Excel how to XXX" and then read the first result.
 
2020-10-22 11:25:43 PM  
Intermediate--comfortable with most of the second column and have done an awful lot of VLOOKUP experiments from the third.

That said... I genuinely hadn't heard of half of the third column. That stuff is well outside of anything I've ever been asked to do.
 
2020-10-22 11:26:42 PM  
I got a chuckle out of the F1 gag.

/know almost everything in Excel
//moved on to Power BI
///Excel is just too slow and my datasets have gotten much too big for it
 
2020-10-22 11:28:00 PM  

clkeagle: Intermediate--comfortable with most of the second column and have done an awful lot of VLOOKUP experiments from the third.

That said... I genuinely hadn't heard of half of the third column. That stuff is well outside of anything I've ever been asked to do.


XLOOKUP is now here to solve the indecision between VLOOKUP and INDEX/MATCH
 
2020-10-23 12:05:51 AM  

clkeagle: Intermediate--comfortable with most of the second column and have done an awful lot of VLOOKUP experiments from the third.

That said... I genuinely hadn't heard of half of the third column. That stuff is well outside of anything I've ever been asked to do.


In the same standing as ckeagle.  Most Intermediate stuff down pat, no call to deal with the advanced.
 
2020-10-23 12:08:41 AM  
69 out of 70. But, I have written or served as a tech advisor for four books on BI and SSAS - I've written some of the docs you've used to learn some of the stuff in that test - so there's that, I guess.

I didn't bother with the wildcard, which is why it's not 70 out of 70.
 
2020-10-23 12:15:09 AM  
As an aside, PowerQuery can fark all the way off. There are still friggin' bugs! Five goddamned years, it's still so buggy it crawls.
 
2020-10-23 12:40:49 AM  
I suck at Excel but according to that test I'm an intermediate user.  I'm pleasantly surprised.
 
2020-10-23 1:03:24 AM  
The only thing I never wanted to learn was pivot tables.  Hate them, don't know really how to do them, don't care and despise when other people use them.  My firm belief is pivot-tables get people promoted in mid-level management and well, fark those people.

Have written entire programs in VBA to make spreadsheets to some amazing things.
 
2020-10-23 1:20:40 AM  
All I did was click on what's my score  .. It gave me a 0 out of 70, congratulated me for being in the top 5.9% of all the people who had taken the test .. Yea me ..
 
2020-10-23 1:32:51 AM  
Your browser was unable to load some necessary resources, contact your IT network administrator and ask him or her to allow access to...

I win!
 
2020-10-23 1:35:47 AM  
I can spell XL....
 
2020-10-23 1:37:08 AM  

madgonad: I got a chuckle out of the F1 gag.

/know almost everything in Excel
//moved on to Power BI
///Excel is just too slow and my datasets have gotten much too big for it


Since it kept bringing up F1, I had to go look up what it did.  I've never used it. Apparently, all it does is bring up the Help. Doesn't hitting F1 again make it go away or does it take a VBA macro, two reboots, and and a signed certficate import to do that and that's why it pisses people off enough to rip the keycap off the keyboard? I don't get it and being on mobile, I can't test it.
 
2020-10-23 1:48:24 AM  
Still missing Works...
 
2020-10-23 2:00:18 AM  
This was the spreadsheet I made to handle our little league draft. It had buttons, sliders, dropdowns, macros,  dialogs, and 10 sheets of supporting data. The basic idea was that it took all the evaluation data gathered from the tryouts and used it to rank the players from best to worst. The sorting weights could be modified on the fly depending on what factors were most important to you. During the draft, a single button assigned kids to their team as they were drafted, and the list would be updated so that it only showed the undrafted kids.
Fark user imageView Full Size

/I don't need no stinkin' test
 
2020-10-23 3:02:04 AM  
Pivot tables are an uncheckable abomination.

Never link excel to other applications unless you are trying to cause a disaster.
 
2020-10-23 3:52:23 AM  

RogermcAllen: Easy.

Search for "Excel how to XXX" and then read the first result.


Fark user imageView Full Size


I don't feel like I got better or smarter...
 
2020-10-23 6:51:23 AM  

Mooammar Al-Cowddafi: RogermcAllen: Easy.

Search for "Excel how to XXX" and then read the first result.

[Fark user image 676x428]

I don't feel like I got better or smarter...


That's actually safer for work than I had anticipated.
 
2020-10-23 7:24:25 AM  

RogermcAllen: Easy.

Search for "Excel how to XXX" and then read the first result.


This has helped me beyond counting at this point. Not just for excel either. Bless all the fine people who make 3 minutes or under, crisp and precise video How-Tos. They have my gratitude.
 
2020-10-23 7:31:28 AM  
Are there any other miserable sods here who use Excel with Oracle Smart View or... quel horreur... Dodeca?

RogermcAllen: Easy.

Search for "Excel how to XXX" and then read the first result.


You do realize this is how 90% of desktop support works, right?
 
2020-10-23 7:32:11 AM  
Excel is really the Swiss-Army knife of office software. Using VBA, I've made quite some interresting tools for myself that would not be worth the developpment of proper software.

But fark pivot tables. fark them up their stupid asses.

/I was the guy who translated Excell 2000 into French.
//That's the version that introduced pivot charts.
///Boy did I hate translating that part.
 
2020-10-23 8:14:44 AM  
I scored higher than I thought I would given that as a software developer, I tend to abandon Excel in favor of SQL Server send using real tools.

I don't do much with Excel outside of making basic tables and charts for viewing small data sets.

I cringe when I'm asked to provide real data in Excel and other have to tell folks, no, we need a real interface for this. Excel farks with datatypes and breaks data way too much to use as a data transfer thing. It's a cute little toy, but you shouldn't use it for much, and you sure as hell shouldn't link it up with other applications, pull datasets from SQL with it, etc.
 
2020-10-23 8:46:44 AM  

nitefallz: The only thing I never wanted to learn was pivot tables.  Hate them, don't know really how to do them, don't care and despise when other people use them.  My firm belief is pivot-tables get people promoted in mid-level management and well, fark those people.


Side fact:  Although M$ had trademarked the term "Pivot table" back in 1993, they  lost that protection this past April because they forgot to make a required filing.
 
2020-10-23 8:54:51 AM  
If you work with Excel long enough, you can actually configure it so that it does not annoy the ever loving shiat out of you.

Then they release a new version.
 
2020-10-23 8:57:22 AM  

Quantumbunny: pull datasets from SQL with it,


I puke SQL to CSV for Excel.  The Office query engine is a hot mess.  But everyone wants their data in Excel.  The entire US economy runs on frigging Excel.
 
2020-10-23 9:32:24 AM  
Histograms are a shiat show without installing the toolpack. Even then, you have to click on the correct part of the graph and it has to be a Tuesday afternoon that's also a full moon and Friday the thirteenth to get the option to change the gap between the bars.
 
2020-10-23 9:50:20 AM  
Just about my only use of Excel is making pivot tables.
 
2020-10-23 10:00:45 AM  
Intermediate. I knew I didn't know everything, and I routinely get questions on how to do something, but that advanced stuff is really advanced.

Also, INDEX/MATCH or GTFO
 
2020-10-23 10:22:22 AM  
VLOOKUP?

pfft, XLOOKUP is all the rage.
 
2020-10-23 10:28:33 AM  

Marcus Aurelius: If you work with Excel long enough, you can actually configure it so that it does not annoy the ever loving shiat out of you.

Then they release a new version.


hence I gave up doing that.  Got pissed at some new 'improved' interface every year it seemed.

Thank god for keyboard shortcuts to do something instead of trying to find where they hid the feature in the update.

I recall in win7 Excel wouldn't open in a separate instance natively.

I recently tried to write a macro for PowerPoint and learned they don't have the recorder feature in that software!  Why not, seems an easy thing to integrate.

VBA code documentation and examples for powerpoint were just not that helpful to me.  had to save 50 ppts as rich text format and wanted to automate the process.
 
2020-10-23 10:35:10 AM  
For those around intermediate that would like to learn some more, (shortcuts, advance functions, macros, vb...),  I got a lot out of this coursera course:

Excel/VBA for Creative Problem Solving, Part 1

its free with option to pay for graded assignments and certificate.  A few videos each day and I got done in about two weeks during those slow afternoons.
 
2020-10-23 10:41:47 AM  
Apparently I'm an intermediate user, which kind of tracks. I know enough about Excel to know there's a TON I haven't taken the time to learn (Visual Basic, DAX, etc.).

But I have found that Excel is a better tool for many of the things I have to do than SQL Server. At least, my staff takes a week to do something on SQL that I can do more accurately in an hour on Excel. So there's that. Yeah, my staff probably sucks.
 
2020-10-23 10:46:30 AM  

BetterMetalSnake: Apparently I'm an intermediate user, which kind of tracks. I know enough about Excel to know there's a TON I haven't taken the time to learn (Visual Basic, DAX, etc.).

But I have found that Excel is a better tool for many of the things I have to do than SQL Server. At least, my staff takes a week to do something on SQL that I can do more accurately in an hour on Excel. So there's that. Yeah, my staff probably sucks.


IIRC, you work in education, the amount of reports generated vs. those that are useful is a small overlap in academia.

Our data folk hate to teach other staff how to access the database to make their own useful reports.  Oh you just need the number of courses being offered in this discipline?  it will take a week and the report will have twenty other columns you don't need.
 
2020-10-23 12:17:37 PM  
No thank you.

I've been on long term disability for a couple of years now.  Things I miss about work:

- my colleagues
- the puzzle that is an unstarted project plan
- satisfaction from completing a project
- a full paycheck

Things I do not miss about work:

- Microsoft Excel (just because I'm good at it doesn't mean  I have to like it)
- Microsoft Powerpoint (just because I'm good at it doesn't mean  I have to like it)
- Microspoft Project (just because I'm good at it doesn't mean  I have to like it)
- Timesheets
- Pointy haired bosses who say things like "You're just the PM, you didn't do any of the work"
 
2020-10-23 12:21:36 PM  

lindalouwho: I'm skeered, I haven't used Exel for 20 years.


I want a LibreOffice test.
 
2020-10-23 12:28:16 PM  

Marcus Aurelius: Quantumbunny: pull datasets from SQL with it,

I puke SQL to CSV for Excel.  The Office query engine is a hot mess.  But everyone wants their data in Excel.  The entire US economy runs on frigging Excel.


That's changing. PowerBI is where it is at (Sorry Tableau, everyone still remembers Lotus 1-2-3, right?). If you can think in SQL and Excel learning PowerBI is a piece of cake. So now instead of looking at Pivot tables we will all start getting used to looking at Dashboards.
 
2020-10-23 1:33:31 PM  

Hyjamon: BetterMetalSnake: Apparently I'm an intermediate user, which kind of tracks. I know enough about Excel to know there's a TON I haven't taken the time to learn (Visual Basic, DAX, etc.).

But I have found that Excel is a better tool for many of the things I have to do than SQL Server. At least, my staff takes a week to do something on SQL that I can do more accurately in an hour on Excel. So there's that. Yeah, my staff probably sucks.

IIRC, you work in education, the amount of reports generated vs. those that are useful is a small overlap in academia.

Our data folk hate to teach other staff how to access the database to make their own useful reports.  Oh you just need the number of courses being offered in this discipline?  it will take a week and the report will have twenty other columns you don't need.


You are right on all of that. What is seldom understood is that the data staff all have full jobs before handling special requests. And about half the faculty have special requests that they need finished today. Also, the president and a few vice presidents also have a request also due today. Also, about half the requests asked for one thing, but they actually needed something else. Also, can you make this table more blue?

And when it is time to prepare the yearly budget, there's no money for additional analysts- "We just have to learn to do more with less." And my unit isn't even special. Much the same can describe most of the units I've worked with in the past. It's kind of a cluster.
 
2020-10-23 1:57:50 PM  

madgonad: Marcus Aurelius: Quantumbunny: pull datasets from SQL with it,

I puke SQL to CSV for Excel.  The Office query engine is a hot mess.  But everyone wants their data in Excel.  The entire US economy runs on frigging Excel.

That's changing. PowerBI is where it is at (Sorry Tableau, everyone still remembers Lotus 1-2-3, right?). If you can think in SQL and Excel learning PowerBI is a piece of cake. So now instead of looking at Pivot tables we will all start getting used to looking at Dashboards.


i learned tableau this past winter, fun pretty easy to use program.

Is picking up Power BI drastically different?  Tableau seems everyone's darling at the moment, but I keep hearing about PowerBI being mentioned since it is cheaper and I imagine integrates well with microsoft products.
 
2020-10-23 2:04:54 PM  

BetterMetalSnake: You are right on all of that. What is seldom understood is that the data staff all have full jobs before handling special requests. And about half the faculty have special requests that they need finished today. Also, the president and a few vice presidents also have a request also due today. Also, about half the requests asked for one thing, but they actually needed something else. Also, can you make this table more blue?

And when it is time to prepare the yearly budget, there's no money for additional analysts- "We just have to learn to do more with less." And my unit isn't even special. Much the same can describe most of the units I've worked with in the past. It's kind of a cluster.


I recently had the pleasure of this happen...

created a heatmap that tracked when a professors students were in and out of class.  the idea being you might not want faculty to hold office hours when 95 out of their 100 students are in someone else's class at that hour.  try to pick hours when your students were out of class.

presented it to my dean who then asked why I was spending time on 'personal projects".  And that she didn't understand why faculty being available for students is important.  This is at a primarily teaching college (no research).  My brain went blank as I couldn't believe I was just asked by the dean (who is now the VPAA) why faculty being available for students is a good thing.

can't wait to leave here.  Applying for a job at Twitter this weekend (and other places)
 
2020-10-23 2:15:58 PM  

Hyjamon: madgonad: Marcus Aurelius: Quantumbunny: pull datasets from SQL with it,

I puke SQL to CSV for Excel.  The Office query engine is a hot mess.  But everyone wants their data in Excel.  The entire US economy runs on frigging Excel.

That's changing. PowerBI is where it is at (Sorry Tableau, everyone still remembers Lotus 1-2-3, right?). If you can think in SQL and Excel learning PowerBI is a piece of cake. So now instead of looking at Pivot tables we will all start getting used to looking at Dashboards.

i learned tableau this past winter, fun pretty easy to use program.

Is picking up Power BI drastically different?  Tableau seems everyone's darling at the moment, but I keep hearing about PowerBI being mentioned since it is cheaper and I imagine integrates well with microsoft products.


BI is even easier once you know Tableau. It is a very similar product to Tableau, Microsoft just leveraged the Excel experience and made the platform interoperable with practically anything. The simplicity of joining disparate sources like a corporate data warehouse, internal spreadsheets, third-party Cloud and web content into a single dynamic Dashboard is the killer business app of this decade. I'm using the ODBC driver right now to extract from some seriously archaic platforms that previously had extremely burdensome ETL to access.

Or to put in simply - if you know SQL, Tableau, and modern Excel - you already know Power BI. Just watch some training videos like Dashboard in Day and everything will click into place.
 
2020-10-23 2:25:33 PM  
39/70, which apparently places me into the "Expert" categories.

I still find charts and pivot tables to be a biatch to deal with...
 
2020-10-23 2:38:51 PM  
 
2020-10-23 2:43:41 PM  

madgonad: Hyjamon: madgonad: Marcus Aurelius: Quantumbunny: pull datasets from SQL with it,

I puke SQL to CSV for Excel.  The Office query engine is a hot mess.  But everyone wants their data in Excel.  The entire US economy runs on frigging Excel.

That's changing. PowerBI is where it is at (Sorry Tableau, everyone still remembers Lotus 1-2-3, right?). If you can think in SQL and Excel learning PowerBI is a piece of cake. So now instead of looking at Pivot tables we will all start getting used to looking at Dashboards.

i learned tableau this past winter, fun pretty easy to use program.

Is picking up Power BI drastically different?  Tableau seems everyone's darling at the moment, but I keep hearing about PowerBI being mentioned since it is cheaper and I imagine integrates well with microsoft products.

BI is even easier once you know Tableau. It is a very similar product to Tableau, Microsoft just leveraged the Excel experience and made the platform interoperable with practically anything. The simplicity of joining disparate sources like a corporate data warehouse, internal spreadsheets, third-party Cloud and web content into a single dynamic Dashboard is the killer business app of this decade. I'm using the ODBC driver right now to extract from some seriously archaic platforms that previously had extremely burdensome ETL to access.

Or to put in simply - if you know SQL, Tableau, and modern Excel - you already know Power BI. Just watch some training videos like Dashboard in Day and everything will click into place.


I took an SQL course, I got the hang of it in general. I just don't use it every day enough to where I can query easily; I'd have to reload all of that syntax into my brain.  Also not to clear on what to learn, there seem to be so many SQL. noSQL, mongoDB, SQLite, similar products listed on job postings.

can't wait to get a job somewhere in the data field so I can focus on a few software platforms instead of trying to become familiar with all of them.  Currently writing up something I did in MatLab a year ago and having to parse the code again to recall what the moving parts were doing.

thanks for the reply
 
2020-10-23 2:55:52 PM  

Hyjamon: madgonad: Hyjamon: madgonad: Marcus Aurelius: Quantumbunny: pull datasets from SQL with it,

I puke SQL to CSV for Excel.  The Office query engine is a hot mess.  But everyone wants their data in Excel.  The entire US economy runs on frigging Excel.

That's changing. PowerBI is where it is at (Sorry Tableau, everyone still remembers Lotus 1-2-3, right?). If you can think in SQL and Excel learning PowerBI is a piece of cake. So now instead of looking at Pivot tables we will all start getting used to looking at Dashboards.

i learned tableau this past winter, fun pretty easy to use program.

Is picking up Power BI drastically different?  Tableau seems everyone's darling at the moment, but I keep hearing about PowerBI being mentioned since it is cheaper and I imagine integrates well with microsoft products.

BI is even easier once you know Tableau. It is a very similar product to Tableau, Microsoft just leveraged the Excel experience and made the platform interoperable with practically anything. The simplicity of joining disparate sources like a corporate data warehouse, internal spreadsheets, third-party Cloud and web content into a single dynamic Dashboard is the killer business app of this decade. I'm using the ODBC driver right now to extract from some seriously archaic platforms that previously had extremely burdensome ETL to access.

Or to put in simply - if you know SQL, Tableau, and modern Excel - you already know Power BI. Just watch some training videos like Dashboard in Day and everything will click into place.

I took an SQL course, I got the hang of it in general. I just don't use it every day enough to where I can query easily; I'd have to reload all of that syntax into my brain.  Also not to clear on what to learn, there seem to be so many SQL. noSQL, mongoDB, SQLite, similar products listed on job postings.

can't wait to get a job somewhere in the data field so I can focus on a few software platforms instead of trying to become familiar with all of them.  Currently writing up something I did in MatLab a year ago and having to parse the code again to recall what the moving parts were doing.

thanks for the reply


If you learn ANSI compliant SQL, that syntax should work across all of them.

You may need to specialize if you want to manage instances, be a DBA, etc. But to know SQL and be able to query it well, you really shouldn't need to specialize.
 
2020-10-23 2:56:27 PM  

Hyjamon: I took an SQL course, I got the hang of it in general. I just don't use it every day enough to where I can query easily; I'd have to reload all of that syntax into my brain.  Also not to clear on what to learn, there seem to be so many SQL. noSQL, mongoDB, SQLite, similar products listed on job postings.

can't wait to get a job somewhere in the data field so I can focus on a few software platforms instead of trying to become familiar with all of them.  Currently writing up something I did in MatLab a year ago and having to parse the code again to recall what the moving parts were doing.

thanks for the reply


You don't 'need' to use SQL in Power BI, but if you already have a library of SQL queries you can drop them right in and put them to work. No need to reinvent the wheel.

You will love the integrated Transform functions in Power BI. Just identify and perform the transformation steps once and it is automatically done going forward. Oh, and those Transform steps are easily edited going forward. Microsoft has essentially taken the complete list of 'wants' and 'desires' of the data analytics community and built it all right in.

For people choking on ancient (90s) reports. Just make sure each type of report is in its own folder and you can have it scrap all of the similarly formatted files and build a giant table holding years worth of daily reports. For businesses that are not 100% data warehouse, Power BI can be a skeleton key to bring everything together.
 
2020-10-23 2:58:49 PM  

Quantumbunny: If you learn ANSI compliant SQL, that syntax should work across all of them.


It can handle my Teradata SQL just fine. It isn't 'that' different, but MS could read it and execute correctly. Don't know how many other 'flavors' of SQL that have compatibility, but at least some of those dialects will work.
 
2020-10-23 3:10:11 PM  

Quantumbunny: If you learn ANSI compliant SQL, that syntax should work across all of them.

You may need to specialize if you want to manage instances, be a DBA, etc. But to know SQL and be able to query it well, you really shouldn't need to specialize.


looking more toward data science/analyst and machine learning/AI
 
2020-10-23 10:45:30 PM  

Linux_Yes: lindalouwho: I'm skeered, I haven't used Exel for 20 years.

I want a LibreOffice test.


Forkin' ay.
 
Displayed 50 of 52 comments


Oldest | « | 1 | 2 | » | Newest | Show all


View Voting Results: Smartest and Funniest

This thread is closed to new comments.

Continue Farking





On Twitter



  1. Links are submitted by members of the Fark community.

  2. When community members submit a link, they also write a custom headline for the story.

  3. Other Farkers comment on the links. This is the number of comments. Click here to read them.

  4. Click here to submit a link.