From there we look at working with data including validating data, highlighting duplicates, and creating data connections. We also look at inserting tables, charts, pictures, and SmartArt into a worksheet. 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 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 working with Workbooks and worksheets including how we can add headers a footers to a workbook, add security, and freeze panes in a worksheet. This course starts with the basics by introducing you to the User Interface for Microsoft Excel for Mac. You are encouraged to have Microsoft Excel for Mac installed on your Mac or MacBook so you can follow along and try it yourself at the end of each lecture.
#MICROSOFT EXCEL TUTOR HOW TO#
We demonstrate how to get started by creating a spreadsheet, change formatting and styles, how to work with cells and rows, how to create formulas, insert objects, use review features and add security to workbooks.
We'll guide you through 50 videos in just over 3 hours, teaching you the basics of creating spreadsheets using Microsoft Excel for Mac. Knowing how to use a spreadsheet application effectively will result in increased productivity. We designed this course for beginners who are new to the Mac or an existing Mac user who may not be familiar with Microsoft Excel for Mac. Understand the user interface of Microsoft Excel for the Mac to efficiently navigate and utilize all the features of the application. Learn how to use Microsoft Excel for the Mac to create, format, review, and share spreadsheets. "I find your tutorials to be some of the best instructional videos I have ever used."