MS Excel: Manage and Report with Microsoft Excel (Basic)

Explore the home menu in Excel to use clipboard functions, font and alignment options, and number formatting, including currency, date, and fraction formats.

Learn to use the insert menu in Excel, clear cells from the home menu, insert online pictures and pivot tables, explore add-ins, and undo changes for enhanced analysis.

Turn data into visuals by creating charts from related data, including map and 3D map options, spark lines, and filters, then hyperlink data and insert text boxes, headers, and symbols.

Explore the Excel page layout menu to customize themes, color schemes, fonts, and effects for print-ready reports. Use the page setup panel to set the print area and preview printing.

Highlight data and set or add to the print area to manage print areas, then adjust margins, orientation, and size to fit on one or two pages, with gridlines toggled.

Explore the formulas menu, learn to apply autosum, average, and key financial formulas like net present value, future value, and internal rate of return, by selecting cells and entering inputs.

Use the formulas menu to sum or average by selecting a range, insert the result, and use formula auditing and defined names while exploring statistical, engineering, cube, and web formulas.

Navigate the data menu in Excel to pull data from files, databases, online services, and the web, then load text or CSV data into your workbook.

Explore the data menu in Excel to sort and filter columns, remove duplicates, and perform what-if analysis, forecast, and data grouping or consolidation.

Explore the review menu in Excel to protect workbooks and sheets, enable allow edit ranges with password protection for specific cells, and collaborate while keeping crucial formulas secure.

Use the view menu to preview prints with page layout, view data in real time, apply split and freeze panes, and record macros to automate repetitive tasks.

Explore using Excel templates to start new workbooks, including budget templates, marketing budgets, and invoices, and customize them by editing the predefined fields.

Format dates in Excel using format cells and custom date codes to display month and year as needed across a row or section, including initials like JFM.

Format numbers in a selected column by formatting cells, choose currency or percentage, noting the value remains unchanged unless you multiply by 0.01 to create a true percent.

Write text in a cell, then format it with the home menu using bold, italic, and underline. Resize the column to fit, and use text or logical formulas.

Create calculations in any cell using formulas and functions. Build a sum from E4 to E16 by entering an equals sign and selecting the numbers.

Create and edit formulas in any cell by starting with the equals sign, use operators like multiply and add, and reference other cells to update totals.

Learn to set up print jobs in Excel using page setup to choose orientation, margins, headers and footers, gridlines, and a print area; center data on the page.

Explore print settings in Excel to tailor how your document becomes a PDF, choosing entire workbook, active sheet, or a selection, and adjust orientation, margins, and scaling to fit pages.

Master the basics of Excel menus, perform simple calculations with text and dates, print exact areas, import templates, customize headers, share files, and export to PDF.