Ã山ǿ¼é

Skip to content
Contact Ã山ǿ¼é

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 Ã山ǿ¼é 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ÌýÌý
Ìý
Ìý Ìý Ìý Pjnurrenbe@usi.eduÌý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý ÌýÃ山ǿ¼é.edu/Custom-Training

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

Ìý Ìý Ìý Ìý8600 University BoulevardÌý
Ìý Ìý Ìý ÌýEvansville, Indiana 47712ÌýÌý
Ìý
Ìý Ìý Ìý Ìýlagroves@usi.eduÌý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ìý Ã山ǿ¼é.edu/Custom-Training