MS Excel (Level 1)

This workshop is intended to help all novice computer users get up to speed with Excel quickly. There are different features including creating a new spreadsheet, working with basic formulas and functions, making a spreadsheet look professional and presentable, and saving and printing.

Content:

• Unit 1 Getting Started:
• You will learn how to:
• • Identify the elements of the Excel interface
• • Create a basic worksheet
• • Use the help system.
• Unit 2 Working with Data:
• Priority Management will show you:
• • Using formulas and functions in a worksheet
• • Working with data
• • Rows, and columns
• • How to sort and filter data.
• Unit 3 Modifying a Worksheet:
• You will learn how to:
• • Format text and cells
• • Align cell contents
• • Use Find & Select tools
• • Spell check a worksheet
• Unit 4 Printing Workbook Contents:
• You will learn how to:
• • Define the basic page layout for a workbook
• • Refine the page layout
• • Apply print options.
• Unit 5 Managing Large Workbooks:
• You will learn how to:
• • Format worksheet tabs
• • Manage worksheets
• • Manage the view of worksheets and workbooks.
• Unit 6 Customizing the Excel Environment:
• You will learn how to:
• • Customize general, language, formula, proofing, and saving options
• • Use Excel’s version control features
• • Customize the ribbon and the Quick Access toolbar
• • Enable add-ins and
• • Customize advanced and Trust Center options