Rating 4.35 out of 5 (11 ratings in Udemy)

• Identify the parts of a worksheet
• Select cells and enter data in a worksheet
• Change column widths and row heights
• Change the appearance of cells using fonts, font sizes, font styles, colors, and borders
• Use the Format Painter to copy formatting from one cell to another
• Apply and clear cell styles
• Find and replace cell contents
• Copy and move data in a worksheet
• Use the drag-and-drop method and Auto Fill options to add data to cells
• Insert and delete rows, columns, and cells
• Freeze panes in a worksheet
• Split a worksheet window
• Insert headers and footers in a worksheet
• Enter and edit formulas
• Distinguish between relative, absolute, and mixed cell references
• Use the Sum button to add values in a range
• Preview a calculation
• Display formulas instead of results in a worksheet
• Manually calculate formulas
• Identify the parts of a function
• Enter formulas with functions
• Use functions to solve mathematical, statistical, and financial problems
• Use logical functions to make decisions with worksheet data
• Use functions to insert times and dates in a worksheet
• Use text functions to format and display cell contents
• Sort and filter data in a worksheet
• Apply conditional formatting to highlight data
• Hide worksheet columns and rows
• Insert a shape, SmartArt graphic, picture, and screenshot in a worksheet
• Use a template to create a new workbook
• Insert a hyperlink in a worksheet
• Save a workbook in a different file format
• Insert, edit, and delete comments in a worksheet
• Use the Research task pane.
• Move between worksheets in a workbook
• Rename worksheets and change the sheet tab color
• Reposition, hide and unhide, and insert and delete worksheets
• Create cell references to other worksheets
• Create 3-D references
• Print all or part of a workbook
• Arrange multiple workbooks in the program window
• Move and copy worksheets between workbooks
• Identify the types of charts you can create in Excel
• Create an embedded chart in a worksheet and move a chart to a chart sheet
• Update a data source
• Choose a chart layout and style
• Create a 3-D chart
• Display and hide chart elements
• Format and modify a chart
• Create sparklines