Students in this 6 hr. class will be using the text function, date and time functions, and information functions; and enter array formulas. Paste only certain parts of cell data; select cells containing particular kinds of data or formatting; quickly locate formulas that result in errors; merge styles between workbooks; insert graphics as chart backgrounds; and create a chart template. You will also use wizards to add commands and functions to Excel; use advanced Solver features; use various Analysis ToolPak tools to analyze data; and embed and link objects in a worksheet. Lastly you will change Excel setting in the Popular, Formulas, Proofing and Advanced categories; use AutoRecover and AutoCorrect; and work with smart tags.
You will get the most out of this course if your goal is to become proficient in using text, date, time, and information functions; entering array formulas; using advanced formatting and editing features; installing and using add-ins and data analysis tools; and using Excel’s customization options.
|