Excel for beginner in 7 hours

Master efficient data selection in Excel using drag, shift-click to select ranges, control-click for noncontiguous cells, and shortcuts like Ctrl+A, the name box, and selecting entire columns or rows.

Adjust column width, autofill months, and enter numbers quickly; learn Excel's order of operations with 2 plus 3 times 4 equals 14.

Master quick data summation in a compact excel worksheet using the auto sum tool and autofill, selecting input data across rows and columns, with the alt+= shortcut generating totals.

Learn to calculate averages, identify max and min values, count filled cells, and apply formulas across columns with autofill in Excel.

Insert dates in Excel manually with control + ;, or dynamically with today() and now(); recalculate with F9 to update the values.

Learn to use sumif and averageif to sum hours and average rates by state, selecting New Jersey, Pennsylvania, Vermont, and California.

Format a six-column travel expenses sheet by applying fonts, fill colors, borders, and a merged, centered title; switch to page layout view to preview print and set borders for headers.

Learn to adjust column widths, row heights, center alignments, and apply wrap text in Excel. Discover auto-fit with double-click, merge and center, and using alt+enter for line breaks.

Explore five types of pictures and illustrations in Excel: pictures, clip art, shapes, Smart Art, and screenshots, and learn practical formatting, color effects, and layout to enhance an expense report.

Explore Excel smart art to insert professional diagrams, customize colors and styles, and even add pictures for presentation-ready spreadsheets.

Learn how to configure Excel print settings, including page size and orientation, set and adjust print areas, apply page breaks, and center content with margins for print previews.

Master Excel’s print preview and print options to set headers, footers, orientation, page size, margins, and scaling, print specific sheets or ranges, and export to PDF or XPS.

Learn to create and switch between named custom views in Excel to navigate large worksheets, adjust zoom, and print selective areas efficiently.

Discover how to protect workbooks and sheets with passwords and encryption. Unlock specific cells for data entry, guard totals, and apply digital signatures or self-certification.

split first and last names in excel using text to columns. insert a new column, select delimited by space in the data tab, and finish to see results.

Learn how to convert data ranges into Excel tables, use sorting and filtering with header rows, and remove duplicates across multiple fields to clean and style your data.

Master Excel's data table to model loan options by varying years and loan amounts, and calculate monthly payments using the PMT function and present value concepts.