Microsoft Excel - Beginner To Expert

Learn how to locate and launch Excel on Windows (and similar on Mac) by using the start menu or search to start your spreadsheet journey.

Explore the Excel startup screen, including home, new, and open sections, templates, recent documents, and account options, and learn how to access a blank workbook and online templates.

Explore the Excel interface, focusing on the ribbon and its tabs, like home and insert. The quick access toolbar, formula bar, and name box help you manage data and formulas.

Learn to customize the quick access toolbar in Excel by adding commands like print, autosum, and sort, and collapse the ribbon to maximize workspace.

Explore the Excel interface by identifying the ribbon, quick access toolbar, formula bar, name box, and the workbook with its worksheets, plus the bottom status bar and zoom controls.

Explore Excel's workbook structure by creating and renaming worksheets, adding sheets, and navigating from A1 to Xfd across 1,048,576 rows and 16,000 columns.

Learn how to save in Excel: use save vs save as, choose name and location, select file type, and use autosave on cloud to preserve separate copies.

Learn how to open a saved Excel file using backstage view and recent files, or browse via File Explorer to locate and reopen your workbook.

Create a monthly budget in a new Microsoft Excel workbook by entering labels, currency values, and totals, then format headings and columns for clarity.

Enter numeric values, including currency amounts, for rents and expenses in Excel, and learn how text vs numeric data differ visually, with decimal alignment and undo to keep numbers tidy.

Learn to input date values in Excel by recognizing day, month, and year, converting text to dates, and applying a custom month-year format (mmm yyyy) for monthly data.

Learn how to reference cells and ranges in Excel to drive formulas, charts, and pivot tables. Use single, contiguous, and non-contiguous selections with the Ctrl key.

Master basic formulas in Excel by using the equals sign to sum January values, and apply cell references to automatically update totals when data changes.

Learn how to use relative and absolute cell references to build and copy totals for months and bills in Excel, and understand how formulas adjust when pasted.

Master absolute references in excel by fixing the grand total with dollar signs, copying formulas, and calculating each bill’s percentage of total expenditure.

Master the order of operations in Excel by applying brackets to enforce precedence and auditing formulas with the evaluate formula tab to verify calculations.

Explore how to use Excel functions to perform calculations, from the sum function on cell ranges to understanding function arguments, the function library, and the argument window.

Master the sum function in Excel by totaling a range of cells, such as B4 through B8, to replace manual additions and compute January's monthly total in B9.

Learn to use Excel's min and max functions to find the smallest and largest values in a range, using insert function to select B4:B8 for January.

Learn how to apply the AVERAGE() function in Excel by selecting a numeric cell range and computing the arithmetic mean of values.

Explore the count function in Excel, which counts numeric values in a range while ignoring blanks and text, using the function library to apply it to a range like B4:B8.

Explore how Excel flags adjacent cells in calculations with a green triangle, and learn when to update formulas or ignore warnings while understanding numbers, text, and dates.

Master the auto sum command in Excel to quickly sum ranges, including non-contiguous selections from the formulas tab, and verify results by adjusting ranges when defaults misbehave.

Learn how relative references affect Excel's sum function and master the Autosum shortcut (alt + equals) to quickly sum the five cells above, with practice tips.

Demonstrate using auto fill in Excel to copy formulas across months and bills, apply Autosum, and apply absolute and relative references for accurate totals.

Explore how the sumproduct function in Excel multiplies selling price by units sold to calculate total revenue, using arrays to boost efficiency.

Move and copy data in Excel across worksheets and workbooks using drag-and-drop, cut, and paste, and adjust the workbook structure by adding or deleting sheets.

Add and manage rows and columns in an existing Excel sheet for a monthly budget, using shortcuts and menu options, while ensuring totals and formulas auto-update.

Learn how to adjust column widths and row heights in Excel to improve readability and formatting, using drag-and-drop, auto fit, and simultaneous resizing of multiple columns or rows.

Learn to conceal and reveal rows and columns in Excel, including hiding and unhiding of columns, and protect sheets to prevent unhiding while printing only visible data.

Rename worksheets to keep workbooks organized by giving descriptive names that reflect their content, such as monthly budget. Use double-click or right-click to rename, and choose names like copy exercise.

Delete a worksheet from a workbook with caution, as there is no undo. If needed, close without saving to recover, but you may lose unsaved work.

Learn to move and reorder worksheets by dragging, copy a sheet without displacement using the control key and drag, and move or copy between workbooks with right-click options.

Learn to format fonts in Excel to make a document more presentable and readable by adjusting font size, color, bold, and underline, and applying bold headers to create clear separation.

Highlight cells and apply background colors using the paint bucket, then adjust font color for contrast to make headers and totals stand out for better readability.

Enhance readability in Excel by applying borders to separate headings, data, and totals, using bottom, top, left, and right borders and printing results.

Learn to transform data into currency values in Excel by applying rupee currency styles, accounting formats, decimals, and thousands separators, with readability tweaks like symbol removal.

Learn to format numbers as percentages in Excel, select the range, apply the percentage format from the Home tab, and adjust decimal places to show precise percentages beyond rounded figures.

Learn to use Excel's format painter to copy formatting from headers to other cells, saving time on large spreadsheets, with similar benefits in Word and PowerPoint.

Learn how to create and reuse cell styles in Excel to keep headers consistent, update themes globally, and apply styles across workbooks with quick formatting modifications.

Insert images in Excel to create visual context without clutter, using the insert tab and illustrations pictures option; add local or online images via Bing or OneDrive, then resize.

Set a print area in Excel to print a specific range, such as A4:F10, via the Page Layout tab. Then clear the print area to return to full sheet printing.

Preview the concept of an Excel template using a monthly budget example, showing how to create a reusable structure with headers, calculations, a chart, and how to leverage existing templates.

Learn to use and create Excel templates to automate recurring weekly reports, preserving headers and layout. Access built-in Office templates, customize data like currency, and avoid reinventing the wheel.

Turn a monthly budget sheet into a reusable excel template by fixing the layout and placeholders. Save as an excel template (.xltx) and access it from the personal templates folder.