The Ultimate Microsoft Excel 2010 Training Course - 14 Hours

Learn to start a workbook, enter text and numbers, accept with enter or tab, cancel with escape, use the fill handle for months, and prepare formulas totaling sales and expenses.

Learn to create basic formulas in Excel 2010 by starting with an equals sign, using cell references across sheets or files, and applying arithmetic operators.

Explore how Excel applies the order of operations to formulas, using parentheses, exponents, multiplication, division, and addition or subtraction, with examples like B3 and B5.

Learn how Excel ranges group adjacent cells, start and end cells, and select by dragging or shift-clicking, and how the status bar shows sum, min, max, and average.

Learn how to save Excel workbooks with correct file extensions, including save as options, and understand the shift from three-digit to four-digit extensions for backward compatibility and data sharing.

Learn to open and close workbooks, handle save prompts, and use the file tab and desktop locations. Explore view options and details with date modified to locate the loan workbook.

Learn to manage larger Excel 2010 workbooks by linking cells between sheets, using the payment function, and navigating with zoom, name box, and freeze panes.

Learn to use Excel freeze panes to keep headers visible while scrolling by selecting a cell and applying freeze panes from the View tab; unfreeze anytime.

Master page setup options to adjust margins (preset or custom) and header and footer, orientation (portrait or landscape), size, print area, and page breaks, and set print titles.

Learn to create and customize headers and footers in Excel's page layout view, using left, center, and right sections, page numbers, and first/odd-even options for consistent printing.

Explore print titles by selecting rows to repeat at the top and, if needed, columns to repeat on the left, ensuring headers appear on every page via print preview.

Explore how to add, view, move, resize, and delete comments in Excel 2010, and learn printing options for comments on screen, on sheet, or not at all.

Learn to fit a multi column Excel report onto a single page using page break preview, adjust margins and orientation, and manipulate breaks to control printing and scaling.

Print Excel workbooks with the file print options, adjust page setup by scaling, margins, and orientation, and print the entire workbook, active sheet, or selections, including collate and copies options.

Learn how to add and delete rows, columns, and cells in Excel. Use insert options, right-click shortcuts, and shift cells down.

Adjust column and row widths in Excel using drag, auto fit, and precise size settings, including setting row height and applying default widths; learn to hide and unhide columns.

Explore cut, copy, and paste in Excel, using the clipboard to move data, manage up to 24 items, and paste from the clipboard with clear workflow.

Copy formulas across regions using the fill handle and relative references, and choose paste options to transfer formulas, values, or formatting.

Write formulas and use functions in Excel, starting with an equal sign, referencing data on any sheet, and compute totals, averages, and highs in column G across quarters.

Learn to build formulas with functions by selecting ranges, using sum, min, max, count, and average, and applying auto sum and insert function to compute results.

Learn how to build formulas with functions in Excel 2010, using multiple ranges with insert function, handling errors, and copying formulas with the fill handle and absolute values.

Apply absolute values to lock specific cells in Excel formulas, preventing row changes during fills. See a commission example using dollar signs to fix G-3 while rows adjust.

Rename sheet tabs by double-clicking and typing a new name, then add, insert between, move, or delete sheets, noting how three-dimensional formulas reference multiple sheets.

Explore moving and copying sheets, hiding or deleting tabs, protecting sheets, changing tab colors, and selecting all sheets, using right-click, drag-and-drop, and view code, with intro to three dimensional formulas.

Learn to build three-dimensional formulas across multiple sheets using sheet ranges and a summary sheet. Use the 3D range syntax, enter the formula, and copy with the fill handle.

Explore essential cell formatting in Excel 2010, including font styles, sizes, colors, alignment, wrap text, and merging cells, plus text orientation and indent controls.

Format numbers in Excel using currency, percentage, date, and custom formats, understanding display versus actual values, and applying these options to cells such as phone and social security numbers.

Master borders and shading in Excel by applying various border styles, colors, and patterns to make selections stand out, including drawing custom borders and using fill options.

Convert worksheet data into an Excel table, apply styles and options like header rows and banded formatting, add rows or columns, and manage table names with the table tools.

Learn to use the format painter to copy formatting from the Australian division to the European division, double-click to keep it on and use escape to turn it off.

Learn to use the fill handle to continue predefined lists like days and months, generate custom sequences from two numbers, and create, import, edit, or delete custom lists in Excel.