Microsoft Excel: Ultimate Mastery from Beginner to Pro

Explore how Microsoft Excel functions as a powerful spreadsheet to store, organize, analyze, and visualize data for budgets, financial reports, dashboards, inventory, and sales.

Explore Excel's user interface, including the title bar, quick access toolbar, ribbon with tabs, and essential elements like the formula bar, name box, worksheet area, and status bar.

Explore how the Excel ribbon organizes commands into tabs and groups, with icons and dialog options that appear based on selection, enabling quick access to chart, shape, and font tools.

Explore the file tab in the Excel ribbon to access the backstage view and navigate left and right panes, manage workbooks, save, export, print, and access account and options.

Open the Excel application using the start menu or search box, then close it via window controls or the Alt+F4 keyboard shortcut.

Explore the Excel start screen, with a left panel for home, new, open, account, and options, and a right panel showing a blank workbook and recent items you can pin.

Explore window controls in Excel: use the minimize, maximize, restore, and close buttons to switch between minimized, maximized, and restored states of the Excel application.

Learn to change the color of Excel worksheet grid lines using display options, selecting a grid color from the dropdown and applying or resetting to automatic.

Minimize the Excel window when maximized, then drag the corners to resize width and height. Move the window by holding the top bar, then right-click and drag to relocate.

Discover the components of the Excel workbook user interface, including the clipboard group, font group, alignment group, the quick access toolbar, and scrollbars, and how rows and columns are organized.

Learn to customize the Excel ribbon by creating a new tab, renaming it, forming groups, adding commands, and placing the tab between existing tabs to suit your workflow.

Discover how the quick access toolbar in Excel speeds workflow by placing frequently used commands at your fingertips and customize it to include tools not on the ribbon.

Explore how rows, columns, and cells define the structure of Excel worksheets, identify row numbers and column letters, and understand cell addresses shown in the name box.

Learn two quick methods to change row height in Excel: drag the row boundary or enter an exact height via the row height option.

Learn how the formula bar displays the active cell’s value or formula, enables editing with cell references, and lets you insert functions and expand or hide the bar.

Use the AutoFit row height feature in Excel to automatically adjust row height as font size changes, by using the Format drop-down and selecting AutoFit row height.

Learn how to adjust an Excel column width using drag-and-drop or the column width menu, and see how font size and default settings influence column sizing.

Learn to hide and unhide rows and columns in Excel using right-click, format options, and visibility settings; master hiding single and multiple rows or columns, manually or automatically.

Learn how to insert rows and columns in Excel, including single, multiple, and non-contiguous selections, to add empty space in your data table.

Learn how to insert and delete cells in Excel, using shift options to move data right, left, or down, and handle horizontal and vertical cell operations within tables.

Explore cell models in Excel, including ready, edit, enter, and point modes; learn how active cell status changes with selection, data entry, and formulas, and how references drive point mode.

Learn to delete rows and columns in Excel using selection, Ctrl-click for multiple non-contiguous rows, Shift-click for continuous ranges, and the Delete drop-down to remove sheet rows or columns.

Learn how ranges in Excel are collections of cells, and distinguish vertical, horizontal, mixed, and multi selection ranges with practical selection examples.

Learn how to freeze top rows, freeze first column, or both in Excel to keep headers visible while scrolling, and how to unfreeze panes using the View tab.

Learn three ways to create a new workbook in Excel—via file tab, Ctrl+N shortcut, and the quick access toolbar—and see how workbooks are named sequentially as book one, book two.

Learn to save an Excel workbook using file tab, Ctrl+S, or Quick Access Toolbar, then use Save As to change location, name, or format.

Learn to save an Excel workbook in multiple formats using save as, including CSV format, XML data format, PDF, and Unicode text.

Learn to switch between open workbooks in Excel by using the taskbar or the view tab's switch windows drop-down, enabling quick navigation from one workbook to another.

Explore how to view multiple workbooks at once with Excel's arrange all options—tilt, horizontal, vertical, and cascade—to compare rows, columns, and move data between workbooks.

Learn to insert and delete worksheets in a workbook using the plus icon, ribbon insert sheet option, and Shift+F11, plus deleting multiple sheets with Ctrl and right-click.

Master naming and formatting worksheet tabs in Excel by following rules: minimum 1 character and maximum 31 characters, avoid duplicate names and restricted characters, and use rename to adjust names.

Learn how to move and copy worksheets in Excel using drag-and-drop with the move indicator, control-drag to duplicate, and the move or copy option to place sheets before others.

Move and copy worksheet data between workbooks using the move or copy option, choosing the destination and inserting before a specific sheet.

Learn how to hide and unhide worksheets in Excel using two methods: right-click a sheet to hide it, or use the Home > Format > Visibility options to unhide.

Learn to enter data in Excel with vertical and horizontal methods, watch the name box update as you type, and use enter and tab to move down or right.

Learn to delete data in Excel using three methods—delete rows or columns, clear cell contents, and filter by criteria—demonstrated on employee data with the clear all option.

Explore how to edit data in Excel using four methods: direct cell selection, double-click, the F2 key, and the formula bar.

Learn how to enter dates in Excel using the system date format, and switch to different date formats by formatting cells, so you can display dates in multiple styles.

Use the fill handle in Excel to copy data from different cells by dragging from the bottom-right corner, and explore default patterns and date formats for months and weekdays.

Explore custom pattern fill handlers in Excel, using the fill handle to copy data, generate sequences with bold formatting, and create date and month start or end patterns.

Learn three ways to move data in Excel: clipboard cut-paste, Ctrl X and Ctrl V shortcuts, and the context menu.

Learn practical techniques to duplicate data in Excel using copy and paste alternatives, context menu options, and keyboard shortcuts, including duplicating cells, columns, and comments.

learn how to use drag and drop in excel to move data between cells, copy data with the control key, and understand when the plus symbol indicates a copy.

Explore how flash fill in Excel automatically fills data patterns, such as extracting domain names from emails, using the data tab, flash fill tool, and Ctrl+E.

Learn to format numbers in Excel using flash fill, replicating a chosen format to remaining cells with Ctrl+E, enabling quick formatting of thousands of numbers.

Learn to use flash fill in microsoft excel to extract dates and invoice numbers from existing data, applying formats and using ctrl-e to auto-fill year, month, and day.

Learn to join and extract data in Excel using Flash Fill, by combining first and last names to form full names and extracting first or last names with Ctrl E.

Find a value in Excel using the find and replace dialog, Ctrl+F, and find next, with sheet or workbook search, rows or columns, and match case or exact match.

Learn to locate and highlight formatted values in Excel by using find next, selecting data by color, and applying or clearing formats with the find format from settings.

Find all matches at once in Excel using the find and replace dialog. Use the find all option to display matches and refine with match case or exact match options.

Learn to find and replace values in Excel using the find and replace dialog, choosing exact or entire cell matches, and performing replace one by one or replace all.

Learn to find and replace formatted values in Excel using the find and replace dialog box, apply formats and colors, and update text using replace all.

Learn to apply bold, italic, and underline styles in Excel using the font group buttons, including single and double underline, and how to apply or remove them on selected text.

Learn how to change font color in Excel using the font color gallery, apply colors to data and headings, and use the more colors option with standard and custom palettes.

Explore how Excel's underlining options differ by format, showing single and double underlines on currency versus accounting formats, and how spacing affects the appearance.

Learn to apply subscript, superscript, and strikethrough formatting in Excel, using precise text selection and font settings to format only selected content within a cell.

Learn how to insert symbols and special characters in Excel using auto correct options or the insert symbol dialog, including arrows, copyright, and checkmarks.

Learn to format individual characters in Excel by selecting characters within a cell and applying font options, bold, italic, underline, color, and size, using find and formulas to automate.

Learn how to apply borders to cells in Excel, including selecting data, opening the format cells dialog, choosing line styles and colors, applying outline and inside borders, and removing borders.

Master how to fill cells in Excel by applying background color or gradient, use pattern styles, preview results, and remove colors via the format cells dialog to customize selection.

Learn to draw borders and border grids in Excel by selecting predefined border styles, choosing line color and style, and applying outside and inside borders with the border options.

Apply borders in Excel using ribbon presets, selecting colors and line styles such as bottom, top, left, right, outside, and double borders for precise cell formatting.

Learn to remove existing borders and fills in Excel by applying no borders in the borders options and choosing no color to remove fills, with an option to undo.

Learn how cell references identify each Excel cell by column and row, enabling copying, dynamic calculations, and the use of relative, absolute, mixed references and the name box.

Learn how relative cell references automatically adjust when you copy a formula in Excel, using price and quantity to calculate total cost, with row-by-row updates as you drag.

Explore relative references in Excel by multiplying quantity by unit cost to get total item costs. Drag formulas to auto-adjust references in vertical and horizontal layouts.

Master absolute cell references in Excel by locking a row and column with the dollar sign, so the referenced cell stays constant when you drag formulas across cells.