Overview
Microsoft Office Specialist (MOS) Excel 2013 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 MOS Excel 2013 Core Exam #77-420. Successful completion of the certification exam provides a competitive advantage by validating the knowledge and skill sets for individuals who may be seeking employment or further job opportunities in their careers.
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 Excel?
- Starting the Microsoft Excel Program
- Looking at the Screen
- Understanding Basic Terminology
- Mouse Symbols
- Using the Quick Access Toolbar
- Using the Ribbon
- Identifying Screen Symbols
- Entering Data in a Worksheet
- Types of Data
- Entering Text
- Entering Numbers
- Entering Dates and Times
- Moving Around the Worksheet
- Working with Workbooks
- Saving Workbooks
- Creating a New Workbook
- Switching Between Workbooks
- Opening a Workbook
- Closing a Workbook
- Working with the Compatibility Mode
- Selecting Cells
- Lesson Summary
- Review Questions
- Editing Cells and Undoing Changes
- Copying and Moving Data
- Cutting, Copying and Pasting Data
- Append Data to Worksheets
- Using Paste Special
- Copying and Moving Cells Using the Mouse
- Inserting and Deleting Rows and Columns
- Inserting Rows and Columns
- Deleting Rows and Columns
- Inserting and Deleting Cells
- Adjusting the Columns and Rows
- Changing the Column Widths
- Adjusting the Row Height
- Using AutoFit
- Hiding/Unhiding Rows & Columns
- Using AutoFill
- Managing Worksheets
- Renaming Worksheets
- Inserting or Deleting Worksheets
- Moving or Copying Worksheets
- Hiding/Unhiding Worksheets
- Adding Color to the Worksheet Tabs
- Lesson Summary
- Review Questions
- Using Formulas
- Creating and Editing Formulas
- Cell References
- Mathematical Operators
- What If Analysis
- Referencing Other Worksheets
- Using Functions
- Common Excel Functions
- Using the Subtotal Function
- Conditional Functions
- Using Conditional Summary Functions
- Using Text Functions
- Using Absolute and Relative Cell References
- Using Absolute Cell References
- Using Mixed Absolute and Relative Cell References
- Displaying and Printing Formulas
- Data Validation
- Lesson Summary
- Review Questions
- Formatting a Cell
- Formatting Numbers and Decimal Digits
- Changing Cell Alignment
- Changing Fonts and Sizes
- Applying Cell Borders
- Using Colors and Patterns
- Using the Format Painter
- Clearing Cell Contents and Formatting
- Themes
- Using Themes
- Modifying Themes
- Using Cell Styles
- Conditional Formatting
- Using the Ribbon
- Using the Rules Manager
- Lesson Summary
- Review Questions
- Changing Worksheet Views
- Creating and Arranging Worksheet Windows
- Splitting Panes
- Freezing Panes
- Changing the Zoom
- Printing and Previewing the Workbook
- Changing the Workbook Views
- Customizing the Page Layout
- Setting Page Breaks
- Page Formatting
- Adding a Header or Footer
- Printing Titles or Range of Cells
- Printing Selected Worksheets
- Lesson Summary
- Review Questions
- Creating a Basic Chart
- Moving and Resizing Charts
- Changing Chart Types
- Working with Pie Charts
- Modifying the Chart Design and Location
- Adding New Data
- Using Sparklines
- Printing Charts
- Using Quick Analysis Tool
- Drawing Shapes
- Moving and Resizing Shapes
- Formatting Shapes
- Using WordArt
- Inserting Pictures and Clip Art
- Using the Image Editor
- Modifying Graphics Objects
- Using the Format Shape Pane
- Resizing, Reshaping, and Scaling Objects
- Rotating Objects
- Inserting a Watermark in the Background
- Using SmartArt Graphics
- Lesson Summary
- Review Questions
- Working with Named Ranges
- Creating Named Ranges
- Modifying and Deleting Named Ranges
- Go To a Cell or Named Range
- Using Tables
- Creating a Table
- Modifying Table Data
- Formatting Table Data
- Sorting Data
- Sorting by Single-Level Data
- Sorting by Multi-Level Data
- Filtering Information
- Removing Duplicate Rows
- Outlining
- Using Automatic Subtotals
- Manually Grouping and Ungrouping Data
- Lesson Summary
- Review Questions
- Customizing Excel
- Customizing the Quick Access Toolbar
- Customize the Ribbon
- Finding and Replacing Data
- Finding Data
- Replacing Data
- Using Hyperlinks
- Inserting Hyperlinks
- Modifying and Deleting Hyperlinks
- Using Comments
- Importing and Exporting Data
- Importing Data Files
- Open Non-Native Files Directly in Excel
- Exporting Data from Excel
- Changing Workbook Properties
- Save to Remote Locations
- SkyDrive
- Macros
- Creating a Macro
- Saving and Opening a Workbook Containing Macros
- Adding Macros to the Quick Access Toolbar
- Lesson Summary
- Review Questions
