Microsoft Excel for Mac: Beginners Excel 2019 Course

Learn how to enter text and numbers in Excel for Mac 2019, using direct cell entry, formula bar, copy-paste, and auto fill, with wrap text and patterns.

Use named ranges to navigate large workbooks and simplify calculations, including non-contiguous selections, naming via the name box, and recalling with F3 for quick formulas.

Guides beginners through a practice exercise in Excel for Mac 2019, calculating 20 percent bonuses, applying them to salaries, and using a named range for new salary to summarize totals.

Save and share Excel for Mac 2019 spreadsheets using the save as dialog, choosing formats like .xlsx, templates, csv, or text, and share via cloud or email.

Practice exercise two guides you to change the bonus amount to 30 percent, ensure totals update, and save the workbook to a location of your choice.

Master freezing panes in Excel for Mac 2019 to keep headings visible while scrolling, and learn to freeze or unfreeze the top row or first column.

Split screen options in Excel for Mac 2019 let you divide the spreadsheet into two panes, allowing independent scrolling for quick comparison; note Mac lacks synchronized scrolling.

Practice exercise 3 guides you to freeze the heading row in the sales data worksheet, split after row 20 to view two copies, then restore the original layout.

Learn how to set print titles in Excel for Mac 2019, repeating the top header row on every page by selecting rows to repeat in the page layout.

Explore printing workbooks in Excel for Mac 2019, adjust printer and presets, copies, page ranges, and paper size, then decide active sheets, entire workbook, or a selection.

Learn to adjust column widths and row heights in Excel for Mac 2019 using drag to resize, auto size by double-click, and right-click options for column width and row height.

Practice exercise for Excel Mac 2019: insert blank rows after row 10, a blank column between G and H, a cell at C20, and set rows 30–35 to height 20.

Master copying formulas in Excel for Mac by using the auto fill handle, rand between for data, and paste values to convert formulas to numbers, including totals and formatting options.

Review the basics of formulas in Excel for Mac 2019, including sum, average, min, max, and count, and learn to use ranges, named ranges, and the formula builder.

Explore basic date and time functions like today and now, and essential text functions such as proper, upper, lower, and trim, plus combining them to clean data.

Explore using vlookup and hlookup to retrieve descriptions and prices from a named parts catalog, with exact and approximate matches, error handling, and practical tax-rate examples.

Use vlookup on the yellow-header table, name the data range customer info, with optional error checking, then count characters in names and last three order-number characters.

Master three-dimensional formulas in Excel for Mac to sum data across multiple worksheets by referencing the same cell, using the sum function across years.

Format cells in Excel for Mac 2019 using the home ribbon to adjust font, size, borders, fill color, and font color, plus right-click format cells for advanced options.

Explore alignment options in Excel for Mac 2019, mastering horizontal and vertical alignment, text orientation, wrap text, indent, shrink to fit, and merge and center across selected cells.

Learn to use cell styles in Excel for Mac 2019 to clarify spreadsheets. Apply a style key, build a summary sheet, and protect data by locking cells.

Explore conditional formatting in Excel 2019 for Mac to highlight data with basic rules, manage and edit formatting, and visualize values using data bars, color scales, and icon sets.

Learn how to use the fill handle and auto fill in Excel to extend days, months, and numbers, and create, import, and manage custom lists for faster data entry.

Complete practice exercise nine in Excel for Mac 2019 by formatting header, creating raw data table with a totals row, applying data bars to column h, and protecting sheet.