Microsoft Excel 2010 Course Beginners/ Intermediate Training

Create a new blank workbook using Ctrl+N, the Quick Access toolbar new icon, or via File > New to choose a blank workbook or templates.

Save a workbook using the quick access save icon, the save command (ctrl+s), or save as. Save as prompts naming and location, while save updates the current file.

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 force Excel to treat numbers as text to preserve leading zeros, using an apostrophe or preformatted text cells, for identifiers like zip codes or phone numbers.

Master entering and formatting dates and times in Excel 2010, including default date formats, slash or hyphen inputs, two-digit year handling, and time with colons.

Learn to edit the contents of a cell in Excel using three methods: formula bar entry, double-click on screen, or the F2 keyboard shortcut, with tips for best fit.

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.

Master the fill handle in Excel to copy values, create patterns, and fill months, days, and numbers by dragging horizontally or vertically, with options to fill series or formatting only.

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.

Learn to select cells, rows, columns, and the whole sheet in Excel using mouse actions and keyboard shortcuts, including shift, ctrl, and spacebar, for efficient formatting and editing.

Learn to insert new columns and rows in Excel, insert copied cells, and shift data to the right or down without losing existing content.

Learn how to delete rows, columns, and cells in Excel 2010, including how to remove content, shift cells, and use undo to restore changes.

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.

Hide and unhide columns and rows in Excel 2010 using right-click, the home ribbon, or keyboard shortcuts, and learn that hidden data do not print, and unhide by selecting columns.

Master how to locate data in Excel 2010 using the Find dialog box or Ctrl+F, search text or numbers across sheets by rows or columns, and refine with match case.

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.

Learn how to insert and delete worksheets in Excel 2010, placing new sheets to the left or end, using the home ribbon or keyboard shortcuts, and confirming deletions.

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.

Set the print area in Excel to control print output, use print preview to see pages, and add to or clear the print area as you expand or reset content.

Learn how to adjust margins and orientation in Excel to fit the print area on a single page, using page layout, print preview, and page setup to scale and preview.

Learn to add headers and footers in Excel 2010 using page layout, with custom headers and footers in left, center, and right sections, including page numbers, date, and file path.

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.

Learn to set print titles in large worksheets by repeating top row headings across every page using the page layout's print titles feature, with multiple rows and optional left-hand columns.

Learn to print grid lines, row and column headings, and print titles in Excel 2010. Use page layout and print preview to control page order and what prints.

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.

Learn how to run the spell checker in Excel 2010 to catch misspellings in employee data, using review tab and F7, with ignore, add to dictionary, and change all options.

Explore Excel 2010 print options with the print preview box, choosing printer, page size, orientation, margins, and whether to print active sheets, a whole workbook, or a selection.

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 merge cells in Excel to center headings across multiple columns with merge and center, or merge across, and understand how merged content may trigger errors and alignment options.

Highlight cells to format numbers in Excel, applying currency, accounting, comma, and percentage styles, adjust decimals, and explore the number format options from general to currency and accounting.

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.

Apply borders to cells and ranges to print, not just grid lines. Use the border tool to select styles, colors, and sides, and explore more borders for precise control.

Apply and customize date formats in Excel using short, long, or custom formats with m's, d's, and y's; learn that dates are stored as serial numbers behind the scenes.

Master the Format Painter in Excel to copy cell formats across cells and non-consecutive ranges without changing data, including colors, borders, alignment, and date formats.

Master clearing cell contents without losing formatting, learn when to use delete vs clear contents, and restore default formatting with the format painter in Excel 2010.

Learn to use Excel for basic math by building simple addition formulas, referencing cells, and understanding how Excel highlights and calculates results.

Learn how to perform subtraction in Excel 2010 using the equals sign and cell references, including multi-cell formulas, color-coded inputs, and dynamic updates when inputs change.

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.

Learn how to perform division in Excel using the equals sign and the forward slash, with cell references like A1 divided by A2, formatting options, and error handling for DIV/0.

Learn how to use the operand to raise one cell to another power in Excel, with equals syntax and examples like A1^A2 and G1^G2, plus how results update.

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.

Master Excel formulas by using the sum function and ranges to add rows, columns, or rectangles, from b2 to b8 to the grand total, with autoSUM.

Copy formulas and functions in Excel, and use paste, fill handle, and autosum to quickly extend calculations while understanding how relative references adjust and avoid #REF errors.

Learn how to reveal and hide all formulas in Excel 2010 to troubleshoot, audit, and understand worksheets, using keyboard shortcuts and the show formulas command.

Explore useful counting functions in Excel, including count, counta, countblank, countif, and countifs, and learn how to count numbers, non-numeric cells, and blanks to troubleshoot data.

Learn how to compute mean, mode, and median in Excel 2010 using the average function and related tools, with a banana data set and practical examples.

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.

Create cross-sheet formulas to summarize weekly fruit totals by linking cells from week sheets into a summary sheet, using equals, sheet names, and paste link to update automatically.

Master cross-worksheet calculations in Excel 2010 by using sum and average across sheets, preserving source values and understanding sheet references.

Learn how 3D referencing sums and averages data across multiple sheets in Excel using a sheet range like week1:week4!B2, with Monday banana examples and automatic inclusion of sheets inserted between.

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.

Apply and customize themes in Excel 2010 to quickly format worksheets and ensure consistency. Use the page layout themes menu to switch colors, adjust headings, and save or browse themes.

Learn how to add, edit, and delete comments in Excel 2010, using the review ribbon to attach notes to cells, resize fixed comments, and control indicators.

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.

Learn to turn a data range into a formatted Excel table, apply styles and header options, resize or convert back to range, and leverage built-in filters for analysis.

Learn how to protect a worksheet in Excel 2010, set or omit a password, and control permissions such as selecting locked or unlocked cells, formatting, inserting columns, and more.

Learn how to protect a worksheet while leaving data-entry holes by unlocking specific cells, applying sheet protection, and ensuring formulas and structure stay intact.

Excel 2010 introduces restricting access to cell ranges by password or user accounts, enabling income and expenditure ranges to be edited only by authorized users.

Protect your excel workbooks by setting a password to open or modify. Use file > save as > tools > general options to apply password protections and read-only options.

Access Office.com templates from the File menu in Excel 2010, download a template such as Home financial expenses, and save the filled workbook with a meaningful name, formulas intact.

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.