MS Excel 365 Academy: Microsoft Excel for Business Easy Way

Navigate Excel’s backstage view and ribbon to create a blank workbook, explore templates, and use the quick access toolbar while understanding tabs and basics of cells, rows, columns, and worksheets.

Customize the quick access toolbar in Excel by adding frequent commands such as new, open, copy, and cut, removing items, and moving it below or above the ribbon.

Learn to customize worksheets by renaming, inserting new sheets, rearranging order, coloring tabs, deleting, moving or copying sheets, and hiding or unhiding them.

Compare modal and modeless dialog boxes in Excel by showing how modal dialogs require you to click okay or apply before changes take effect, while modeless dialogs apply changes immediately.

Build your first Excel sheet by entering student data and fees, navigate with arrow keys, auto-fill serial numbers, center align, bold headers, insert a title row, and merge cells.

Format cells by setting the font to Helvetica, size to 18, and center alignment, then save the workbook to the desktop with the name students fee.

Explore Excel's mini toolbar that appears on right-click for formatting. Apply font, font size, percent style, koma style, alignment, borders, fill, font color, merge and center, and format painter.

Apply workbook level protection in Excel by setting passwords to open and modify, and optionally enable read-only and backup options to safeguard data and formulas.

Learn to remove workbook level password protection in Excel by saving as, accessing general options, clearing the password to open, overwriting the file, and verifying access without a password.

Remove worksheet level protection by going to the review tab, clicking unprotect sheet, entering the password 123, and clicking okay.

Protect the workbook structure to prevent altering the workbook, such as hiding or inserting sheets. Set a password for the Protect workbook command and verify sheets are not added.

Learn how to use common Excel shortcut keys to copy, paste, cut, undo, select all, save, print, and apply bold, italic, and underline, boosting speed and focus.

Master autofill in Excel by using the fill handle to quickly generate sequential numbers, patterns, days of the week, months, and dates.

Master autofill in Excel using the fill handle to generate multiples of five, fill time intervals, duplicate values, color fills, and copy formulas across rows and columns.

Explore advanced Flash Fill techniques in Excel, handling names with varying parts, blanks, and multi-column data to join fields accurately using Ctrl+E and undo with Ctrl+Z.

Master advanced flash fill techniques to create usernames and emails, join phone numbers, and extract years, months, and dates from hyphenated data.

Explore the limitations of flash fill, including case sensitivity, and compare it to formulas like left and right that stay linked to original text and update when the source changes.

Learn four practical ways to apply Excel formulas: manual entry with cell ranges, autocomplete, using the function library, and inserting functions via the insert function dialog.

Explore how Excel formulas perform calculations on data using values, cell references, and operators, and learn how built-in functions fit inside those formulas.

Learn to use the Excel SUM formula to total student fees from January to April, auto-fill results, and create a grand total by merging cells in a student fee sheet.

Learn to create a sum without the sum function by using an equals sign and plus operators to add multiple cell references. Press enter to let Excel compute the total.

Master pro tips for Excel formulas, including typing in lowercase to trigger uppercase when correct and using double-click to confirm whether a formula exists in a cell.

The min formula in Excel finds the smallest number in a range, helping you determine minimum marks per student and per subject by selecting ranges and dragging the fill handle.

Learn to calculate the average monthly sales per employee by applying the division formula to total sales and staff count, then fill across teams.

Learn to use the round formula in Excel to convert grocery prices from three decimals to integers, applying standard rounding rules through a practical grocery chart exercise.

Explore roundup and round down formulas in Excel, learn to round to the next decimal place, set decimal places, use the equals sign, and drag the formula down across cells.

Discover pro-tips for using round formulas in Excel, testing how the mini toolbar hides decimals, and applying rounding across a range to produce exact rounded prices.

Explore how Excel’s odd and even functions round numbers to the nearest odd or even integers and categorize data by numerical patterns.

Learn to multiply numbers in Excel with the product formula, handling numbers, cell values, and ranges for large data sets, reducing manual input and errors in sales revenue calculations.