Learn Microsoft Excel 2010 the Easy Way

Learn to start a new workbook, enter text and numbers, and manage entries in Excel 2010 with enter, tab, and cancel actions, then set up months, headings, and basic formulas.

Learn to write basic Excel formulas using equal signs, cell references across sheets and files, and the fill handle to calculate sales, expenses, and profits.

Explore how relative references adjust formulas when copied across columns and down rows in Excel, and preview the concept of absolute references to control these changes.

Master the order of operations in Excel formulas using parentheses, exponents, and the sequence of multiplication, division, addition, and subtraction, following the please excuse my dear Aunt Sally guideline.

Learn how ranges, adjacent cells, are defined and selected in Excel. Use ranges in formulas to sum, average, min, and max, and view these functions in the status bar.

Learn how to save workbooks in Excel 2010 using Save and Save As, name your file, and choose a location and folder; understand extensions and organizing with folders.

Open and close workbooks in Excel using the file tab, save prompts, and search by date modified with details or list views to locate files quickly.

Explore how to use the freeze panes feature in the view tab to lock rows above or columns to the left, keeping headers visible as you scroll, with quick unfreeze.

Master page setup options in Excel to adjust margins (including custom), choose portrait or landscape, select paper size, set print areas and breaks, manage backgrounds, and enable print titles.

Explore headers and footers in page layout view, and learn to customize left, center, and right sections with text, page numbers, dates, and sheet names that appear on every page.

Set print titles in Excel 2010 by selecting rows to repeat at top in page layout, ensuring headers print on every page via print titles and print preview.

Insert and manage comments in Excel 2010, including adding, editing, deleting, moving comment boxes, and controlling whether they print or display on a sheet.

Learn how to fit a workbook on one page by adjusting margins, orientation, and scaling, using page break preview to place breaks and print across pages as needed.

Learn how to print workbooks in Excel 2010, adjust page setup, scaling, and margins, choose to print the entire workbook or a selection, collate copies, and manage the active sheet.

Learn how to add and delete rows, columns, and cells in Excel 2010, using insert options, right-click menus, and cell shifting to manage your spreadsheet layout.

Learn how to adjust column and row widths in Excel 2010, using drag and auto fit, set exact sizes, and hide or unhide rows and columns for precise data display.

Use cut, copy, and paste in Excel by selecting data, choosing an action, and pasting to a new location; the clipboard holds up to 24 items and can be cleared.

Learn how to copy formulas in Excel 2010 using the fill handle and paste options, understand relative references, and apply formulas across regions while preserving accuracy.

Learn how to write formulas and use functions in Excel 2010, starting with the equal sign, using operators, and referencing data across sheets to compute totals, averages, and highs.

Learn to build Excel 2010 formulas with functions, ranges, and arguments, using auto sum and insert function, and apply sum, average, min, max, and concatenate.

Learn to create formulas using functions in Excel, use insert function for multi-range sums, calculate averages and max values, and copy formulas with the fill handle; study absolute values.

Learn how to use absolute values in Excel formulas by locking a cell with dollar signs, preventing row or column changes when copying with the fill handle.

Rename sheet tabs to identify divisions, add and insert new sheets between existing ones, move and delete sheets, and apply three dimensional formulas with awareness of range changes.

Learn to build three-dimensional formulas across multiple sheets using range selection with shift. The lesson covers creating summary sheets, cross-sheet references, and entering formulas across the sheet range.

Invite learners to leave a review and, if needed, update it later by rating this course with stars. Encourage comments to help improve the training material and provide valuable feedback.

Explore formatting worksheets in Excel 2010, applying font choices, sizes, colors, and effects. Align text, wrap, rotate, indent, shrink to fit, and merge cells to organize headings and data.

Convert data ranges to a table via insert, ensure header row is recognized, then use table tools to apply styles, add rows or columns, and rename the table for navigation.

Learn to use and customize styles in Excel 2010, apply predefined formats, clear formatting, and create or merge styles alongside conditional formatting to highlight data.

Learn to use the format painter to copy cell formatting across ranges, including borders and colors; double-click to keep it on, and press escape to turn it off.

Protect cells, the sheet, and the workbook in Excel 2010 by unlocking specific cells, using find and select to target formulas or constants, and setting passwords.

Learn to use the fill handle to auto-fill days, months, and sequences in Excel 2010, and create or import custom lists for quick data entry.