Microsoft Excel 2013 Course Beginners/ Intermediate Training

Create a new blank workbook in Excel 2013 and save it using Save or Save As to Computer, SkyDrive, or SharePoint, naming the file with the .xlsx extension.

Open workbooks from recent files or browse locations with file open in Excel 2013. Save As creates a new file name or saves to an older format like Excel 97-2003.

learn how to save and open Excel workbooks to SkyDrive, sign in, choose SkyDrive folders, upload, and access files from any internet-connected machine.

Navigate Excel workbooks efficiently by using keyboard shortcuts to move cells and sheets, with arrows, home, ctrl+home, ctrl+end, ctrl+pg up/down, and alt+pg up/down.

Excel lets you add multiple worksheets beyond the default using the plus button, right-click insert, Shift+F11, or Insert > Sheet, with sheets named Sheet1 and Sheet2 placed to the left.

Learn to rename, move, and copy worksheets in Excel 2013. Use navigation shortcuts, drag-and-drop, and Ctrl-drag to create copies, while observing sheet name limits and restrictions.

Enter text, numbers, and dates in Excel by pressing enter, tab, or the confirm tick to accept. Text left, numbers and dates right; widen the column to avoid overflow.

Learn how to enter numbers as text in Excel, using an apostrophe or pre-formatting a cell to avoid leading zeros and unintended date conversions.

Learn how to edit a cell's contents in Excel by entering the cell with double-click, F2, or the formula bar to add or modify data without replacing existing content.

Master the Excel 2013 undo and redo features: unlimited back to file open, multi-action undo from the quick access toolbar, with Ctrl+Z and Ctrl+Y shortcuts.

Master Excel's cut, copy, and paste with clipboard tricks, marching ants, and quick paste options to move or duplicate data across sheets and ranges.

Learn how to drag and drop cells and ranges in Excel 2013, including cutting, copying with Ctrl or Alt keys, moving across sheets, and scrolling while dragging.

Learn how the fill handle in Excel 2013 replicates text, increments numbers and dates, and fills areas across rows or columns, with options to customize series and weekdays.

Learn how to insert and delete rows, columns, and individual cells in Excel, using right-click or the home ribbon, and decide how data shifts when you remove items.

Learn to adjust column widths and row heights in Excel 2013 by dragging, auto-fitting to the widest entry, and applying these changes to single or multiple columns and rows.

Hide and unhide columns and rows in Excel 2013 to control printing and onscreen display, using right-click options and range selection to reveal hidden data.

Discover how to use Excel 2013's find tool to search values across a workbook or a single sheet, with options for match case, entire cell, and search scope.

Learn to build basic math formulas in Excel using the five operators—plus, minus, multiplication, division, and exponent—by referencing cells with equals and observing live results.

Master Excel's order of operations with BODMAS, using brackets to control calculations and ensure correct results when mixing division, multiplication, addition, subtraction, and exponent.

Learn to use the sum function to add consecutive ranges, using B2:B5 or B2:D2, and autosum with the sigma button while noting gaps can affect totals.

Explore copying and pasting formulas and functions in Excel, using relative references, the fill handle, and auto sum to replicate calculations across rows and columns.

Master how to reveal and audit formulas in Excel 2013, using Ctrl+` or the show formulas option, and apply the formula text function to display a single cell’s formula.

Learn to select cells for formatting in Excel 2013, from single cells and ranges to non-consecutive areas, whole columns or rows, using mouse or keyboard with shift and ctrl.

Format your worksheet by changing font face, size, color, and background; apply bold, italic, and underline; select the active area with ctrl+a; and use theme colors for headings and totals.

Learn how to wrap text and merge cells in Excel 2013, use forced line breaks with Alt+Enter, and create centered headings for tidy, readable spreadsheets.

Learn to format numbers in Excel 2013, applying accounting, currency, and percentage formats, adjusting decimal places, and using thousands separators to ensure a consistent display across cells.

Learn to align and orient cell content in Excel 2013 by adjusting horizontal and vertical alignment, rotation, wrap, shrink to fit, and merging cells.

Explore how to add and remove borders in Excel, choosing styles, colors, and thickness for selections to print attractive, well-defined worksheets.

Learn to apply and customize date formats in Excel 2013, choosing from short or long dates or creating custom formats using d, m, and y codes for cells or ranges.

Master the format painter to copy cell formatting—alignment, borders, colors, and bold—from one cell to others, paste across multiple cells, and stop by pressing escape.

Learn to find and replace cell formats across a workbook with the find dialog, using format search for bold or white text via find all and replace all.

Understand the difference between clearing cell contents and clearing formatting in Excel 2013, using delete, delete cell, and formats like normal and format painter.

Explore worksheet navigation in Excel 2013, including using navigation buttons, Ctrl+Left/Right to jump to first or last sheet, and coloring tabs to indicate status with tab color options.

Move and copy worksheets by dragging tabs within a workbook or between open books, using Ctrl to copy, and move or copy to a new workbook.

Learn to view and compare multiple workbooks in Excel 2013 by using switch windows, arrange all layouts (cascade, vertical, horizontal, tiled), and enable synchronous scrolling.

Learn how to hide and unhide sheets in Excel 2013 using right-click tabs or the format ribbon, managing hidden worksheets within a workbook such as January to March.

Learn how to modify multiple worksheets at once by selecting and grouping sheets, then insert columns, add formulas, copy sheets, and apply consistent tab colors across the workbook.

Set rows to repeat at the top on every page and define the print area with the page layout tools to control Excel printing. Use print preview to confirm.

Adjust paper size, orientation, and margins in the page layout, and use scale to fit with optional forced width or height to preview how spreadsheets print.

Learn how to add headers and footers to every page in an Excel workbook via the page setup dialog, including custom headers and footers with left, center, and right sections.

Switch from normal view to page break preview and page layout view to control prints, adjust margins, and edit headers and footers with file path.

Highlight the cells to print, choose print selection, and use ctrl to select nonconsecutive ranges so each area prints on its own page.

Learn to run Excel 2013's spell checker from the review tab or F7, accept changes, add words to the dictionary, and use ignore or auto-correct for future workbooks.

Explore how Excel 2013 merges print and print preview into one screen, enabling control of active sheets, page range, orientation, margins, scaling, headers and footers, and print quality.

Learn to use the sum function in Excel 2013, including auto-sum, non-consecutive ranges, and adding across rows and columns for quick totals.

Learn how to copy formulas and functions in Excel 2013 using shortcuts, toolbars, and the fill handle, preserving relative addresses so pasted formulas reference new cells rather than results.

Explore using Excel 2013's average function, how it handles data ranges, and how to find daily highs and lows with max and min, plus copying formulas across cells.

Explore useful count functions in Excel, including count, counta, and countblank, using the yellow range B2:F11 to count numbers, content, and empty cells, and compute total cells.

Explore how absolute referencing in Excel 2013 fixes cells when copying formulas, using dollar signs and F4 to lock rows or columns, with tax and total calculation examples.

Create cross-sheet formulas to link cells across multiple worksheets and populate a summary sheet, using relative references, paste link, and separate default values for tax and profit.

Learn 3D referencing in Excel by summing cells across identical sheets with Jan to Dec ranges, using =sum, colon syntax, and paste special options.

Create and manage named ranges in Excel using the name box and Name Manager, then apply them across a workbook for concise cross sheet formulas.

Master applying and customizing themes in Excel to align background colors, fonts, and effects across sheets. See how theme changes update colors, fonts, and objects.

Learn to add, edit, and delete comments in Excel 2013, using the review ribbon to insert New Comment, show or hide comments, and position text boxes without obstructing the worksheet.

Create custom autofill lists in Excel via File options, add items like departments, then use the fill handle to repeat them across rows or columns.

Learn to convert data into an Excel table to streamline formatting with built-in styles, headers, totals, filters, and banded rows, and explore related tools like slicers and pivot table options.

Learn how to activate and deactivate worksheet protection in Excel 2013, set an optional password, and control allowed actions like selecting cells, inserting columns, and unprotecting sheets.

Unlock selected cells, protect the sheet from the review ribbon with a password, and allow edits only in unlocked cells while preserving headings and formulas.

Learn how to protect Excel workbooks and worksheets, securing sheet changes, workbook structure, and file access with open and modify passwords, plus read-only options.