Course Description: This course introduces the basic concepts and applications of an electronic spreadsheet program, including organizing, creating, and modifying a spreadsheet. It presents the basics of entering data in a worksheet using columns and rows, labels, and values; completing worksheet calculations using formulas and functions; and producing professional looking charts. In addition, the course introduces formatting, sorting, querying, and multi-sheet management. It also introduces 3-D cell referencing, financial functions, “Goal Seek”, “VLOOKUP”, “What If”, and decision-making.
|