Microsoft Excel Mastery: Excel from Zero to Hero

Learn to customize the quick access toolbar in Excel by adding or removing commands, using more commands to locate tools, and placing undo, redo, open, new, save, and save as.

See how the title bar displays the workbook name and updates after saving, from the default 'book one' to your chosen name, using Quick Access or Ctrl+S.

Use the Excel search bar to locate and apply commands in your workbook, then manage accounts in the account session and sign in for cloud saving with OneDrive.

Explore the Excel interface by navigating the menu bar and ribbon, and discover the home, insert, draw, page layout, formula, data, review, view, and help tabs.

Explore the Excel name box, which shows the name of the selected cell or range, and learn to rename a cell or range, and select it using the small icon.

Master the formula bar in Excel: enter or edit data and create formulas or functions that appear in the selected cell, while you explore the interface.

Explore how Excel names columns with letters from A to Z and beyond to AA, and discover that the workbook supports more than 16,000 columns.

Learn how Excel rows are identified by numbers, from row 1 to over a million, and how columns are identified by letters for clear data organization.

Identify each cell as the intersection of a row and a column, such as A1 or F7, and name it by selecting it.

Learn that a workbook is the Excel file containing multiple worksheets, each sheet is a page for data, and you can add sheets with the plus icon to organize data.

Learn how to use the vertical and horizontal scroll bars in Excel to navigate data by clicking and dragging, or using arrows for precise up, down, left, and right movement.

Explore worksheet views in Excel, including normal view for data entry, page layout and print layout views, and page break preview to adjust print areas.

Master the Excel zoom control to magnify a selected area of a spreadsheet using the plus or minus icons and the slider, without changing font size.

Explore the status bar in Microsoft Excel, learn how it displays critical info, printing readiness, and dynamic calculations like average, count, and sum, with customizable visibility and accessibility features.

Hide or show the ribbon in Excel to save space, use the up arrow or Ctrl F1 to toggle, and understand auto hide and show tabs in older versions.

Learn basics of Excel by understanding that a cell is the intersection of a column and a row, with addresses like B2, and how to select and name cell ranges.

Explore how Excel cells store diverse data types, including text, numbers, dates, times, formulas, and currency, and how to format values and cell backgrounds.

Learn to enter data in Excel by selecting cells, typing directly or via the formula bar, and moving with tab and enter, then saving.

Copy and paste cell contents in Excel by selecting cells or a range, using Ctrl+C and Ctrl+V, with paste appearing in vertical or horizontal form starting from the selected cell.

Cut and paste cell contents in excel using Ctrl x and Ctrl v to move data between cells, including multi-cell ranges, while preserving the original horizontal order.

Learn to drag and drop cell content in Excel to move single cells or a range without cutting or copying.

Select a cell or range, then clear contents via the home tab, or press delete or backspace to remove content and activate the cell for new data.

Learn how to delete cells in Excel, including deleting cell content versus the cell itself, and shift cells up to fill gaps using the home tab and delete commands.

Master the fill handle and auto fill in Excel to copy content, fill series, auto-populate days and months, and calculate totals with the sum function.

Modify default column width and row height to fit content in a new workbook. Enter headings and student data with the formula bar and A1, illustrating data layout and visibility.

Resize Excel column width by dragging borders, auto fit, or entering a point value. Ensure dates and names display fully without pound signs.

Resize row height in Excel by dragging the row border, using autofit with a double-click, or setting a precise height via row height to ensure content fits.

Learn how to insert columns in Excel by selecting a column, then right-clicking to insert, or using the Home tab to insert columns, and populate fields like email and gender.

Learn how to insert rows in Excel by selecting the target row, right-clicking to insert, and placing the new row above the highlighted one.

Delete columns or rows in Excel by selecting the header, right-clicking, and choosing delete, then observe how following columns shift left, and learn the delete sheet columns/rows options.

Learn how to move a column or a row in Excel using cut and insert cut cells, such as placing date of birth after full name and before email.

Learn to hide and unhide rows and columns in Excel, using right-click or the format visibility menu to manage hidden data while preserving headers.

Learn how to wrap text and merge cells in Excel, demonstrating practical steps to fit content within a cell, expand row height, and create larger cells using merge.

Master Excel merge and center to combine text across cells. Explore match across, match cells, and how merge cells preserves the upper-left value.

Master font size in Excel by selecting cells and using the home tab's font group to preview and set the desired size across a range or entire worksheet.

Learn to change font type in Excel by selecting a cell or range, choosing a font from the font group, and applying it to the header or the entire worksheet.

Learn how to change the font color in Excel by selecting a cell and choosing a color from standard options or the more colors dialog with rgb, hsl, and hex.

Select the cell with text and apply bold, italic, or underline from the font group. Use shortcuts Ctrl+B, Ctrl+I, and Ctrl+U to toggle styles, including double underline.

Learn to apply cell fill colors and borders in Excel by selecting cells or ranges, choosing from available colors, and adjusting font color for contrast, enhancing worksheet clarity.

Apply predefined cell styles in Excel to quickly format titles and headers, preview styles on hover, and adjust colors and row height to suit your design.

Master text alignment in Excel by using horizontal alignment options from the home tab, choosing left, center, right, top, middle, or bottom, and exploring indentation and orientation.

Master applying and customizing cell borders in Excel to format data like a table, using all borders, outside borders, top and bottom, draw border, color, and line styles.

Use the format painter on the home tab to copy a cell's formatting and drag over target cells to apply it, including merge and center and text alignment.

Learn how to apply and manage number formats in Excel, including currency, percentage, date, and time formats, to ensure accurate calculations and readable spreadsheets.

Master date formats in Excel by entering valid dates using multiple formats, understanding how Excel stores dates as serial numbers, and recognizing valid versus text dates for accurate calculations.

Master how to enter valid times in Excel using formats like 9:00, 14:00, or 12:30:45, and learn to display with am/pm by adding a space or applying number format.

Learn to apply various date formats in Excel by using the number format options, including short date and long date formats, and see how the value remains a serial number.

Learn how to apply different time formats in Excel by using number format options, more number format, and custom formats to display time exactly as you need.

Learn to enter date and time together in Excel by typing a date, a space, and a time to form a combined date-time value, viewable in 24-hour format.

Learn to manage multiple worksheets in a workbook by adding, grouping, and switching sheets, and copy data across sheets to organize large datasets efficiently.

Learn to copy or move a worksheet in Excel by using the move or copy option, choosing before a sheet or to the end, and renaming duplicated sheets.

Select a worksheet, right-click, choose rename, type a new name, and press enter to apply; duplicate worksheets and rename them, such as January through May, to organize a monthly budget.

Learn to change worksheet tab color in Excel by right-clicking a tab, selecting tab color, and applying a chosen color to organize sheets like January to December.

Select the worksheet you want to delete, right-click it, and choose delete to remove a sheet in Excel. Remember that deletion is permanent and cannot be recovered.

Protect a worksheet by right-clicking and choosing protect sheet, optionally with a password, to prevent edits or deletion; unprotect via the same menu and confirm the password when needed.

Learn to switch between Excel worksheets quickly by using tabs or right-clicking the scroll arrow to select the desired sheet, such as January budget or September budget.

Group and ungroup worksheets to work with multiple sheets at once, so changes apply across all grouped sheets and make monthly budget tasks faster.

Learn how to enter data across clustered worksheets in Excel by grouping January to December, entering monthly expenses, income, and summary, and using formulas to calculate totals and balance.

Master Excel's find and replace to locate data, navigate results, and refine searches with options like match case, match entire cell content, and find all occurrences.

Use find and replace in Excel via the home tab and replace dialog to locate text and swap it, with options like match entire cell content and replace all.

Learn to use Excel's spell check to find and correct misspellings, using the review tab, change and ignore options, and features like change all and add to dictionary.

Explore how to access the print pane from the file tab and print a workbook in Excel. Adjust orientation, margins, paper size, scaling, and print range for clear output.

Learn to set up your Excel worksheet for printing by using page layout, scaling, and page break preview to fit all columns on landscape orientation across two pages.

Learn to scale and fit worksheet content for printing by choosing options like fit all columns on one page and fit all rows on one page, with landscape orientation.

Learn to use the print titles feature in Excel to repeat row and column headings on every page, via the page layout and print titles dialog.

Master page setup in Excel by adjusting margins, orientation, and paper size via print preview or page layout to tailor portrait or landscape printing.

Learn how to print a selected portion of an Excel worksheet by choosing the data, opening the print options, and selecting print selection to print only your current selection.

Learn to show or hide gridlines and headings, enable print gridlines, and preview printing to produce a table-like worksheet with visible column and row headings.

Learn to add headers and footers in Excel using page layout view, insert text in header or footer, place text on the left or right, and preview before printing.

Master header and footer customization in Excel using page layout view, inserting page numbers, dates, times, file and sheet names, logos, and page settings for first and odd/even pages.

Use the file tab to print a workbook, choose a printer or print to pdf, and save with a name; verify headers, date, time, and page numbers for accurate output.