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!

Tuesday, November 6, 2012

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!



Here is how it works.. Follow these steps carefully!

1.  Create one blank excel file and open it!


2.  Make sure that you are connected to the Internet and your IT does not block your website.


3.  Go to ribbon “Data” and click “From Web” on the Get External Data group tab.

4.  Type your website on the address box. Let’s use livescore.com for this example.


5.  The yellow-arrow boxes indicate the data that we can import to our spreadsheet. But first things first, let’s go to Option and check the Full HTML formatting option.


6.  Choose the table that you want to import and click Import.


7.  Let’s put our data at Cell A1 and click Ok.


8.  You’re all set! You can continue to pretend that you’re working!


By importing the table from web, we create an external connection to livescore.com! Once the connection exists, you don’t have to go through step 1-8 to get updated scores. You can simply click Refresh All. Your scoreboard will be automatically updated. As long as the connection exists, you can delete the table on your spreadsheet and click Refresh All later to get your scoreboard back.

You can remove this connection later. Here is how to do it.


Btw, you still need to click Refresh All to update your table. Or you can go to Connection Properties and set auto-refresh every minute.



Let’s imagine “other things” that you can do with this feature. By “other things”, I mean "something" that can speed up your work, something productive. For instance, you can create a magical-table that can update its value automatically (e.g. currency, scoreboard, points, share prices, market prices, etc).

That’s it! Don’t get too excited, People. There’s more to come!

See you in my next post!