Excel Worksheet Fundamentals (Level 1)

Solid Excel spreadsheet skills are essential in today’s business world. Learn the basics of Excel spreadsheets with this comprehensive introductory course. Gain confidence and develop skills that can be transferred immediately to the workplace. 

Prerequisites: Basic keyboard and mouse skills.
 

Content:

• Excel application window    
• Add borders and shading to a worksheet
• Enter labels and values into a worksheet    
• Sort the records of a list
• Enter a formula into a worksheet    
• Filter the records of a list
• Adjust column width and row height in a worksheet    
• Excel tables
• Open a new workbook    
• Insert comments into a worksheet
• Use the spelling checker    
• Split the worksheet window into panes
• Use an Excel template to create a workbook    
• Freeze the worksheet window
• Automatically fill a range    
• Hide rows and columns of a worksheet
• Copy and move cells    
• Change the page setup for a worksheet
• Automatically compute a row or column total    
• Preview a worksheet
• Insert and delete rows and columns    
• Print selected worksheet entries
• Formatting including cell styles    
• Find and replace a specific entry in a worksheet
• Use alignment options in the Format Cells dialog box    
• Use Excel functions (SUM, AVERAGE, MAX, MIN and COUNT)
• Apply conditional formatting to a worksheet    
• Reset the number format of cell entries