Excel 2007 Essentials
Welcome to the Microsoft Excel 2007 Essentials course. Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2007, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into useable information – and better information leads to better decision making!
Course Objectives
Research has consistently demonstrated that when clear goals are associated with learning, it occurs more easily and rapidly.
By the end of this course, participants should be able to:
- Open and close Excel
- Differentiate between worksheets, workbooks, rows, columns, and cells
- Enter labels and values
- Edit data
- Check spelling
- Open, close, and save workbooks (including publishing to PDF)
- Switch between Excel views
- Use Zoom
- Set up your page
- Preview and print your workbook
- Build and edit formulas
- Copy formulas
- Use absolute referencing appropriately
- Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
- Use Selection Statistics
- Use AutoFill and AutoComplete
- Sort and filter data
- Format text and numbers
- Apply borders
- Use cell styles
- Change the workbook theme
Categories
Microsoft Excel