Microsoft Excel - Beginners Introduction to Excel (Volume 2)

Explore how Excel formats control cell display from numbers to dates, and learn to apply long date formats, comma separators, decimals, borders, bold text, and font color.

Learn to apply advanced cell formatting in Excel by using ribbon groups and the format cells dialog for alignment, shrink to fit, fonts, and more.

Learn to format numbers, text, and dates in Excel using the Format Cells dialog, covering number, date, and custom formats with examples like thousand separators and red negative numbers.

Explore how to customize number formats in Excel using the four-part code (positive; negative; zero; text), applying color and style changes for numbers and text.

Learn how custom formatting in Excel controls the display of positive, negative, zero values and text, using the format cells dialog, including red negatives in parentheses and hyphens for zeros.

Explore how to customize date formats in Excel using date codes (d, m, y), display options, and the Format Cells dialog to show day, month, and year in preferred orders.

Explore advanced formatting in Excel by converting dates to just years, applying thousand separators, and displaying negative figures in red with parentheses using custom formats.

Discover how sorting data in Excel arranges records for presentation, using criteria like alphabetical order, department, hire date, city, or salary, and interpret blanks as still employed.

Discover how to sort data in Excel using the data tab, with A to Z and Z to A, while rows stay aligned as the driver column determines order.

Learn how to handle spaces in data when sorting in Excel by identifying empty rows or columns, highlighting the data range, and using the filter button with dropdowns.

Explore how to use Excel's data tab filters and drop-down sorting to organize text, dates, numbers, and colors, including sort by color, fill color, and font color.

Master advanced sorting options in Excel, including custom sort and sort by color. Perform multi-level sorting by department then staff name, and sort by annual pay from largest to smallest.

Apply data filtering in Excel to hide rows that don't match, focus on specific job descriptions such as account representative or controls engineer, and avoid deleting any data.

Learn to clear filters from specific columns or entire tables, manage multi-column filters, and use the search box to quickly select and add multiple staff names.

Master smart filtering in Excel using color, text, date, and number rules to focus on specific records, with calendar-based dates and top ten options.

Learn to use advanced filters to extract data from a criteria list; copy the selection, paste below the data, and configure list and criteria ranges with a matching header.

Learn to keep headers visible while scrolling by using freeze panes in Excel; place the cursor on row 2 and column 2 to freeze both header row and first column.

Learn to create an outline in Excel to collapse and expand grouped rows, using the data tab outline group and auto outline to manage multiple levels.

Learn to create serial numbers and date sequences in Excel using fill series and autofill, including dragging the fill handle and 1,2 or 1,5 patterns with seven day gaps.

Use the fill dialog box to create serial numbers and date sequences, choosing columns or rows, setting step and stop values, and leveraging the bottom-right fill handle for quick autofill.

Learn how to use Excel's field dialog to fill data series with linear and growth options, choosing a fixed step or a growth factor like 1.1 to expand values.

Explore filling series in Excel using step values and trend, extending historical growth to future years by selecting series and applying a linear trend.

Learn how to use flash fill to quickly create patterns, such as combining first names with the first letter of surnames, and apply the shortcut Ctrl+E for fast filling.

Use data validation in Excel to limit cell inputs by setting constraints such as whole numbers, dates, or decimals, and customize input messages and error alerts.

Create drop down lists in Excel using data validation. Set the source to a typed list or a referenced cell range so users select from predefined options only.

Use text to columns to split cell content by delimiters, such as space, into first name and surname, and set the destination columns B and C from the data tab.

Explore how to separate text to columns using fixed width in Excel, splitting strings into specific character groups, adjusting split points with the ruler and double-click, and skipping unused columns.