All lectures are $150 each and can be covered by STAP funds, Departmental PTA, or Educational Assistance Funds.
Learn little-known but very useful Excel techniques in this 3-hour lecture! Learners who incorporate these techniques into their daily workflows should need less time to complete Excel tasks and at the same improve the quality of their work products.
Course outline/topics:
What is the Paste Special dialog box, and why should I care?
- Fixing numbers-stored-as-text errors
- Pasting data and column widths into a new location
- Control how values, formulas and formatting are pasted
- Copy a row of cells and paste the values into a column instead
- Pasting links to copied cells rather than cell contents
What is the Go To Special dialog box and how can it help me?
- Select all blank cells so you can populate them in a single operation
- Select all formula cells or all formula cells with errors or all formula cells without errors
- Select all cells that contain numbers
- Select only cells in a dataset that are different from a cell value
- Select all shapes and graphics on a worksheet
The surprising power of custom number formatting
- Learn the difference between rounding and formatting numbers to appear rounded
- Use leading zeros in numbers to force the same number of digits in all numbers
- Understanding dates in Excel
- Use special format codes to get the exact appearance you want for dates
- Understand what makes dates different from other numbers in Excel
- Add color rules to your number formats
- Combine numbers and text in the same cell while still using the cell in numeric calculations
Using CONCATENATE and the text-to-column features
- Combine several columns of cells into a single column without having to retype anything
- Split one column into several columns, again without retyping anything
- Use multiple columns as the lookup value in a VLOOKUP formula
Essential keyboard shortcuts for navigating and selecting datasets
Use and re-use the format painter to speed up your formatting tasks
Various other tips and tricks for working more efficiently in Excel
Laptops are recommended, but not required.
