Lynda - Office 365 for Mac: Excel Essential Training

Size: 903MB | Duration: 6h 21m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 48KHz 2ch

Genre: eLearning | Level: Beginner | Language: English

Learn everything you need to master the world's most popular spreadsheet program—now accessible from anywhere with an Office 365 subscription. Curt Frye provides a comprehensive overview of Excel for Mac, including manipulating workbook and cell data, using functions, printing worksheets, and collaborating with others. In the last half of the course, he covers more complex techniques, such as summarizing data with charts, working with external data, adding images and shapes, and automating routine tasks.

Topics include:

* Customizing the Ribbon

* Formatting worksheets, cells, and cell data

* Sorting and filtering data

* Working with formulas

* Detecting formula errors

* Creating charts

* Importing data

* Inserting objects and graphics

* Using PivotTables

* Recording macros

* Sharing workbooks