Microsoft Excel Mastery: From Beginner to Pro

Create your first Excel worksheet by entering text, moving between cells, and adjusting column width with double-click auto-fit, using keyboard shortcuts like enter, tab, and control.

Learn to move and duplicate selections with the four-headed arrow and control key, copy to the clipboard, and explore paste options like keep source column and transpose.

Learn to use the autofill handle to automatically enter months, days, and numbers, create incremental and custom lists, and apply these techniques across rows and columns in Excel.

Discover practical selection techniques in Excel to select large data ranges, including drag-and-select, shift-click, the name box, and Ctrl+A to pick entire worksheets, columns, and rows.

Insert blank cells, rows, or columns by right-clicking and choosing insert, including before a column or above a row. Learn to shift cells right or down and undo with ctrl+z.

Learn how formulas and built-in functions in Excel use the equal sign and cell references to perform calculations, from sum and average to square root, with proper referencing.

Master manual summing in Excel by building formulas with equals and plus signs, using relative and absolute references and autofill to extend sums across rows and columns.

Learn to sum numbers in Excel using the sum function and AutoSum, select ranges, enter formulas, adjust ranges, and auto fill results with the autofill handle.

Learn to auto sum across all worksheet data to quickly total each row and column without writing a formula. Use the auto sum button and a shortcut for faster results.

Learn to use average, max, min, and count functions in Excel to compute averages, find the highest and lowest values, and count numeric cells.

learn how to use absolute cell references in excel to fix the denominator when calculating percentages, preventing errors during autofill.

Learn to display static dates with ctrl+; and dynamic dates with today() and now(), and trigger recalculation with edits or F9. Adjust date time settings to control updates.

Master the Excel if function to perform conditional logic with true and false results, using logical tests, value if true, value if false, and absolute references in real-world bonus scenarios.

Master excel's sumif and averageif functions to calculate total and average sales for specific products, using product ranges and total sales ranges with criteria like banana or apple.

Create named ranges in Excel by naming cells with the name box or from selection, then use them in formulas, and understand absolute references and autofill implications.

Learn how to format numbers and dates in Excel, applying currency signs, decimals, thousands separators, and percentage displays. Use tools like Format Painter and Merge and Center for consistent formatting.

Apply fonts, background colors, borders, and alignment in Excel by formatting the header with merge and center, selecting colors, adjusting font color and boldness, and adding borders for data presentation.

Learn how to adjust row height and column width, align text vertically and horizontally, merge and center cells, wrap text, and format fonts to create a polished Excel worksheet.

Learn to visualize, explore, and analyze data using conditional formatting in Excel, including data bars, color scales, and icon sets, and manage rules.

Explore customizing Excel conditional formatting by applying rules for values greater than 90, below 60, or between 60 and 80, using color scales and the rules manager.

Insert pictures from your computer or online sources, add shapes and diagrams, apply transparency and color adjustments, and use artistic effects for Excel worksheets.

Learn to insert and customize SmartArt graphics in Excel to visually represent data, choose layouts (list, process, cycle, hierarchy, relationship), enter text, add pictures, and apply color and 3D formatting.

Apply themes in Excel to instantly change colors, fonts, and the worksheet look for a consistent, professional appearance, then save and reuse your custom theme across documents.

Apply and manage cell styles in Excel to ensure consistent formatting. Create and modify custom styles, apply built-in styles, format numbers with currency, and import styles between workbooks.

Learn to use and create templates in Excel to save time, using online templates or adapting existing workbooks with built-in formatting and formulas.

Learn to prepare a worksheet for printing using the page layout view, landscape orientation, print areas, print previews, and manage page breaks, margins, and headers or footers for multi-page outputs.

Master printing formats in Excel by scaling to fit one page wide by two pages tall, and applying headers, footers, margins, and print titles.

Print an Excel workbook using the print window and preview. Choose active sheets, entire workbook, or a selection; adjust orientation, size, margins, and scaling; export to Adobe PDF.

Discover how to locate and replace data in an Excel worksheet using find and replace tools, keyboard shortcuts, and options like match case and entire cell contents, including find all.

Learn to freeze panes in Excel to keep headers and key columns visible while scrolling, unfreeze when needed, and use split view to compare data across a large worksheet.

Learn to save and switch between multiple custom views in Excel, including magnification, freezing panes, and selective print areas across fall and spring course sections.

Learn to hide and unhide rows or columns, create and manage grouped outlines (including nested groups), and inspect print previews to show only visible data in Excel.

Rename, move, copy, and delete worksheets; copy between workbooks and color-code sheets, plus add new sheets. Learn to select multiple sheets for simultaneous edits and manage workbook worksheets.

Learn to build a cross-sheet summary in Excel by duplicating a quarterly budget sheet, renaming it to summary, and using sum formulas across Q1–Q4 to total income and expenses.

Learn how to import and export text and CSV files in Excel, using delimited and CSV formats, with header rows, preview steps, and awareness of formatting and formulas during export.

Protect workbooks, worksheets, and cells in Excel with passwords, including encrypting workbooks and protecting workbook structure. Learn to unlock specific cells for data entry while preserving formulas and formatting.

Learn to attach, view, edit, and format comments in Excel cells, using sticky-note style annotations, with options to show, hide, print, and customize color, font, and shape.

discover how to share an excel file for easy collaboration using google drive, assign editors or viewers, and track changes with version history.

split full names into first and last names in Excel using text to columns, with a space delimiter and a preceding insertion of a blank column.

Learn to join first name and last name into a single full name cell using ampersand and a space, or with the concatenate function.

Sort data in Excel by school name or course name, or by final grade average from high to low, then filter and copy results to another sheet.

Learn to convert data into a table in Excel, apply sorting and filtering, and remove duplicates using table features and quick formatting for clean, accurate data.

Learn to insert subtotals in a sorted data list to sum students per school and compute per-school averages and grand totals using the subtotal command, data tab, and grouping outlines.

Master vlookup, hlookup, and xlookup to search a value in the first column or row and return related data, with exact or approximate matches for vertical or horizontal data.

Learn how to use Goal Seek in Excel to determine the maximum purchase price based on a target monthly mortgage payment, using the payment function and loan parameters.

Using the Excel Solver, this lecture teaches how to maximize profit under multiple production constraints by adjusting multiple input cells to generate optimal solutions.

Create one-input and two-input data tables in Excel to explore how interest rate and down payment affect monthly payments, total payments, and total interest using what-if analysis.

Use the scenario manager to store multiple input value sets and generate a summary report showing loan amount, monthly payment, total payment, and total interest for 15–30 year plans.