Are you using the fastest methods to accomplish tasks in Excel? Do you want to learn tips for automaticallly filling data in a worksheet, adding comments to cells in a worksheet, entering data more easily, and visually showing trends in your data?
Attend this course if you want to:
Use keyboard and mouse shortcuts. Learn tips for entering data. Use the Go To Special command to automate the selection and manipulation of data. Use Flash Fill to easily separate or combine data in a worksheet. Use AutoFill to quickly enter a series of data (e.g., days of the week, years, numbers). Freeze the headings on your worksheet so that they remain visible as you scroll. Split a worksheet into multiple panes or windows (to view non-adjacent areas of your worksheet simultaneously). Create a new workbook with current workbook content. Add a comment to a cell to make a note to yourself or other users. View calculated values in the status bar. Find cells that contain constant values or formulas. View the formulas in a worksheet, rather than formula results. Use and format Sparklines to visually show trends in data. Use Quick Analysis to easily add totals, charts, and other common elements to a worksheet.
