Courseware 3243-1         Exam 77-882

Microsoft Excel 2010 Core Skills seminar 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.

Full Course Description Below

We are offering MS Excel 2010 Core Skills seminar commencing on December 3/2018  9 am-1 pm for 6 sessions.






SCS Training Centre are offering our hands-on MS Excel 2010 Core Skills seminar commencing on December 3/2018 9 am-1 pm for 6 sessions.

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.

Course Objectives

This course teaches the skills you will need to successfully complete the Excel 2010 Core exam. These skill sets are introduced using a fictional company named Tolano Adventures, a travel service that is a department within Tolano Environmental Consulting. Tolano Adventures offers tours to the public that are friendly to the environment.
You will use Excel to create and edit professional-looking spreadsheets for a variety of purposes and situations. As you begin to build your skills, you will then create a variety of flyers and other promotional materials as well as explore different ways to share the information with internal and external customers.

After completing this course, you will be able to:

  • understand and describe the concept of electronic spreadsheets
  • identify the basic components of Excel
  • enter data, symbols, and special characters into a worksheet
  • move around in a workbook
  • create, open, save, and close a workbook
  • save a workbook in a previous Excel version format
  • select a range of cells
  • change and undo changes to the contents of cells
  • cut, copy, and paste data in a worksheet using the Windows and Office Clipboard
  • adjust column widths and row heights
  • hide and unhide rows and columns
  • insert and delete rows, columns, or cells
  • find and replace data in a worksheet
  • use AutoFill to copy or fill data or set up a series of data
  • rename, insert, delete, copy or move worksheets
  • create and edit simple formulas using math operators and cell references
  • format numbers and decimal places
  • enhance the worksheet using fonts, alignment, lines, borders, colors or patterns
  • use the Format Painter
  • clear cell contents and formatting
  • apply themes, styles, and conditional formatting
  • create and arrange worksheet windows
  • split and freeze panes
  • zoom in and out of worksheets
  • print and preview worksheets
  • use different workbook views
  • add and preview page breaks
  • change margins, orientation, or layout for printing a worksheet
  • set headers and footers for a worksheet
  • change Excel options
  • create, edit, format and print charts
  • insert, modify and format clip art images, pictures, shapes, WordArt, and SmartArt objects
  • sort data

About This Courseware
Courseware Description
Course Design
Course Objectives
Conventions and Graphics
Lesson 1: Introducing Excel
Lesson Objectives
What is an Electronic Spreadsheet?
Looking at the Screen
Entering Data in a Worksheet
Working with Workbooks
Selecting Cells
Lesson Summary
Review Questions
Lesson 2: Constructing Cell Data
Lesson Objectives
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
Lesson 3: Using Formulas
Lesson Objectives
Using Formulas
Using Functions
Lesson Summary
Review Questions

Lesson 4: Formatting the Worksheet
Lesson Objectives
Formatting a Cell
Clearing Cell Contents and Formatting
Using Cell Styles
Lesson Summary
Review Questions
Lesson 5: Viewing and Printing Workbooks
Lesson Objectives
Changing Worksheet Views
Printing and Previewing the Workbook
Customizing the Page Layout
Changing Excel Default Settings
Lesson Summary
Review Questions
Lesson 6: Working with Charts
Lesson Objectives
Creating a Basic Chart
Moving and Resizing Charts
Changing Chart Types
Working with Pie Charts
Changing the Chart Layout and Location
Printing Charts
Lesson Summary
Review Questions

Lesson 7: Working with Graphics
Lesson Objectives
Drawing Shapes
Modifying Graphics Objects
Using SmartArt Graphics
Lesson Summary
Review Questions
Lesson 8: Analyzing, Organizing andSharing Workbooks
Lesson Objectives
Sorting Data
Filtering Information
Importing and Exporting Data
Lesson Summary
Review Questions
Appendix A: Courseware Mapping
Appendix B: Glossary of Terms
Appendix C: Index