DEAR READER
No title available
blake kathryn
Cosmic Funnies
"I'm Dorothy Gale from Kansas"
No title available
JVL
@theartofmadeline
Not today Justin
Stranger Things
Today's Document
Xuebing Du
oozey mess
Lint Roller? I Barely Know Her
Love Begins
KIROKAZE
dirt enthusiast
RMH
Alisa U Zemlji Chuda
Product Placement
seen from North Macedonia
seen from Canada
seen from North Macedonia
seen from United States
seen from United States
seen from Argentina
seen from North Macedonia
seen from United States
seen from United States
seen from China
seen from Indonesia
seen from United States
seen from United States
seen from United States
seen from United States
seen from United States
seen from United States
seen from United States
seen from United States
seen from Belgium
@gamblecomputersol
New Post has been published on Gamble Computer Solutions
New Post has been published on http://gamblecomputersolutions.com/free-computer-tutorials/microsoft-excel/excels-sparklines/
Excel's Sparklines
Explores how to insert a sparkline in an Excel worksheet.
New Post has been published on Gamble Computer Solutions
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
En este capitulo te explico cómo configurar y visualizar herramientas en menus, Curso Básico en español Adobe Illustrator CC e illustrator tutorial español C…
New Post has been published on Gamble Computer Solutions
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
http://www.worksmarter.tv This video shows you how you can format the labels on the x- and y axis in an Excel chart. You can use chart labels to explain what… Video Rating: 3 / 5
New Post has been published on Gamble Computer Solutions
New Post has been published on http://gamblecomputersolutions.com/free-computer-tutorials/microsoft-excel/microsoft-powerbi-powermap/
Microsoft PowerBI - PowerMap
Video Rating: 0 / 5
New Post has been published on Gamble Computer Solutions
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
Insertion de textes, d’éléments géométriques (cercles, traits). Positionnement des éléments pour créer une affiche. Source “Savoir tout faire avec Indesign -… Video Rating: 4 / 5
New Post has been published on Gamble Computer Solutions
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.
Microsoft Excel Tips from Excel Tip .com / Excel Tutorial / Free Excel Help
New Post has been published on Gamble Computer Solutions
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
Learn about using undo and redo in power view in Microsoft Excel at www.teachUcomp.com. A clip from Mastering Excel Made Easy v. 2010. Get the complete tutor… Video Rating: 5 / 5
New Post has been published on Gamble Computer Solutions
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
Creating an interactive PDF? Allow InPhotoshop1 to show you how to easily add a hyperlink and email address. http://youtu.be/WClnv5nLp4I http://youtu.be/THha… Video Rating: 5 / 5
New Post has been published on Gamble Computer Solutions
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
See how to use the Array function TRANSPOSE to transpose a table, switching rows and columns to columns and rows. In this series see how to create array form…
New Post has been published on Gamble Computer Solutions
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
This InDesign tutorial demonstrates how to set a publication’s folio options. Watch more at http://www.lynda.com/InDesign-CS5-tutorials/Up-and-Running-with-A… Video Rating: 5 / 5
New Post has been published on Gamble Computer Solutions
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?
If you like to use pivot tables and charts in Access, the latest version (2013) must have been a disappointment for you. To get around this problem, there ar… Video Rating: 5 / 5
New Post has been published on Gamble Computer Solutions
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
Want all our free Adobe InDesign CS6 Training Videos? Download our free iPad app at : http://itunes.apple.com/us/app/video-training-courses-from/id418130423?… Video Rating: 5 / 5
New Post has been published on Gamble Computer Solutions
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.
Microsoft Excel Tips from Excel Tip .com / Excel Tutorial / Free Excel Help
New Post has been published on Gamble Computer Solutions
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/ -…
Excel 2013 Tutorial for Beginners – Comments and Hyperlinks. Video Rating: 4 / 5
New Post has been published on Gamble Computer Solutions
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.
Indiscripts
New Post has been published on Gamble Computer Solutions
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)
Dieses Video ist der Sprung ins kalte Wasser. Er bietet einen Einstieg in die Umsetzung eines XML-Schemas. Hier der Link zum Thema XML-Schema, sowie das Diag… Video Rating: 5 / 5
New Post has been published on Gamble Computer Solutions
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
Training on Microsoft Project Professional 2013 for Project Managers. Video Rating: 4 / 5