false
OasisLMS
Login
Catalog
Excel Mac Basic
Excel Mac Basic - Quick Reference Guide
Excel Mac Basic - Quick Reference Guide
Back to course
Pdf Summary
This document is a two-page Microsoft Excel for Mac Basic Quick Reference Guide focused on working with columns, cells, worksheets, and common tasks. It introduces the Excel for Mac program screen, identifying key interface elements such as the Quick Access Toolbar, Ribbon, Formula Bar, Name Box, worksheet tabs, scroll bars, zoom slider, and view controls.<br /><br />It covers essential “Getting Started” actions: creating, opening, saving, printing, and closing workbooks; using Undo/Redo/Repeat; changing views; using zoom; and configuring AutoRecover settings through Excel Preferences. It explains cell selection techniques (single cell, ranges, entire worksheet, and non-adjacent selections), cell addressing (e.g., A1), and how to jump to a specific cell using the Name Box.<br /><br />A large section lists keyboard shortcuts for general commands (New, Open, Save, Print), navigation (moving between cells, jumping to A1 or the last cell), editing (cut/copy/paste, find/replace, clear contents), and formatting (bold/italic/underline, Format Cells dialog, selecting rows/columns, hiding rows/columns).<br /><br />The guide then explains core editing operations: editing cell contents via the Formula Bar or double-click, clearing contents, cut/copy/paste, Paste Special (including transpose), drag-and-drop move/copy (Option to copy), find and replace, and inserting/deleting/hiding rows and columns.<br /><br />Basic formatting topics include text and number formats, alignment, wrap text, merging cells, borders and fill color, Format Painter, and adjusting/AutoFitting column widths and row heights.<br /><br />It also summarizes basic formulas and functions: entering formulas, inserting functions, referencing cells, and using common functions like SUM, MIN, MAX, and COUNT, plus AutoFill for completing series. Finally, it covers inserting objects (images, shapes, hyperlinks), setting object properties and alt text, and managing worksheets (insert/delete/hide/rename/tab color/move/copy), freezing panes, setting print areas, and adjusting page layout settings for printing.
Keywords
Excel for Mac
Quick Reference Guide
keyboard shortcuts
cell selection
worksheet management
rows and columns
formatting cells
formulas and functions
AutoFill
printing and page layout
×
Please select your language
1
English