Microsoft Excel Training

Course details

Course Modules:

Module 1: 

• Set Up a Workbook 
  
• Creating Workbooks 
  
• Modifying Workbooks 
  
• Modifying Worksheets 
  
• Customizing the Excel 2010 Program Window 
  
• Zooming In on a Worksheet 
  
• Arranging Multiple Workbook Windows 
  
• Adding Buttons to the Quick Access Toolbar 
  
• Customizing the Ribbon 
  
• Maximizing Usable Space in the Program Window 
  

Module 2: 

• Work with Data and Excel Tables 
• Entering and Revising Data 
  
• Moving Data Within a Workbook 
  
• Finding and Replacing Data 
  
• Correcting and Expanding Upon Worksheet Data 
  
• Defining Excel Tables 
  

Module 3: 

• Perform Calculations on Data 
  
• Naming Groups of Data 
  
• Creating Formulas to Calculate Values 
  
• Summarizing Data That Meets Specific Conditions 
  
• Finding and Correcting Errors in Calculations 
  

Module 4:

• Change Workbook Appearance 
  
• Formatting Cells 
  
• Defining Styles 
  
• Applying Workbook Themes and Excel Table Styles 
  
• Making Numbers Easier to Read 
  
• Changing the Appearance of Data Based on Its Value 
  
• Adding Images to Worksheets 
  

• Focus on Specific Data by Using Filters 
• Limiting Data That Appears on Your Screen 
  
• Manipulating Worksheet Data 
  
• Selecting List Rows at Random 
  
• Summarizing Worksheets with Hidden and Filtered Rows 
  
• Finding Unique Values Within a Data Set 
  
• Defining Valid Sets of Values for Ranges of Cells