MOS - Excel 2013 Core
Print in

21 Hours

Course Objectives (Exam 77-420)

Microsoft 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 Microsoft Office Specialist Excel 2013 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.

Course 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. Customize the PowerPoint Environment

  • 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

Lesson 1: Introducing Excel

  • What is Excel?
    • Starting the Microsoft Excel
  • 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 2: Constructing Cell Data

  • 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 3: Using Formulas

  • 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 4: Formatting the Worksheet

  • 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 5: Viewing and Printing Workbooks

  • 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 6: Working with Charts and Graphics

  • 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 ScalingObjects
    • Rotating Objects
  • Inserting a Watermark in the Background
  • Using SmartArt Graphics

Lesson 7: Organizing Data

  • 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 8: Macros, Importing and Exporting Data

  • 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

Register online @ http://one.pa.gov.sg

SDF Applicant, please register @ https://www.skillsconnect.gov.sg

IT Centre reserves the right to reschedule the course without prior notice due to class size or unforeseen circumstances.