About this Course

Microsoft 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.

Course Prerequisites :

This course is designed for students who are familiar with personal computers, using a keyboard and using amouse. The course assumes that students have completed the Microsoft Windows course or have equivalentMicrosoft 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 Objectives :

This course book teaches the skills you will need to successfully complete the Excel 2010 Core exam. Theseskill sets are introduced using a fictional company named Tolano Adventures, a travel service that is adepartment within Tolano Environmental Consulting. Tolano Adventures offers tours to the public that arefriendly 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 wellas 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 

 use commonly-used functions and conditional functions 

 use absolute and relative cell references 

 display and print formulas 

 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 

 create, customize, and remove Sparkline charts 

 insert, modify and format clip art images, pictures, shapes, WordArt, and SmartArt objects 

 sort data 

 use the AutoFilter 

 work with named ranges create, modify or remove a hyperlink 

 use Office Backstage to share workbooks with others

Duration : 3days / 22 hrs

Entry Requirement : Basic Computer Knowledge.

Rate this course:

Log in to submit

Comments