Overview
MOS Excel 2010 Core teaches the information worker how to work with different types of documents using a variety of core and intermediate features to create and edit professional-looking spreadsheets for a variety of purposes and situations. Some topics may appear to be basic skill sets but are discussed in more detail, exploring at a higher level different options that can be chosen or applied for that skill set.
Students who complete this course will have reviewed all of the exam objectives and be on their way to preparing for Microsoft Excel 2010 Core Exam #77-882.
Prerequisites
This course is designed for students who are familiar with personal computers, using a keyboard and using a mouse. The course assumes that students have completed the Microsoft Windows course or have equivalent Microsoft Windows knowledge and experience.
- start and run Windows
- use the taskbar
- use the Start button
- use the Help feature
- use Minimize, Restore Down/Maximize, or Close
- use the left and right mouse buttons appropriately
- understand file management techniques
- navigate between files, folders, or drives
Course Outline
- What is an Electronic Spreadsheet?
- Looking at the Screen
- Entering Data in a Worksheet
- Working with Workbooks
- Selecting Cells
- Lesson Summary
- Review Questions
- Editing Cells and Undoing Changes
- Copying and Moving Data
- Inserting and Deleting Rows and Columns
- Adjusting the Columns and Rows
- Finding and Replacing Data
- Using AutoFill
- Managing Worksheets
- Lesson Summary
- Review Questions
- Using Formulas
- Using Functions
- Using Absolute and Relative Cell References
- Displaying and Printing Formulas
- Lesson Summary
- Review Questions
- Formatting a Cell
- Clearing Cell Contents and Formatting
- Themes
- Using Cell Styles
- Conditional Formatting
- Lesson Summary
- Review Questions
- Changing Worksheet Views
- Printing and Previewing the Workbook
- Customizing the Page Layout
- Changing Excel Default Settings
- Lesson Summary
- Review Questions
- Creating a Basic Chart
- Moving and Resizing Charts
- Changing Chart Types
- Working with Pie Charts
- Changing the Chart Layout and Location
- Using Sparklines
- Printing Charts
- Lesson Summary
- Review Questions
- Drawing Shapes
- Modifying Graphics Objects
- Using SmartArt Graphics
- Lesson Summary
- Review Questions
- Sorting Data
- Filtering Information
- Working with Named Ranges
- Using Hyperlinks
- Using Comments
- Importing and Exporting Data
- Sharing Workbooks
- Lesson Summary
- Review Questions
