Skip to content
Contact USI

This course is designed for experienced Microsoft Excel users who want to further master their skills. This three-hour session goes beyond the basics to fully utilize the features of Excel.

Participants in this course can expect to learn the following:

  • Data Visualizations and Charting
    • Adding figures to charts to represent data
    • Using smooth lines in line charts
    • Copy and paste chart formatting between charts
    • Change display units
    • Create filled maps based on location-specific worksheet data
    • Create a forecast sheet from worksheet data
  • Data Analysis Tips and Tricks
    • Use Quick Analysis to analyze selected worksheet data
    • Filter and remove duplicate data
    • Use 3-D referencing to make working with data on multiple worksheets faster
    • Get data from PivotTables separated from source data
    • Grouping worksheets
  • Data Entry and Cleanup Tips and Tricks
    • Use paste special to transpose data, paste values and increase/decrease Excel values
    • Convert pasted-in text with delimiters into separate columns
    • Use DATEVALUE to solve date problems
    • Use IFERROR to clean up data
    • Add autoformat to the Quick Access toolbar and use it to format selected data
    • Set up an easy user data entry form without using the Developer tab
    • Use Fill Justify to combine text in separate cells into a single cell
  • Keyboard Shortcuts Tips and Tricks
    • Use keyboard shortcuts to improve access to Excel features
Whether it is shortening a training to fit in one day, increasing the curriculum to cover several classes,
or changing the location of the training from here at USI to your location,
we have the training you are looking for to grow your business.

Get Started Today

Request more information to get started on a needs assessment.
Together, we will develop the best plan for your employees and company.

      Paula Nurrenbern                                                      Office 812-461-5425
      Director of Corporate Partnerships                      Cell 812-455-3629
      and Customized Training  

      8600 University Boulevard 
      Evansville, Indiana 47712                                    

       Lesley Groves                                                            Office 812-464-1854
       Asst. Director of Corporate Partnerships        
       and Customized Training  

       8600 University Boulevard 
       Evansville, Indiana 47712