2015
Pluralsight
Mike Thomas
2:23
English

Learn how to use the brand new Excel 2016 for Mac! You’ll learn how to set up a spreadsheet from scratch, update an existing spreadsheet, and improve the appearance of a spreadsheet to make it easy to read and understand. You’ll also learn how to create simple calculations, work with list based data, and print your spreadsheet.

Introduction to Excel 2016 for Mac
Introduction to the Course
The Workbook Gallery
Screen Interface Elements
Saving, Closing, and Opening a Workbook
Summary
Entering and Editing Data
Introduction
Working with Cell Entries
Cell Entries that Begin with a Zero
Working with Cell Comments
Cut, Copy, Paste
AutoFill
Creating a Custom List
Summary
Formatting Your Data
Introduction
Resizing, Inserting, and Deleting Columns and Rows
Applying Formatting to a Cell
The Format Painter
Conditional Formatting
Hiding Columns and Rows and Protecting Cells
Summary
Creating Formulas and Using Functions
Introduction
Creating Basic Calculations
Using Brackets in a Formula
Copying a Formula
Using Absolute Cell References in a Formula
Using a Named Cell in a Formula
Introduction to Functions
Summary
Working with Lists
Introduction
Sorting a List of Data into Order
Sorting a Multi-column List into Order
Sorting a Row of Items into Order
Fixing Issues that Prevent Correct Sorting
Filtering a List
Prevent List Headings from Disappearing as You Scroll
Summary
Printing Your Data
Introduction
Defining What Is to be Printed
Setting Orientation Scaling and Margins
Setting Headers, Footers, and Other Print Settings
Summary

Download File Size:403.9 MB

---