Summary
Highlights
The video starts by opening Microsoft Excel, noting that while using Windows 10 and Office 2016, the tutorial is largely applicable to other versions. It highlights initial features like recent files, the pinning option for important documents, and the extensive use of templates for quick, professional-looking workbooks. The best way to learn is by starting with a blank workbook to understand the basics.
The tutorial explains the fundamental components of the Excel interface: tabs at the top (like Home, Insert), the ribbon under each tab containing groups (e.g., Font, Alignment), and options hidden under small arrows within groups. Key terminology includes columns (vertical, labeled A, B, C), rows (horizontal, labeled 1, 2, 3), cells (intersection of a column and row, e.g., C4), and ranges (a group of selected cells). A workbook contains multiple worksheets, which can be added, renamed, and reordered.
The video demonstrates how to enter data, using 'Top 10 Grossing Movies' as an example. It shows how to navigate between cells using Tab, Shift+Tab, Enter, Shift+Enter, and arrow keys. It explains how to adjust column and row widths by dragging the dividers or double-clicking for auto-fit. Basic text formatting options like font style, size, bolding, and color are covered, similar to Microsoft Word. Double-clicking a cell allows in-cell editing without deleting existing content. Styles can be applied to rows or cells for quick formatting, and borders can be added to define cell boundaries visually for print.
The tutorial introduces 'Wrap Text' to fit long text within a cell without widening the column excessively. It shows how to insert new rows (e.g., for a main title) by right-clicking. The 'Merge & Center' feature is demonstrated to combine multiple cells into one and center text, ideal for main titles. For numerical data, applying currency formats (like dollar signs) and adjusting decimal places is shown. The 'Print Preview' feature is used to check how the spreadsheet will look when printed, emphasizing the importance of borders and colors for readability, as gridlines do not appear by default.
Formulas are introduced as Excel's powerful feature, always starting with an equal sign (=). The video explains that formulas take cell references, so changes in referenced cells automatically update the formula's result. An example of a simple multiplication formula is shown. The 'formula bar' at the top displays the actual formula within a cell, not just its calculated value. The tutorial then demonstrates creating a new column for 'Domestic Percentage' and using a formula (e.g., =E3/D3) to calculate the ratio, then formatting it as a percentage with two decimal places. The fill handle (small square at the bottom-right of a selected cell) is used to quickly copy the formula down to other cells, automatically adjusting cell references (e.g., E4/D4, E5/D5), showcasing a major time-saving feature.
A helpful tip is given: 'Freeze Panes' under the View tab, which allows specific rows or columns (e.g., the first column) to remain visible while scrolling, aiding data comparison. The tutorial then moves to functions, highlighting 'AutoSum' as a quicker way to sum a range of cells, instead of manually adding each one. It demonstrates using AutoSum to calculate totals for columns and then efficiently copying this function across other columns using the fill handle. Similar steps are shown for the 'Average' function. The dynamic nature of formulas and functions is re-emphasized: any change in the source data instantly updates all dependent calculations.
The final section covers creating a simple chart. The 'Tell me what you want to do' search bar (top of Excel) is introduced as a quick way to find features. To create a chart, specific data (e.g., movie titles and worldwide gross) is selected, using the Control key for non-contiguous selections. Under the 'Insert' tab, 'Recommended Charts' is used to generate a basic bar graph. Chart elements like titles and axis labels can be customized. The video also shows how to change chart styles. Finally, printing is revisited, showing how selecting a chart will only print that chart, while deselecting it will print the entire sheet. Adjustments to column widths or print settings may be needed to ensure all data fits on a single printed page.