Microsoft Excel - from scratch to pro level

Learn why an Excel file is called a workbook, how to add and delete sheets, and the importance of data restoration settings to protect your reports.

Learn to quickly adjust column widths and row heights in Excel by double-clicking between headers and dragging, and use undo or right-click options for precise sizing.

Center the product wise sales for 2021 heading by merging and centering the selected cells; alternatively, use Ctrl+1 and center across selection under alignment to keep cells separate.

Apply date formats in Excel using the Format Cells dialog (Ctrl+1), choose from various date styles, and pick a favorite format that shows date, month name, and year.

Save your Excel file with ctrl+s to lock in changes. Use save as (f12) to rename or pick a different location, and choose a clear file name.

Calculate net price per unit from a 25 unit lot by applying a 13.5% discount to the gross total, bracket the expression, then divide by 25 in Excel.

Learn best practices for calculations in Excel using cell references and input cells, calculating discount value, net value, and price per unit, with quick access toolbar formatting.

Discover the difference between formulas and functions in Excel, build a profit-per-unit calculation, apply discount and net price, and use the sum function to total sales.

Learn to use the sum function in Excel to total a column of numbers or a range, including syntax, equals sign, and array usage, and distinguish between formulas and functions.

Explore how Excel groups functions in a dialog box and formula bar, with categories like financial, date and time, mathematics, and logical.

Master how to use freeze panes in Excel to keep headers visible and anchor important data as you scroll, including top row, first column, and custom freezes.

Toggle gridlines, the formula bar, and headings to tailor your Excel view for reports and dashboards. Learn how page layout supports right-to-left languages and 180-degree orientation when needed.

Unfreeze panes in the view ribbon, then enable split panes to create four windows for simultaneous scrolling and viewing the grand total and the week total, contrasting with free space.

Generate random sales revenue values in Excel using the randbetween function with a 500 to 5000 range, then fill the results across the selected data with copy and paste.

Learn how ctrl d copies formulas down and ctrl r copies across, and how row and column references move when filling cells, with a future lesson on fixing them.

Learn how to fix a logical test in Excel to award bonuses when actual sales meet or exceed the minimum target sales, using the E7 >= D7 condition.

Apply a complete if function in a single cell to test whether actual sales meet the target and compute a 5% bonus, returning zero when not eligible.

Learn to create a copy of an Excel sheet by using move or copy, selecting the target workbook, and moving to end so the original remains intact.

Explore creating an excel bonus calculator: use IF to test target sales against actual sales, apply a locked bonus percentage, and return the bonus or zero with proper true/false handling.

Excel's if function does not treat text cases as sensitive; testing yes or no with different capitalization still evaluates the condition correctly in bonus calculations.

Use a combined if and function in Excel to build a logical test for bonus eligibility, returning yes or no and copying the formula across employees.