MS Excel Level 1

This course will familiarize learners with Excel, helping them to create, enter, and edit text, values, and formulas, save workbooks, and move and copy data and formulas. They will work with ranges (contiguous versus non-contiguous), rows, and columns. Participants will also learn to use simple functions and easily apply formatting techniques to worksheet data. They will review workbooks for spelling errors, modify page setup, and learn how to print professional-looking worksheets.  

Prerequisites: The course requires that you are familiar with using personal computers and have used a mouse and keyboard; basic typing skills are recommended. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer.

Contents:

• Spreadsheet terminology
• The Excel environment
• Navigating a worksheet
• Entering and editing text and values
• Entering and editing formulas
• Saving and updating workbooks
• Moving, copying, and viewing data and formulas
• Absolute references
• Inserting and deleting ranges, rows, and columns
• AutoSum and other common functions
• Text formatting
• Row and column formatting
• Number formatting
• Additional formatting options
• Preparing to print
• Page Setup options
• Printing worksheets

Note: This course will be taught using the windows operating system environment