Excel Tutorials Collection from Youtube

Excel Tutorials 2010

VLOOKUP Function for Beginners

How to createa monthly budget worksheet

Tutorial - Excel 2010 - 10 Things you must know

INDEX & MATCH functions Beginner to Advanced 19 Examples

Excel Data Analysis: Sort, Filter, PivotTable, Formulas

How to Create a Summary Report from an Excel Table

Tour Of Excel: Formulas, Formatting, Sort, Filter, PivotTables,

http://www.youtube.com/watch?v=IO7bCmtW7XY

SUMIFS Function (Excel Magic Trick 978): Add with 1 or More Criteria 36 Examples & SUMIF function

Office 2010 Class #38: Excel IF Function Formula Made Easy

Excel Magic Trick #506: Summarize Data - Multiple Sheets & Banks Accounts - Checkbook Register

Transfer data from one Excel worksheet to another automatically

How to Protect Cells that Contain Formulas in Excel

How to link two (multiple) workbooks and cells in Excel

Create an Excel UserForm Part 1 of 3

Create an Excel UserForm Part 2 of 3

Create an Excel UserForm Part 1 of 3

Dragon Nest KR PvP Ladder 60S Hero Weapons

Dragon Nest KR will open Dragon Nest 2.0 update on June 13 and there comes updates on PvP ladder. The images below are about pvp ladder 60s hero weapons.

Please note that Dragon Nest KR has not announced it officially so it it not 100% true.

Hero weapons' icons

Hero weapons' icons

Hero weapons' icons

Long sword

Axe

Hammer

Armguard

Archer hero weapons' icons

Longbow

Short bow

Cross bow

Academic hero weapons' icons

Cannon

Kabbalah

Credits/Reference/Source:

http://dn.mmosite.com/news/2013-06-08/dragon_nest_kr_pvp_ladder_60s_hero_weapons.shtml

Drago Nest Videos GDN/DDN party TKN/PKN Solo Runs etc..

 DDN Runs!
https://www.youtube.com/watch?v=UuYM8GHEyY4


https://www.youtube.com/watch?v=RP1M_fmvS-8

Green Dragon Nest 8-Man w/ SecretSwrd (Gladiator) - Dragon Nest Sword

https://www.youtube.com/watch?v=WfB2CIduwT4

 

PKN SOLO

Inquisitor

https://www.youtube.com/watch?v=qBuA-9GQOc0

Dragon NEst Sea. Smasher PKN HELL MODE

https://www.youtube.com/watch?v=3sL27dozmog 

Dragon Nest Crusader Solo Professor K Hell 

https://www.youtube.com/watch?v=jZmWY6jlr7s.

 

 

 

[Tutorial] Dragon Nest SEA - Sandboxie Dual Client

Watch this video https://www.youtube.com/watch?v=3JaLa9_RciE

Steps :

Step 1: Install SandBoxie (any version will do, where to download? use google) download sandboxie -> Sandbox download link

Step 2: Go to Sandbox Tab Click Create New Sandbox - Let's Name it DragonNestSea1 or anyname will do.


Step 3. Run your Dragon Nest Launcher, dun start it yet


Step 4: In the Sandboxie Control Window - Go to Sandboxie Tab - DragonNestSEAA - Run Sandboxed - Run Any Program -Browse for your dragon nest shortcut in your desktop then click ok

Step 5. Wait till you see 2 Dragon Nest Launchers running. then click start on both!

How to create a userform in excel.

1. Open your ms excel then go to developer tab and click visual basic editor. if you don't see the developer tab on your ribbon/menu tab,for ms excel 2010/2013 users click this link http://msdn.microsoft.com/en-us/library/bb608625.aspx , and for ms excel 2007 users click this link http://office.microsoft.com/en-us/word-help/show-the-developer-tab-or-run-in-developer-mode-HA010173052.aspx

2. Click Visual Basic Editor or press the shortcut key  alt+F11 to open it
 

3. Click insert on the menu tab then click 'Insert User form'


4. Now that we have a user form, to add controls click on the user form(if the toolbox didn't appear, on the menu tab, click view > select toolbox

 5. Create labels, text box combo box etc.. there are many controls that are useful in there so make use of it

6. To access your user form go back to your ms excel then click on the developer tab > click insert > click the command button > and click to any area of your excel cells




7. Click new, find below picture














8. Put this code. See below pics

9.  Everytime you click the Button1(Command Button) your form will show, find below snapshot:)

Data validation/combo box on cells in excel

Steps:
1. Select a Column or cells that you want to make a combo box
2. On the menu tab click data and find 'data validation' and click it.
3. Below the validation criteria, Select List on the options,
4. Type the list you want on the 'Source Box'


You can watch the video here :
http://youtu.be/RYU6wuRChp0