Gamble Computer Solutions

New Post has been published on http://gamblecomputersolutions.com/free-computer-tutorials/microsoft-excel/excels-sparklines/

Excel's Sparklines

New Post has been published on http://gamblecomputersolutions.com/free-computer-tutorials/free-adobe-indesign-tutorials/adobe-indesign-cc-configurar-y-visualizar-herramientas-en-menus-curso-basico-espanol-cs6-cap-4/

Adobe InDesign CC, Configurar y visualizar herramientas en menus, Curso básico español CS6 cap 4

New Post has been published on http://gamblecomputersolutions.com/free-computer-tutorials/microsoft-excel/how-to-format-the-chart-axis-labels-in-excel-2010/

How to format the chart axis labels in Excel 2010

New Post has been published on http://gamblecomputersolutions.com/free-computer-tutorials/microsoft-excel/microsoft-powerbi-powermap/

Microsoft PowerBI - PowerMap

New Post has been published on http://gamblecomputersolutions.com/free-computer-tutorials/free-adobe-indesign-tutorials/adobe-indesign-cs6-kennenlernen/

Adobe Indesign CS6 kennenlernen

Das ist Adobe Indesign CS6. Weitere Trainings- und kostenlose Downloads gibt es auf pixelstarter-training.de. Video Rating: 5 / 5

New Post has been published on http://gamblecomputersolutions.com/free-computer-tutorials/microsoft-excel/retrieving-the-last-value-and-the-last-character-in-a-row-in-microsoft-excel-2010/

Retrieving the Last Value and the Last Character in a Row in Microsoft Excel 2010

To retrieve the last value, we use a combination of “INDEX”, “MAX”, and “COLUMN” functions, and to retrieve the last character in a row, we use the “HLOOKUP” and “REPT” functions in Microsoft Excel 2010.

INDEX: The Index formula returns a value from the intersection between the row number and the column number in an Array. There are 2 syntaxes for the “INDEX” function.

1st Syntax of “INDEX” function:=INDEX (array, row_num, [column_num])

2nd Syntax of “INDEX” function:=INDEX (reference, row_num, [column_num], [area_num])

For example:- We have data in range A1:C5 in which column A contains Order Id, column B contains Unit Price, and column C contains Quantity.

Follow below given steps:-

Write the formula in cell D2.

=INDEX(A1:C5,2,3)

Press Enter on your keyboard.

The function will return 10, which means 10 is available in 2nd row and 3rd column.

    MAX: This function is used to return the largest number in a set of values. It ignores logical values and text.

Syntax of “MAX” function:            =MAX(number1, [number2],….)

Example: Range A1:A4 contains numbers, and we need to return the maximum number from this range.  

Follow the below given steps:-

Select the cell B1 and write the formula.

=MAX(A1:A4)

Press Enter on your keyboard.

The function will return 9.

9 is the maximum value in the range A1:A4. 

    COLUMN: This function is used to return the column number of a reference.

Syntax of “COLUMN” function:     =COLUMN(reference)

For Example: If we want to return the column number for the cell A1, we need to follow below given steps:-

Write the formula in cell B2.

=COLUMN(A2)

Press Enter on your keyboard.

The function will return 1, which means this is column 1.

    HLOOKUP: The function is used for looking a value in the top row of a table or array of values and returns the value in the same column from a row you specify.

Syntax of “HLOOKUP” function:            =HLOOKUP(lookup_value,table_array,row_index_num,[range_lookup])

Uses of Hlookup Function

We use this function to pick the values from one data to another, but to meet the condition we should have the common values in both data sets so that we can easily pick the value.

Let’s take an example and understand how and where we can use Vlookup function in Microsoft Excel 2010.

Example 1: We have 2 data sets in which we require joining date from 1st data to 2nd data.

    To pick the value from 1st data to 2nd data, the common value we have is Emp. Code. So we will put the Hlookup function through Emp. Code. We need to follow below mentioned steps to pick the joining date:-

Select the cell C9 and write the formula.

=HLOOKUP(C8,$ C$ 2:$ G$ 3,2,false)

Press Enter on your keyboard.

The function will return the joining date for this L1056 Emp code.

To return the date of joining to all the employees, copy the same formula and paste in the range D9:G9.

    Note: If the common value we do not have in other data from which we want to pick the data, then the formula will give the #N/A error. As you can see in above snapshot, the employee code L1089 in not available in 1st data set so formula is giving the error.

REPT:- This function is used to repeat text a given number of times. Use REPT to fill a cell with a number of instances of text string.

Syntax of “REPT” function:           =COLUMN(reference)

For example:- Write the formula in cell A1 =REPT(“a”,10), and press Enter on your keyboard. The function will show that “a” is repeating 10 times.     MODE: This function is available for compatibility with Excel 2007 and earlier. It returns the most frequently occurring or repetitive value in an array or range of data.

Syntax of “MODE” function:          =MODE(number1, [number2],……..)

For Example:-We have number list in the range A1:A5.

To return the mode of numbers, follow below given steps:-

Write the formula in cell B1.

=MODE(A1:A5)

Press Enter on your keyboard.

The function will return 1.

    IF: - Check whether a condition is met and returns one value if True and another value if False.

The syntax of “IF” function =if(logical test,[value_if_true],[value_if_false])

Firstly, the formula will do the logical test to know if the output of logical test is true or false.

For example:Cell A2 and A3 contain the number 3 and 5. If the number is 3, the formula should display “Yes”, else “No”.

=IF (A1=3,”Yes”,”No”)     Let’s take an example to understand how we can retrieve the last value and the last character in a row.

We have data in range A2:E5 in which cells contain characters and numbers individually. Some of the cells in the range may be empty.

We want to retrieve both the last values (of any type) and the last character that appears in each row of the range.

    To find the last character for each row, follow below given steps:-

Write the formula in cell F2.

=HLOOKUP(REPT(“z”,10),A2:E2,1)

Press Enter on your keyboard.

The function will return the last character for each row.

    Copy the same formula by pressing the key Ctrl+C and paste in the range F3:F5 by pressing the key Ctrl+V on your keyboard.

    To find the last value (of any type) in each row, follow below given steps:-

Write the formula in cell G2.

=INDEX(A2:E2,1,MAX(IF(A2:E2<>””,COLUMN(A2:E2)))-COLUMN(A2)+1)

Press Shift+Ctrl+Enter on your keyboard.

=INDEX(A2:E2,1,MAX(IF(A2:E2<>””,COLUMN(A2:E2)))-COLUMN(A2)+1)

The function will return the last character for each row.

    Copy the same formula by pressing the key Ctrl+C and paste in the range G3:G5 by pressing the key Ctrl+V on your keyboard.

      This entry passed through the Full-Text RSS service – if this is your content and you’re reading it on someone else’s site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.

New Post has been published on http://gamblecomputersolutions.com/free-computer-tutorials/microsoft-excel/excel-2013-using-undo-and-redo-in-power-view-microsoft-training-lesson-34-4/

Excel 2013 Using Undo and Redo in Power View Microsoft Training Lesson 34.4

New Post has been published on http://gamblecomputersolutions.com/free-computer-tutorials/free-adobe-indesign-tutorials/how-to-link-a-hyperlink-and-email-in-indesign/

How to Link a Hyperlink and Email in InDesign

New Post has been published on http://gamblecomputersolutions.com/free-computer-tutorials/microsoft-excel/excel-array-formula-series-2-transpose-function/

Excel Array Formula Series #2: TRANSPOSE function

New Post has been published on http://gamblecomputersolutions.com/free-computer-tutorials/free-adobe-indesign-tutorials/indesign-tutorial-setting-a-publications-folio-options-lynda-com/

InDesign tutorial: Setting a publication's folio options | lynda.com

New Post has been published on http://gamblecomputersolutions.com/free-computer-tutorials/microsoft-excel/no-more-pivot-tables-in-access-2013-what-now/

No More Pivot Tables in Access 2013. What Now?

New Post has been published on http://gamblecomputersolutions.com/free-computer-tutorials/free-adobe-indesign-tutorials/adobe-indesign-cs6-tutorials-tab-tips-pt2-infiniteskills/

Adobe InDesign CS6 Tutorials | Tab Tips pt2 | InfiniteSkills

New Post has been published on http://gamblecomputersolutions.com/free-computer-tutorials/microsoft-excel/removing-redundant-characters-from-a-range-of-cells-and-resetting-the-format-in-microsoft-excel-2010/

Removing Redundant Characters from a Range of Cells and Resetting the Format in Microsoft Excel 2010

In this article, we will learn how to remove the redundant characters from a range of cells and how to reset the format. We will use Text, Trim and Substitute function in Microsoft Excel 2010 to get the desired outcome.

SUBSTITUTE: This function is used to replace the existing text with new text in a text string.

Syntax of “SUBSTITUTE” function:=SUBSTITUTE(text,old_text,new_text,[instance_num])

Example: Cell A2 contains the text “By hook or by crook”

=SUBSTITUTE (A2, A2,”By hook or by crook”)

The function will return “By hook or by cook”.     TEXT:-This function is used to convert a value to text in a specific number format.

Syntax of “TEXT” function:    =TEXT (Value, format_text)

For Example: -

Cell B2 contains the date 12-Feb-2013

Write the formula in cell C2 =TEXT(A2,”MMMM”)

Press Enter on your keyboard.

The function will return the month name.

    TRIM: Trim function is used to remove additional leading and trailing spaces from the text in a cell.

Syntax of “TRIM” function:           =TRIM (text)

Example:

Cell A2 contains the text “Excel Tips”

Enter the formula in cell B2 =TRIM(A2)

Press Enter on your keyboard

The function will return the text after deleting the unnecessary spaces.

    Let’s take an example to understand how we can remove the redundant characters from a range of cells and reset the format.

The text values in the range A2:A5 contain redundant parentheses.

We want to create a formula that will remove the parentheses and set the format of the cells to “general”.     Follow below given steps:-

Write the formula in cell B2.

=TEXT(TRIM(SUBSTITUTE(SUBSTITUTE(A2,”)”,””),”(“,””)),”General”)

Press Enter on your keyboard.

    The function will remove the redundant character from a range of cells and reset the format.

Copy the same formula and paste in range B3:B5 by pressing the key Ctrl+V on your keyboard.

      This entry passed through the Full-Text RSS service – if this is your content and you’re reading it on someone else’s site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.

New Post has been published on http://gamblecomputersolutions.com/free-computer-tutorials/microsoft-excel/microsoft-office-excel-2013-tutorial-linking-data-between-worksheets-k-alliance/

Microsoft Office Excel 2013 Tutorial: Linking Data Between Worksheets | K Alliance

Learn how to link data between worksheets in this Microsoft Office Excel 2013 training video. Contact K Alliance for more info. ‪http://www.kalliance.com/‬ -…

New Post has been published on http://gamblecomputersolutions.com/free-computer-tutorials/free-adobe-indesign-tutorials/wordalizer-2015-is-out/

Wordalizer 2015 is out!

Wordalizer 2015 (v. 1.508) is finally available at no additional cost—update is free for all licensed users. Major additions and improvements have been done so that you can design the greatest word clouds ever from within InDesign. Easily import weighted word lists, apply new shapes and color themes, setup the width/height ratio of the whole artwork! But that’s just part of the story:

New Features in version 1.508

Here are some of the new key features:

• New design and enhanced readability of the Cloud panel.

• Four new shapes: Triangle, Reversed Triangle, Losange, and Astroid.

• New option in the advanced settings panel: “Detect word list” (refer to the manual for details).

• 38 new color themes:

• InDesign CS4, CS5, CS5.5, CS6, CC and CC 2014 compatible, on Mac OS and Windows platforms.

…and so much more!

Sample clouds

Many word clouds have been already posted here, and here, based on the previous versions. Here are new examples:

Give it a try!

Wordalizer’s TRY version offers all the features of the PRO release, except it automatically inserts the word Wordalizer. If you need to use the plug-in in production, consider to purchase a PRO version license.

• Installation. — The TRY and PRO versions of Wordalizer are both delivered in the jsx format. You simply need to put the file in your Scripts Panel folder. The script is instantly available in the InDesign Scripts panel.

• Note. — If you cannot find the location of your Scripts Panel folder, run InDesign and display the Scripts panel (Window > Automation > Scripts or Window > Utilities > Scripts). Then right-click the User folder and, in the fly-out menu, pick Reveal in Finder (Mac OS) or Reveal in Explorer (Windows). If there is not already a Scripts Panel subfolder within the revealed Scripts folder, create here a new folder named Scripts Panel.

Notice, Acknowledgements

Wordalizer has a long story. The seminal idea came from Jonathan Feinberg, who created the applet Wordle. Details on how I implemented a similar algorithm in ExtendScript are still available in my original post.

My very special thanks to Theunis de Jong (aka Jongware), Dominique Chiron (doopix.com) and Jean-Christophe Courte (urbanbike.com). I also wish to thank the people who have helped improve and promote this product, in no particular order: Klaus Nordby, David Blatner, Stéphane Baril (Adobe France), Loïc Aigon (Ozalto), Laurent Tournier (Indigrep), Cécile Mazin (ActuaLitté), Alexander Charchar (Smashing Magazine), Rinniee Ginsburg, Ingo Wilsinger, Jan Mirus—not forgetting those graphic designers, trainers, authors, and InDesign gurus who have all contributed at some level to the success of Wordalizer: Sandee Cohen and Diane Burns (authors of “Digital Publishing with Adobe InDesign”), Pariah Burke, Erica Gamet, Haeme Ulrich, Khaled Galal, Jennifer Blatz, Phillip Southgate and so many others!

• Purchase now Wordalizer Pro

This entry passed through the Full-Text RSS service – if this is your content and you’re reading it on someone else’s site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.

New Post has been published on http://gamblecomputersolutions.com/free-computer-tutorials/free-adobe-indesign-tutorials/xml-technologien-13-xml-schema-umsetzung-i/

XML-Technologien (13) - XML-Schema (Umsetzung I)

New Post has been published on http://gamblecomputersolutions.com/free-computer-tutorials/microsoft-excel/training-on-microsoft-project-professional-2013-for-project-managers/

Training on Microsoft Project Professional 2013 for Project Managers