Microsoft Excel 2010 Course Beginners/ Intermediate Training

Learn how to save workbooks in formats beyond Excel 2010, using the Save As dialog (F12) to export to xlsx, 97–2003, csv, text, pdf, and XPS, with compatibility considerations.

Open an existing Excel 2010 workbook using Ctrl+O, File > Open, or File > Recent to locate and open files from the default location or recent items.

Navigate an Excel workbook quickly using keyboard shortcuts like Ctrl+Home, Ctrl+End, and Alt+Page Up/Down. Move between cells, rows, columns, and sheets, and learn end mode to jump to data boundaries.

Enter text and numbers in Excel by selecting a cell, typing values, and confirming with enter or tab. Observe left alignment for text and right alignment for numbers.

Learn to copy and paste in Excel 2010, using the clipboard and multi clipboard, drag and drop, and shortcuts like Ctrl+C and Ctrl+V with orientation preserved.

Learn how to use undo and redo in Excel 2010, including the shortcut keys Ctrl+Z and Ctrl+Y, the drop-down history, and how saving preserves history for later undo.

Adjust column widths and row heights by dragging between headers and using auto-fit to the widest entry. Use the home ribbon to set sizes for multiple columns.

Learn to rename and format worksheet tabs in Excel 2010, using double-click or right-click renaming, 1–32 character limits, allowed punctuation, and tab color coding for organization.

Master moving and copying worksheets in Excel 2010, using drag-and-drop or right-click move or copy between workbooks, and resolve name conflicts by creating duplicates.

Copy sheets within a workbook by dragging with the control key or by right-clicking and choosing create a copy, preserving column widths and formatting for safe duplication.

Open and view two workbooks simultaneously. Switch between them with Ctrl+F6 or Ctrl+Tab, and arrange them with tiled, horizontal, vertical, or cascade layouts.

Learn how to hide and unhide worksheets in Excel 2010, using the sheet tab or the format ribbon, and recover accidentally hidden sheets.

Master page break preview in Excel to adjust page breaks by dragging blue lines, optimize print preview layouts, and reduce number of pages while returning to normal view for editing.

Enable the page layout view in Excel 2010 to edit headers and footers in three sections, insert fields like page numbers and date, and preview via print preview.

Master font formatting in Excel by changing typeface, font size, and color for selected cells. Apply bold, italic, underline, strike-through, and optional superscript or subscript to emphasize data.

Learn to align Excel 2010 cell contents with horizontal options (left, center, right) and vertical options (bottom, middle, top) for polished presentation.

Learn to change the text direction in a cell by rotating text with orientation options, including counter-clockwise, clockwise, vertical, or rotate up and down, refine angles with the alignment dialog.

Learn basic multiplication formulas in Excel using the equals sign and the asterisk, referencing cells G1 and G2. See how changing feed cells updates results automatically across the multiplication sheet.

Discover how Excel uses the BODMAS order of operations, prioritizing brackets, then division and multiplication, then addition and subtraction, to evaluate formulas like A1 + A2 times A3.

Learn to use the min and max functions to identify the lowest and highest values in a range, apply them across rows and columns in Excel.

Learn to use absolute referencing in Excel to keep certain cell references fixed when copying formulas. Use $ signs or F4 to lock rows and columns.

Define named cells and ranges to shorten formulas and enable references across sheets. Use name tool or name box, set workbook scope, and apply names in sum, average, or count.

Create and manage autofill lists in Excel using the fill handle, including months and days, and extend to custom lists by importing, editing, and deleting entries.

Create a custom Excel 2010 template by clearing nonessential data and preserving formulas, then save as an .xltx and access via File > New > My Templates.