♫ Just about New Info That I Found ♪: 2015

Monday, June 8, 2015

12 Useful Math Hacks That They Didn’t Teach You In School







After finding these math hacks, I’m convinced that all those years of being forced to struggle through math class really was just a torture ploy created by evil math teachers everywhere. Check out these amazing math tips and you’ll agree! Watch out though, you may just unleash the inner math whiz you never knew was in you…
AD-MathCover

1. How To Convert Fahrenheit to Celsius

As if it was this simple all along…
DONT SWIPE Why Didn't They Teach Us This In School?! The Most Useful Math Hacks In Existence 0 - https://www.facebook.com/diplyofficial
via reddit/u/quaxon

2. How To Multiply Large Numbers In Your Head

Who knew?
AD-99via imgur / MoonnMan
 Advertisement

3. How To Multiply By 11

Finally! I can now multiply more than single digits by 11 in my head.

4. Secret To Remembering The Numbers In Pi

Also a cool party trick.

5. How To Find Fractions Of Whole Numbers

DONT SWIPE Why Didn't They Teach Us This In School?! The Most Useful Math Hacks In Existence 6 - https://www.facebook.com/diplyofficialvia imgur / ayounes
 Advertisement

6. How To Figure Out What Day Of The Week Falls On What Date…

You might be confused looking at the picture below, but the math is actually quite simple (albeit a bit elaborate). You’ll need the codesHERE, which will help you master this.
July simply has a code of 5.
20th is 6 because 7 goes into 20 twice, which is 14. 20 – 14 = 6.
2069 is 2 because the leap year code of 2068 is 1 and 2069 is 1 year after, so that’s 2.
The math can be difficult at first because there are a lot of codes, but it works out incredibly well once you pick it up. Here’s a separate example:
January 3, 2014 is a Friday, right?
So, January, according to the table, is 6, and we handle days by using multiples of 7. We don’t need to, so it’s actually just 3 in this case. Next we need to know the closest leap year, which was 2012. That has a year code of 1 and 2013 is 2 years after, so 3 again.
We get 6 + 3 + 3 = 12 – 7 = 5! FRIDAY!

7. How to Add And Subtract Fractions

DONT SWIPE Why Didn't They Teach Us This In School?! The Most Useful Math Hacks In Existence 11 - https://www.facebook.com/diplyofficialvia imgur / ayounes

8. How To Figure Out Multiples Of Nine

Just count up in the tens column and down in the ones column.
DONT SWIPE Why Didn't They Teach Us This In School?! The Most Useful Math Hacks In Existence 13 - https://www.facebook.com/diplyofficialvia Pinterest / Charles Stirton

9. How To Use Your Hands For 5, 6, and 9 Times Tables

Click HERE for more detailed instruction…
DONT SWIPE Why Didn't They Teach Us This In School?! The Most Useful Math Hacks In Existence 16 - https://www.facebook.com/diplyofficial
DONT SWIPE Why Didn't They Teach Us This In School?! The Most Useful Math Hacks In Existence 17 - https://www.facebook.com/diplyofficial
DONT SWIPE Why Didn't They Teach Us This In School?! The Most Useful Math Hacks In Existence 18 - https://www.facebook.com/diplyofficial
DONT SWIPE Why Didn't They Teach Us This In School?! The Most Useful Math Hacks In Existence 19 - https://www.facebook.com/diplyofficial
via instructables / misko13

10. How To Figure Out Percentages

DONT SWIPE Why Didn't They Teach Us This In School?! The Most Useful Math Hacks In Existence 21 - https://www.facebook.com/diplyofficialvia Twitter / @LifeHacks

11. How To Remember Which Sign Is Greater Than and Which Is Less Than

Alligator always eats the bigger number!
DONT SWIPE Why Didn't They Teach Us This In School?! The Most Useful Math Hacks In Existence 23 - https://www.facebook.com/diplyofficialvia ducksters

12. Use Lines To Multiply

 here the video demonstration, please klik the URL:
Sumber:http://www.architecturendesign.net/12-useful-math-hacks-that-they-didnt-teach-you-in-school/
Continue Reading...

Monday, May 25, 2015

Shortcut Fillcolour Ms. Excel yang Dapat Mempermudah pekerjaan



This article explains all the possible ways to apply font or fill (background or shading) colors using keyboard shortcuts, including a way to customize your own.
I have done extensive research on this issue, and this article is a collection of all the solutions you will find on the web.  So this should save you some time in your search for an answer.

Excel Font Fill Color Keyboard Shortcut Keys
The shortcuts presented here are for Excel for Windows versions 2007, 2010, & 2013.

Do you want the Good News or Bad News First?

Well, I’ll give you the bad news first to get it out of the way…  There is no keyboard shortcut in Excel that directly applies a font or fill color to a cell.  Sorry I have to be the one to tell you that.
But the good news is that there are a few workarounds that will get you close.  And the better news is that I have developed a simple (free) solution that will allow you to easily customize your own keyboard shortcuts for font and fill colors.

Overview of the Font Fill Color Shortcut Solutions

In the first part of this article I will explain all the built-in keyboard shortcuts that will help you apply font and fill colors.  Since there is no direct way, I consider these to be workaround solutions (#1-#4 below).  Even though these workarounds won’t directly solve your problem, there are some great tricks to learn here to help save you time.
The ultimate goal of using a keyboard shortcut is to save time.  Especially for repetitive tasks when you need to quickly apply the same colors over and over again.  None of the workaround methods really accomplish this, so I created an Excel add-in that will allow you to customize your own shortcuts.  The add-in is explained in #5 below with a link to the download page.
Here is an outline of the article:
  1. Open the Color Palette Menus with Alt+H+ (workaround)
  2. Quick Access Toolbar (workaround)
  3. F4 Key or Alt+Enter (workaround)
  4. Copy/Paste Formatting (workaround)
  5. Keyboard Shortcuts Add-in (custom solution)
Step-by-step instructions and the pros & cons of each of these methods are provided below.

#1 Open the Color Palette Menus with Alt+H+

The keyboard shortcut to open the Fill Color menu on the ribbon is Alt+H+H.  This will open the menu so you can view the color palette, but you have to take additional steps to select and apply the color.  Here is a quick guide:
  1. With the cells selected, press Alt+H+H
  2. Use the arrow keys on the keyboard to select the color you want.  The arrow keys will move a small orange box around the selected color.
  3. Press the Enter key to apply the fill color to the selected cells.
Excel Fill Color Keyboard Shortcut Alt+H+H
Alt+H+F+C is the shortcut for the Font Color menu and functions the exact same as the Fill Color menu.
Pros: 
  • You can select a color from the menu using only the keyboard.
  • Any color on the color palette can be applied relatively quickly.
  • There is a direct shortcut for “No Fill” – Alt+H+H+N
Cons:
  • This method is SLOW.  It’s really a three step process, and even more time consuming if your color is at the bottom right side of the color palette.
  • There is a lot more room for error because you are required to press the arrow keys multiple times.
  • Font colors are even harder to apply because the shortcut (Alt+H+F+C) contains an additional letter.

#2 Quick Access Toolbar (QAT)

The Fill Color and Font Color menus can be added to the Quick Access Toolbar (QAT).  This will help make the keyboard shortcut to access them shorter.  Instead of pressing Alt+H+H, you could put the Fill Color menu in position #1 of the QAT and use the shortcut Alt+1 to open the Fill Color menu.

Excel Fill Color Keyboard Shortcut Quick Access Toolbar QAT
Once the menu is open you still have to use the arrow keys to select your color.  It’s basically the same three step process as above.
Pros
  • This is faster than the Alt+H+H(FC) methods because you can eliminate at least one key stroke.
  • If you are using the Font or Fill Color palettes frequently it might be nice to have them on the QAT.  This way you can access the menus with the mouse without having to navigate to the Home tab on the ribbon.
Cons
  • It’s still slow and requires you to use the arrow keys to select your color.

#3 F4 Key or Alt+Enter

The F4 key is a great keyboard shortcut to know and can save you time.  The F4 key will repeat the last action you’ve taken in Excel.
For example, let’s say you just used the Fill Color menu to change a cell to have a blue background.  When you select another cell and press the F4 key, the cell’s fill color will be changed to blue.  The F4 key just repeats the last action you took.
 Excel F4 Key Repeat Last Action for Font Fill Color Shortcut
This applies to many different types of actions, not just font and fill colors.  You can use F4 to add/delete rows/columns, change number formats, alignment, page setup, etc.  The F4 key can be a real time saver any time you are doing a repetitive task. 
Pros
  • The F4 key can be a one-step solution to applying font and fill colors.
  • It has many other uses and is great to know.
Cons
  • It requires you to use another method for the first time a font or fill color is applied, and only allows you to repeat that process.
  • Can only be used to repeat the last action.  If you take a different action between needing the color shortcut then this will not work.
Dominykas left a comment below about the Alt+Enter shortcut.  Alt+Enter works in the same basic way as F4.  Thanks for sharing Dominykas!

#4 Copy/Paste Formatting

The copy and paste formatting feature can be used if you have already applied the font/fill color to another cell.  Similar to the F4 method mentioned above, you can quickly copy the colored cell and apply the formatting only to other cells.
A keyboard shortcut for Paste Formatting can be created by adding the button to the Quick Access Toolbar (QAT).  This makes it very fast to copy the cell that contains the color and then only paste the formatting of that cell.  The values or formulas in the copied cell will NOT be pasted.  Only the formatting is pasted.
Excel Fill Color Keyboard Shortcut Paste Formatting QAT

Pros:
  • Probably the quickest way to copy formatting that is already applied to another cell.
  • Better alternative to the Format Painter because you can use the arrow keys to move more than one cell from the copied cell before pasting the formatting.
Cons:
  • Not a direct method for applying a font/fill color.  A cell must already contain the formatting you want to copy.
  • Does NOT work if the copied cell and destination cell have different number formatting.  The Paste Formats feature pastes all the formatting options that are applied to a cell.  For example, if the cell you copy contains a number formatted as a percentage (%) and the destination cell you want to color contains a number formatted as currency ($), then paste formats will change the formatting of the destination cell to percentage.  This is not what you want.

#5 Formatting Shortcuts Add-in

The four solutions listed above are the best workarounds that I’ve found, and hopefully they will help you learn some new Excel skills if nothing else.  But they do not directly solve the problem, which is to have a fast way to apply a font or fill colors with one single keyboard shortcut.
So I developed this add-in that allows you to create custom keyboard shortcuts for font and fill colors.  It basically allows you to choose your own shortcut key that will apply a specific font or fill color to the selected cell(s).
Formatting Shortcuts Lite Ribbon Button Userform
The shortcut key is a combination of Ctrl+Shift+[any key on the keyboard].
You can change the shortcut key to any character on the keyboard.  The screenshot above shows the setup menu for the shortcut keys.  You can see that I have setup the keyboard shortcut Ctrl+Shift+A for the font color of red.  When I press Ctrl+Shift+A on the keyboard the font color of the selected cells will change to red.   It’s a one-step process that is really fast!
The shortcuts are saved so you only need to set it up once, and they can be changed at any time.
You can also choose if you want the font or fill color to be changed in the Format Type drop-down menu.  The “Font+Fill” option allows you to change both the font and fill color of the cell with one keyboard shortcut!  In the example above, Ctrl+Shift+D will change the font and fill color of the cell to light green fill with dark green font.
Pros:
  • Create custom keyboard shortcuts to apply font or fill colors to selected cells in one step.
  • The add-in is very easy to use, and there is a free version available!
  • This is the fastest way to apply font and fill colors to a cell.
  • Undo your changes if you accidentally press the wrong shortcut key.
  • Does NOT change the number formatting like the paste formatting solution.
Cons:
  • Requires the use of an add-in.  The add-in is easy to install and setup, but it is not built into Excel.
  • Limited to one undo, but the full version of the add-in resolves this issue.
  • Limited to three keyboard shortcuts on the free version.  The full version gives you 10 shortcuts plus a lot of other features including number formats.

Conclusion

Unfortunately there are no direct keyboard shortcuts for font & fill colors.  Hopefully you learned some new tricks with the workaround solutions (#1-#4) that you can apply to other areas of your work.  If nothing else, at least it will save you time from doing the web searches and research I did before building the custom add-in.
Did I miss anything?  Do you know of any other ways to apply font & fill colors?  Please leave a comment below with any suggestions or questions.  I would love to hear from you.


Credits (Sumber)::
http://www.excelcampus.com/keyboard-shortcuts/keyboard-shortcuts-font-fill-color/
Continue Reading...

Saturday, May 23, 2015

Cara Memunculkan File Excel yang dibuka dan Datanya Tidak Muncul

Saya mau bagi pengalaman nii..
ditempatkerja saya beberapa hari yang lalu, kami mendapat laporan dari client kami bahwa file Excel-nya itu setelah di double click atau dienter, yang muncul hanya bag atasnya saja tidak muncul tampilan filenya. Seperti ini nii:


nah,, jadinya dia sangat kebingungan sehingga kami ditanyai. dan pada saat itupun kami tidak taahu kenapa. anggapan pertamanya adalah bahwa file tersebut tersenrang virus sehingga semacam corupted begitu. padahal tidak. 
Langsung saja kecaranya yaa..

1) Buka File yang Bermasalah
2) Maka akan muncul tampilan seperti gambar diatas
3) Setelah itu di tab view klik tombol Unhide
    seperti dibawah ini

4) Ketika muncul sebuah windows baru Seperti ini ni..

6) Just klik OK
5) Setelah itu, file akan muncul kembali

XD


Semoga bermanfaat yaa...
Continue Reading...