Microsoft Excel

PreRequisite: Windows Basics. Students should have a good understanding of how to use Windows, and a computer in general. No prior spreadsheet experience is required. We also recommend our Microsoft Word course before taking this one, as the interface is very similar, however this is not a requirement.

Excel 1: Parts of the Excel interface, Title Bar, Menu Bar, Toolbars, columns and rows, scroll bars, entering data, data, labels, formulas, formatting your spreadsheet, highlighting and selecting cells, alignment, colors, borders, working with calculations, addition, subtraction, multiplication, division, math order of operations, deleting cells, functions, SUM, AVERAGE, COUNT, MAX, MIN, inserting rows and columns, cut, copy, paste, paste format, keyboard shortcuts, AutoFill, creating a calendar in Excel using AutoFill, saving and loading workbooks, rounding data, resizing columns and rows, printing, page setup, scaling, margins, headers & footers, sorting data, graphing & charting, column chart, 3D column chart, pie chart, chart formatting, rotating your chart, spell check, find & replace, naming your sheet tabs.

Excel 2: Format cells, conditional statements, IF function, relative v. absolute references, using Named cells and ranges, VLOOKUP function, referencing subtables, referencing data on other sheets, or in other files, password protecting your data, protecting specific data in a sheet, linking data between Excel and Word or other office applications, paste v. embed v. link, freeze panes, splitting your sheet, cell comments, cell formatting, customizing toolbars, MEDIAN, ROUND, NOW functions.

Excel 3: 3D Ranges across multiple sheets, range intersections, arrays, auditing, data grouping, using form controls, drop-down menus, check boxes, autofilter data, pivot tables, macros, loan calculator, optional (time permitting): amortization, advanced graphics & drawing, advanced charting options, advanced macro techniques, advanced financial calculations.