Microsoft Excel Courses

excel s
Please note that any course can be customized to your company needs.

Excel Basics
(4-6 hours) –Create a new workbook; Enter, edit, and delete data; Undo/Redo; learn navigational tools; change row height and column width; copy data; using auto-fill tools; move data; save workbooks; close workbooks; open existing workbooks; shortcuts for selecting data; Learn to use the following format options: alignment, number formats; format cell dialog box, orientation, wrap text, merge & center, font type & color, borders, and fill. Use different views; insert and delete cells, columns, and rows. Add, delete, and rename worksheets. Change worksheet tab color. Learn how to use Autosum function to summarize cell values. Create simple mathematical formulas. Learn basic setup features (margins, orientation, and gridlines). Learn about available printing options.

Excel Intermediate
(4-5 hours) – Learn how to “Freeze panes” to keep headings in view; change views; set up the workbook to print by using the “Scale to fit” option; create header and footer; set a print area; print headings on every page; view row and column headings; insert page breaks; hide/unhide rows or columns; sort data; convert data in a single column to multiple columns; move and copy worksheets; use the Find and Replace tool to locate and replace data or formats within the workbook; customize Excel through “Options”; Use the AutoCalculate tool to see totals, averages, etc. of selected cells; Enter mixed formulas within a workbook; Copy formulas; learn how to fix error messages; Insert, edit, and delete comments attached to specific cells. Learn how to quickly remove duplicate data (Excel 2007 and 2010)

Excel Basic Formulas & Functions
(2 ½ hrs.) – Learn to create basic formulas in cells; learn to use AutoCalculate; learn how to use AutoSum. Create formulas using the “Order of Operations”. Learn how to copy formulas; learn common functions such as SUM, COUNT, COUNTA, AVERAGE, MIN, and MAX. (NOTE: These skills are also taught in the Excel Basics/Intermediate classes.)

Excel Advanced Formulas & Functions
(2- 4 hrs.) – Learn how to create both relative and absolute cell references; create COUNTIF, IF, and nested IF functions; use CONCATENATE to join cell values; and use VLOOKUP or HLOOKUP to lookup values in a table. Set up name ranges; use named range in formula; create a multi-cell array formula; create a single cell array formula; use Functions – ISNA, MATCH, ROUND, INDIRECT, OR, AND, RIGHT, LEFT, MID,IF, AGGREGATE. Learn to use the formula auditing tools.

Excel Creating & Editing Charts
(3 hrs.) – Create a chart; change chart type; save a chart template; switch row & column; change chart layout, styles, & location; resize a chart; insert additional data; delete a chart; format a chart item; insert an object; edit labels; edit axis; edit plot area, wall, floor, & 3-D options; chart name; working with custom charts (thermometer chart, picture charts, gauge chart, add a second axis, log scale, Gantt, sparklines)

Excel Macros
(2 hrs.) –You’ll want to take this class if you perform a task repeatedly in Excel. This task can be automated by recording a macro. Once you record a macro, Excel stores information about each step you take as you perform a series of commands. You then run the macro to repeat, or “play back,” the commands. Record an absolute or relative macro; run a macro; assign a button to a macro; make a macro available on Quick Access Toolbar; delete a macro; learn about security and macros.

Excel Pivot Tables
(2-3½ hrs.) – Create PivotTables; Sort data within a PivotTable; Format numbers in a PivotTable; edit label headings; change how data is summarized; change detail displayed; display/hide subtotals; filter data; group items; change layout; change design; refresh data; add data; move PivotTable; delete PivotTable; Data field options; create a formula; Top 10 Autoshow to show the top or bottom numbers only; filter data using Slicers; Create a static chart from PivotTable; Create a PivotChart; change a PivotChart to a Static Chart

Excel Managing Data
(4 hrs.) Learn how to apply Filters to data; Convert data range to Table to use table features, Use Conditional Formatting with cell color, data bars, color scales & icons; Insert subtotals; Link data within a workbook and between different workbooks, consolidate data from multiple worksheets onto one worksheet, insert hyperlinks to other documents or web pages; Use the format painter to copy existing formats onto other cells.

Creating Forms in Word & Excel
(3-4 hrs.) Create Excel & Word Forms using Content Controls (text control, drop-down list and combo box, date picker, building block control, check box, and picture control) and Legacy tools (text box, check box, drop-down box). Setup simple calculations in Word. Modify properties of a form. Protect a Document for form completion.

Track Changes in Word & Excel
(3 hrs.) WORD: Turn on Track Changes in a document; Insert comments; Choose how revisions display; show or hide comments or tracked changes; Merge several documents containing track changes; delete comments; print with or without markup; compare the differences between two documents that don’t contain track changes. EXCEL: Track changes in a shared workbook; highlight changes as you work; accept and reject changes; view the History of changes; prevent change tracking from being removed.

 

Back to Courses