Expand your knowledge of Excel’s many capabilities as you learn to use multiple worksheets and multiple workbooks efficiently. Use absolute referencing and named ranges in your formulas. Apply IF statements so Excel will enter one of two answers. Have Excel interpret a lookup function to pull information from a table. Manipulate the contents of a database by sorting, filtering, and calculating. Create a basic PivotTable to analyze a database. Generate business charts and format them.
Recommended: CCTO140 Microsoft Excel Level I.