91社区

Skip to content
Contact 91社区

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 91社区 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听 听 听 听 听 听 听 听 听 听 听 听 听 听 听 听 听 听 听 听 听 听 听91社区.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听 听 听 听 听 听 听 听 听 听 听 听 听 听 听 听 听 听 听 听 听 听 听 听 91社区.edu/Custom-Training