Microsoft Excel Tips and Tricks
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
If you would like more information on having this program brought to your site, please contact Paula Nurrenbern, manager, customized solutions at 812-461-5425 or pjnurrenbe@usi.edu.
