About this badge
Gain a solid understanding of Excel's foundation, basic calculations, five most commonly used functions, and the order of operations. Other topics also covered in class include using find and replace text, number formatting, copying formulas with relative and absolute cell reference, defining a name for a cell or for a range of cells, inserting rows, columns and sheets, copying and moving worksheets, and hide and un-hide rows and columns. Learn to use the unique, time-saving Excel autofill feature--the fill handle--to copy data, formulas, formats, and fill series. Various formatting techniques are introduced. By the end of this hands-on course, you will be able to create basic professional workbooks.