Profile cover photo
Profile photo
Professor Excel
6 followers -
Let's excel with Excel
Let's excel with Excel

6 followers
About
Posts

Post has attachment
Sounds like a standard task in #Excel, doesn't it?
Here are 5 methods of how to count the number of unique values in a list!
http://professor-excel.com/number-unique-records/
Add a comment...

Post has attachment
Today we have a rather exotic #Excel formula for you: FREQUENCY. Do you know it? Have you used it before?

http://professor-excel.com/frequency-formula-excel/
Add a comment...

Post has attachment
Ever struggled with 0 as return values from #Excel formulas when the actual value should be blank? Here is how to deal with this!

http://professor-excel.com/return-blank-cells-instead-zeroes/
Add a comment...

Post has attachment
Did you ever have to transform a table into one column in Excel? Copy all columns underneath each other? If yes: Check out these 4 methods! 👍👨‍💼

#excel #pivottables
http://professor-excel.com/copy-table-one-column-excel/
Add a comment...

Post has attachment
Add a comment...

Post has attachment

Post has attachment
Add a comment...

Post has attachment
Which one are you?
#excelfact #excel
Photo
Add a comment...

Post has attachment
Do you sometimes use the SUMPRODUCT formula in #Excel?

Here is everything you should know! 👉 http://professor-excel.com/sumproduct/
Add a comment...

Post has attachment
The series of advanced lookups in #Excel continues! Today: Case-sensitive lookups.
With these 4 methods of VLOOKUP, HLOOKUP, INDEX/MATCH and SUMPRODUCT, you can differentiate between capital- and small letters. 👍

http://professor-excel.com/case-sensitive-lookups/
Add a comment...
Wait while more posts are being loaded