false
OasisLMS
Login
Catalog
Excel Mac Intermediate
Excel Mac Intermediate - Quick Reference Guide
Excel Mac Intermediate - Quick Reference Guide
Back to course
Pdf Summary
This quick reference guide for <strong>Microsoft Excel for Mac (Intermediate)</strong> summarizes key tasks for working with charts, formulas, data management, tables, formatting, printing, and collaboration. It explains how to <strong>create, move/resize, change chart types, and filter charts</strong>, plus how to add <strong>sparklines</strong> and <strong>trendlines</strong>. It also outlines common <strong>chart types</strong> (column, line, pie, bar, area, scatter/XY, stock, surface) and describes useful <strong>chart elements</strong> such as titles, legends, gridlines, axis titles, data labels, data tables, error bars, and trendlines. For <strong>printing and distribution</strong>, it covers setting <strong>page size</strong>, defining a <strong>print area</strong>, printing <strong>titles/gridlines/headings</strong>, adding <strong>headers and footers</strong>, and adjusting <strong>margins</strong> and <strong>page orientation</strong> (portrait/landscape). In <strong>intermediate formulas</strong>, it highlights <strong>absolute references</strong> (using dollar signs), <strong>naming cells/ranges</strong> for easier formulas, referencing <strong>other worksheets and workbooks</strong>, and the <strong>order of operations</strong> (PEMDAS). It also introduces common functions: <strong>CONCAT</strong> for combining text, <strong>PMT</strong> for loan payments, and <strong>DATE/TODAY/NOW</strong> for dates and times, plus how to <strong>show formulas</strong> on the sheet. For <strong>data management</strong>, it includes steps to <strong>import/export data</strong>, create <strong>outlines and subtotals</strong>, use <strong>Flash Fill</strong>, and set up <strong>data validation</strong> rules. The <strong>tables</strong> section explains formatting a range as a table, <strong>sorting and filtering</strong>, inserting rows/columns, choosing <strong>table style options</strong>, removing duplicates, and adding <strong>slicers</strong>. Finally, it covers <strong>intermediate formatting</strong> (conditional formatting, cell styles, custom styles, workbook themes) and <strong>collaboration/security</strong> (comments, sharing, protecting sheets, and adding workbook passwords).
Keywords
Microsoft Excel for Mac
intermediate Excel
charts and chart elements
sparklines and trendlines
chart types (column line pie scatter)
printing setup (print area headers footers)
absolute cell references
Excel functions (CONCAT PMT TODAY NOW)
data management (import export validation Flash Fill)
tables (sorting filtering slicers remove duplicates)
×
Please select your language
1
English