Archive for the 'Beginner' Category

Join 2 Cells into 1-Concatenation

Download example ExcelMagicTricks01-10.xls Description Easily join two columns of data into one column. It’s called Concatenation. And we will use the join operator “&” to create a Text formula! Yes that is right, formulas are not just for numbers anymore! Also, see how to double click the fill handle to copy a formula down quickl

Excel shortcuts

Managing worksheets

Download example worksheets.xls Description Learn how to add, delete, move, and format your excel worksheets. Menu Link Insert > Worksheet

Arranging multiple windows or panes

Download example multiple-panes.xls Description Learn how to manage multiple windows at one time for optimal viewing. Menu Link Window > Arrange…

Inserting a picture

Description Learn how to insert any picture into excel in under 60 seconds. Download example Picture.xls Insert clipart You can insert clipart the same way… Insert > picture > clip art