Excel 2010 Essentials
Welcome to the Microsoft Excel 2010 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 2010, 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
- Understand the new Interface and the new Backstage View
- Enter labels and values
- Edit data
- Add rows and columns
- Check spelling
- Open, close, and save workbooks (including publishing to PDF and sending via E-mail)
- Switch between Excel views and create custom views
- Use Zoom
- Set up, Preview and print your workbook
- Build, copy and edit formulas
- Use absolute referencing appropriately
- Understand the difference between Formulas and Functions
- Understand the new Function Names
- Use the Formulas Tab
- Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
- Use the status bar to perform calculations
- Use AutoFill and AutoComplete
- Sort and filter data
- Use sparklines
- Format text and numbers
- Use alignment options
- Merge cells
- Apply borders
- Use cell styles
- Use conditional formatting
- Change the workbook theme
Categories
Microsoft Excel