Learn how to use Microsoft Excel with our tutorial Tutor for Microsoft Excel. This tutorial covers the Mac version of Excel and includes 49 easy-to-follow video lessons. We start out by looking at the interface to Excel and how to create documents and save a document as a template. From there we look at working with Workbooks and worksheets including how we can add headers a footers to a workbook, add security, and freeze panes in a worksheet. We then take a look at working with cells including selecting and formatting cells, adding and deleting cells, autofilling cells, and merging multiple cells into a single cell. From there we look at how we work with rows and columns including inserting and deleting rows and columns, sorting and filtering columns, and grouping rows and columns. We also look at inserting tables, charts, pictures, and SmartArt into a worksheet. From there we look at working with data including validating data, highlighting duplicates, and creating data connections. We also look at our review options including adding comments and trading changes in Excel. From here we look at our different printing and sharing options as well as looking at Excel shortcuts.
If you need to learn Excel for the Mac – our tutorial is for you!
- Working with Cells Introduction
- Adding Text and Formulas to Cells
- Selecting, Styling, and Formatting Cells
- Adding Borders and Fills to Cells
- Using the Format Painter
- Adding Conditional Formatting to Cells
- Clearing and Autofilling Cells
- Merging Multiple Cells into One Cell
- Moving, Inserting, and Deleting Cells