MOS Excel Associate Certification MO-200: Master Concepts

Learn to import data from text files into an Excel workbook, choose from data transformation options, specify comma delimiters, and load data into a new worksheet.

Import data from CSV files into Excel using from text or CSV and get data from file, preview the data with delimiter and headers, and load into a new worksheet.

Learn to locate data in a workbook with go to (Ctrl+G) or find and replace (Ctrl+F), using Find and Select, search scopes, formulas, formatting, and wildcard options.

Navigate named cells, ranges, and workbook elements in Excel using go to from the home find and select menu or ctrl+g, then name ranges and double-click to highlight.

Adjust column width and row height to fit cell content using drag, double-click, or format options, including auto fit and specific value settings for multiple columns.

Learn to insert custom headers and footers in Excel using the page layout options, including logos, page numbers, dates, and file names, with different headers for odd and even pages.

Use custom views to save display settings, including hidden drawers and columns and filters. View print areas with page layout and page break preview.

Discover how to customize the quick access toolbar in Microsoft Excel by adding your most used commands, choosing its position, and using shortcuts to speed up formatting and table creation.

Modify basic workbook properties, including data tags and other details, from the properties group. Add custom properties with a name and value, view advanced properties, and return to your workbook.

Discover how to display formulas in Excel using the formulas menu or the keyboard shortcut, highlight cells with formulas, view the formulas used, and edit them for corrections.

Configure print settings in Excel by selecting worksheets or tables, using print preview, printing active sheets or selections, and choosing PDF or a configured printer.

Learn how to inspect Excel workbooks for issues using the document inspector, choose items like document properties and personal information, and remove or reinspect data as needed.

Learn how to merge and unmerge cells in Excel, keep the left cell value, choose from four merge options with the merge icon, and use the alignment section.

Slant headings to fit columns within the visible range, adjust alignment and orientation, and apply borders and cell styles for refined formatting.

Learn how to use freeze panes in Excel to keep headers and the first column visible while scrolling; freeze top row, first column, or multiple areas for persistent viewing.

Learn to wrap text within a cell by using the alignment options wrap text checkbox, or press Ctrl+1 to open the format cells menu and enable wrap text.

Select a cell and apply formats from the Home tab, including currency, date, percentage, thousand separators, and decimals, or open Custom to type a format like 0-00.

Apply cell formats from the format cells dialog box in Excel, adjusting font size, style, color, and background, then use superscript, subscript, and clear formats to undo.

Apply cell styles from the home menu to selected cells, using fonts, number formats, and borders; create and name custom styles, then apply via the cell styles option.

Remove formatting from a cell in Excel by selecting the cell, clicking the eraser, and choosing clear formats to reset formatting.

Copy formatting from a source cell to destination cells in Excel using the format painter, for continuous or non-continuous ranges; double-click to select destinations, press escape to deactivate.

Learn how to name an Excel table, set a custom name with a 255-character limit, and reference it in formulas, plus quick navigation.