Skip to main content

Posts

Showing posts from May, 2013

2010 Version Excel Keyboard Shortcuts List Begin With [ALT] + [Other Keys] | Exceltip2day

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to tell you about: Excel shortcut keys begin with "Ctrl" for 89 Keys. If you are seeking for Excel shortcut key to complying with any of your particular sake. Here is the place for you to take a glance and pick the one you like. In addition, you can save our site as your remark about the future visit. This is the list of Excel version 2010 shortcut way by using keyboard key beginning with "ALT" key button for the main key and plus together with another key(s) like letters, numbers, comma, period, semicolon, arrow keys, Caps Lock key, control keys, function keys, page up, page down, command key button and more. Tip Quiz What is the shortcut to open the visual basic editor? Benefits: • The mouse will be never used for this shortcut key. Therefore, you can say goodbye to your mouse from now on. Why we bring thing unless we can leave it at its h

Excel Trick “A Keystroke” Make Space Between Combine Text Data In Different Cell

When we use some excel formula such as formula to combine the data entered of each cell to together. The regular formula that we usually use are: “ CONCATENATE ” and “ & ”. However, somebody who use the mentioned formula above may frustrate that the data entered of each active cell are connecting together completely. There are no space between each group of the data entered. This is the example of the using 'CONCATENATE (A1, A2, A3)' formula: Suppose the data in each of the three active cells as below: A1 [Sales Accumulation] A2 [Sales Forecast] A3 [Actual Sales] Then we put the active cell names into the formula: = CONCATENATE (A1, A2, A3) # Result : Sales Accumulation Sales Forecast Actual Sales See that the three group of word are connected without any room space. Here we go to the trick for making space accordingly. Just add more formula symbols "Double Quotation Mark"[ " " ] between the cell name in a formula, press an [ E

Shortcut Trick and Tip for Microsoft Excel Office Software Program

What does it Microsoft Excel Office Shortcut Trick and Tip? Microsoft Excel is developed by Microsoft. It has the basic features of all spreadsheets. It’s worked by ordering through tools on the ribbon. Likewise, we are able to use the “Shortcut” to save time and apply its functions to support our requirements. To share my acknowledges about Excel through my blog to everyone who might interesting in it. Excel not only works according to the function tools, but also the shortcut.  I usually use Excel for my daily jobs. Pivot table, formula (Particular “=If(..,..,..)”) , graph, screen shot are the most tools which I have been using. Sometimes I am so nervous when the new assignments have came up just out of the blue. Since, I don’t know lots of Excel formula to finish my works (Inventory report) as soon as possible. How so good if I were very prompt at getting assignment done without taking a long time! I have begun to study Excel function through Excel manual books , Excel on

[Concatenate] Or [&] Excel Formula Gathering The Data Entered In The Active Cells

Do you know the method of a congregation the data entered from cells? Well, I have two methods for gathering the data entered from each active cell to set into the only one place. To use these formulas to pick up data as you want and link them together in a chain or series into just a single active cell in a worksheet. Here we go to the two ways respectively. 1. Formula ‘CONCATENATE’ = CONCATENATE (text1, text2, text3,) Example: Supposing there are the data entered in each cell as: A1 [Sales Accumulation] A2 [Sales Forecast] A3 [Actual Sales] Replace the active cell names into the formula: = CONCATENATE (A1, A2, A3) Result: Sales AccumulationSales ForecastActual Sales [Click! Kindle Fire HD Tablet - Power by Amazon.com] 2. Formula ‘&’ = text1 & text2 & text3 &, Example: Let’s say the data entered in the active cells follow are as: B1 [Total students] B2 [Students present] B3 [Actual absence] To input the cell names to the series

How To Calculate Number Of The Current Active Cells In An Excel Worksheet. | Exceltip2day

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about: How to count the only number (Excluding text) In Excel , not only calculate the sum amount of figure/number but also result in the number of active cells that having the data(number) in them.  Tip Quiz What is the shortcut to delete cell(s) in Excel Worksheet? The result will give us to know that how many cells which contained the numbers we are using them. This Excel formula will skip counting if those cells are blanked or having another data beside the number(s). Here below is a formula: = COUNT(A first reference cell : An end reference cell ). Pertaining the mentioned formula above will be used for count the amount of cell(s) in column (s)/row (s) within the range declare in a formula. Not capable of counting the alphabet, symbol, empty cell(s) entered into the cells. For example, all the cells in the column from A1 to A8 below being fill