HAN.xlsx [Read-Only] - Excel at Microsoft Excel!
Home
Introduction
Excel
101
So, you're new to spreadsheet huh.. Check this out!
Excel
Formula
How to write an excel formula!
New Posts
Love
Meter
Who is Your Crush's Big Time Crush?
Unprotect
Sheet
Remove password from protected worksheets and workbooks!
Dictionary
Attack
Open password-protected excel file using a dictionary attack!
Projects
Gag
Love
Meter
Who is Your Crush's Big Time Crush?
Other
Gag
Coming soon!
Social Network
Excel
Facebook
Coming soon!
Excel
Twitter
Coming soon!
Games
Formulas
Financial Modeling
Developer
Passwords
Password Recovery
Unprotect
Sheet
Remove password from protected worksheets and workbooks!
Dictionary
Attack
Open password-protected excel file using a dictionary attack!
Brute-force
Attack
Learn how to open password protected Excel File! Coming soon!
About
HANxlsx
About
Me
A little intro..
Privacy
Policy
Privacy Policy!
Disclaimer
Disclaimer!

[back to top!]

Coming up next!

Chatting and updating status using excel spreadsheet like a boss!

Our next excel project is to create a facebook-like excel spreadsheet that works like facebook. You don't say.. :D

Stay tuned, people! More cool stuff is coming!

Sunday, May 5, 2013

I’m Sick of Password-Protected Worksheets!


Aw man, I cannot edit and see the formula on this excel spreadsheet! Can you help to recover the password? YES, but not for free. There are too many websites that provide recovery service for your password protected file and worksheet for a small amount of fee.

Read through this post and you’re gonna be able to do it yourself. Trust me, it's free!

By the way, did I mention that nothing is unbreakable? Yes, I did. Check this post!


Wednesday, November 28, 2012

Part I: Open Your Password-Protected Excel File: A Dictionary Attack!

In cryptanalysis and computer security, a dictionary attack is a technique for defeating a cipher or authentication mechanism by trying to determine its decryption key or passphrase by trying likely possibilities, such as words in a dictionary.

A dictionary attack uses a targeted technique of successively trying all the words in an exhaustive list called a dictionary (from a pre-arranged list of values). In contrast with a brute force attack, where a large proportion key space is searched systematically, a dictionary attack tries only those possibilities which are most likely to succeed, typically derived from a list of words for example a dictionary (hence the phrase dictionary attack). Generally, dictionary attacks succeed because many people have a tendency to choose passwords which are short (7 characters or fewer), single words found in dictionaries or simple, easily predicted variations on words, such as appending a digit. However these are easy to defeat. Adding a single random character in the middle can make dictionary attacks untenable.

Friday, November 9, 2012

Naming Cells

Another way to make an absolute reference to the cells is to put a name on them. By naming the specific cells, you can easily use those names in your formula. For example, instead of typing =$A$1*B1, you can name cell A1 to any name that you want (let's say we name it "pung") and change the formula to =pung*B1. See the following embedded excel file:



Thursday, November 8, 2012

Get Initial from a Name - Because Full Name is Too Mainstream


Let’s say you have a list of Names, and you want the initials of the people. There are many ways to do it. The easiest one is to do it manually. You can just type in the initials to the column next to the Names. But it would take million years if you have trillion of names. Ok, I know I exaggerated things.

I will try to cover this topic in VBA section later. Before it happens, let’s see how to do it using simple excel formula.


Wednesday, November 7, 2012

Part II: Who is Your Crush's Big Time Crush?

So.. Where were we?

Yeah.. Who is Your Crush's Big Time Crush? And I told you that your spreadsheet is smart enough to tell you who your crush's crush.

By the way, you should probably check out this post if you have not read Part I!

Well, it really took me some time to re-write some of the VBA codes for this project. So, I decided to just update the 2003 version of XLS file instead of writing new VBA codes on 2007 XLSM file. But, I promise you that you won't notice any difference. If you are going to use the file provided below it should be working perfectly fine with 2007 version. As I've said before, I have not try to run the code on 2010 version. Just email me if you find any trouble!

Now, let's see how to set up everything! The time has come! Let your spreadsheet tell you who your crush's BIG-time crush is. Hopefully, it was YOU the entire time!

Tuesday, November 6, 2012

Conditional Formatting


For those who don't know about this function yet, conditional formatting allows us to format certain cells if it meets certain criteria. It can be useful to highlight certain cells in a list with a defining characteristic e.g. greater than certain amount, lower than certain amount, and etc.

See the following embedded final version of conditional formatting spreadsheet or click Download! to grab the file directly from hanxlsx.com.


How to Avoid Getting Caught Checking Scoreboard DWH?


So, you missed the BIG game last night. You don’t want to get caught browsing your sport-betting-website which provides live score during work hours, do you? For those who are addicted to soccer and would kill to check the scoreboard every-minute-every-hour-every-day during work hours, here are some tips for you.

So how exactly are we going to do all this?

We are going to use the “Get External Data” function on your Excel to feed your hunger for SCORE!