Data Entry Skills [2023]: Goals and Career

Learn to enter text and numeric values in Excel cells, access and edit cells, move with enter and tab, and use the formula bar to input data.

Navigate the Microsoft Excel interface, from the name box and formula bar to the ribbon, with tools for formatting, formulas, charts, pivot tables, data management, and page layout.

Master how to address and access cells in Excel using the row and column system, from A to Z and beyond, with the formula bar and cell definitions.

Identify how Excel distinguishes workbook and worksheet: a worksheet is a single sheet, while a workbook contains multiple worksheets in a file, each with a matrix of rectangular cells.

Learn how to enter, format, and autofill dates and times in Excel, and use formulas and shortcuts to insert the current date or time.

Learn how Flash Fill in Excel automatically detects column relationships to create full names from first and second names, and use autofill for thousands of rows.

Learn how to format data in Excel by adjusting alignment, fonts, colors, and number formats, including currency and accounting options, to present data clearly in cells.

Learn to implement data validation in Excel to restrict inputs, using text length and number ranges, plus drop-down lists for regions, with input and error messages.

Edit worksheet data in Excel by double-clicking a cell to modify values, replace or delete entries, or delete columns, and use undo, redo, and escape to manage changes.

Learn to navigate Excel entirely with keyboard shortcuts, using arrow keys to move cells, Alt to access the ribbon, and Ctrl+Page Up/Down to switch sheets, boosting data entry speed.

Explore changing the appearance of an Excel worksheet by applying themes, color palettes, fonts, and effects across the workbook and adjusting layout and print settings.

Master how to freeze panes to keep top rows and first columns visible while scrolling, and how to split panes to view separate data sections in Excel.

Document your Excel worksheet by adding comments to cells, noting accepted values or warnings, using the Review menu to create, view, delete, and manage comments.

Learn to select cells, columns, and rows in Excel using header clicks, drag to extend ranges, Ctrl-click for multiple cells, and the corner button to select the entire sheet.

Learn to delete, copy, and move data in Excel cells using simple clicks, backspace, and drag-and-drop, plus cut, copy, and paste with keyboard shortcuts.

Learn to manage Excel worksheets within a workbook by naming tabs, coloring sheets, duplicating and moving sheets, grouping to sync changes, and using delete and insert options.

Protect your worksheet and workbook by setting a password, restricting edits, and selecting what users may modify, such as locking or unlocking cells, formatting, and inserting rows.

Hide worksheets in Excel by right-clicking a tab and choosing hide, then unhide using a tab to reveal hidden sheets, including handling multiple sheets in a workbook.

explore how formulas and functions in Excel power data analysis, from summing scores with auto sum to calculating percentages and creating custom formulas.

Explore relative, mixed, and absolute cell references in Excel with practical examples, using dollar signs and F4 to fix references as you drag formulas.

In data entry skills, explore how Excel supports arithmetic operations by using addition, subtraction, multiplication, division, percentage, and exponential calculations with symbols like plus, minus, asterisk, and forward slash.

Master Excel's comparison operators, including equal to, greater than, less than, and not equal to. Use cell references to return true or false and include greater than or equal to and less than or equal to.

Master the Excel concatenation operator to join values from different cells, and build on-the-spot formulas to combine data from columns or rows without spaces.

Explore the three Excel reference operators—colon for range, comma for union, and space for intersection—and see how they reference cell ranges like B5:B15 or D5:D15 in formulas.

Explore how Excel applies operator precedence, from brackets to division, multiplication, addition, and subtraction. The lecture also outlines range, intersection, union, negation, percentage, exponent, concatenation, and comparison operators.

Learn to copy a formula from one cell to an entire column in Excel, using absolute referencing and fill methods. Explore relative and mixed references in a sample percentage calculation.

Learn to trace cell references in Excel using trace precedents and dependents, apply absolute referencing with F4, and visually identify which cells contribute to a formula.

Explore Excel functions, their syntax and arguments, and use the insert function dialog (Shift+F3) to build built-in or user-defined formulas.

Explore how function arguments accept numbers, text, booleans, arrays, and error values, and learn to use Excel's count and count if to analyze data with criteria.

Explore text concatenation in Excel by using the concatenate function to join first and last names into a full name, and mix text with numbers using spaces.

Learn to calculate the average of numeric values in Excel using the average function, including float and negative values, with auto selection and enter.

Learn how to use the LEN function in Microsoft Excel to count text characters and digits in a cell, with practical examples across text and numeric data.

Explore how to compare ranges of values in Excel using large and small functions, alongside max and min, to identify top and lowest scores across a dataset.

Master data extraction in Excel using left, right, and mid functions to pull characters from the start, end, or middle of a text string.

Explore how to capitalize text in Excel using the upper, lower, and proper functions, applying them to columns or single cells for clean data entry.

Master Excel's PMT function to estimate loan payments using rate, nper, and pv with fv and type. Learn syntax and apply PMT in formulas for annual, monthly, and weekly payments.

Explore what-if analytics in Excel by using scenario manager, goal seek, and data tables to model revenue, costs, and profit from price and quantity changes.

Align text and numbers in Excel by using the alignment bar and Home ribbon to choose left, center, or right alignment for individual columns or entire selections.

Learn to merge and center text across multiple cells in Excel, using merge and center and merge across to create a single centered header.

Master how to delete and insert rows and columns in Excel. Use right-click delete and insert options to modify your worksheet.

Learn to adjust rows and columns in Excel by using double-click auto fit, format options for row height and column width, and paste special to copy widths.

Select the table in the worksheet, then use the border options on the home tab to apply borders and customize their color and style in Excel.

Learn to style a worksheet in Excel using cell styles from the Home tab. Explore applying built-in styles such as title heading, theme, and currency to columns and values.