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.

Discover how to create the five basic formulas in Excel for Mac 2019, using sum, average, min, max, and count on a data range.

Explore relative versus absolute references in Excel for Mac 2019. Learn how to use the auto fill handle and dollar signs to lock references when creating absolute references.

Explore the order of operations in Excel, applying bodmas and brackets to manage division, multiplication, addition, and subtraction for accurate formulas.

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.

Arrange multiple open spreadsheets on Excel for Mac 2019 using the arrange all option, choosing horizontal or tiled layouts, then maximize a selected window for focused work.

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.

Explore headers and footers in Excel for Mac 2019, using page layout view to add page numbers, dates, titles, or file names with left, center, and right sections.

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.

Learn to add and manage comments in Excel for Mac 2019, including inserting, viewing, resolving or deleting threads, and printing comments with author name from file properties and printing options.

Explore page setup options in Excel for Mac: adjust margins, orientation, paper size, print area, page breaks, background, print titles, and center on page for clean printouts.

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.

Add header with the file name centered. Footer shows page number on the right and date on the left; print headings on every page; add a comment in H7.

Learn to add and delete rows, columns, and cells in Excel for Mac 2019. Use selection, control-click, and right-click inserts and deletes, and shift cells as needed.

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 cut, copy, and paste in Microsoft Excel for Mac 2019, moving data with cut and paste, and exploring paste options such as keep source formatting, paste values, and transpose.

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.

Complete practice exercise six in Microsoft Excel for Mac 2019 by pasting top table data into the highlighted area and filling column B with copy tag so headings run vertically.

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.

Explore how to manage worksheets in a Mac workbook by adding, renaming, deleting, color-coding, moving or copying sheets, and hiding or organizing related tabs.

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.

Rename sheet 1 to 2017, color the 2019, 2018, and 2017 tabs the same, and use three dimensional formulas to complete the summary sheet from the next three tabs.

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 apply number formats in Excel for Mac 2019, moving from general to currency and accounting, and formatting dates, times, percentages, fractions, scientific notation, text, and custom options.

Format data as a table in Excel for Mac 2019, apply table styles, enable headers, use filters, name the table, and enjoy automatic chart updates as data grows.

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.

Use format painter, the paintbrush in the clipboard group on the home ribbon, to copy formatting from one cell to another; double-click to apply across cells, press escape to deactivate.

Protect cells, worksheets, and workbooks in Excel 2019 for Mac with password-protected sheet protection, and unlock specific cells to allow editing.

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.